VIEW: APPS.JAI_AP_MATCH_TAXES_V

Source

View Text - Preformatted

SELECT a.invoice_id, ai.invoice_num, ai.invoice_amount, ai.invoice_date, a.error_message, a.processing_time error_date , b.distribution_cnt num_dist_lines from JAI_AP_MATCH_ERS_T a,ap_invoices_all ai, ( select invoice_id invoice_id, count(1) distribution_cnt from JAI_AP_MATCH_ERS_T group by invoice_id ) b WHERE a.invoice_id = b.invoice_id and b.invoice_id = ai.invoice_id and a.error_flag ='Y' and NVL(a.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT A.INVOICE_ID
, AI.INVOICE_NUM
, AI.INVOICE_AMOUNT
, AI.INVOICE_DATE
, A.ERROR_MESSAGE
, A.PROCESSING_TIME ERROR_DATE
, B.DISTRIBUTION_CNT NUM_DIST_LINES
FROM JAI_AP_MATCH_ERS_T A
, AP_INVOICES_ALL AI
, ( SELECT INVOICE_ID INVOICE_ID
, COUNT(1) DISTRIBUTION_CNT
FROM JAI_AP_MATCH_ERS_T GROUP BY INVOICE_ID ) B
WHERE A.INVOICE_ID = B.INVOICE_ID
AND B.INVOICE_ID = AI.INVOICE_ID
AND A.ERROR_FLAG ='Y'
AND NVL(A.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)