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.ONT_OEXOEIOD_XMLP_PKG dependencies on OE_ORDER_HEADERS

Line 186: OE_ORDER_HEADERS H

182: INTO L_COUNT
183: FROM
184: OE_ORDER_LINES_ALL L,
185: RA_CUSTOMER_TRX_LINES_ALL TRXL,
186: OE_ORDER_HEADERS H
187: WHERE L.HEADER_ID = C_LINE_COUNTFORMULA.HEADER_ID1
188: AND H.HEADER_ID = L.HEADER_ID
189: AND TRXL.INTERFACE_LINE_CONTEXT = P_INVOICE_LINE_CONTEXT
190: AND TRXL.INTERFACE_LINE_ATTRIBUTE1 = H.ORDER_NUMBER

Line 817: COUNT_OE_ORDER_HEADERS NUMBER(10);

813: END;
814:
815: /*
816: DECLARE
817: COUNT_OE_ORDER_HEADERS NUMBER(10);
818: COUNT_oe_order_lines_all NUMBER(10);
819: COUNT_oe_transaction_types_tl NUMBER(10);
820: COUNT_hz_cust_site_uses_all NUMBER(10);
821: COUNT_hz_cust_acct_sites_all NUMBER(10);

Line 831: SELECT COUNT(*) INTO COUNT_OE_ORDER_HEADERS FROM OE_ORDER_HEADERS;

827: COUNT_hz_cust_accounts NUMBER(10);
828:
829: BEGIN
830:
831: SELECT COUNT(*) INTO COUNT_OE_ORDER_HEADERS FROM OE_ORDER_HEADERS;
832:
833: SELECT COUNT(*) INTO COUNT_oe_order_lines_all FROM oe_order_lines_all;
834:
835: SELECT COUNT(*) INTO COUNT_oe_transaction_types_tl FROM oe_transaction_types_tl;

Line 853: DSP_COUNT:= DSP_COUNT ||' COUNT_OE_ORDER_HEADERS-->' || COUNT_OE_ORDER_HEADERS || ' COUNT_oe_order_lines_all--->' || COUNT_oe_order_lines_all ||'COUNT_oe_transaction_types_tl--->' || COUNT_oe_transaction_types_tl || 'COUNT_hz_cust_site_uses_all--->' ||

849: SELECT COUNT(*) INTO COUNT_hz_parties FROM hz_parties;
850:
851: SELECT COUNT(*) INTO COUNT_hz_cust_accounts FROM hz_cust_accounts;
852:
853: DSP_COUNT:= DSP_COUNT ||' COUNT_OE_ORDER_HEADERS-->' || COUNT_OE_ORDER_HEADERS || ' COUNT_oe_order_lines_all--->' || COUNT_oe_order_lines_all ||'COUNT_oe_transaction_types_tl--->' || COUNT_oe_transaction_types_tl || 'COUNT_hz_cust_site_uses_all--->' ||
854: COUNT_hz_cust_site_uses_all || 'COUNT_hz_cust_acct_sites_all--->' || COUNT_hz_cust_acct_sites_all || 'COUNT_hz_party_sites--->'||COUNT_hz_party_sites|| 'COUNT_hz_locations-->' ||COUNT_hz_locations||'COUNT_ra_salesreps_all-->' ||
855: COUNT_ra_salesreps_all||' COUNT_fnd_territories_vl-->'|| COUNT_fnd_territories_vl || 'COUNT_hz_parties--->' || COUNT_hz_parties||' COUNT_hz_cust_accounts-->'|| COUNT_hz_cust_accounts;
856:
857: END;*/