DBA Data[Home] [Help]

APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on OE_ORDER_LINES_ALL

Line 1315: oe_order_lines_all ol,

1311: IF (del_det_int_rec.line_direction = 'IO') THEN
1312: select wdd.delivery_detail_id, wdd.requested_quantity BULK COLLECT
1313: into l_detail_id_tab, l_detail_qty_tab
1314: from wsh_delivery_details wdd,
1315: oe_order_lines_all ol,
1316: po_requisition_lines_all pl,
1317: po_requisition_headers_all ph
1318: where wdd.source_code = 'OE'
1319: and wdd.released_status in ('R','B','X')

Line 2068: oe_order_lines_all ol,

2064: IF (del_det_int_rec.line_direction = 'IO') THEN
2065: select wdd.delivery_detail_id, wdd.requested_quantity BULK COLLECT
2066: into l_detail_id_tab, l_detail_qty_tab
2067: from wsh_delivery_details wdd,
2068: oe_order_lines_all ol,
2069: po_requisition_lines_all pl,
2070: po_requisition_headers_all ph
2071: where wdd.source_code = 'OE'
2072: and wdd.released_status in ('R','B','X')

Line 5357: oe_order_lines_all ol,

5353: SELECT wdd1.delivery_detail_id
5354: FROM wsh_del_details_interface wddi,
5355: wsh_del_assgn_interface wdai,
5356: wsh_delivery_details wdd1,
5357: oe_order_lines_all ol,
5358: po_requisition_lines_all pl,
5359: po_requisition_headers_all ph
5360: where wdd1.source_code = 'OE'
5361: and wdd1.released_status in ('R','B','X')