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.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 204: FROM OE_ORDER_HEADERS_ALL OOH,

200: OOH.PRICE_LIST_ID,
201: OOH.QUOTE_NUMBER,
202: OOH.FLOW_STATUS_CODE,
203: OOH.UPGRADED_FLAG
204: FROM OE_ORDER_HEADERS_ALL OOH,
205: OE_ORDER_TYPES_V OOT --MOAC view based on multiple obj
206: WHERE OOH.ORDER_TYPE_ID = OOT.ORDER_TYPE_ID
207: AND NVL(OOH.TRANSACTION_PHASE_CODE,''F'')<>''N''';
208:

Line 698: FROM OE_ORDER_HEADERS_ALL OOH,

694: OOH.PRICE_LIST_ID,
695: OOH.EXPIRATION_DATE,
696: OOH.FLOW_STATUS_CODE,
697: OOH.UPGRADED_FLAG
698: FROM OE_ORDER_HEADERS_ALL OOH,
699: OE_ORDER_TYPES_V OOT --MOAC view based on multiple objects
700: WHERE OOH.ORDER_TYPE_ID = OOT.ORDER_TYPE_ID
701: AND NVL(OOH.TRANSACTION_PHASE_CODE,''F'')=''N''';
702:

Line 1119: oe_order_headers_all ooh

1115: , l_flow_status_code
1116: , l_upgraded_flag
1117: , l_transaction_phase_code
1118: From oe_order_types_v oot, --MOAC view based on multiple objects
1119: oe_order_headers_all ooh
1120:
1121: WHERE
1122: ooh.header_id = l_header_id
1123: AND ooh.order_type_id = oot.order_type_id;

Line 1917: oe_order_headers_all sh,

1913: --FROM oe_order_lines sl1,
1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,
1918: oe_order_types_v ot --MOAC view based on multiple objects
1919: WHERE sh.order_number = p_order_number
1920: AND sh.order_type_id = ot.order_type_id
1921: AND ot.name = p_order_type_name