DBA Data[Home] [Help]

APPS.INV_CUSTOMER_ITEM_GRP dependencies on MTL_CUSTOMER_ITEMS

Line 369: FROM MTL_CUSTOMER_ITEMS

365: --customer level only.
366: CURSOR CI_Cur (v_Customer_Id IN NUMBER) IS
367: SELECT Customer_Item_Id, Address_Id, Customer_Category_Code,
368: Inactive_Flag, Item_Definition_Level
369: FROM MTL_CUSTOMER_ITEMS
370: WHERE Customer_Id = v_Customer_Id
371: AND Item_Definition_Level in
372: (Temp_level_1, Temp_level_2, Temp_level_3)
373: AND ( (Y_Customer_Item_Id is NULL AND

Line 432: MTL_CUSTOMER_ITEMS MCI

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
436: AND MCI.Customer_Item_Id = MCIXRF.Customer_item_Id