INV Customer Items

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

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