ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702151A9E05362FB09050512Y select &P_Item_FlexSql Item, msi.inventory_item_id, msi.description Description, misi.secondary_inventory Subinventory, msci.description SubDescription, mfglA.meaning Primary_Subinventory_Flag, misi.picking_order Picking_Order, mfglB.meaning Inventory_Planning_Code, misi.min_minmax_quantity Minimum_Minmax_Quantity, misi.max_minmax_quantity Maximum_Minmax_Quantity, misi.fixed_lot_multiple Fixed_Lot_Multiple, misi.minimum_order_quantity Minimum_Order_Quantity, misi.maximum_order_quantity Maximum_Order_Quantity, mfglC.meaning Source_Type, ood.name Source_Organization_Name, misi.source_subinventory Source_Subinventory, misi.encumbrance_account chart_of_accts_id, &P_Acct_FlexSql Account, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_flexval', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') Item_FlexVal, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flexval', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') Acct_FlexVal, INV_INVSRISA_XMLP_PKG.chart_of_accts_id_p chart_of_accts_id from MTL_SYSTEM_ITEMS_VL msi, MTL_ITEM_SUB_INVENTORIES misi, MTL_SECONDARY_INVENTORIES msci, MFG_LOOKUPS mfglA, MFG_LOOKUPS mfglB, MFG_LOOKUPS mfglC, HR_ALL_ORGANIZATION_UNITS ood, GL_CODE_COMBINATIONS gcc where misi.inventory_item_id = msi.inventory_item_id and misi.organization_id = msi.organization_id and misi.organization_id = :P_ORG_ID and misi.secondary_inventory = msci.secondary_inventory_name and misi.organization_id = msci.organization_id and misi.primary_subinventory_flag = mfglA.lookup_code(+) and mfglA.lookup_type(+) = 'SYS_YES_NO' and misi.inventory_planning_code = mfglB.lookup_code and mfglB.lookup_type = 'MTL_MATERIAL_PLANNING' and misi.source_type = mfglC.lookup_code(+) and mfglC.lookup_type(+) = 'MTL_SOURCE_TYPES' and misi.source_organization_id = ood.organization_id(+) and misi.encumbrance_account = gcc.code_combination_id(+) --order by 1,4 order by 1,4,7,8,9,10,11,12,13,14,15,16,18 INV INVSRISA_XML AR INV تقرير مخزن الصنف (بتنسيق XML) Imported from BI Publisher Description: تقرير المخزن للصنف Application: المخازن Source: تقرير مخزن الصنف (بتنسيق XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG D INV Artikel nach Lager Imported from BI Publisher Description: Artikel nach Lager Application: Lager Source: Artikel nach Lager (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG E INV Subalmacenes de Artículos Imported from BI Publisher Description: Informe de subalmacenes de artículos Application: Inventory Source: Subalmacenes de Artículos (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG F INV Etat des articles par magasin Imported from BI Publisher Description: Etat article-magasin Application: Inventory Source: Etat des articles par magasin (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG I INV Rapporto Articolo-sottomagazzino Imported from BI Publisher Description: Rapporto Articolo-sottomagazzino Application: Inventory Source: Rapporto Articolo-sottomagazzino (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG JA INV 品目-保管場所レポート Imported from BI Publisher Description: 品目-保管場所レポート Application: Inventory Source: 品目-保管場所レポート(XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG KO INV 품목-창고 보고서 Imported from BI Publisher Description: 품목-창고 보고서 Application: Inventory Source: 품목-창고 보고서(XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG PTB INV Relatório de subinventário do item Imported from BI Publisher Description: Relatório de subinventário do item Application: Inventário Source: Relatório de subinventário do item (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG RU INV Отчет о позициях/складских подразделениях Imported from BI Publisher Description: Отчет о позициях/складских подразделениях Application: Запасы Source: Отчет о позициях/складских подразделениях (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG S INV Artikel-lagerställe - rapport Imported from BI Publisher Description: Artikel-lagerställe - rapport Application: Inventory Source: Artikel-lagerställe - rapport (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG TR INV Kalem stok yeri raporu Imported from BI Publisher Description: Kalem-stok yeri raporu Application: Stok Yönetimi Source: Kalem stok yeri raporu (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG US INV Item-subinventory Imported from BI Publisher Description: Item-subinventory report Application: Inventory Source: Item-subinventory report (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG ZHS INV 物料子库存报表 Imported from BI Publisher Description: 物料子库存报表 Application: 库存管理系统 Source: 物料子库存报表 (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG BI Publisher &p_acct_flexsql &p_item_flexsql :chart_of_accts_id :p_acct_flexsql :p_acct_structnum :p_conc_request_id :p_item_flexsql :p_item_structnum :p_org_id 1 -20 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR ORGANIZATION_ID معرف التنظيم D ORGANIZATION_ID Organisationskennung E ORGANIZATION_ID Id Organización F ORGANIZATION_ID ID organisation I ORGANIZATION_ID ID organizzazione JA ORGANIZATION_ID 組織ID KO ORGANIZATION_ID 조직 ID PTB ORGANIZATION_ID ID da Organização RU ORGANIZATION_ID Идентификатор организации S ORGANIZATION_ID Organisations-id TR ORGANIZATION_ID Organizasyon No US ORGANIZATION_ID Organization ID ZHS ORGANIZATION_ID 组织标识