APPS.INV_PROCESS_TEMP dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1301: FROM MTL_TRANSACTION_LOTS_TEMP

1297: TRANSACTION_QUANTITY,
1298: SERIAL_TRANSACTION_TEMP_ID,
1299: fnd_date.date_to_canonical(LOT_EXPIRATION_DATE) LOT_EXPIRATION_DATE,
1300: ROWID
1301: FROM MTL_TRANSACTION_LOTS_TEMP
1302: WHERE TRANSACTION_TEMP_ID = txnTempID;
1303:
1304: l_dummy NUMBER;
1305: BEGIN

Line 1309: DELETE FROM MTL_TRANSACTION_LOTS_TEMP

1305: BEGIN
1306: if(not (item.lot_control_code = 2 AND txnrec.transaction_action_id = 24))
1307: then
1308: if(txnrec.transaction_temp_id <> NULL) then
1309: DELETE FROM MTL_TRANSACTION_LOTS_TEMP
1310: WHERE TRANSACTION_temp_id = txnrec.transaction_temp_id;
1311: end if;
1312: if((item.serial_number_control_code in (2,5) OR
1313: (item.serial_number_control_code = 6 AND

Line 1360: FROM MTL_TRANSACTION_LOTS_TEMP MTLT

1356: ERROR_EXPLANATION = substrb(error_exp,1,240)
1357: WHERE ROWID = txnrec.rowid
1358: AND ABS(TRANSACTION_QUANTITY) <>
1359: (SELECT ABS(SUM(TRANSACTION_QUANTITY))
1360: FROM MTL_TRANSACTION_LOTS_TEMP MTLT
1361: WHERE MTLT.TRANSACTION_TEMP_ID = txnrec.transaction_temp_id);
1362:
1363: if(SQL%FOUND) then return 0; else return 1; end if;
1364:

Line 1367: UPDATE MTL_TRANSACTION_LOTS_TEMP MTLT

1363: if(SQL%FOUND) then return 0; else return 1; end if;
1364:
1365: if org.lot_number_uniqueness = 1 then
1366: loadmsg('INV_INT_LOTUNIQCODE','INV_INT_LOTUNIQEXP');
1367: UPDATE MTL_TRANSACTION_LOTS_TEMP MTLT
1368: SET LAST_UPDATE_DATE = SYSDATE,
1369: LAST_UPDATED_BY = userid,
1370: LAST_UPDATE_LOGIN = loginid,
1371: PROGRAM_APPLICATION_ID = applid,

Line 1418: UPDATE MTL_TRANSACTION_LOTS_TEMP MTLT

1414: end if;
1415: if(item.shelf_life_code = 4 AND
1416: lotrec.lot_expiration_date IS NULL) then
1417: loadmsg('INV_LOT_EXPREQD','INV_LOT_EXPREQD');
1418: UPDATE MTL_TRANSACTION_LOTS_TEMP MTLT
1419: SET LAST_UPDATE_DATE = SYSDATE,
1420: LAST_UPDATED_BY = userid,
1421: LAST_UPDATE_LOGIN = loginid,
1422: PROGRAM_APPLICATION_ID = applid,

Line 1455: UPDATE MTL_TRANSACTION_LOTS_TEMP MTLT

1451: AND rownum < 2;
1452: EXCEPTION
1453: WHEN NO_DATA_FOUND THEN
1454: loadmsg('INV_INT_SERMISCODE','INV_INT_SERMISEXP');
1455: UPDATE MTL_TRANSACTION_LOTS_TEMP MTLT
1456: SET LAST_UPDATE_DATE = SYSDATE,
1457: LAST_UPDATED_BY = userid,
1458: LAST_UPDATE_LOGIN = loginid,
1459: PROGRAM_APPLICATION_ID = applid,