VIEW: APPS.APFV_AP_PAYMENTS

Source

View Text - Preformatted

SELECT CH.CHECK_ID , CH.BANK_ACCOUNT_NAME , CH.AMOUNT , CH.CURRENCY_CODE , CH.CHECK_DATE , CH.CHECK_NUMBER , CH.CHECK_VOUCHER_NUM , CH.CHECKRUN_NAME , CH.PAYMENT_TYPE_FLAG , '_LA:CH.PAYMENT_TYPE_FLAG:AP_LOOKUP_CODES:PAYMENT TYPE:DISPLAYED_FIELD' , CH.STATUS_LOOKUP_CODE , '_LA:CH.STATUS_LOOKUP_CODE:AP_LOOKUP_CODES:CHECK STATE:DISPLAYED_FIELD' , CH.PAYMENT_METHOD_CODE , '_LA:CH.PAYMENT_METHOD_CODE:AP_LOOKUP_CODES:PAYMENT METHOD:DISPLAYED_FIELD' , CH.DOC_SEQUENCE_ID , CH.CLEARED_AMOUNT , CH.CLEARED_DATE , CH.VENDOR_ID , CH.VENDOR_SITE_ID , CH.VENDOR_NAME , CH.ADDRESS_LINE1 , CH.ADDRESS_LINE2 , CH.ADDRESS_LINE3 , CH.CITY , CH.STATE , CH.ZIP , CH.COUNTRY , CH.VENDOR_SITE_CODE , CH.BANK_ACCOUNT_NUM , CH.BANK_ACCOUNT_TYPE , CH.TREASURY_PAY_DATE , CH.TREASURY_PAY_NUMBER , CH.RELEASED_AT , CH.RELEASED_BY , CH.STOPPED_AT , CH.STOPPED_BY , CH.VOID_DATE , CH.FUTURE_PAY_DUE_DATE , '_DF:SQLAP:AP_CHECKS:CH' , '_DF:JG:JG_AP_CHECKS:CH' , CH.CLEARED_BASE_AMOUNT , CH.CLEARED_EXCHANGE_RATE , CH.CLEARED_EXCHANGE_DATE , CH.CLEARED_EXCHANGE_RATE_TYPE , CH.EXCHANGE_RATE , CH.EXCHANGE_DATE , CH.EXCHANGE_RATE_TYPE , CH.BASE_AMOUNT , CH.CLEARED_ERROR_AMOUNT , CH.CLEARED_CHARGES_AMOUNT , CH.CLEARED_ERROR_BASE_AMOUNT , CH.CLEARED_CHARGES_BASE_AMOUNT , CH.TRANSFER_PRIORITY , CH.STAMP_DUTY_AMT , CH.STAMP_DUTY_BASE_AMT , CH.CE_BANK_ACCT_USE_ID ,/* changed for DBI */ CH.EXTERNAL_BANK_ACCOUNT_ID , CH.CREATION_DATE , CH.CREATED_BY , CH.LAST_UPDATE_DATE , CH.LAST_UPDATED_BY FROM AP_CHECKS CH WITH READ ONLY

View Text - HTML Formatted

SELECT CH.CHECK_ID
, CH.BANK_ACCOUNT_NAME
, CH.AMOUNT
, CH.CURRENCY_CODE
, CH.CHECK_DATE
, CH.CHECK_NUMBER
, CH.CHECK_VOUCHER_NUM
, CH.CHECKRUN_NAME
, CH.PAYMENT_TYPE_FLAG
, '_LA:CH.PAYMENT_TYPE_FLAG:AP_LOOKUP_CODES:PAYMENT TYPE:DISPLAYED_FIELD'
, CH.STATUS_LOOKUP_CODE
, '_LA:CH.STATUS_LOOKUP_CODE:AP_LOOKUP_CODES:CHECK STATE:DISPLAYED_FIELD'
, CH.PAYMENT_METHOD_CODE
, '_LA:CH.PAYMENT_METHOD_CODE:AP_LOOKUP_CODES:PAYMENT METHOD:DISPLAYED_FIELD'
, CH.DOC_SEQUENCE_ID
, CH.CLEARED_AMOUNT
, CH.CLEARED_DATE
, CH.VENDOR_ID
, CH.VENDOR_SITE_ID
, CH.VENDOR_NAME
, CH.ADDRESS_LINE1
, CH.ADDRESS_LINE2
, CH.ADDRESS_LINE3
, CH.CITY
, CH.STATE
, CH.ZIP
, CH.COUNTRY
, CH.VENDOR_SITE_CODE
, CH.BANK_ACCOUNT_NUM
, CH.BANK_ACCOUNT_TYPE
, CH.TREASURY_PAY_DATE
, CH.TREASURY_PAY_NUMBER
, CH.RELEASED_AT
, CH.RELEASED_BY
, CH.STOPPED_AT
, CH.STOPPED_BY
, CH.VOID_DATE
, CH.FUTURE_PAY_DUE_DATE
, '_DF:SQLAP:AP_CHECKS:CH'
, '_DF:JG:JG_AP_CHECKS:CH'
, CH.CLEARED_BASE_AMOUNT
, CH.CLEARED_EXCHANGE_RATE
, CH.CLEARED_EXCHANGE_DATE
, CH.CLEARED_EXCHANGE_RATE_TYPE
, CH.EXCHANGE_RATE
, CH.EXCHANGE_DATE
, CH.EXCHANGE_RATE_TYPE
, CH.BASE_AMOUNT
, CH.CLEARED_ERROR_AMOUNT
, CH.CLEARED_CHARGES_AMOUNT
, CH.CLEARED_ERROR_BASE_AMOUNT
, CH.CLEARED_CHARGES_BASE_AMOUNT
, CH.TRANSFER_PRIORITY
, CH.STAMP_DUTY_AMT
, CH.STAMP_DUTY_BASE_AMT
, CH.CE_BANK_ACCT_USE_ID
, /* CHANGED FOR DBI */ CH.EXTERNAL_BANK_ACCOUNT_ID
, CH.CREATION_DATE
, CH.CREATED_BY
, CH.LAST_UPDATE_DATE
, CH.LAST_UPDATED_BY
FROM AP_CHECKS CH WITH READ ONLY