View: JAI_AP_MATCH_TAXES_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_AP_MATCH_TAXES_V

View Text

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)

Columns