[Home] [Help]
View: AP_CHECK_STOCKS_V
Product: | AP - Payables |
Description: | (Release 10SC Only) |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ACS.BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, ACS.CHECK_STOCK_ID CHECK_STOCK_ID
, ACS.NAME NAME
, ALC1.DISPLAYED_FIELD DISBURSEMENT_TYPE
, ALC2.DISPLAYED_FIELD PAYMENT_METHOD
FROM AP_CHECK_STOCKS ACS
, AP_CHECK_FORMATS ACF
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
WHERE ACS.CHECK_FORMAT_ID = ACF.CHECK_FORMAT_ID
AND ALC1.LOOKUP_TYPE = 'DISBURSEMENT TYPE'
AND ALC1.LOOKUP_CODE = ACS.DISBURSEMENT_TYPE_LOOKUP_CODE
AND ALC2.LOOKUP_TYPE (+) = 'PAYMENT METHOD'
AND ALC2.LOOKUP_CODE (+) = ACF.PAYMENT_METHOD_LOOKUP_CODE
Columns
Name |
BANK_ACCOUNT_ID |
CHECK_STOCK_ID |
NAME |
DISBURSEMENT_TYPE |
PAYMENT_METHOD |