INV Customer Items

Description
Categories: BI Publisher
Application: Inventory
Source: Customer Items Report (XML)
Short Name: INVIRCIT_XML
DB package: INV_INVIRCIT_XMLP_PKG
Run INV Customer Items and other Oracle EBS reports with Blitz Report™ on our demo environment
Select 	Customer_Item_Id,
	Customer_Id,
	Customer_Name,
	Customer_Number,
	Customer_Category_Code,
	Address_Id,
	Concatenated_Address,
	Customer_Item_Number,
	Customer_Item_Desc,
	Item_Definition_Level,
	Item_Level,
	Model_Customer_Item,
	Model_Customer_Item_Desc,
	Commodity_Code,
	MCI.Description,
	Master_Container_Item_Id,
                  MSM.Concatenated_Segments Master_Container,
	MSM.Description Master_Container_Desc,
	Container_Item_Org_Id,
	OOD.Organization_Code Org_Code,
	OOD.Organization_Name Org_Name,
	Detail_Container_Item_Id,
	MSD.Concatenated_Segments Detail_Container,
	MSD.Description Detail_Container_Desc,
	Min_Fill_Percentage,
	Decode(Dep_Plan_Required_Flag,'Y','Yes','N','No'),
	Decode(Dep_Plan_Prior_Bld_Flag,'Y','Yes','N','No'),
	Decode(Inactive_Flag,'N','Yes','Y','No'),
	Demand_Tolerance_Positive,
	Demand_Tolerance_Negative,
	Customer_Category
From 	MTL_CUSTOMER_ITEMS_ALL_V MCI,
	MTL_SYSTEM_ITEMS_KFV MSD,
	MTL_SYSTEM_ITEMS_KFV MSM,
	ORG_ORGANIZATION_DEFINITIONS OOD
Where	MCI.Master_Container_Item_Id = MSM.Inventory_Item_Id(+)
And	MCI.Container_Item_Org_Id = MSM.Organization_Id(+)
And	MCI.Detail_Container_Item_Id = MSD.Inventory_Item_Id(+)
And	MCI.Container_Item_Org_Id = MSD.Organization_Id(+)
And	MCI.Container_Item_Org_Id = OOD.Organization_Id(+)
&P_WHERE
Order By	Customer_Name, Item_Definition_Level, Customer_Item_Number
Parameter Name SQL text Validation
Organization
 
Number
Customer
 
LOV Oracle
Address Category
 
LOV Oracle
Address
 
LOV Oracle
Customer Items From
 
LOV Oracle
To
 
LOV Oracle
No Cross References Only
 
LOV Oracle