APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 446: FROM wsh_delivery_assignments

442: UPDATE wsh_delivery_details
443: SET released_status = 'Y'
444: WHERE delivery_detail_id IN (
445: SELECT delivery_detail_id
446: FROM wsh_delivery_assignments
447: WHERE delivery_id = p_delivery_id)
448: AND released_status IN ('R', 'B', 'X')
449: AND container_flag = 'N'
450: RETURNING delivery_detail_id, organization_id BULK COLLECT INTO l_detail_tab, l_organization_tab; -- Added for TPW - Distributed changes;

Line 647: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

643: decode(wddi.container_flag, 'Y', wdai.parent_delivery_detail_id,null) desc nulls first;
644:
645: CURSOR cont_inst_exists(l_del_det_id NUMBER) IS
646: SELECT count(*)
647: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
648: WHERE wdd.source_line_id = l_del_det_id
649: AND wdd.source_code = 'WSH'
650: AND wdd.container_flag = 'Y'
651: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 5146: wsh_delivery_assignments_v wda

5142: wdd.source_code,
5143: wdd.container_flag,
5144: wdd.requested_quantity_uom
5145: FROM wsh_delivery_details wdd,
5146: wsh_delivery_assignments_v wda
5147: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
5148: AND wda.delivery_id = p_delivery_id;
5149:
5150: l_del_det_int_rec del_det_int_cur%ROWTYPE;

Line 5235: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

5231: l_dummy_id NUMBER;
5232:
5233: CURSOR lock_delivery_details IS
5234: SELECT wdd.delivery_detail_id
5235: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
5236: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
5237: AND wda.delivery_id = p_delivery_id
5238: FOR UPDATE NOWAIT;
5239:

Line 5329: wsh_delivery_assignments wda

5325:
5326: CURSOR lock_delivery_details IS
5327: SELECT wdd.delivery_detail_id
5328: FROM wsh_delivery_details wdd,
5329: wsh_delivery_assignments wda
5330: WHERE wdd.source_code = 'OE'
5331: AND wdd.delivery_detail_id = wda.delivery_detail_id
5332: AND wdd.released_status in ('R','B','X')
5333: AND wdd.delivery_detail_id in (