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 WSH_DELIVERY_DETAILS

Line 51: FROM wsh_delivery_Details wdd, wsh_delivery_assignments wda

47: END IF;
48:
49: SELECT wdd.lpn_id
50: into l_lpn_id
51: FROM wsh_delivery_Details wdd, wsh_delivery_assignments wda
52: WHERE wdd.delivery_detail_id(+) = wda.parent_delivery_detail_id
53: AND wda.delivery_detail_id = p_wdd_id;
54:
55: IF (g_asn_debug = 'Y') THEN

Line 67: PROCEDURE unmark_wdd_lpn(p_wdd_rec IN wsh_delivery_details%rowtype,

63: END IF;
64: raise fnd_api.g_exc_unexpected_error;
65: END get_return_lpn_id;
66:
67: PROCEDURE unmark_wdd_lpn(p_wdd_rec IN wsh_delivery_details%rowtype,
68: p_lpn_id IN NUMBER DEFAULT NULL,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 265: ( p_wdd_rec IN WSH_DELIVERY_DETAILS%ROWTYPE,

261: END create_return_reservation;
262: --
263:
264: PROCEDURE relieve_return_reservation
265: ( p_wdd_rec IN WSH_DELIVERY_DETAILS%ROWTYPE,
266: p_lpn_id IN NUMBER, ---- RTV2 rtv project phase 2
267: x_return_status OUT NOCOPY VARCHAR2, ---- RTV2 rtv project phase 2
268: x_msg_count OUT NOCOPY NUMBER, ---- RTV2 rtv project phase 2
269: x_msg_data OUT NOCOPY VARCHAR2) IS ---- RTV2 rtv project phase 2

Line 329: ( p_wdd_rec IN WSH_DELIVERY_DETAILS%ROWTYPE) IS

325: END relieve_return_reservation;
326:
327: -- RTV2 rtv project phase 2 : start
328: PROCEDURE relieve_return_reservation
329: ( p_wdd_rec IN WSH_DELIVERY_DETAILS%ROWTYPE) IS
330:
331: l_lpn_id NUMBER;
332: l_return_status VARCHAR2(1);
333: l_msg_count NUMBER;

Line 356: PROCEDURE rollback_rtp_fail( p_wdd_rec IN wsh_delivery_details%rowtype,

352: END IF;
353: raise fnd_api.g_exc_unexpected_error;
354: END relieve_return_reservation;
355: --
356: PROCEDURE rollback_rtp_fail( p_wdd_rec IN wsh_delivery_details%rowtype,
357: p_group_id IN NUMBER) IS
358: l_lpn_id NUMBER;
359: l_new_rti_id NUMBER;
360: l_new_org_id NUMBER;

Line 362: l_wdd_rec2 wsh_delivery_details%rowtype;

358: l_lpn_id NUMBER;
359: l_new_rti_id NUMBER;
360: l_new_org_id NUMBER;
361: l_wdd_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
362: l_wdd_rec2 wsh_delivery_details%rowtype;
363: l_return_status VARCHAR2(1);
364: l_msg_count NUMBER;
365: l_msg_data VARCHAR2(2000);
366: BEGIN

Line 438: wsh_delivery_Details wdd

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
442: AND new_rti.processing_mode_code = 'ONLINE'

Line 613: FROM wsh_delivery_details

609: l_progress := '020';
610: BEGIN
611: SELECT substr (nvl(max(to_number(source_line_number)),0.1)+1, 1, instr(nvl(max(to_number(source_line_number)),0.1)+1,'.')-1) || '.1'
612: INTO l_wdd_tbl(1).source_line_number
613: FROM wsh_delivery_details
614: WHERE source_header_number = to_char(rti_rec.group_id)
615: AND source_code = 'RTV';
616: EXCEPTION
617: WHEN OTHERS THEN

Line 980: FROM wsh_delivery_details wdd,

976:
977: -- Cursor for picking Returns agaist no document
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

Line 998: FROM wsh_delivery_details wdd,

994:
995: -- Cursor for picking Returns made from the Receipt's org
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

Line 1019: FROM wsh_delivery_details wdd,

1015:
1016: -- Cursor for picking Returns made from an org different from Receipt's org for Direct org txr
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

Line 1040: FROM wsh_delivery_details wdd,

1036:
1037: -- Cursor for picking Returns made from an org different from Receipt's org which are pending after DIrect org txr.
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

Line 1064: FROM wsh_delivery_details wdd,

1060:
1061: -- Cursors for picking wdds that should be updated as inv_interfaced.
1062: CURSOR wdd_cursor_5 IS
1063: SELECT wdd.delivery_detail_id
1064: FROM wsh_delivery_details wdd,
1065: wsh_delivery_assignments wda,
1066: rcv_transactions rt
1067: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1068: AND wda.delivery_id = p_delivery_id

Line 1079: FROM wsh_delivery_details wdd,

1075: FOR UPDATE OF inv_interfaced_flag nowait;
1076:
1077: CURSOR wdd_cursor_6 IS
1078: SELECT wdd.delivery_detail_id
1079: FROM wsh_delivery_details wdd,
1080: wsh_delivery_assignments wda,
1081: mtl_material_transactions mmt
1082: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1083: AND wda.delivery_id = p_delivery_id

Line 1557: p_wdd_rec IN wsh_delivery_details%rowtype,

1553:
1554: ===========================================================================*/
1555: PROCEDURE load_mtl_interfaces
1556: ( p_txn_desc IN VARCHAR2,
1557: p_wdd_rec IN wsh_delivery_details%rowtype,
1558: p_header_id IN NUMBER,
1559: p_delivery_id IN NUMBER) IS
1560:
1561: CURSOR msnt_cursor IS

Line 1816: p_wdd_rec IN wsh_delivery_details%rowtype,

1812:
1813: ===========================================================================*/
1814: PROCEDURE load_rcv_interfaces (
1815: p_delivery_id IN NUMBER,
1816: p_wdd_rec IN wsh_delivery_details%rowtype,
1817: p_group_id IN NUMBER) IS
1818:
1819: l_rti_id NUMBER; -- Bug 11831232
1820: l_shipped_uom mtl_units_of_measure.unit_of_measure%TYPE;

Line 2231: p_wdd_rec IN wsh_delivery_details%rowtype,

2227:
2228: ===========================================================================*/
2229: PROCEDURE load_lot_serial_interfaces (
2230: p_source IN VARCHAR2,
2231: p_wdd_rec IN wsh_delivery_details%rowtype,
2232: p_parent_id IN NUMBER) IS
2233:
2234: CURSOR WSN_cursor IS
2235: SELECT *

Line 2606: FROM wsh_delivery_details wdd,

2602: rti.unit_of_measure bkup_rti_uom,
2603: rti.primary_unit_of_measure bkup_rti_puom,
2604: rti.secondary_unit_of_measure bkup_rti_suom,
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

Line 2638: FROM wsh_delivery_details wdd,

2634: rti.unit_of_measure bkup_rti_uom,
2635: rti.primary_unit_of_measure bkup_rti_puom,
2636: rti.secondary_unit_of_measure bkup_rti_suom,
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

Line 2985: FROM wsh_delivery_details

2981: e_cancel_unpack_lpn_error EXCEPTION; -- RTV2 rtv project phase 2
2982:
2983: CURSOR cancelled_wdd_cur (p_src_line_id NUMBER) IS
2984: SELECT *
2985: FROM wsh_delivery_details
2986: WHERE source_code = 'RTV'
2987: AND source_line_id = p_src_line_id
2988: AND released_status = 'D'
2989: AND container_flag = 'N';

Line 2996: FROM wsh_delivery_details wdd1,

2992: CURSOR cancelled_lpn_cur (p_src_line_id NUMBER) IS
2993: SELECT distinct wdd1.lpn_id,
2994: wdd2.delivery_detail_id,
2995: wdd1.delivery_detail_id lpn_wdd_id
2996: FROM wsh_delivery_details wdd1,
2997: wsh_delivery_Details wdd2,
2998: wsh_delivery_assignments wda
2999: WHERE wdd2.source_code = 'RTV'
3000: AND wdd2.source_line_id = p_src_line_id

Line 2997: wsh_delivery_Details wdd2,

2993: SELECT distinct wdd1.lpn_id,
2994: wdd2.delivery_detail_id,
2995: wdd1.delivery_detail_id lpn_wdd_id
2996: FROM wsh_delivery_details wdd1,
2997: wsh_delivery_Details wdd2,
2998: wsh_delivery_assignments wda
2999: WHERE wdd2.source_code = 'RTV'
3000: AND wdd2.source_line_id = p_src_line_id
3001: AND wdd1.container_flag = 'Y'

Line 3059: FROM wsh_delivery_details

3055:
3056: SELECT max(source_header_id), max(requested_quantity_uom)
3057: INTO l_source_header_id,
3058: l_wdd_uom_code
3059: FROM wsh_delivery_details
3060: WHERE source_line_id = p_rti_id_tbl(i)
3061: AND source_code = 'RTV';
3062:
3063: IF (g_asn_debug = 'Y') THEN