APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_SALES_CREDITS_INTERFACE

Line 301: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_SALES_CREDITS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) SALES_CREDITS_INVALID,

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
305: FROM OKS_INT_ERROR_STG_TEMP) INVALID_Q;

Line 423: ,OKS_SALES_CREDITS_INTERFACE OSCI

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
427: AND OUCI.LINE_INTERFACE_ID(+) = OLI.line_interface_id