INV Item-subinventory

➜ Back to Library
Description
Categories: BI Publisher
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
Run INV Item-subinventory and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
CAC ICP PII Inventory and Intransit Value (Period-End) CAC Material Account Detail CAC ICP PII Material Account Detail CAC ICP PII Inventory Pending Cost Adjustment OPM2 OPM WIP Value - V2 CAC Inventory Out-of-Balance CAC Onhand Lot Value (Real-Time) CAC Inventory and Intransit Value (Period-End)
Blitz Report™

Blitz Report™ provides multiple benefits: