APPS.WMS_RULES_WORKBENCH_PVT dependencies on OE_ORDER_LINES_ALL

Line 1903: -- MOAC : and oe_order_lines to oe_order_lines_all

1899: -- Bug #3387877
1900: -- to get the sales order type at header level
1901:
1902: -- MOAC : changed oe_order_headers to oe_order_headers_all
1903: -- MOAC : and oe_order_lines to oe_order_lines_all
1904:
1905: elsif l_transaction_source_type_id = 12 then
1906: select oh.order_type_id into l_order_type_id
1907: from oe_order_headers_all oh ,

Line 1908: oe_order_lines_all ol

1904:
1905: elsif l_transaction_source_type_id = 12 then
1906: select oh.order_type_id into l_order_type_id
1907: from oe_order_headers_all oh ,
1908: oe_order_lines_all ol
1909: where oh.header_id = ol.header_id
1910: and ol.line_id = l_reference_id ;
1911:
1912: end if;

Line 1957: -- MOAC : and oe_order_lines to oe_order_lines_all

1953: -- Bug #3387877
1954: -- to get the sales order type at header level
1955:
1956: -- MOAC : changed oe_order_headers to oe_order_headers_all
1957: -- MOAC : and oe_order_lines to oe_order_lines_all
1958:
1959: elsif p_transaction_source_type_id = 12 then
1960: select oh.order_type_id into l_order_type_id
1961: from oe_order_headers_all oh ,

Line 1962: oe_order_lines_all ol

1958:
1959: elsif p_transaction_source_type_id = 12 then
1960: select oh.order_type_id into l_order_type_id
1961: from oe_order_headers_all oh ,
1962: oe_order_lines_all ol
1963: where oh.header_id = ol.header_id
1964: and ol.line_id = p_reference_id ;
1965:
1966: end if;

Line 2033: FROM oe_order_lines_all oola,

2029: hz.PARTY_ID,
2030: oola.freight_carrier_code
2031: INTO l_customer_id,
2032: l_freight_code
2033: FROM oe_order_lines_all oola,
2034: HZ_PARTIES hz
2035: WHERE oola.line_id = l_trx_source_line_id
2036: AND hz.party_id = oola.sold_to_org_id;
2037: