APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 891: from wsh_delivery_assignments_v

887: l_delivery_id NUMBER;
888:
889: cursor check_assign (detail_id IN NUMBER) is
890: select delivery_id
891: from wsh_delivery_assignments_v
892: where delivery_detail_id = detail_id
893: and delivery_id IS NOT NULL;
894:
895: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

Line 2120: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda

2116: x_return_status OUT NOCOPY VARCHAR2) IS
2117:
2118: CURSOR c_check_qty_inside_del (del_id IN NUMBER) IS
2119: select sum(wdd.requested_quantity), wdd.source_code, wdd.source_line_id
2120: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda
2121: where wdd.delivery_detail_id = wda.delivery_detail_id
2122: and wda.delivery_id is not null
2123: and wda.delivery_id = del_id
2124: and wdd.released_status <> 'D'

Line 2131: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda

2127:
2128:
2129: CURSOR c_source_info IS
2130: select distinct wdd.source_line_id, wdd.source_code
2131: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda
2132: where wdd.delivery_detail_id = wda.delivery_detail_id
2133: and wdd.released_status <> 'D'
2134: and wda.delivery_id is not null
2135: and wda.delivery_id = p_delivery_id;

Line 2181: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

2177: FOR source_rec IN c_source_info LOOP
2178: BEGIN
2179: select sum(wdd.requested_quantity)
2180: into l_req_qty
2181: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2182: where wdd.delivery_detail_id = wda.delivery_detail_id
2183: and wnd.delivery_id(+) = wda.delivery_id
2184: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2185: and wdd.released_status not in ('C', 'D')

Line 3416: wsh_delivery_assignments_v wda

3412: nvl(wnd.shipment_direction, 'O'), -- J inbound logistics jckwok
3413: nvl(wnd.ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
3414: nvl(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
3415: from wsh_new_deliveries wnd,
3416: wsh_delivery_assignments_v wda
3417: where wnd.delivery_id = wda.delivery_id
3418: and wda.delivery_detail_id = p_del_det_id;
3419:
3420: -- frontport bug 5478065 of 11i10 performance bug 5439331:

Line 3429: FROM wsh_delivery_assignments_v wda

3425: ( SELECT wdd.delivery_detail_id
3426: FROM wsh_delivery_details wdd
3427: WHERE wdd.delivery_detail_id IN
3428: (SELECT wda.delivery_detail_id
3429: FROM wsh_delivery_assignments_v wda
3430: START WITH parent_delivery_detail_id = p_container_id
3431: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id)
3432: AND wdd.container_flag = 'N'
3433: AND wdd.released_status = 'Y' );