APPS.WSH_MAPPING_DATA dependencies on WSH_DELIVERY_DETAILS

Line 59: FROM wsh_delivery_details wdd,

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

Line 114: wsh_delivery_details wdd

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

Line 868: FROM wsh_delivery_details wdd

864: HCSU.SITE_USE_CODE;
865:
866: CURSOR org_id_cur(p_del_detail_id NUMBER) IS
867: SELECT wdd.org_id org_id, count(*) cnt
868: FROM wsh_delivery_details wdd
869: WHERE wdd.delivery_detail_id IN
870: (SELECT wda.delivery_detail_id
871: FROM wsh_delivery_assignments_v wda
872: START WITH delivery_detail_id = p_del_detail_id

Line 948: FROM wsh_delivery_details wdd

944:
945: CURSOR l_get_ship_to_contact_csr (p_detail_id NUMBER)
946: IS
947: SELECT wdd.ship_to_contact_id
948: FROM wsh_delivery_details wdd
949: WHERE wdd.delivery_detail_id = p_detail_id
950: AND wdd.container_flag = 'N';
951:
952: