APPS.INV_RECEIVING_TRANSACTION dependencies on RCV_TRANSACTIONS_INTERFACE

Line 54: FROM rcv_transactions_interface rti

50: rti.created_by,
51: rti.last_update_date,
52: rti.last_updated_by,
53: rti.last_update_login
54: FROM rcv_transactions_interface rti
55: WHERE rti.group_id = p_group_id;
56:
57: UPDATE rcv_transactions_interface
58: SET processing_status_code = 'COMPLETED',

Line 57: UPDATE rcv_transactions_interface

53: rti.last_update_login
54: FROM rcv_transactions_interface rti
55: WHERE rti.group_id = p_group_id;
56:
57: UPDATE rcv_transactions_interface
58: SET processing_status_code = 'COMPLETED',
59: transaction_status_code = 'ERROR'
60: WHERE group_id = p_group_id;
61:

Line 259: FROM rcv_transactions_interface

255: , source_document_code
256: INTO l_from_organization_id
257: , l_receipt_source_code
258: , l_source_document_code
259: FROM rcv_transactions_interface
260: WHERE group_id = p_group_id
261: AND ROWNUM < 2;
262:
263: l_progress := '55';

Line 340: FROM rcv_transactions_interface rti

336:
337: DELETE mtl_txn_request_lines
338: WHERE line_id IN
339: (SELECT line_id
340: FROM rcv_transactions_interface rti
341: , mtl_txn_request_lines mol
342: WHERE rti.group_id = p_group_id
343: AND mol.txn_source_id = rti.interface_transaction_id
344: AND mol.organization_id = rti.to_organization_id

Line 424: FROM rcv_transactions_interface

420: SELECT 'ONLINE'
421: INTO l_txn_mode_code
422: FROM dual
423: WHERE exists (SELECT 1
424: FROM rcv_transactions_interface
425: WHERE interface_transaction_id = p_group_id
426: AND processing_mode_code = 'ONLINE');
427: EXCEPTION
428: WHEN OTHERS THEN

Line 456: FROM rcv_transactions_interface

452: , lpn_id
453: , item_revision
454: , item_description
455: , to_organization_id
456: FROM rcv_transactions_interface
457: WHERE interface_transaction_id =
458: p_group_id)
459: LOOP
460: IF (l_rti_rec.processing_mode_code <> 'ONLINE') THEN

Line 607: FROM rcv_transactions_interface

603: , to_organization_id
604: , lpn_id
605: , item_description
606: , item_revision
607: FROM rcv_transactions_interface
608: WHERE lpn_group_id =
609: p_group_id)
610: LOOP
611: IF (l_rti_rec.processing_mode_code <> 'ONLINE') THEN

Line 763: FROM rcv_transactions_interface

759: , to_organization_id
760: , lpn_id
761: , item_description
762: , item_revision
763: FROM rcv_transactions_interface
764: WHERE header_interface_id = p_group_id)
765: LOOP
766: IF (l_rti_rec.processing_mode_code <> 'ONLINE') THEN
767: IF l_rti_rec.mmtt_temp_id IS NOT NULL THEN

Line 918: FROM rcv_transactions_interface

914: , lpn_group_id
915: , lpn_id
916: , item_description
917: , item_revision
918: FROM rcv_transactions_interface
919: WHERE group_id =
920: p_group_id)
921: LOOP
922: IF (l_rti_rec.processing_mode_code <> 'ONLINE') THEN

Line 1224: FROM rcv_transactions_interface rti

1220: x_msg_count OUT NOCOPY NUMBER)
1221: IS
1222: CURSOR c_mmtt_txn_temp_id IS
1223: SELECT DISTINCT rti.mmtt_temp_id
1224: FROM rcv_transactions_interface rti
1225: WHERE rti.group_id = p_group_id;
1226:
1227: l_transaction_type VARCHAR2(100);
1228: l_organization_id NUMBER;

Line 1266: FROM rcv_transactions_interface rti

1262: -- the same mobile_txn, transaction_type, lpn_id, transfer_lpn_id,
1263: -- content_lpn_id
1264: SELECT count(Nvl(rti.mobile_txn, 'N'))
1265: INTO l_mobile_txn_count
1266: FROM rcv_transactions_interface rti
1267: WHERE rti.group_id = p_group_id
1268: AND processing_mode_code = 'ONLINE'
1269: AND processing_status_code = 'PENDING'
1270: AND transaction_status_code = 'PENDING';

Line 1354: , rcv_transactions_interface rti

1350: UPDATE mtl_serial_numbers
1351: SET lpn_txn_error_flag = 'Y'
1352: WHERE ROWID IN (SELECT msn.ROWID
1353: FROM mtl_serial_numbers msn
1354: , rcv_transactions_interface rti
1355: WHERE msn.last_txn_source_id = p_group_id
1356: AND rti.group_id = p_group_id
1357: AND rti.item_id = msn.inventory_item_id);
1358:

Line 1394: from rcv_transactions_interface

1390:
1391: delete from mtl_serial_numbers_temp msnt
1392: where msnt.transaction_temp_id in
1393: ( select interface_transaction_id
1394: from rcv_transactions_interface
1395: where group_id = p_group_id )
1396: ;
1397:
1398: IF (l_debug = 1) THEN

Line 1408: from rcv_transactions_interface

1404: ( select mtlt.serial_transaction_temp_id
1405: from mtl_transaction_lots_temp mtlt
1406: where mtlt.transaction_temp_id in (
1407: select interface_transaction_id
1408: from rcv_transactions_interface
1409: where group_id = p_group_id )
1410: );
1411:
1412: IF (l_debug = 1) THEN

Line 1419: from rcv_transactions_interface

1415:
1416: delete from mtl_transaction_lots_temp mtlt
1417: where mtlt.transaction_temp_id
1418: in ( select interface_transaction_id
1419: from rcv_transactions_interface
1420: where group_id = p_group_id );
1421:
1422: IF (l_debug = 1) THEN
1423: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Committing after rollbacking and cleanup',4);