DBA Data[Home] [Help]

APPS.WSH_INTEGRATION dependencies on OE_ORDER_LINES_ALL

Line 248: oe_order_lines_all oel, po_requisition_lines_all pl

244: select count(*)
245: into l_rec_exp_count
246: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
247: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
248: oe_order_lines_all oel, po_requisition_lines_all pl
249: where
250: wdd.source_code = 'OE'
251: and wdd.released_status = 'C'
252: and wdd.inv_interfaced_flag in ('N' ,'P')

Line 287: oe_order_lines_all oel, po_requisition_lines_all pl,

283: select count(*)
284: into l_rec_direct_count
285: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
286: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
287: oe_order_lines_all oel, po_requisition_lines_all pl,
288: mtl_interorg_parameters mip
289: where
290: wdd.source_code = 'OE'
291: and wdd.released_status = 'C'