APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 536: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

532: ORDER BY wddi.container_flag desc;
533:
534: CURSOR cont_inst_exists(l_del_det_id NUMBER) IS
535: SELECT count(*)
536: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
537: WHERE wdd.source_line_id = l_del_det_id
538: AND wdd.source_code = 'WSH'
539: AND wdd.container_flag = 'Y'
540: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 4004: wsh_delivery_assignments_v wda

4000: wdd.source_code,
4001: wdd.container_flag,
4002: wdd.requested_quantity_uom
4003: FROM wsh_delivery_details wdd,
4004: wsh_delivery_assignments_v wda
4005: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
4006: AND wda.delivery_id = p_delivery_id;
4007:
4008: l_del_det_int_rec del_det_int_cur%ROWTYPE;

Line 4093: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

4089: l_dummy_id NUMBER;
4090:
4091: CURSOR lock_delivery_details IS
4092: SELECT wdd.delivery_detail_id
4093: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
4094: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
4095: AND wda.delivery_id = p_delivery_id
4096: FOR UPDATE NOWAIT;
4097: