DBA Data[Home] [Help]

APPS.INV_CUSTOMER_ITEM_GRP dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 377: FROM MTL_CUSTOMER_ITEM_XREFS

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 =

Line 428: MTL_CUSTOMER_ITEM_XREFS MCIXRF,

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