APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 812: from wsh_delivery_assignments da,

808:
809: cursor check_unassign (detail_id IN NUMBER) is
810: select da.parent_delivery_detail_id , da.delivery_id ,
811: dd.container_name , dd.container_flag
812: from wsh_delivery_assignments da,
813: wsh_delivery_Details dd
814: where da.delivery_detail_id = detail_id
815: and nvl(da.type,'S') in ('S', 'C')
816: and da.parent_Delivery_Detail_id = dd.delivery_Detail_id (+);

Line 931: from wsh_delivery_assignments_v

927: l_delivery_id NUMBER;
928:
929: cursor check_assign (detail_id IN NUMBER) is
930: select delivery_id
931: from wsh_delivery_assignments_v
932: where delivery_detail_id = detail_id
933: and delivery_id IS NOT NULL;
934:
935: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

Line 2192: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda

2188: -- muom
2189: CURSOR c_check_qty_inside_del (del_id IN NUMBER) IS
2190: select sum(wdd.requested_quantity), wdd.source_code, wdd.source_line_id,
2191: decode(wdd.requested_quantity_uom2,null,'P',WSH_UTIL_CORE.Get_Line_Fulfillment_Base(wdd.source_code,wdd.source_line_id)) fulfill_base
2192: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda
2193: where wdd.delivery_detail_id = wda.delivery_detail_id
2194: and wda.delivery_id is not null
2195: and wda.delivery_id = del_id
2196: and wdd.released_status <> 'D'

Line 2205: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda

2201: CURSOR c_source_info IS
2202: -- muom
2203: select distinct wdd.source_line_id, wdd.source_code,
2204: decode(wdd.requested_quantity_uom2,null,'P',WSH_UTIL_CORE.Get_Line_Fulfillment_Base(wdd.source_code,wdd.source_line_id)) fulfill_base
2205: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda
2206: where wdd.delivery_detail_id = wda.delivery_detail_id
2207: and wdd.released_status <> 'D'
2208: and wda.delivery_id is not null
2209: and wda.delivery_id = p_delivery_id;

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

2262: IF source_rec.fulfill_base = 'P' THEN
2263: BEGIN
2264: select sum(wdd.requested_quantity)
2265: into l_req_qty
2266: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2267: where wdd.delivery_detail_id = wda.delivery_detail_id
2268: and wnd.delivery_id(+) = wda.delivery_id
2269: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2270: and wdd.released_status not in ('C', 'D')

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

2286: ELSE
2287: BEGIN
2288: select sum(wdd.requested_quantity2)
2289: into l_req_qty
2290: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2291: where wdd.delivery_detail_id = wda.delivery_detail_id
2292: and wnd.delivery_id(+) = wda.delivery_id
2293: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2294: and wdd.released_status not in ('C', 'D')

Line 3539: wsh_delivery_assignments_v wda

3535: nvl(wnd.shipment_direction, 'O'), -- J inbound logistics jckwok
3536: nvl(wnd.ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
3537: nvl(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
3538: from wsh_new_deliveries wnd,
3539: wsh_delivery_assignments_v wda
3540: where wnd.delivery_id = wda.delivery_id
3541: and wda.delivery_detail_id = p_del_det_id;
3542:
3543: -- frontport bug 5478065 of 11i10 performance bug 5439331:

Line 3552: FROM wsh_delivery_assignments_v wda

3548: ( SELECT wdd.delivery_detail_id
3549: FROM wsh_delivery_details wdd
3550: WHERE wdd.delivery_detail_id IN
3551: (SELECT wda.delivery_detail_id
3552: FROM wsh_delivery_assignments_v wda
3553: START WITH parent_delivery_detail_id = p_container_id
3554: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id)
3555: AND wdd.container_flag = 'N'
3556: AND wdd.released_status = 'Y' );