INV Customer Item Cross References

Description
Categories: BI Publisher
Application: Inventory
Source: Customer Item Cross References Report (XML)
Short Name: INVIRCXR_XML
DB package: INV_INVIRCXR_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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