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_ASSIGNMENTS

Line 35: -- as wsh_delivery_assignments.parent_delivery_detail_id is cleared after cancellation.

31: END get_uom_from_code;
32:
33: --RTV2 rtv project phase 2 : start
34: -- Get_return_lpn_id() function should not be used to fetch lpn_id after cancellation
35: -- as wsh_delivery_assignments.parent_delivery_detail_id is cleared after cancellation.
36: FUNCTION get_return_lpn_id
37: ( p_wdd_id IN NUMBER)
38: RETURN NUMBER IS
39: l_lpn_id number;

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 981: wsh_delivery_assignments wda,

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
985: AND wdd.source_code = 'RTV'

Line 999: wsh_delivery_assignments wda,

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
1003: AND wdd.source_code = 'RTV'

Line 1020: wsh_delivery_assignments wda,

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
1024: AND wdd.source_code = 'RTV'

Line 1041: wsh_delivery_assignments wda,

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
1045: AND wdd.source_code = 'RTV'

Line 1065: wsh_delivery_assignments wda,

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
1069: AND wdd.source_code = 'RTV'

Line 1080: wsh_delivery_assignments wda,

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
1084: AND wdd.source_code = 'RTV'

Line 2607: wsh_delivery_assignments wda,

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
2611: AND wda.delivery_id = p_delivery_id

Line 2639: wsh_delivery_assignments wda,

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
2643: AND wda.delivery_id = p_delivery_id

Line 2998: wsh_delivery_assignments wda

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'
3002: AND wdd1.lpn_id is not null

Line 3125: --from wsh_delivery_assignments

3121: IF (g_asn_debug = 'Y') THEN
3122: asn_debug.put_line('before calling wms_return_sv.unmark_returns for lpn_id:'|| l_lpn_id);
3123: END IF;
3124: --we should pass lpn_id here, since we are not able to fetch lpn_id
3125: --from wsh_delivery_assignments
3126: unmark_wdd_lpn(p_wdd_rec => wdd_rec,
3127: p_lpn_id => l_lpn_id,
3128: x_return_status => l_return_status,
3129: x_msg_count => l_msg_count,

Line 3137: FROM wsh_delivery_assignments

3133: END IF;
3134: --check if relevant contaienr wdd is fully cancelled , if yes, delete it.
3135: SELECT count(1)
3136: INTO l_count
3137: FROM wsh_delivery_assignments
3138: WHERE parent_delivery_detail_id = l_wdd_lpns(indx).lpn_wdd_id;
3139: IF( l_count = 0 ) THEN
3140: IF (g_asn_debug = 'Y') THEN
3141: asn_debug.put_line('before deleting container wdd :'||l_wdd_lpns(indx).lpn_wdd_id);

Line 3155: --from wsh_delivery_assignments

3151: END IF;
3152: END LOOP;
3153: END IF;
3154: --we should pass lpn_id here, since we are not able to fetch lpn_id
3155: --from wsh_delivery_assignments
3156: relieve_return_reservation(p_wdd_rec => wdd_rec,
3157: p_lpn_id => l_lpn_id,
3158: x_return_status => l_return_status,
3159: x_msg_count => l_msg_count,