373: ORDER BY Item_Definition_Level DESC;
374:
375: CURSOR CI_XREF_Cur (TmpCustItemId NUMBER) IS
376: SELECT Master_Organization_Id, Inventory_Item_Id, Inactive_Flag
377: FROM MTL_CUSTOMER_ITEM_XREFS
378: WHERE Customer_Item_Id = TmpCustItemId
379: AND Inventory_Item_Id =
380: NVL(Y_Inventory_Item_Id, Inventory_Item_Id)
381: AND Master_Organization_Id =
424: MCI.Attribute13,
425: MCI.Attribute14,
426: MCI.Attribute15
427: FROM MTL_SYSTEM_ITEMS MSI,
428: MTL_CUSTOMER_ITEM_XREFS MCIXRF,
429: MTL_CUSTOMER_ITEMS MCI
430: WHERE MCIXRF.Customer_Item_Id = TmpCustItemId
431: AND MCIXRF.Inventory_Item_Id = TmpInvItemId
432: AND MCIXRF.Master_Organization_Id = TmpMstrOrgId