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_LINES_ALL

Line 184: OE_ORDER_LINES_ALL L,

180: SELECT
181: 1
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

Line 818: COUNT_oe_order_lines_all NUMBER(10);

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);
822: COUNT_hz_party_sites NUMBER(10);

Line 833: SELECT COUNT(*) INTO COUNT_oe_order_lines_all FROM oe_order_lines_all;

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;
836:
837: SELECT COUNT(*) INTO COUNT_hz_cust_site_uses_all FROM hz_cust_site_uses_all;

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;*/