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 174: SELECT rcv_transactions_interface_s.NEXTVAL

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

Line 286: INSERT INTO rcv_transactions_interface

282:
283:
284:
285:
286: INSERT INTO rcv_transactions_interface
287: (
288: receipt_source_code
289: , interface_transaction_id
290: , GROUP_ID

Line 529: UPDATE rcv_transactions_interface

525: INTO v_lcm_ship_line_id, v_unit_landed_cost
526: FROM rcv_shipment_lines
527: WHERE shipment_line_id = l_shipment_line_id;
528:
529: UPDATE rcv_transactions_interface
530: SET lcm_shipment_line_id = v_lcm_ship_line_id,
531: unit_landed_cost = v_unit_landed_cost
532: WHERE interface_transaction_id = l_interface_transaction_id
533: AND to_organization_id = l_org_id;

Line 606: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt

602: , mtlt.lot_expiration_date
603: , mtlt.primary_quantity
604: , rti.item_id
605: , rti.shipment_line_id
606: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt
607: WHERE rti.interface_transaction_id = p_interface_transaction_id
608: AND mtlt.transaction_temp_id = rti.interface_transaction_id;
609:
610: -- Bug 2458540

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

651: , NULL
652: , rti.vendor_lot_num
653: , rti.item_id
654: , rti.to_organization_id
655: FROM rcv_transactions_interface rti, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp mtst
656: WHERE rti.interface_transaction_id = p_interface_transaction_id
657: AND mtlt.transaction_temp_id = rti.interface_transaction_id
658: AND mtlt.serial_transaction_temp_id = mtst.transaction_temp_id;
659: END IF;

Line 709: FROM rcv_transactions_interface rti, mtl_serial_numbers_temp mtst

705: , NULL
706: , rti.vendor_lot_num
707: , rti.item_id
708: , rti.to_organization_id
709: FROM rcv_transactions_interface rti, mtl_serial_numbers_temp mtst
710: WHERE rti.interface_transaction_id = p_interface_transaction_id
711: AND mtst.transaction_temp_id = rti.interface_transaction_id;
712: END IF;
713: END IF;

Line 1512: UPDATE rcv_transactions_interface

1508:
1509: l_rcv_transaction_id := p_rcv_transaction_rec.rcv_transaction_id;
1510: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1511:
1512: UPDATE rcv_transactions_interface
1513: SET transaction_status_code = 'PENDING'
1514: , processing_status_code = 'PENDING'
1515: WHERE parent_transaction_id = l_rcv_transaction_id
1516: AND GROUP_ID = l_group_id

Line 4270: FROM rcv_transactions_interface rti

4266: CURSOR c_rti_txn_id IS
4267: /* Bug 2443163 */
4268: /* SELECT MIN(rti.interface_transaction_id) */
4269: SELECT MAX(rti.interface_transaction_id)
4270: FROM rcv_transactions_interface rti
4271: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4272: GROUP BY rti.lpn_id;
4273:
4274: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 4465: FROM rcv_transactions_interface rti

4461: CURSOR c_rti_txn_id IS
4462: /* Bug 2443163 */
4463: /* SELECT MIN(rti.interface_transaction_id) */
4464: SELECT MAX(rti.interface_transaction_id)
4465: FROM rcv_transactions_interface rti
4466: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4467: GROUP BY rti.lpn_id;
4468:
4469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 4848: FROM rcv_transactions_interface rti

4844: l_inspection_status VARCHAR2(25);
4845:
4846: CURSOR c_rti_txn_id IS
4847: SELECT DISTINCT rti.interface_transaction_id
4848: FROM rcv_transactions_interface rti
4849: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4850:
4851: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4852: BEGIN

Line 5242: FROM rcv_serials_interface rsi, rcv_transactions_interface rti

5238: SAVEPOINT sp_update_rss;
5239:
5240: SELECT rsi.fm_serial_num
5241: INTO l_serial_number
5242: FROM rcv_serials_interface rsi, rcv_transactions_interface rti
5243: WHERE rti.shipment_line_id = p_shipment_line_id
5244: AND rti.interface_transaction_id = rsi.interface_transaction_id;
5245:
5246: IF (l_debug = 1) THEN

Line 5741: FROM rcv_transactions_interface

5737: FROM mtl_transaction_lots_interface
5738: WHERE product_code = 'RCV'
5739: AND product_transaction_id
5740: IN (SELECT interface_transaction_id
5741: FROM rcv_transactions_interface
5742: WHERE parent_transaction_id = l_rtv_rec.rcv_transaction_id
5743: )
5744: AND lot_number = p_lot_number;
5745: EXCEPTION

Line 5840: SELECT rcv_transactions_interface_s.NEXTVAL

5836: END IF;
5837: GOTO nextrtrecord;
5838: END IF;
5839:
5840: SELECT rcv_transactions_interface_s.NEXTVAL
5841: INTO l_new_intf_id
5842: FROM dual;
5843:
5844: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN

Line 6137: SELECT rcv_transactions_interface_s.NEXTVAL

6133: l_rti_tb(l_txn_id)(l_lot_num).quantity
6134: := l_rti_tb(l_txn_id)(l_lot_num).quantity + 1;
6135:
6136: ELSE
6137: SELECT rcv_transactions_interface_s.NEXTVAL
6138: INTO l_new_intf_id
6139: FROM dual;
6140:
6141: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;