DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on WSH_DELIVERY_DETAILS

Line 58: and not exists (select 1 from wsh_delivery_details w

54: and nvl(l.fulfilled_flag,'N') = 'N'
55: and nvl(l.shipped_quantity,0) = 0
56: and nvl(l.fulfilled_quantity,0) = 0
57: and l.actual_shipment_date is null
58: and not exists (select 1 from wsh_delivery_details w
59: where w.source_line_id = l.line_id
60: and w.source_header_id = h.header_id
61: and w.source_code = 'OE'
62: and w.released_status = 'C')

Line 1219: and not exists (select 1 from wsh_delivery_details w

1215: and l.header_id = v_order_header_id
1216: -- and h.open_flag = 'Y'
1217: and nvl(cancelled_flag,'N') = 'N'
1218: and l.open_flag = 'Y'
1219: and not exists (select 1 from wsh_delivery_details w
1220: where w.source_line_id = l.line_id
1221: and w.source_code = 'OE'
1222: and released_status = 'C')
1223: order by l.line_id;