DBA Data[Home] [Help]

APPS.INVCIINT dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 5304: FROM MTL_CUSTOMER_ITEM_XREFS MCIXRF

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

Line 5323: FROM MTL_CUSTOMER_ITEM_XREFS MCIXRF

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

Line 5573: INTO MTL_CUSTOMER_ITEM_XREFS

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