APPS.INV_PROCESS_TEMP dependencies on MTL_LOT_NUMBERS

Line 1379: FROM MTL_LOT_NUMBERS MLN

1375: ERROR_CODE = substrb(err_code,1,240)
1376: WHERE TRANSACTION_TEMP_ID = txnrec.transaction_temp_id
1377: AND EXISTS (
1378: SELECT NULL
1379: FROM MTL_LOT_NUMBERS MLN
1380: WHERE MLN.LOT_NUMBER = MTLT.LOT_NUMBER
1381: AND MLN.INVENTORY_ITEM_ID <> item.inventory_item_id);
1382:
1383: if(SQL%ROWCOUNT > 1) then

Line 1406: FROM MTL_LOT_NUMBERS

1402: lotrec.lot_expiration_date IS NULL)
1403: then
1404: SELECT fnd_date.date_to_canonical(EXPIRATION_DATE)
1405: INTO lotrec.lot_expiration_date
1406: FROM MTL_LOT_NUMBERS
1407: WHERE INVENTORY_ITEM_ID = item.inventory_item_id
1408: AND ORGANIZATION_ID = org.organization_id
1409: AND LOT_NUMBER = lotrec.lot_number;
1410: if(item.shelf_life_code = 2 AND