APPS.WMS_RULES_WORKBENCH_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1642: -- MOAC : changed oe_order_headers to oe_order_headers_all

1638: end if;
1639:
1640: if l_transaction_source_type_id in (2,8) then
1641:
1642: -- MOAC : changed oe_order_headers to oe_order_headers_all
1643:
1644: /* added the index hint with the suggestion of apps performance team */
1645: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1646: from oe_order_headers_all oh,

Line 1646: from oe_order_headers_all oh,

1642: -- MOAC : changed oe_order_headers to oe_order_headers_all
1643:
1644: /* added the index hint with the suggestion of apps performance team */
1645: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1646: from oe_order_headers_all oh,
1647: wsh_delivery_details wdd
1648: where oh.header_id = wdd.source_header_id
1649: and wdd.released_status = 'S'
1650: and wdd.source_code = 'OE'

Line 1656: -- MOAC : changed oe_order_headers to oe_order_headers_all

1652:
1653: -- Bug #3387877
1654: -- to get the sales order type at header level
1655:
1656: -- MOAC : changed oe_order_headers to oe_order_headers_all
1657: -- MOAC : and oe_order_lines to oe_order_lines_all
1658:
1659: elsif l_transaction_source_type_id = 12 then
1660: select oh.order_type_id into l_order_type_id

Line 1661: from oe_order_headers_all oh ,

1657: -- MOAC : and oe_order_lines to oe_order_lines_all
1658:
1659: elsif l_transaction_source_type_id = 12 then
1660: select oh.order_type_id into l_order_type_id
1661: from oe_order_headers_all oh ,
1662: oe_order_lines_all ol
1663: where oh.header_id = ol.header_id
1664: and ol.line_id = l_reference_id ;
1665: