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.RCV_WSH_INTERFACE_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 118: DELETE FROM rcv_transactions_interface

114:
115: PROCEDURE remove_RTV_order
116: ( p_bkup_rti_id IN NUMBER) IS
117: BEGIN
118: DELETE FROM rcv_transactions_interface
119: WHERE interface_transaction_id = p_bkup_rti_id;
120: IF (g_asn_debug = 'Y') THEN
121: asn_debug.put_line('DELETED RTI');
122: END IF;

Line 373: FROM rcv_transactions_interface

369: to_organization_id
370: INTO l_lpn_id,
371: l_new_rti_id,
372: l_new_org_id
373: FROM rcv_transactions_interface
374: WHERE group_id = p_group_id
375: AND interface_source_line_id = p_wdd_rec.delivery_detail_id;
376:
377: --re-create MR

Line 436: FROM rcv_transactions_interface new_rti,

432: new_rti.from_locator_id,
433: new_rti.transfer_lpn_id,
434: new_rti.uom_code,
435: sum(new_rti.quantity) quantity
436: FROM rcv_transactions_interface new_rti,
437: rcv_transactions_interface rtv_rti,
438: wsh_delivery_Details wdd
439: WHERE new_rti.group_id = p_group_id
440: AND new_rti.interface_source_line_id IS NOT NULL

Line 437: rcv_transactions_interface rtv_rti,

433: new_rti.transfer_lpn_id,
434: new_rti.uom_code,
435: sum(new_rti.quantity) quantity
436: FROM rcv_transactions_interface new_rti,
437: rcv_transactions_interface rtv_rti,
438: wsh_delivery_Details wdd
439: WHERE new_rti.group_id = p_group_id
440: AND new_rti.interface_source_line_id IS NOT NULL
441: AND new_rti.transfer_lpn_id IS NOT NULL

Line 516: rti_rec RCV_TRANSACTIONS_INTERFACE%ROWTYPE;

512: FROM mtl_transaction_lots_temp
513: WHERE transaction_temp_id = p_interface_txn_id;
514:
515: l_progress VARCHAR2(3);
516: rti_rec RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
517: l_primary_uom VARCHAR2(25);
518: l_price NUMBER;
519: l_price_in_fc NUMBER;
520: l_currency VARCHAR2(3);

Line 549: FROM rcv_transactions_interface

545:
546: l_progress := '000';
547: SELECT *
548: INTO rti_rec
549: FROM rcv_transactions_interface
550: WHERE interface_transaction_id = p_interface_txn_id;
551:
552: l_progress := '010';
553: l_IN_rec.caller := 'WSH_PUB';

Line 982: rcv_transactions_interface rti

978: CURSOR wdd_cursor_1 IS
979: SELECT wdd.*
980: FROM wsh_delivery_details wdd,
981: wsh_delivery_assignments wda,
982: rcv_transactions_interface rti
983: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
984: AND wda.delivery_id = p_delivery_id
985: AND wdd.source_code = 'RTV'
986: AND wdd.released_status = 'C'

Line 1000: rcv_transactions_interface rti

996: CURSOR wdd_cursor_2 IS
997: SELECT wdd.*
998: FROM wsh_delivery_details wdd,
999: wsh_delivery_assignments wda,
1000: rcv_transactions_interface rti
1001: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1002: AND wda.delivery_id = p_delivery_id
1003: AND wdd.source_code = 'RTV'
1004: AND wdd.released_status = 'C'

Line 1021: rcv_transactions_interface rti

1017: CURSOR wdd_cursor_3 IS
1018: SELECT wdd.*
1019: FROM wsh_delivery_details wdd,
1020: wsh_delivery_assignments wda,
1021: rcv_transactions_interface rti
1022: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1023: AND wda.delivery_id = p_delivery_id
1024: AND wdd.source_code = 'RTV'
1025: AND wdd.released_status = 'C'

Line 1042: rcv_transactions_interface rti

1038: CURSOR wdd_cursor_4 IS
1039: SELECT wdd.*
1040: FROM wsh_delivery_details wdd,
1041: wsh_delivery_assignments wda,
1042: rcv_transactions_interface rti
1043: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1044: AND wda.delivery_id = p_delivery_id
1045: AND wdd.source_code = 'RTV'
1046: AND wdd.released_status = 'C'

Line 1415: FROM rcv_transactions_interface

