View: AP_INTERFACE_REJECTIONS_V

Product:	AP - Payables
Description:	- Retrofitted
Implementation/DBA Data:	APPS.AP_INTERFACE_REJECTIONS_V

View Text

SELECT AII.VENDOR_ID
, AII.VENDOR_NUM
, AII.VENDOR_NAME
, AII.VENDOR_SITE_ID
, AII.VENDOR_SITE_CODE
, AII.INVOICE_NUM
, AII.INVOICE_ID
, DECODE(AIR.PARENT_TABLE
, 'AP_INVOICE_LINES_INTERFACE'
, TO_CHAR(AILI.LINE_NUMBER)
, 'AP_INVOICES_INTERFACE'
, ALC2.DISPLAYED_FIELD)
, ALC1.DESCRIPTION
, ALC1.DISPLAYED_FIELD
, AIR.PARENT_TABLE
, AIR.PARENT_ID
, AIR.REJECT_LOOKUP_CODE
, AIR.LAST_UPDATED_BY
, AIR.LAST_UPDATE_DATE
, AIR.LAST_UPDATE_LOGIN
, AIR.CREATED_BY
, AIR.CREATION_DATE
FROM AP_INTERFACE_REJECTIONS AIR
, AP_INVOICES_INTERFACE AII
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_INVOICE_LINES_INTERFACE AILI
WHERE STATUS = 'REJECTED'
AND DECODE(AIR.PARENT_TABLE
, 'AP_INVOICE_LINES_INTERFACE'
, AILI.INVOICE_LINE_ID
, 'AP_INVOICES_INTERFACE'
, AII.INVOICE_ID) =AIR.PARENT_ID
AND ALC1.LOOKUP_TYPE = 'REJECT CODE'
AND AIR.REJECT_LOOKUP_CODE = ALC1.LOOKUP_CODE
AND ALC2.LOOKUP_TYPE = 'NLS TRANSLATION'
AND ALC2.LOOKUP_CODE = 'INVOICE'
AND AII.INVOICE_ID = AILI.INVOICE_ID (+) GROUP BY AII.VENDOR_ID
, AII.VENDOR_NUM
, AII.VENDOR_NAME
, AII.VENDOR_SITE_ID
, AII.VENDOR_SITE_CODE
, AII.INVOICE_NUM
, AII.INVOICE_ID
, DECODE(AIR.PARENT_TABLE
, 'AP_INVOICE_LINES_INTERFACE'
, TO_CHAR(AILI.LINE_NUMBER)
, 'AP_INVOICES_INTERFACE'
, ALC2.DISPLAYED_FIELD)
, ALC1.DESCRIPTION
, ALC1.DISPLAYED_FIELD
, AIR.PARENT_TABLE
, AIR.PARENT_ID
, AIR.REJECT_LOOKUP_CODE
, AIR.LAST_UPDATED_BY
, AIR.LAST_UPDATE_DATE
, AIR.LAST_UPDATE_LOGIN
, AIR.CREATED_BY
, AIR.CREATION_DATE

Columns