APPS.WSH_TP_RELEASE_INT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 73: wsh_delivery_assignments_v wda

69: wdd.vendor_id,
70: wdd.party_id,
71: wdd.wv_frozen_flag -- WV changes
72: FROM wsh_delivery_details wdd,
73: wsh_delivery_assignments_v wda
74: WHERE
75: (
76: wdd.source_code = x_plan_source_code
77: AND wdd.source_header_id = x_plan_source_header_id

Line 2851: FROM wsh_delivery_assignments_v wda

2847:
2848: -- make a flat list of contents within the topmost container.
2849: CURSOR c_contents(p_topmost_cont_id IN NUMBER) IS
2850: SELECT wda.delivery_detail_id
2851: FROM wsh_delivery_assignments_v wda
2852: START WITH wda.delivery_detail_id = p_topmost_cont_id
2853: CONNECT BY PRIOR wda.delivery_detail_id = wda.parent_delivery_detail_id;
2854:
2855: -- another cursor to look up the attributes

Line 6576: from wsh_delivery_assignments_v

6572:
6573: -- validate whether the delivery has a delivery detail.
6574: cursor c_empty_dels (p_del_id IN NUMBER) is
6575: select delivery_detail_id
6576: from wsh_delivery_assignments_v
6577: where delivery_id = p_del_id
6578: and delivery_id is not null
6579: and rownum = 1;
6580:

Line 6651: wsh_delivery_assignments_v wda

6647: wdd.earliest_pickup_date,
6648: wdd.latest_dropoff_date
6649: from wsh_delivery_details wdd,
6650: wsh_new_deliveries wnd,
6651: wsh_delivery_assignments_v wda
6652: where wdd.delivery_detail_id = wda.delivery_detail_id
6653: and wda.delivery_id = wnd.delivery_id
6654: and wnd.delivery_id is not null
6655: and (wdd.earliest_pickup_date > p_initial_pu_date or

Line 7858: FROM wsh_delivery_assignments_v a, wsh_delivery_details d

7854:
7855: -- check for any line in this delivery
7856: CURSOR c_has_line(p_delivery_id IN NUMBER) IS
7857: SELECT d.delivery_detail_id
7858: FROM wsh_delivery_assignments_v a, wsh_delivery_details d
7859: WHERE a.parent_delivery_detail_id is NULL
7860: AND a.delivery_id = p_delivery_id
7861: AND a.delivery_id IS NOT NULL
7862: AND a.delivery_detail_id = d.delivery_detail_id

Line 7872: FROM wsh_delivery_assignments_v a, wsh_delivery_details d

7868: CURSOR c_dangling_lpns(p_delivery_id IN NUMBER) IS
7869: SELECT d.delivery_detail_id,
7870: d.container_name,
7871: a.parent_delivery_detail_id
7872: FROM wsh_delivery_assignments_v a, wsh_delivery_details d
7873: WHERE a.delivery_id = p_delivery_id
7874: AND a.delivery_id IS NOT NULL
7875: AND a.delivery_detail_id = d.delivery_detail_id
7876: AND d.container_flag = 'Y'

Line 8142: FROM wsh_delivery_assignments_v a, wsh_delivery_details d

8138: d.container_flag,
8139: d.source_code,
8140: d.released_status,
8141: d.lpn_id
8142: FROM wsh_delivery_assignments_v a, wsh_delivery_details d
8143: WHERE a.parent_delivery_detail_id is NULL
8144: AND a.delivery_id = p_delivery_id
8145: AND a.delivery_id IS NOT NULL
8146: AND a.delivery_detail_id = d.delivery_detail_id

Line 8178: FROM wsh_delivery_assignments_v wda

8174: WHERE wdd.container_flag = 'N'
8175: AND wdd.released_status <> 'D' -- 4322654
8176: AND wdd.delivery_detail_id IN
8177: (SELECT wda.delivery_detail_id
8178: FROM wsh_delivery_assignments_v wda
8179: START WITH parent_delivery_detail_id = p_container_id
8180: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id);
8181:
8182:

Line 8196: FROM wsh_delivery_assignments_v wda

8192: WHERE wdd.container_flag = 'N'
8193: AND wdd.released_status = 'Y'
8194: AND wdd.delivery_detail_id IN
8195: (SELECT wda.delivery_detail_id
8196: FROM wsh_delivery_assignments_v wda
8197: START WITH parent_delivery_detail_id = p_container_id
8198: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id);
8199:
8200: WSH_PLANNED_DEL_NOT_MATCH EXCEPTION;