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;
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;
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,