INV Customer Item Cross References

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Customer Item Cross References Report (XML)
Short Name: INVIRCXR_XML
DB package: INV_INVIRCXR_XMLP_PKG
Select 	Customer_Item_Id,
	Master_Organization_Id,
	Customer_Name,
	Customer_Number,
	Customer_Category_Code,
	Concatenated_Address,
	Customer_Item_Number,
	Customer_Item_Desc,
	Item_Definition_Level,
	Item_Level,
	Inventory_Item_Id,
	Concatenated_segments,
	Item_Description,
	Rank,
	Decode(Inactive_Flag,'N','Yes','Y','No'),
	Customer_Category
From 	MTL_CUSTOMER_ITEM_XREFS_V A
Where 	A.Master_Organization_Id = :C_MASTER_ORG_ID 
&P_WHERE
Order By	Customer_Name, Item_Definition_Level,
	Customer_Item_Number, Rank
Parameter Name SQL text Validation
First Ranked Items Only
 
LOV Oracle
To
 
LOV Oracle
Customer Items From
 
LOV Oracle
Level
 
LOV Oracle
Address
 
LOV Oracle
Address Category
 
LOV Oracle
Customer
 
LOV Oracle
Organization
 
Number