INV Customer Items

Description
Categories: BI Publisher
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 NameSQL textValidation
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