INV Customer Item Cross References

➜ Back to Library
Description
Categories: BI Publisher
Application: Inventory
Source: Customer Item Cross References Report (XML)
Short Name: INVIRCXR_XML
DB package: INV_INVIRCXR_XMLP_PKG
Run INV Customer Item Cross References and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
DIS Workbooks, Folders, Items and LOVs CAC Internal Order Shipment Margin WSH Shipping/Delivery Transactions ONT Outstanding Holds PA Project Event Upload WSH Commercial Invoice ECC Process Manufacturing, Material Details for Quality ONT Order Discount Detail ONT Lines on Credit Check Hold
Blitz Report™

Blitz Report™ provides multiple benefits: