DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on OE_ORDER_LINES_ALL

Line 1657: -- MOAC : and oe_order_lines to oe_order_lines_all

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
1661: from oe_order_headers_all oh ,

Line 1662: oe_order_lines_all ol

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:
1666: end if;

Line 1734: FROM oe_order_lines_all oola,

1730: hz.PARTY_ID,
1731: oola.freight_carrier_code
1732: INTO l_customer_id,
1733: l_freight_code
1734: FROM oe_order_lines_all oola,
1735: HZ_PARTIES hz
1736: WHERE oola.line_id = l_trx_source_line_id
1737: AND hz.party_id = oola.sold_to_org_id;
1738: