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 720: wsh_delivery_assignments wda,

716: into l_eligible_line
717: from oe_order_lines_all oel
718: where exists (select 'Exists'
719: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
720: wsh_delivery_assignments wda,
721: mtl_customer_items mci
722: where wdd.source_line_id = oel.line_id
723: and mci.customer_item_id = oel.ordered_item_id
724: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 812: wsh_delivery_assignments wda

808: select 'NOTASSIGNED'
809: into l_assigned
810: from oe_order_lines_all oel,
811: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
812: wsh_delivery_assignments wda
813: where oel.line_id = p_line_id
814: and wdd.source_line_id = oel.line_id
815: and wdd.source_code = 'OE' --bugfix 1988967
816: --and oel.ordered_quantity - nvl(oel.cancelled_quantity, 0) = (select nvl(sum(wdd1.requested_quantity), 0)

Line 849: wsh_delivery_assignments wda,

845: select 'NOTPLANNED'
846: into l_planned
847: from oe_order_lines_all oel,
848: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
849: wsh_delivery_assignments wda,
850: WSH_NEW_DELIVERIES_OB_GRP_V wnd
851: where oel.line_id = p_line_id
852: and wdd.source_line_id = oel.line_id
853: and wdd.source_code = 'OE' --bugfix 1988967