INV Customer Items

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Customer Items Report (XML)
Short Name: INVIRCIT_XML
DB package: INV_INVIRCIT_XMLP_PKG
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
No Cross References Only
 
LOV Oracle
To
 
LOV Oracle
Customer Items From
 
LOV Oracle
Address
 
LOV Oracle
Address Category
 
LOV Oracle
Customer
 
LOV Oracle
Organization
 
Number