DBA Data[Home] [Help]

APPS.INVCIINT dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 5303: FROM MTL_CUSTOMER_ITEM_XREFS MCIXRF

5299:
5300:
5301: SELECT Customer_Item_Id, Inventory_Item_Id, Master_Organization_Id
5302: INTO Temp_Customer_Item_Id, Temp_Inventory_Item_Id, Temp_Master_Organization_Id
5303: FROM MTL_CUSTOMER_ITEM_XREFS MCIXRF
5304: WHERE MCIXRF.Customer_Item_Id = P_Customer_Item_Id
5305: AND MCIXRF.Inventory_Item_Id = P_Inventory_Item_Id
5306: AND MCIXRF.Master_Organization_Id = P_Master_Organization_Id
5307: AND Rownum = 1;

Line 5322: FROM MTL_CUSTOMER_ITEM_XREFS MCIXRF

5318: ELSE
5319:
5320: SELECT Customer_Item_Id, Master_Organization_Id, Preference_Number
5321: INTO Temp_Customer_Item_Id, Temp_Master_Organization_Id, Temp_Preference_Number
5322: FROM MTL_CUSTOMER_ITEM_XREFS MCIXRF
5323: WHERE MCIXRF.Customer_Item_Id = P_Customer_Item_Id
5324: AND MCIXRF.Master_Organization_Id = P_Master_Organization_Id
5325: AND MCIXRF.Preference_Number = P_Preference_Number
5326: AND Rownum = 1;

Line 5572: INTO MTL_CUSTOMER_ITEM_XREFS

5568:
5569: ELSE
5570:
5571: INSERT
5572: INTO MTL_CUSTOMER_ITEM_XREFS
5573: (
5574: Customer_Item_Id,
5575: Inventory_Item_Id,
5576: Master_Organization_Id,