ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F9951A9E05362FB09050512 SELECT &P_FLEXDATA C_FLEXDATA, rh.bill_of_resources C_resource_scenario_name, rh.organization_id C_organization_id, rh.assembly_item_id C_assembly_id, rh.source_item_id C_source_item_id, wl.line_code C_line_code, bd.department_code C_department_code, br.resource_code C_resource_code, rh.setback_days C_setback_days, rh.assembly_usage C_assembly_usage, rh.operation_seq_num C_op_seq_num, rh.resource_department_hours C_required_hours, lu1.meaning C_basis_meaning, rh.resource_units C_resource_units, lu2.meaning C_origination_meaning, (rh.resource_department_hours * DECODE ( rh.basis, 1, rh.assembly_usage, 1)) C_total_hours, substr(dr.resource_group_name,1,12) C_resource_use, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'INV', 'MSTK', 101, sys.ORGANIZATION_ID, sys.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD FROM mtl_system_items sys, crp_resource_hours rh, wip_lines wl, bom_departments bd, bom_resources br, mfg_lookups lu1, mfg_lookups lu2, bom_department_resources dr WHERE rh.organization_id = :P_ORG_ID AND rh.organization_id = sys.organization_id AND rh.source_item_id = sys.inventory_item_id AND rh.line_id = wl.line_id(+) AND rh.organization_id = wl.organization_id(+) AND rh.department_id = bd.department_id(+) AND rh.organization_id = bd.organization_id(+) AND rh.resource_id = br.resource_id(+) AND rh.organization_id = br.organization_id(+) AND rh.basis = lu1.lookup_code(+) AND 'CST_BASIS' = lu1.lookup_type(+) AND rh.origination_type = lu2.lookup_code AND 'CRP_ROLLUP_ORIGINATION' = lu2.lookup_type AND rh.department_id = dr.department_id(+) AND rh.resource_id = dr.resource_id(+) &C_RSRC_USE_WHERE and rh.bill_of_resources=:C_bill and rh.assembly_item_id=:C_inventory_id and rh.organization_id=:C_org_id ORDER BY rh.source_item_id, rh.operation_seq_num, rh.line_id, rh.department_id, rh.resource_id, rh.assembly_usage, rh.resource_department_hours Y CRP CRPRRBOR_XML AR CRP تقرير فاتورة الموارد (بتنسيق XML) Imported from BI Publisher Description: تقرير فاتورة الموارد Application: قدرة الإنتاج Source: تقرير فاتورة الموارد (بتنسيق XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG D CRP Kapazitätsmatrix Imported from BI Publisher Description: Kapazitätsmatrix Application: Kapazität Source: Kapazitätsmatrix (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG E CRP Listas de Recursos Imported from BI Publisher Description: Informe de listas de recursos Application: Capacity Source: Listas de Recursos (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG F CRP Etat Macro-gamme Imported from BI Publisher Description: Etat Macro-gamme Application: Capacité Source: Etat Macro-gamme (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG I CRP Rapporto Distinta delle risorse Imported from BI Publisher Description: Rapporto Distinta delle risorse Application: Capacity Source: Rapporto Distinta delle risorse (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG JA CRP 生産資源構成表レポート Imported from BI Publisher Description: 生産資源構成表レポート Application: Capacity Source: 生産資源構成表レポート(XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG KO CRP 자원명세서 보고서 Imported from BI Publisher Description: 자원명세서 보고서 Application: Capacity Source: 자원명세서 보고서(XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG PTB CRP Relatório da Lista de Recursos Imported from BI Publisher Description: Relatório da Lista de Recursos Application: Capacity Source: Relatório da Lista de Recursos (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG RU CRP Отчет о списке ресурсов Imported from BI Publisher Description: Отчет о списках ресурсов Application: Производственные мощности Source: Отчет о списке ресурсов (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG S CRP Komponentstrukturer - rapport Imported from BI Publisher Description: Komponentstrukturer - rapport Application: Capacity Source: Komponentstrukturer - rapport (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG TR CRP Kaynak Ağacı Raporu Imported from BI Publisher Description: Kaynak Ağacı Raporu Application: Kapasite Yönetimi Source: Kaynak Ağacı Raporu (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG US CRP Bill of Resources Imported from BI Publisher Description: Bill of Resources Report Application: Capacity Source: Bill of Resources Report (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG ZHS CRP 资源清单报表 Imported from BI Publisher Description: 资源清单报表 Application: 能力管理系统 Source: 资源清单报表 (XML) Short Name: CRPRRBOR_XML DB package: CRP_CRPRRBOR_XMLP_PKG BI Publisher &c_rsrc_use_where &p_flexdata :c_bill :c_inventory_id :c_org_id :p_conc_request_id :p_flexdata :p_flexdata2 :p_high_item :p_item_range :p_low_item :p_org_id :p_qty_precision :p_resource_set :p_resource_use :p_struct_num 1 -20 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Org.-Kennung Org.-Kennung E Id Organización Identificador de organización F ID organisation ID organisation I Id organizzazione Id dell'organizzazione JA 組織id 組織id KO 조직 ID 조직 ID PTB Id da Org. Id da Org. RU Идентификатор организации Идентификатор организации S Org.-id Org.-id TR Org no Org no US Org id Org id ZHS 组织标识 组织标识 2 10 :p_resource_set LOV Oracle CRP_SRS_RESOURCE_SCENARIO Y select bill_of_resources id, bill_of_resources value, description description from crp_bills_of_resources where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by bill_of_resources Y AR مجموعة فاتورة الموارد D KapazitätsmatrixSet E Juego de Listas de Recursos F Jeu de macro-gammes I Serie distinte delle risorse JA 生産資源構成表セット KO 자원 명세서 세트 PTB Conjunto da Lista de Recursos RU Набор списков ресурсов S Komponentstrukturserie TR Kaynak Ağacı Kümesi US Bill of Resource Set ZHS 资源清单集 3 20 :p_resource_use LOV Oracle CRP_SRS_RESOURCE_GROUPS Y select lookup_code id, lookup_code value, meaning description from fnd_common_lookups where lookup_type='CRP_RESOURCE_GROUPS' order by lookup_code AR مجموعة الموارد D Ressourcengruppe E Grupo de Recursos F Groupe de ressources I Gruppo di risorse JA 生産資源グループ KO 자원 그룹 PTB Grupo de Recursos RU Группа ресурсов S Resursgrupp TR Kaynak Grubu US Resource Group ZHS 资源组 4 30 :p_low_item Char AR الأصناف من D Von Artikel E De Artículo F Articles - De I Articoli - Da JA 品目:自 KO 품목: 부터 PTB Itens - De RU Позиции с S Från artiklar TR Kalemler, İlk US Items From ZHS 物料自 5 40 :p_high_item Char AR إلى D Bis E A F A I A JA 至 KO 까지 PTB Até RU По S Till TR Son US To ZHS 至