APPS.WSH_XC_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 3305: from wsh_delivery_details a, wsh_delivery_assignments_v b

3301: and a.delivery_id=p_delivery_id)
3302: AND p_delivery_id is not null
3303: AND p_delivery_contents = 'Y')
3304: /*OR (we.container_name in (select distinct a.container_name --LPN Synch Up..samanna
3305: from wsh_delivery_details a, wsh_delivery_assignments_v b
3306: where a.delivery_detail_id = b.delivery_detail_id
3307: and a.container_flag = 'Y'
3308: and b.delivery_id=p_delivery_id)
3309: AND p_delivery_id is not null

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

3697: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_delivery_id);
3698: /*Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3699: Exceptions_SQL := Exceptions_SQL || ' CONTAINER_NAME IN';
3700: Exceptions_SQL := Exceptions_SQL || ' (SELECT DISTINCT a.container_name';
3701: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_details a, wsh_delivery_assignments_v b';
3702: Exceptions_SQL := Exceptions_SQL || ' WHERE a.delivery_detail_id=b.delivery_detail_id';
3703: Exceptions_SQL := Exceptions_SQL || ' AND a.container_flag = ''Y''';
3704: Exceptions_SQL := Exceptions_SQL || ' AND b.delivery_id= :p_delivery_id)';
3705: Exceptions_SQL := Exceptions_SQL || ' UNION ALL';

Line 3958: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

3954: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);
3955:
3956: CURSOR Get_Details_Delivery(v_delivery_id NUMBER) IS
3957: SELECT wdd.delivery_detail_id, wdd.container_flag
3958: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
3959: WHERE wda.delivery_id = v_delivery_id
3960: AND wdd.delivery_detail_id = wda.delivery_detail_id
3961: ORDER BY wdd.container_flag;
3962:

Line 3998: FROM wsh_delivery_details

3994: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
3995:
3996: CURSOR Get_Container_Flag (v_delivery_detail_id NUMBER) IS
3997: SELECT container_flag
3998: FROM wsh_delivery_details
3999: WHERE delivery_detail_id = v_delivery_detail_id;
4000:
4001: CURSOR c_dummy_stop (v_stop_id NUMBER) IS
4002: SELECT stop_id

Line 4433: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

4429: ) IS
4430:
4431: CURSOR Get_Details_Delivery(v_delivery_id NUMBER) IS
4432: SELECT wdd.delivery_detail_id, wdd.container_flag
4433: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
4434: WHERE wda.delivery_id = v_delivery_id
4435: AND wdd.delivery_detail_id = wda.delivery_detail_id
4436: ORDER BY wdd.container_flag;
4437: