VIEW: APPS.POS_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_NAME, PV.SEGMENT1 VENDOR_NUMBER, AC.VENDOR_SITE_CODE VENDOR_SITE_CODE , AC.VENDOR_SITE_ID VENDOR_SITE_ID , AC.VENDOR_ID VENDOR_ID , decode(AC.STATUS_LOOKUP_CODE, 'CLEARED', decode(AC.CLEARED_DATE, '', '', '*'), '') CLEARED , decode(AC.STATUS_LOOKUP_CODE, 'VOIDED', 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, '' INVOICES, AC.STATUS_LOOKUP_CODE, APLC.DISPLAYED_FIELD, AC.ORG_ID, HOU.NAME, '' PO_NUMBER FROM AP_CHECKS_ALL AC , PO_VENDORS PV, AP_LOOKUP_CODES APLC, HR_ALL_ORGANIZATION_UNITS_TL HOU WHERE AC.VENDOR_ID = PV.VENDOR_ID (+) AND HOU.ORGANIZATION_ID (+) = AC.ORG_ID AND APLC.lookup_type = 'CHECK STATE' AND AC.STATUS_LOOKUP_CODE = APLC.lookup_code AND HOU.LANGUAGE (+)= USERENV('LANG')

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_NAME
, PV.SEGMENT1 VENDOR_NUMBER
, AC.VENDOR_SITE_CODE VENDOR_SITE_CODE
, AC.VENDOR_SITE_ID VENDOR_SITE_ID
, AC.VENDOR_ID VENDOR_ID
, DECODE(AC.STATUS_LOOKUP_CODE
, 'CLEARED'
, DECODE(AC.CLEARED_DATE
, ''
, ''
, '*')
, '') CLEARED
, DECODE(AC.STATUS_LOOKUP_CODE
, 'VOIDED'
, 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
, '' INVOICES
, AC.STATUS_LOOKUP_CODE
, APLC.DISPLAYED_FIELD
, AC.ORG_ID
, HOU.NAME
, '' PO_NUMBER
FROM AP_CHECKS_ALL AC
, PO_VENDORS PV
, AP_LOOKUP_CODES APLC
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE AC.VENDOR_ID = PV.VENDOR_ID (+)
AND HOU.ORGANIZATION_ID (+) = AC.ORG_ID
AND APLC.LOOKUP_TYPE = 'CHECK STATE'
AND AC.STATUS_LOOKUP_CODE = APLC.LOOKUP_CODE
AND HOU.LANGUAGE (+)= USERENV('LANG')