DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on WSH_DELIVERY_DETAILS

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

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

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

1347: and l.header_id = v_order_header_id
1348: -- and h.open_flag = 'Y'
1349: and nvl(cancelled_flag,'N') = 'N'
1350: and l.open_flag = 'Y'
1351: and not exists (select 1 from wsh_delivery_details w
1352: where w.source_line_id = l.line_id
1353: and w.source_code = 'OE'
1354: and released_status = 'C')
1355: order by l.line_id;