eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_STD_DELIVER_APIS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 172: SELECT rcv_transactions_interface_s.NEXTVAL

168:
169: -- Chk if RCV_TRANSACTION.INTERFACE_transaction_id item is populated
170: -- If not, populate the item with get_interface_id function
171: --if l_rcv_transaction_rec.INTERFACE_transaction_id is null THEN
172: SELECT rcv_transactions_interface_s.NEXTVAL
173: INTO l_interface_transaction_id
174: FROM SYS.DUAL;
175:
176: l_rcv_transaction_rec.interface_transaction_id := l_interface_transaction_id;

Line 266: INSERT INTO rcv_transactions_interface

262: print_debug('Error occurred while fetching UOM code', 1);
263: END IF;
264: END;
265:
266: INSERT INTO rcv_transactions_interface
267: (
268: receipt_source_code
269: , interface_transaction_id
270: , GROUP_ID

Line 505: UPDATE rcv_transactions_interface

501: INTO v_lcm_ship_line_id, v_unit_landed_cost
502: FROM rcv_shipment_lines
503: WHERE shipment_line_id = l_shipment_line_id;
504:
505: UPDATE rcv_transactions_interface
506: SET lcm_shipment_line_id = v_lcm_ship_line_id,
507: unit_landed_cost = v_unit_landed_cost
508: WHERE interface_transaction_id = l_interface_transaction_id
509: AND to_organization_id = l_org_id;

Line 582: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt

578: , mtlt.lot_expiration_date
579: , mtlt.primary_quantity
580: , rti.item_id
581: , rti.shipment_line_id
582: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt
583: WHERE rti.interface_transaction_id = p_interface_transaction_id
584: AND mtlt.transaction_temp_id = rti.interface_transaction_id;
585:
586: -- Bug 2458540

Line 631: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp mtst

627: , NULL
628: , rti.vendor_lot_num
629: , rti.item_id
630: , rti.to_organization_id
631: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp mtst
632: WHERE rti.interface_transaction_id = p_interface_transaction_id
633: AND mtlt.transaction_temp_id = rti.interface_transaction_id
634: AND mtlt.serial_transaction_temp_id = mtst.transaction_temp_id;
635: END IF;

Line 685: FROM rcv_transactions_interface rti, mtl_serial_numbers_temp mtst

681: , NULL
682: , rti.vendor_lot_num
683: , rti.item_id
684: , rti.to_organization_id
685: FROM rcv_transactions_interface rti, mtl_serial_numbers_temp mtst
686: WHERE rti.interface_transaction_id = p_interface_transaction_id
687: AND mtst.transaction_temp_id = rti.interface_transaction_id;
688: END IF;
689: END IF;

Line 1478: UPDATE rcv_transactions_interface

1474:
1475: l_rcv_transaction_id := p_rcv_transaction_rec.rcv_transaction_id;
1476: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1477:
1478: UPDATE rcv_transactions_interface
1479: SET transaction_status_code = 'PENDING'
1480: , processing_status_code = 'PENDING'
1481: WHERE parent_transaction_id = l_rcv_transaction_id
1482: AND GROUP_ID = l_group_id

Line 4154: FROM rcv_transactions_interface rti

4150: CURSOR c_rti_txn_id IS
4151: /* Bug 2443163 */
4152: /* SELECT MIN(rti.interface_transaction_id) */
4153: SELECT MAX(rti.interface_transaction_id)
4154: FROM rcv_transactions_interface rti
4155: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4156: GROUP BY rti.lpn_id;
4157:
4158: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 4349: FROM rcv_transactions_interface rti

4345: CURSOR c_rti_txn_id IS
4346: /* Bug 2443163 */
4347: /* SELECT MIN(rti.interface_transaction_id) */
4348: SELECT MAX(rti.interface_transaction_id)
4349: FROM rcv_transactions_interface rti
4350: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4351: GROUP BY rti.lpn_id;
4352:
4353: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 4730: FROM rcv_transactions_interface rti

4726: l_inspection_status VARCHAR2(25);
4727:
4728: CURSOR c_rti_txn_id IS
4729: SELECT DISTINCT rti.interface_transaction_id
4730: FROM rcv_transactions_interface rti
4731: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4732:
4733: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4734: BEGIN

Line 5120: FROM rcv_serials_interface rsi, rcv_transactions_interface rti

5116: SAVEPOINT sp_update_rss;
5117:
5118: SELECT rsi.fm_serial_num
5119: INTO l_serial_number
5120: FROM rcv_serials_interface rsi, rcv_transactions_interface rti
5121: WHERE rti.shipment_line_id = p_shipment_line_id
5122: AND rti.interface_transaction_id = rsi.interface_transaction_id;
5123:
5124: IF (l_debug = 1) THEN

Line 5606: FROM rcv_transactions_interface

5602: FROM mtl_transaction_lots_interface
5603: WHERE product_code = 'RCV'
5604: AND product_transaction_id
5605: IN (SELECT interface_transaction_id
5606: FROM rcv_transactions_interface
5607: WHERE parent_transaction_id = l_rtv_rec.rcv_transaction_id
5608: )
5609: AND lot_number = p_lot_number;
5610: EXCEPTION

Line 5705: SELECT rcv_transactions_interface_s.NEXTVAL

5701: END IF;
5702: GOTO nextrtrecord;
5703: END IF;
5704:
5705: SELECT rcv_transactions_interface_s.NEXTVAL
5706: INTO l_new_intf_id
5707: FROM dual;
5708:
5709: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN

Line 5994: SELECT rcv_transactions_interface_s.NEXTVAL

5990: l_rti_tb(l_txn_id)(l_lot_num).quantity
5991: := l_rti_tb(l_txn_id)(l_lot_num).quantity + 1;
5992:
5993: ELSE
5994: SELECT rcv_transactions_interface_s.NEXTVAL
5995: INTO l_new_intf_id
5996: FROM dual;
5997:
5998: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;