APPS.WSH_XC_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 3297: from wsh_delivery_details a, wsh_delivery_assignments_v b

3293: and a.delivery_id=p_delivery_id)
3294: AND p_delivery_id is not null
3295: AND p_delivery_contents = 'Y')
3296: /*OR (we.container_name in (select distinct a.container_name --LPN Synch Up..samanna
3297: from wsh_delivery_details a, wsh_delivery_assignments_v b
3298: where a.delivery_detail_id = b.delivery_detail_id
3299: and a.container_flag = 'Y'
3300: and b.delivery_id=p_delivery_id)
3301: AND p_delivery_id is not null

Line 3693: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_details a, wsh_delivery_assignments_v b';

3689: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_delivery_id);
3690: /*Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3691: Exceptions_SQL := Exceptions_SQL || ' CONTAINER_NAME IN';
3692: Exceptions_SQL := Exceptions_SQL || ' (SELECT DISTINCT a.container_name';
3693: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_details a, wsh_delivery_assignments_v b';
3694: Exceptions_SQL := Exceptions_SQL || ' WHERE a.delivery_detail_id=b.delivery_detail_id';
3695: Exceptions_SQL := Exceptions_SQL || ' AND a.container_flag = ''Y''';
3696: Exceptions_SQL := Exceptions_SQL || ' AND b.delivery_id= :p_delivery_id)';
3697: Exceptions_SQL := Exceptions_SQL || ' UNION ALL';

Line 3950: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

3946: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);
3947:
3948: CURSOR Get_Details_Delivery(v_delivery_id NUMBER) IS
3949: SELECT wdd.delivery_detail_id, wdd.container_flag
3950: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
3951: WHERE wda.delivery_id = v_delivery_id
3952: AND wdd.delivery_detail_id = wda.delivery_detail_id
3953: ORDER BY wdd.container_flag;
3954:

Line 3990: FROM wsh_delivery_details

3986: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
3987:
3988: CURSOR Get_Container_Flag (v_delivery_detail_id NUMBER) IS
3989: SELECT container_flag
3990: FROM wsh_delivery_details
3991: WHERE delivery_detail_id = v_delivery_detail_id;
3992:
3993: CURSOR c_dummy_stop (v_stop_id NUMBER) IS
3994: SELECT stop_id

Line 4425: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

4421: ) IS
4422:
4423: CURSOR Get_Details_Delivery(v_delivery_id NUMBER) IS
4424: SELECT wdd.delivery_detail_id, wdd.container_flag
4425: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
4426: WHERE wda.delivery_id = v_delivery_id
4427: AND wdd.delivery_detail_id = wda.delivery_detail_id
4428: ORDER BY wdd.container_flag;
4429: