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

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 222: FROM rcv_transactions rt

218: rt.task_id
219: INTO l_movement_id,
220: l_project_id,
221: l_task_id
222: FROM rcv_transactions rt
223: WHERE rt.transaction_id = l_parent_transaction_id;
224:
225: /* FP-J Lot/Serial Support Enhancement
226: * Populate the LPN_GROUP_ID and validation_flag columns if INV and PO

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 874: rcv_transactions_sv.val_destination_info(

870: IF (l_debug = 1) THEN
871: print_debug('populate_default_values 20: ', 4);
872: END IF;
873:
874: rcv_transactions_sv.val_destination_info(
875: p_organization_id
876: , p_item_id
877: , NULL
878: , p_rcv_rcvtxn_rec.final_deliver_to_location_id

Line 1355: -- need to pick up rate from rcv_transactions

1351: l_matchflag := SUBSTR(l_matchflag, 1, 1);
1352: l_rcvtrxid := p_rcv_transaction_rec.rcv_transaction_id;
1353:
1354: IF l_matchflag = 'R' THEN
1355: -- need to pick up rate from rcv_transactions
1356: SELECT currency_conversion_date
1357: , currency_conversion_rate
1358: INTO l_ratedate
1359: , l_rate

Line 1360: FROM rcv_transactions

1356: SELECT currency_conversion_date
1357: , currency_conversion_rate
1358: INTO l_ratedate
1359: , l_rate
1360: FROM rcv_transactions
1361: WHERE transaction_id = l_rcvtrxid;
1362:
1363: p_rcv_transaction_rec.currency_conversion_rate := l_rate;
1364: p_rcv_transaction_rec.currency_conversion_date := l_ratedate;

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 1653: FROM rcv_transactions rt

1649: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
1650: --The following columns are needed for matching in cases where no LPN is involved
1651: , rsup.to_subinventory from_subinventory_code
1652: , rsup.to_locator_id from_locator_id
1653: FROM rcv_transactions rt
1654: , rcv_supply rsup
1655: , rcv_shipment_headers rsh
1656: , rcv_shipment_lines rsl
1657: , mtl_system_items msi

Line 2034: FROM rcv_transactions rt

2030: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
2031: --The following columns are needed for matching in cases where no LPN is involved
2032: , rsup.to_subinventory from_subinventory_code
2033: , rsup.to_locator_id from_locator_id
2034: FROM rcv_transactions rt
2035: , rcv_supply rsup
2036: , rcv_shipment_headers rsh
2037: , rcv_shipment_lines rsl
2038: , mtl_system_items msi

Line 2142: FROM rcv_transactions rt

2138: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
2139: --The following columns are needed for matching in cases where no LPN is involved
2140: , rsup.to_subinventory from_subinventory_code
2141: , rsup.to_locator_id from_locator_id
2142: FROM rcv_transactions rt
2143: , rcv_supply rsup
2144: , rcv_shipment_headers rsh
2145: , rcv_shipment_lines rsl
2146: , po_lines pol

Line 2819: FROM rcv_transactions rt

2815: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
2816: --The following columns are needed for matching in cases where no LPN is involved
2817: , rsup.to_subinventory from_subinventory_code
2818: , rsup.to_locator_id from_locator_id
2819: FROM rcv_transactions rt
2820: , rcv_supply rsup
2821: , rcv_shipment_headers rsh
2822: , rcv_shipment_lines rsl
2823: , mtl_system_items msi

Line 3550: FROM rcv_transactions rt

3546: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
3547: --The following columns are needed for matching in cases where no LPN is involved
3548: , rsup.to_subinventory from_subinventory_code
3549: , rsup.to_locator_id from_locator_id
3550: FROM rcv_transactions rt
3551: , rcv_supply rsup
3552: , rcv_shipment_headers rsh
3553: , rcv_shipment_lines rsl
3554: , mtl_system_items msi

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 5485: rcv_transactions rt,

5481: ,rs.secondary_quantity secondary_quantity
5482: ,msni.transaction_interface_id transaction_interface_id
5483: ,rsl.asn_line_flag asn_line_flag
5484: FROM rcv_supply rs,
5485: rcv_transactions rt,
5486: rcv_serials_supply rss,
5487: rcv_shipment_lines rsl,
5488: rcv_shipment_headers rsh,
5489: mtl_serial_numbers_interface msni

Line 5528: rcv_transactions rt,

5524: ,decode(rt.uom_code, p_rcvtxn_uom_code, 1, 2) ORDERING1
5525: ,decode(rt.uom_code, p_rcvtxn_uom_code, (p_rcvtxn_qty - rs.quantity), 0) ORDERING2
5526: ,rsl.asn_line_flag asn_line_flag
5527: FROM rcv_supply rs,
5528: rcv_transactions rt,
5529: rcv_shipment_lines rsl,
5530: rcv_lots_supply rls,
5531: rcv_shipment_headers rsh
5532: WHERE rs.item_id = p_item_id

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 5795: ( SELECT unit_of_measure FROM RCV_TRANSACTIONS

5791: SELECT UOM_CODE INTO l_rtv_rec.uom_code FROM
5792: mtl_item_uoms_view WHERE organization_id=p_organization_id
5793: AND inventory_item_id = p_item_id
5794: AND unit_of_measure =
5795: ( SELECT unit_of_measure FROM RCV_TRANSACTIONS
5796: WHERE TRANSACTION_ID = l_rtv_rec.rcv_transaction_id);
5797:
5798: EXCEPTION
5799: WHEN OTHERS THEN

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;