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'
64: AND rownum = 1;
109:
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'
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
873: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id )
874: GROUP BY org_id
875: HAVING org_id IS NOT NULL
937: --bug 4227777
938:
939: CURSOR l_get_lines_in_container_csr IS
940: SELECT wda.delivery_detail_id
941: FROM wsh_delivery_assignments_v wda
942: START WITH wda.parent_delivery_detail_id = p_delivery_detail_id
943: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id;
944:
945: CURSOR l_get_ship_to_contact_csr (p_detail_id NUMBER)