DBA Data[Home] [Help]

APPS.INV_CUSTOMER_ITEM_GRP dependencies on MTL_CUSTOMER_ITEMS

Line 366: FROM MTL_CUSTOMER_ITEMS

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

Line 429: MTL_CUSTOMER_ITEMS MCI

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