[Home] [Help]
294: P_parent_request_id PARENT_REQUEST_ID,
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
416: ,DECODE (UPPER(OLI.LINE_TYPE),'USAGE',NVL(OUCI.LINE_INTERFACE_ID,-3)
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
554: ERROR_MESSAGE)
555: VALUES
556: (G_WORKER_REQ_ID,
557: P_parent_request_id,
558: 'OKS_LINES_INTERFACE',
559: process_rec.HEADER_INTERFACE_ID,
560: process_rec.LINE_INTERFACE_ID,
561: 'OKS_IMP_LINE_INVALID_COVL' );
562: END IF;
573: ERROR_MESSAGE)
574: VALUES
575: (G_WORKER_REQ_ID,
576: P_parent_request_id,
577: 'OKS_LINES_INTERFACE',
578: process_rec.HEADER_INTERFACE_ID,
579: process_rec.LINE_INTERFACE_ID,
580: 'OKS_IMP_LINE_INVALID_USAGE' );
581: END IF;