INV Item-subinventory

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Item-subinventory report (XML)
Short Name: INVSRISA_XML
DB package: INV_INVSRISA_XMLP_PKG
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
Parameter Name SQL text Validation
ORGANIZATION_ID
 
Number