View: POS_AP_CHECKS_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_AP_CHECKS_V

View Text

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
, POS_AP_CHECKS_PKG.GET_INVOICES_PAID( AC.CHECK_ID) INVOICES
, AC.ORG_ID
, HOU.NAME
FROM AP_CHECKS_ALL AC
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE HOU.ORGANIZATION_ID = AC.ORG_ID
AND HOU.LANGUAGE = USERENV('LANG')

Columns