Product: | AP - Payables |
---|---|
Description: | (Release 10SC only) |
Implementation/DBA Data: | Not implemented in this database |
SELECT AC.AMOUNT AMOUNT
, TO_CHAR(AC.AMOUNT) || ' ' || AC.CURRENCY_CODE AMOUNT_CURRENCY_CODE
, 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_DATE
, ''
, ''
, DECODE(AC.RELEASED_DATE
, ''
, '*'
, '')) STOPPED
, AC.CLEARED_DATE CLEARED_DATE
, AC.VOID_DATE VOID_DATE
, AC.STOPPED_DATE STOPPED_DATE
, AC.RELEASED_DATE RELEASED_DATE
, AC.FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, AC.CITY || ' ' || AC.STATE ADDRESS
, 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
, AP_CHECKS_PKG.GET_INVOICES_PAID( AC.CHECK_ID) INVOICES
FROM AP_CHECKS AC