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 |
