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 423: FROM rcv_transactions_interface

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

Line 455: FROM rcv_transactions_interface

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

Line 548: FROM rcv_transactions_interface

544: , to_organization_id
545: , lpn_id
546: , item_description
547: , item_revision
548: FROM rcv_transactions_interface
549: WHERE lpn_group_id =
550: p_group_id)
551: LOOP
552: IF (l_rti_rec.processing_mode_code <> 'ONLINE') THEN

Line 643: FROM rcv_transactions_interface

639: , to_organization_id
640: , lpn_id
641: , item_description
642: , item_revision
643: FROM rcv_transactions_interface
644: WHERE header_interface_id = p_group_id)
645: LOOP
646: IF (l_rti_rec.processing_mode_code <> 'ONLINE') THEN
647: IF l_rti_rec.mmtt_temp_id IS NOT NULL THEN

Line 737: FROM rcv_transactions_interface

733: , lpn_group_id
734: , lpn_id
735: , item_description
736: , item_revision
737: FROM rcv_transactions_interface
738: WHERE group_id =
739: p_group_id)
740: LOOP
741: IF (l_rti_rec.processing_mode_code <> 'ONLINE') THEN

Line 982: FROM rcv_transactions_interface rti

978: x_msg_count OUT NOCOPY NUMBER)
979: IS
980: CURSOR c_mmtt_txn_temp_id IS
981: SELECT DISTINCT rti.mmtt_temp_id
982: FROM rcv_transactions_interface rti
983: WHERE rti.group_id = p_group_id;
984:
985: l_transaction_type VARCHAR2(100);
986: l_organization_id NUMBER;

Line 1024: FROM rcv_transactions_interface rti

1020: -- the same mobile_txn, transaction_type, lpn_id, transfer_lpn_id,
1021: -- content_lpn_id
1022: SELECT count(Nvl(rti.mobile_txn, 'N'))
1023: INTO l_mobile_txn_count
1024: FROM rcv_transactions_interface rti
1025: WHERE rti.group_id = p_group_id
1026: AND processing_mode_code = 'ONLINE'
1027: AND processing_status_code = 'PENDING'
1028: AND transaction_status_code = 'PENDING';

Line 1112: , rcv_transactions_interface rti

1108: UPDATE mtl_serial_numbers
1109: SET lpn_txn_error_flag = 'Y'
1110: WHERE ROWID IN (SELECT msn.ROWID
1111: FROM mtl_serial_numbers msn
1112: , rcv_transactions_interface rti
1113: WHERE msn.last_txn_source_id = p_group_id
1114: AND rti.group_id = p_group_id
1115: AND rti.item_id = msn.inventory_item_id);
1116:

Line 1152: from rcv_transactions_interface

1148:
1149: delete from mtl_serial_numbers_temp msnt
1150: where msnt.transaction_temp_id in
1151: ( select interface_transaction_id
1152: from rcv_transactions_interface
1153: where group_id = p_group_id )
1154: ;
1155:
1156: IF (l_debug = 1) THEN

Line 1166: from rcv_transactions_interface

1162: ( select mtlt.serial_transaction_temp_id
1163: from mtl_transaction_lots_temp mtlt
1164: where mtlt.transaction_temp_id in (
1165: select interface_transaction_id
1166: from rcv_transactions_interface
1167: where group_id = p_group_id )
1168: );
1169:
1170: IF (l_debug = 1) THEN

Line 1177: from rcv_transactions_interface

1173:
1174: delete from mtl_transaction_lots_temp mtlt
1175: where mtlt.transaction_temp_id
1176: in ( select interface_transaction_id
1177: from rcv_transactions_interface
1178: where group_id = p_group_id );
1179:
1180: IF (l_debug = 1) THEN
1181: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Committing after rollbacking and cleanup',4);