eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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