INV Customer Item Cross References

Description
Categories: BI Publisher
Columns: 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 ...
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
Organization
 
Number
Customer
 
LOV Oracle
Address Category
 
LOV Oracle
Address
 
LOV Oracle
Level
 
LOV Oracle
Customer Items From
 
LOV Oracle
To
 
LOV Oracle
First Ranked Items Only
 
LOV Oracle