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

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

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

846: IF (l_debug = 1) THEN
847: print_debug('populate_default_values 20: ', 4);
848: END IF;
849:
850: rcv_transactions_sv.val_destination_info(
851: p_organization_id
852: , p_item_id
853: , NULL
854: , p_rcv_rcvtxn_rec.final_deliver_to_location_id

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

1327: l_matchflag := SUBSTR(l_matchflag, 1, 1);
1328: l_rcvtrxid := p_rcv_transaction_rec.rcv_transaction_id;
1329:
1330: IF l_matchflag = 'R' THEN
1331: -- need to pick up rate from rcv_transactions
1332: SELECT currency_conversion_date
1333: , currency_conversion_rate
1334: INTO l_ratedate
1335: , l_rate

Line 1336: FROM rcv_transactions

1332: SELECT currency_conversion_date
1333: , currency_conversion_rate
1334: INTO l_ratedate
1335: , l_rate
1336: FROM rcv_transactions
1337: WHERE transaction_id = l_rcvtrxid;
1338:
1339: p_rcv_transaction_rec.currency_conversion_rate := l_rate;
1340: p_rcv_transaction_rec.currency_conversion_date := l_ratedate;

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

1615: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
1616: --The following columns are needed for matching in cases where no LPN is involved
1617: , rsup.to_subinventory from_subinventory_code
1618: , rsup.to_locator_id from_locator_id
1619: FROM rcv_transactions rt
1620: , rcv_supply rsup
1621: , rcv_shipment_headers rsh
1622: , rcv_shipment_lines rsl
1623: , mtl_system_items msi

Line 2000: FROM rcv_transactions rt

1996: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
1997: --The following columns are needed for matching in cases where no LPN is involved
1998: , rsup.to_subinventory from_subinventory_code
1999: , rsup.to_locator_id from_locator_id
2000: FROM rcv_transactions rt
2001: , rcv_supply rsup
2002: , rcv_shipment_headers rsh
2003: , rcv_shipment_lines rsl
2004: , mtl_system_items msi

Line 2108: FROM rcv_transactions rt

2104: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
2105: --The following columns are needed for matching in cases where no LPN is involved
2106: , rsup.to_subinventory from_subinventory_code
2107: , rsup.to_locator_id from_locator_id
2108: FROM rcv_transactions rt
2109: , rcv_supply rsup
2110: , rcv_shipment_headers rsh
2111: , rcv_shipment_lines rsl
2112: , po_lines pol

Line 2785: FROM rcv_transactions rt

2781: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
2782: --The following columns are needed for matching in cases where no LPN is involved
2783: , rsup.to_subinventory from_subinventory_code
2784: , rsup.to_locator_id from_locator_id
2785: FROM rcv_transactions rt
2786: , rcv_supply rsup
2787: , rcv_shipment_headers rsh
2788: , rcv_shipment_lines rsl
2789: , mtl_system_items msi

Line 3454: FROM rcv_transactions rt

3450: , rt.SECONDARY_UNIT_OF_MEASURE --OPM Convergence
3451: --The following columns are needed for matching in cases where no LPN is involved
3452: , rsup.to_subinventory from_subinventory_code
3453: , rsup.to_locator_id from_locator_id
3454: FROM rcv_transactions rt
3455: , rcv_supply rsup
3456: , rcv_shipment_headers rsh
3457: , rcv_shipment_lines rsl
3458: , mtl_system_items msi

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

5359: ,rs.secondary_quantity secondary_quantity
5360: ,msni.transaction_interface_id transaction_interface_id
5361: ,rsl.asn_line_flag asn_line_flag
5362: FROM rcv_supply rs,
5363: rcv_transactions rt,
5364: rcv_serials_supply rss,
5365: rcv_shipment_lines rsl,
5366: rcv_shipment_headers rsh,
5367: mtl_serial_numbers_interface msni

Line 5406: rcv_transactions rt,

5402: ,decode(rt.uom_code, p_rcvtxn_uom_code, 1, 2) ORDERING1
5403: ,decode(rt.uom_code, p_rcvtxn_uom_code, (p_rcvtxn_qty - rs.quantity), 0) ORDERING2
5404: ,rsl.asn_line_flag asn_line_flag
5405: FROM rcv_supply rs,
5406: rcv_transactions rt,
5407: rcv_shipment_lines rsl,
5408: rcv_lots_supply rls,
5409: rcv_shipment_headers rsh
5410: WHERE rs.item_id = p_item_id

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

5656: SELECT UOM_CODE INTO l_rtv_rec.uom_code FROM
5657: mtl_item_uoms_view WHERE organization_id=p_organization_id
5658: AND inventory_item_id = p_item_id
5659: AND unit_of_measure =
5660: ( SELECT unit_of_measure FROM RCV_TRANSACTIONS
5661: WHERE TRANSACTION_ID = l_rtv_rec.rcv_transaction_id);
5662:
5663: EXCEPTION
5664: WHEN OTHERS THEN

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;