APPS.WSH_MAPPING_DATA dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 61: wsh_delivery_assignments_v wda

57: CURSOR l_src_hdr_no_cur
58: IS
59: SELECT wdd.source_header_number
60: FROM wsh_delivery_details wdd,
61: wsh_delivery_assignments_v wda
62: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
63: AND wda.delivery_id = p_delivery_id
64: AND wdd.container_flag= 'N'
65: AND rownum = 1;

Line 114: FROM wsh_delivery_assignments_v wda,

110:
111: --bug 3920178 {
112: cursor l_ship_to_site_use_id_csr( p_delivery_id IN NUMBER) is
113: SELECT wdd.ship_to_site_use_id ship_to_site_use_id , count(*) cnt
114: FROM wsh_delivery_assignments_v wda,
115: wsh_delivery_details wdd
116: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
117: AND wda.delivery_id = p_delivery_id
118: AND wdd.container_flag = 'N'

Line 873: FROM wsh_delivery_assignments_v wda

869: SELECT wdd.org_id org_id, count(*) cnt
870: FROM wsh_delivery_details wdd
871: WHERE wdd.delivery_detail_id IN
872: (SELECT wda.delivery_detail_id
873: FROM wsh_delivery_assignments_v wda
874: START WITH delivery_detail_id = p_del_detail_id
875: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id )
876: GROUP BY org_id
877: HAVING org_id IS NOT NULL

Line 943: FROM wsh_delivery_assignments_v wda

939: --bug 4227777
940:
941: CURSOR l_get_lines_in_container_csr IS
942: SELECT wda.delivery_detail_id
943: FROM wsh_delivery_assignments_v wda
944: START WITH wda.parent_delivery_detail_id = p_delivery_detail_id
945: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id;
946:
947: CURSOR l_get_ship_to_contact_csr (p_detail_id NUMBER)

Line 1380: FROM wsh_delivery_assignments_v wda,

1376: wsh_invalid_delivery_id EXCEPTION;
1377:
1378: CURSOR l_ship_to_site_use_id_csr( c_delivery_id IN NUMBER) is
1379: SELECT wdd.ship_to_site_use_id ship_to_site_use_id , count(*) cnt
1380: FROM wsh_delivery_assignments_v wda,
1381: wsh_delivery_details wdd
1382: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1383: AND wda.delivery_id = c_delivery_id
1384: AND wdd.container_flag = 'N'

Line 2018: FROM wsh_delivery_assignments_v wda

2014:
2015:
2016: CURSOR c_get_lines_in_container_csr IS
2017: SELECT wda.delivery_detail_id
2018: FROM wsh_delivery_assignments_v wda
2019: START WITH wda.parent_delivery_detail_id = p_delivery_detail_id
2020: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id;
2021:
2022: CURSOR c_get_sites_contacts (c_detail_id NUMBER)

Line 2444: wsh_delivery_assignments_v wda,

2440: CURSOR c_del_sites IS
2441: SELECT ol.ship_to_org_id,
2442: ol.invoice_to_org_id
2443: FROM wsh_new_deliveries wnd,
2444: wsh_delivery_assignments_v wda,
2445: wsh_delivery_details wdd,
2446: oe_order_lines_all ol
2447: WHERE wnd.delivery_id = p_delivery_id
2448: AND wnd.delivery_id = wda.delivery_id

Line 2602: wsh_delivery_assignments_v wda,

2598: BEGIN
2599: select distinct ol.ship_to_contact_id
2600: into l_ship_to_contact_id
2601: from wsh_new_deliveries wnd,
2602: wsh_delivery_assignments_v wda,
2603: wsh_delivery_details wdd,
2604: oe_order_lines_all ol
2605: where wnd.delivery_id = p_delivery_id
2606: and wnd.delivery_id = wda.delivery_id

Line 2662: wsh_delivery_assignments_v wda,

2658: BEGIN
2659: select distinct ol.invoice_to_contact_id
2660: into l_bill_to_contact_id
2661: from wsh_new_deliveries wnd,
2662: wsh_delivery_assignments_v wda,
2663: wsh_delivery_details wdd,
2664: oe_order_lines_all ol
2665: where wnd.delivery_id = p_delivery_id
2666: and wnd.delivery_id = wda.delivery_id