VIEW: APPS.ICX_AP_CHECKS_V

Source

View Text - Preformatted

SELECT TO_CHAR(AC.AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK( AC.CURRENCY_CODE, 30)) AMOUNT , AC.CHECK_DATE CHECK_DATE , AC.CHECK_ID CHECK_ID , AC.CHECK_NUMBER CHECK_NUMBER , AC.CURRENCY_CODE CURRENCY_CODE , AC.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME , AC.VENDOR_SITE_CODE VENDOR_SITE_CODE , AC.VENDOR_SITE_ID VENDOR_SITE_ID , AC.VENDOR_ID VENDOR_ID , DECODE(AC.CLEARED_DATE, '', '', '*') CLEARED , DECODE(AC.VOID_DATE, '', '', '*') VOIDED , DECODE(AC.STOPPED_AT, '', '', DECODE(AC.RELEASED_AT, '', '*', '')) STOPPED , AC.CLEARED_DATE CLEARED_DATE , AC.VOID_DATE VOID_DATE , AC.STOPPED_AT STOPPED_AT , AC.RELEASED_AT RELEASED_AT , AC.FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE , AC.CITY || ' ' || AC.STATE ADDRESS /* URL DATA FOR IC */ , AC.ATTRIBUTE14 ADDRESS_URL , AC.ADDRESS_STYLE ADDRESS_STYLE , AC.ADDRESS_LINE1 ADDRESS_LINE1 , AC.ADDRESS_LINE2 ADDRESS_LINE2 , AC.ADDRESS_LINE3 ADDRESS_LINE3 , AC.ADDRESS_LINE4 ADDRESS_LINE4 , AC.CITY CITY , AC.COUNTY COUNTY , AC.STATE STATE , AC.PROVINCE PROVINCE , AC.ZIP ZIP , AC.COUNTRY COUNTRY , ICX_AP_CHECKS_PKG.GET_INVOICES_PAID( AC.CHECK_ID) INVOICES FROM AP_CHECKS AC

View Text - HTML Formatted

SELECT TO_CHAR(AC.AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( AC.CURRENCY_CODE
, 30)) AMOUNT
, AC.CHECK_DATE CHECK_DATE
, AC.CHECK_ID CHECK_ID
, AC.CHECK_NUMBER CHECK_NUMBER
, AC.CURRENCY_CODE CURRENCY_CODE
, AC.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, AC.VENDOR_SITE_CODE VENDOR_SITE_CODE
, AC.VENDOR_SITE_ID VENDOR_SITE_ID
, AC.VENDOR_ID VENDOR_ID
, DECODE(AC.CLEARED_DATE
, ''
, ''
, '*') CLEARED
, DECODE(AC.VOID_DATE
, ''
, ''
, '*') VOIDED
, DECODE(AC.STOPPED_AT
, ''
, ''
, DECODE(AC.RELEASED_AT
, ''
, '*'
, '')) STOPPED
, AC.CLEARED_DATE CLEARED_DATE
, AC.VOID_DATE VOID_DATE
, AC.STOPPED_AT STOPPED_AT
, AC.RELEASED_AT RELEASED_AT
, AC.FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, AC.CITY || ' ' || AC.STATE ADDRESS /* URL DATA FOR IC */
, AC.ATTRIBUTE14 ADDRESS_URL
, AC.ADDRESS_STYLE ADDRESS_STYLE
, AC.ADDRESS_LINE1 ADDRESS_LINE1
, AC.ADDRESS_LINE2 ADDRESS_LINE2
, AC.ADDRESS_LINE3 ADDRESS_LINE3
, AC.ADDRESS_LINE4 ADDRESS_LINE4
, AC.CITY CITY
, AC.COUNTY COUNTY
, AC.STATE STATE
, AC.PROVINCE PROVINCE
, AC.ZIP ZIP
, AC.COUNTRY COUNTRY
, ICX_AP_CHECKS_PKG.GET_INVOICES_PAID( AC.CHECK_ID) INVOICES
FROM AP_CHECKS AC