DBA Data[Home] [Help]

APPS.INV_CUSTOMER_ITEM_GRP dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 380: FROM MTL_CUSTOMER_ITEM_XREFS

376: ORDER BY Item_Definition_Level DESC;
377:
378: CURSOR CI_XREF_Cur (TmpCustItemId NUMBER) IS
379: SELECT Master_Organization_Id, Inventory_Item_Id, Inactive_Flag
380: FROM MTL_CUSTOMER_ITEM_XREFS
381: WHERE Customer_Item_Id = TmpCustItemId
382: AND Inventory_Item_Id =
383: NVL(Y_Inventory_Item_Id, Inventory_Item_Id)
384: AND Master_Organization_Id =

Line 431: MTL_CUSTOMER_ITEM_XREFS MCIXRF,

427: MCI.Attribute13,
428: MCI.Attribute14,
429: MCI.Attribute15
430: FROM MTL_SYSTEM_ITEMS MSI,
431: MTL_CUSTOMER_ITEM_XREFS MCIXRF,
432: MTL_CUSTOMER_ITEMS MCI
433: WHERE MCIXRF.Customer_Item_Id = TmpCustItemId
434: AND MCIXRF.Inventory_Item_Id = TmpInvItemId
435: AND MCIXRF.Master_Organization_Id = TmpMstrOrgId