eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_RULES_WORKBENCH_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1888: -- MOAC : changed oe_order_headers to oe_order_headers_all

1884: end if;
1885:
1886: if l_transaction_source_type_id in (2,8) then
1887:
1888: -- MOAC : changed oe_order_headers to oe_order_headers_all
1889:
1890: /* added the index hint with the suggestion of apps performance team */
1891: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1892: from oe_order_headers_all oh,

Line 1892: from oe_order_headers_all oh,

1888: -- MOAC : changed oe_order_headers to oe_order_headers_all
1889:
1890: /* added the index hint with the suggestion of apps performance team */
1891: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1892: from oe_order_headers_all oh,
1893: wsh_delivery_details wdd
1894: where oh.header_id = wdd.source_header_id
1895: and wdd.released_status = 'S'
1896: and wdd.source_code = 'OE'

Line 1902: -- MOAC : changed oe_order_headers to oe_order_headers_all

1898:
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

Line 1907: from oe_order_headers_all oh ,

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 ,
1908: oe_order_lines_all ol
1909: where oh.header_id = ol.header_id
1910: and ol.line_id = l_reference_id ;
1911:

Line 1942: -- MOAC : changed oe_order_headers to oe_order_headers_all

1938: end if;
1939:
1940: if p_transaction_source_type_id in (2,8) then
1941:
1942: -- MOAC : changed oe_order_headers to oe_order_headers_all
1943:
1944: /* added the index hint with the suggestion of apps performance team */
1945: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1946: from oe_order_headers_all oh,

Line 1946: from oe_order_headers_all oh,

1942: -- MOAC : changed oe_order_headers to oe_order_headers_all
1943:
1944: /* added the index hint with the suggestion of apps performance team */
1945: select /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ oh.order_type_id into l_order_type_id
1946: from oe_order_headers_all oh,
1947: wsh_delivery_details wdd
1948: where oh.header_id = wdd.source_header_id
1949: and wdd.released_status = 'S'
1950: and wdd.source_code = 'OE'

Line 1956: -- MOAC : changed oe_order_headers to oe_order_headers_all

1952:
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

Line 1961: from oe_order_headers_all oh ,

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 ,
1962: oe_order_lines_all ol
1963: where oh.header_id = ol.header_id
1964: and ol.line_id = p_reference_id ;
1965: