APPS.CTO_WIP_UTIL dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 124: wsh_delivery_assignments wda

120: select sum(wdd.requested_quantity) pQuantity,
121: -- Note: bug 1661094: wdd.requested_quantity is in primary uom
122: wda.delivery_id, wdd.load_seq_number lsn
123: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
124: wsh_delivery_assignments wda
125: where wdd.source_line_id = p_line_id
126: and wda.delivery_detail_id = wdd.delivery_detail_id
127: and wdd.source_code = 'OE' -- bugfix 1988967: only OE lines should be picked since
128: -- wsh_delivery_details can have lines related to

Line 738: wsh_delivery_assignments wda,

734: into l_eligible_line
735: from oe_order_lines_all oel
736: where exists (select 'Exists'
737: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
738: wsh_delivery_assignments wda,
739: mtl_customer_items mci
740: where wdd.source_line_id = oel.line_id
741: and mci.customer_item_id = oel.ordered_item_id
742: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 830: wsh_delivery_assignments wda

826: select 'NOTASSIGNED'
827: into l_assigned
828: from oe_order_lines_all oel,
829: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
830: wsh_delivery_assignments wda
831: where oel.line_id = p_line_id
832: and wdd.source_line_id = oel.line_id
833: and wdd.source_code = 'OE' --bugfix 1988967
834: --and oel.ordered_quantity - nvl(oel.cancelled_quantity, 0) = (select nvl(sum(wdd1.requested_quantity), 0)

Line 867: wsh_delivery_assignments wda,

863: select 'NOTPLANNED'
864: into l_planned
865: from oe_order_lines_all oel,
866: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
867: wsh_delivery_assignments wda,
868: WSH_NEW_DELIVERIES_OB_GRP_V wnd
869: where oel.line_id = p_line_id
870: and wdd.source_line_id = oel.line_id
871: and wdd.source_code = 'OE' --bugfix 1988967