APPS.INV_FLEX_LOT_ALLOCATION_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 58: and NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP MTLT WHERE MTLT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID)

54: from MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
55: where INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
56: and ORGANIZATION_ID = P_ORGANIZATION_ID
57: and TRANSACTION_STATUS = 2 --ALLOCATED
58: and NOT EXISTS (SELECT 1 FROM MTL_TRANSACTION_LOTS_TEMP MTLT WHERE MTLT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID)
59: AND ROWNUM = 1;
60: EXCEPTION
61: WHEN OTHERS THEN
62: l_existSgstWithoutLot := 'N';