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.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_USAGE_COUNTERS_INTERFACE

Line 300: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_USAGE_COUNTERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) USAGE_COUNTERS_INVALID,

296: 2 STATISTIC_TYPE_ID,
297: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_HEADERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) HEADERS_INVALID,
298: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_LINES_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) LINES_INVALID,
299: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_COVERED_LEVELS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) COVERED_LEVELS_INVALID,
300: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_USAGE_COUNTERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) USAGE_COUNTERS_INVALID,
301: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_SALES_CREDITS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) SALES_CREDITS_INVALID,
302: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_NOTES_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) NOTES_INVALID
303: FROM (SELECT distinct INTERFACE_SOURCE_TABLE,
304: count(distinct INTERFACE_ID) over (partition by INTERFACE_SOURCE_TABLE) INVALID_COUNT

Line 422: ,OKS_USAGE_COUNTERS_INTERFACE OUCI

418: ,'SUBSCRIPTION',NVL(OLI.line_interface_id,-1) ) line_flow
419: FROM OKS_HEADERS_INTERFACE OHI
420: ,OKS_LINES_INTERFACE OLI
421: ,OKS_COVERED_LEVELS_INTERFACE OCLI
422: ,OKS_USAGE_COUNTERS_INTERFACE OUCI
423: ,OKS_SALES_CREDITS_INTERFACE OSCI
424: WHERE OHI.batch_id = q_batch_id
425: AND OLI.HEADER_INTERFACE_ID(+) = OHI.HEADER_INTERFACE_ID
426: AND OCLI.LINE_INTERFACE_ID(+) = OLI.line_interface_id