1411: asn_debug.put_line('Inside invoke_RTP');
1412:
1413: SELECT COUNT(*)
1414: INTO l_rcv_count
1415: FROM rcv_transactions_interface
1416: WHERE group_id = p_group_id;
1417: asn_debug.put_line('RTI record count for group_id ' || p_group_id || ' : ' || l_rcv_count);
1418:
1419: l_status := fnd_transaction.synchronous

Line 1602: rcv_transactions_interface rti,

1598: --
1599: SELECT rt.subinventory, rt.locator_id, rt.organization_id, rti.rma_reference, mp.WMS_ENABLED_FLAG -- Bug 12974284
1600: INTO l_deliver_subinv, l_deliver_locator, l_receipt_org, l_txn_reference, l_wms_rec_org -- Bug 12974284
1601: FROM rcv_transactions rt,
1602: rcv_transactions_interface rti,
1603: mtl_parameters mp
1604: WHERE rt.transaction_id = rti.parent_transaction_id
1605: AND rti.interface_transaction_id = p_wdd_rec.source_line_id
1606: AND rt.transaction_type = 'DELIVER'

Line 1692: FROM rcv_transactions_interface

1688: AND wnd.delivery_id = p_delivery_id;
1689: --
1690: SELECT rma_reference
1691: INTO l_txn_reference
1692: FROM rcv_transactions_interface
1693: WHERE interface_transaction_id = p_wdd_rec.source_line_id; -- Bug 12974284
1694: --
1695: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232
1696: --

Line 1824: rti_rec rcv_transactions_interface%ROWTYPE;

1820: l_shipped_uom mtl_units_of_measure.unit_of_measure%TYPE;
1821: l_shipped_uom2 mtl_units_of_measure.unit_of_measure%TYPE := NULL;
1822: l_primary_qty NUMBER;
1823: l_marker_flag BOOLEAN := FALSE;
1824: rti_rec rcv_transactions_interface%ROWTYPE;
1825: l_rev_control NUMBER;
1826: l_txn_date date;
1827: l_from_subinventory rcv_transactions_interface.from_subinventory%TYPE;
1828: l_from_locator_id NUMBER;

Line 1827: l_from_subinventory rcv_transactions_interface.from_subinventory%TYPE;

1823: l_marker_flag BOOLEAN := FALSE;
1824: rti_rec rcv_transactions_interface%ROWTYPE;
1825: l_rev_control NUMBER;
1826: l_txn_date date;
1827: l_from_subinventory rcv_transactions_interface.from_subinventory%TYPE;
1828: l_from_locator_id NUMBER;
1829: --RTV2 rtv project phase 2 : start
1830: l_rec_wms_org VARCHAR2(1);
1831: l_return_status VARCHAR2(1);

Line 1853: FROM rcv_transactions_interface

1849: END IF;
1850: --
1851: SELECT *
1852: INTO rti_rec
1853: FROM rcv_transactions_interface
1854: WHERE interface_transaction_id = p_wdd_rec.source_line_id;
1855:
1856: IF (g_asn_debug = 'Y') THEN
1857: asn_debug.put_line('rti_rec.primary_unit_of_measure : ' || rti_rec.primary_unit_of_measure);

Line 1952: SELECT rcv_transactions_interface_s.nextval INTO l_rti_id FROM DUAL; -- Bug 11831232

