DBA Data[Home] [Help]

APPS.INV_DIAG_PI_SUBLOC dependencies on MTL_SYSTEM_ITEMS

Line 46: MTL_SYSTEM_ITEMS I

42: and mil.subinventory_code = moqd.subinventory_code
43: and mil.inventory_location_id = moqd.locator_id)
44: and exists (SELECT 1 FROM MTL_PARAMETERS P,
45: MTL_SECONDARY_INVENTORIES S,
46: MTL_SYSTEM_ITEMS I
47: WHERE I.INVENTORY_ITEM_ID = moqd.INVENTORY_ITEM_ID
48: AND S.SECONDARY_INVENTORY_NAME = moqd.SUBINVENTORY_CODE
49: AND P.ORGANIZATION_ID = moqd.ORGANIZATION_ID
50: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 92: ' FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I ' ||

88: ' where mil.organization_id = moqd.organization_id ' ||
89: ' and mil.subinventory_code = moqd.subinventory_code ' ||
90: ' and mil.inventory_location_id = moqd.locator_id) ' ||
91: ' and exists (SELECT 1' ||
92: ' FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I ' ||
93: ' WHERE I.INVENTORY_ITEM_ID = moqd.INVENTORY_ITEM_ID ' ||
94: ' AND S.SECONDARY_INVENTORY_NAME = moqd.SUBINVENTORY_CODE ' ||
95: ' AND P.ORGANIZATION_ID = moqd.ORGANIZATION_ID ' ||
96: ' AND I.ORGANIZATION_ID = S.ORGANIZATION_ID ' ||