INV Customer Items
Description
Categories: BI Publisher
Application: Inventory
Source: Customer Items Report (XML)
Short Name: INVIRCIT_XML
DB package: INV_INVIRCIT_XMLP_PKG
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 | |
---|---|---|---|
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 |