1948: AND wdl.pick_up_stop_id = wts.stop_id
1949: AND wnd.initial_pickup_location_id = wts.stop_location_id
1950: AND wnd.delivery_id = p_delivery_id;
1951: --
1952: SELECT rcv_transactions_interface_s.nextval INTO l_rti_id FROM DUAL; -- Bug 11831232
1953: --
1954: INSERT INTO rcv_transactions_interface
1955: ( receipt_source_code,
1956: interface_transaction_id,

Line 1954: INSERT INTO rcv_transactions_interface

1950: AND wnd.delivery_id = p_delivery_id;
1951: --
1952: SELECT rcv_transactions_interface_s.nextval INTO l_rti_id FROM DUAL; -- Bug 11831232
1953: --
1954: INSERT INTO rcv_transactions_interface
1955: ( receipt_source_code,
1956: interface_transaction_id,
1957: interface_source_line_id,
1958: group_id,

Line 2270: rcv_transactions_interface rti

2266: SELECT msi.lot_control_code, msi.serial_number_control_code,
2267: rti.to_organization_id, rti.item_id
2268: INTO l_lot_control, l_serial_control, l_rti_org_id, l_rti_item_id
2269: FROM mtl_system_items msi,
2270: rcv_transactions_interface rti
2271: WHERE msi.organization_id = rti.to_organization_id
2272: AND msi.inventory_item_id = rti.item_id
2273: AND rti.interface_transaction_id = p_parent_id;
2274:

Line 2609: rcv_transactions_interface rti

2605: rti.source_doc_unit_of_measure bkup_rti_src_uom
2606: FROM wsh_delivery_details wdd,
2607: wsh_delivery_assignments wda,
2608: rcv_transactions rt,
2609: rcv_transactions_interface rti
2610: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2611: AND wda.delivery_id = p_delivery_id
2612: AND wdd.source_code = 'RTV'
2613: AND wdd.released_status = 'C'

Line 2641: rcv_transactions_interface rti

2637: rti.source_doc_unit_of_measure bkup_rti_src_uom
2638: FROM wsh_delivery_details wdd,
2639: wsh_delivery_assignments wda,
2640: mtl_material_transactions mmt,
2641: rcv_transactions_interface rti
2642: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2643: AND wda.delivery_id = p_delivery_id
2644: AND wdd.source_code = 'RTV'
2645: AND wdd.released_status = 'C'

Line 2849: UPDATE rcv_transactions_interface

2845: IF (g_asn_debug = 'Y') THEN
2846: asn_debug.put_line('l_src_uom_qty : ' || l_src_uom_qty);
2847: END IF;
2848: --
2849: UPDATE rcv_transactions_interface
2850: SET quantity = l_txn_qty,
2851: secondary_quantity = secondary_quantity - l_shipped_qty2,
2852: primary_quantity = primary_quantity - l_primary_qty,
2853: source_doc_quantity = l_src_uom_qty

Line 2914: FROM rcv_transactions_interface

2910: BEGIN
2911: DELETE FROM mtl_serial_numbers_interface
2912: WHERE product_transaction_id IN
2913: (SELECT interface_transaction_id
2914: FROM rcv_transactions_interface
2915: WHERE group_id = p_group_id
2916: AND processing_mode_code = 'ONLINE');
2917:
2918: EXCEPTION

Line 2927: FROM rcv_transactions_interface

2923: BEGIN
2924: DELETE FROM mtl_transaction_lots_interface
2925: WHERE product_transaction_id IN
2926: (SELECT interface_transaction_id
2927: FROM rcv_transactions_interface
2928: WHERE group_id = p_group_id
2929: AND processing_mode_code = 'ONLINE');
2930:
2931: EXCEPTION

Line 2936: DELETE FROM rcv_transactions_interface

2932: WHEN OTHERS THEN NULL;
2933: END;
2934: asn_debug.put_line('After deleting MTLI : count = ' || sql%rowcount);
2935: --
2936: DELETE FROM rcv_transactions_interface
2937: WHERE group_id = p_group_id
2938: AND processing_mode_code = 'ONLINE';
2939: asn_debug.put_line('After deleting RTI : count = ' || sql%rowcount);
2940: --

Line 3052: FROM rcv_transactions_interface

3048: l_rti_suom,
3049: l_rti_src_uom,
3050: l_transfer_lpn_id, -- RTV2 rtv project phase 2
3051: l_rtv_order -- RTV2 rtv project phase 2
3052: FROM rcv_transactions_interface
3053: WHERE interface_transaction_id = p_rti_id_tbl(i)
3054: AND transaction_type = 'RETURN TO VENDOR';
3055:
3056: SELECT max(source_header_id), max(requested_quantity_uom)

Line 3238: UPDATE rcv_transactions_interface

3234: IF (g_asn_debug = 'Y') THEN
3235: asn_debug.put_line('l_rti_new_src_qty : ' || l_rti_new_src_qty);
3236: END IF;
3237: --
3238: UPDATE rcv_transactions_interface
3239: SET quantity = l_rti_new_qty,
3240: primary_quantity = l_rti_new_pqty,
3241: secondary_quantity = l_rti_new_sqty,
3242: source_doc_quantity = l_rti_new_src_qty

Line 3248: --DELETE FROM rcv_transactions_interface

3244: ELSE
3245: --RTV project phase 2 : start
3246: --call remove_RTV_order() instead of delete RTI directly, as we also need to handle
3247: --serial and lot interface tables.
3248: --DELETE FROM rcv_transactions_interface
3249: --WHERE interface_transaction_id = p_rti_id_tbl(i);
3250: remove_RTV_order(p_rti_id_tbl(i));
3251: --RTV project phase 2 : end
3252: END IF;