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_COVERED_LEVELS_INTERFACE

Line 299: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_COVERED_LEVELS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) COVERED_LEVELS_INVALID,

295: G_WORKER_REQ_ID REQUEST_ID,
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,

Line 421: ,OKS_COVERED_LEVELS_INTERFACE OCLI

417: ,NVL(OCLI.LINE_INTERFACE_ID,-2)))
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