VIEW: APPS.AP_INTERFACE_REJECTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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