Product: | AP - Payables |
---|---|
Description: | (Release 10SC only) |
Implementation/DBA Data: | Not implemented in this database |
SELECT ACS.BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, ACS.BANK_CHARGES_CCID BANK_CHARGES_CCID
, ACS.BANK_ERRORS_CCID BANK_ERRORS_CCID
, ACS.CHECK_FORMAT_ID CHECK_FORMAT_ID
, ACS.CHECK_STOCK_ID CHECK_STOCK_ID
, ACS.CLEARING_DAYS CLEARING_DAYS
, ACS.CREATED_BY CREATED_BY
, ACS.CREATION_DATE CREATION_DATE
, ACS.DISBURSEMENT_TYPE_LOOKUP_CODE DISBURSEMENT_TYPE_LOOKUP_CODE
, ACS.DOC_CATEGORY_CODE DOC_CATEGORY_CODE
, ACS.FUTURE_PAY_CODE_COMBINATION_ID FUTURE_PAY_CODE_COMBINATION_ID
, ACS.INACTIVE_DATE INACTIVE_DATE
, ACS.LAST_AVAILABLE_DOCUMENT_NUM LAST_AVAILABLE_DOCUMENT_NUM
, ACS.LAST_DOCUMENT_NUM LAST_DOCUMENT_NUM
, ACS.LAST_UPDATED_BY LAST_UPDATED_BY
, ACS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ACS.NAME NAME
, ACS.NUM_SETUP_CHECKS NUM_SETUP_CHECKS
, ACS.ORG_ID ORG_ID
, ABA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, ABA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, ABA.CURRENCY_CODE BANK_CURRENCY_CODE
, ABA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ABA.MULTI_CURRENCY_FLAG BANK_MULTI_CURRENCY_FLAG
, ABA.ZERO_AMOUNTS_ALLOWED BANK_ZERO_AMOUNTS_ALLOWED
, ACF.NAME CHECK_FORMAT_NAME
, ACF.PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, ACF.CURRENCY_CODE FORMAT_CURRENCY_CODE
, ACF.MULTI_CURRENCY_FLAG FORMAT_MULTI_CURRENCY_FLAG
, ACF.ZERO_AMOUNTS_ONLY FORMAT_ZERO_AMOUNTS_ONLY
, ACF.INVOICES_PER_STUB INVOICES_PER_STUB
, ALC1.DISPLAYED_FIELD DISBURSEMENT_TYPE
, ALC2.DISPLAYED_FIELD PAYMENT_METHOD
, APP1.PROGRAM_NAME FORMAT_PAYMENTS_PROGRAM_NAME
, APP1.FRIENDLY_NAME FORMAT_PAYMENTS_FRIENDLY_NAME
, APP2.PROGRAM_NAME REMITTANCE_PROGRAM_NAME
, APP2.FRIENDLY_NAME REMITTANCE_FRIENDLY_NAME
, FDSC.NAME DOC_CATEGORY_NAME
, AP_AUTO_PAYMENT_PKG.GET_CHECK_STOCK_IN_USE_BY(ACS.CHECK_STOCK_ID) IN_USE_BY
, ABB.BANK_NUM BANK_NUM
, ACS.CASH_CLEARING_CCID
, ACS.FUTURE_DATED_PAYMENTS_FLAG
FROM AP_CHECK_STOCKS ACS
, AP_CHECK_FORMATS ACF
, AP_BANK_ACCOUNTS_ALL ABA
, AP_BANK_BRANCHES ABB
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_PAYMENT_PROGRAMS APP1
, AP_PAYMENT_PROGRAMS APP2
, FND_DOC_SEQUENCE_CATEGORIES FDSC
WHERE ACS.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID
AND 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
AND APP1.PROGRAM_ID = ACF.FORMAT_PAYMENTS_PROGRAM_ID
AND APP2.PROGRAM_ID (+) = ACF.REMITTANCE_ADVICE_PROGRAM_ID
AND ACS.DOC_CATEGORY_CODE = FDSC.CODE (+)
AND FDSC.APPLICATION_ID(+) = 200
AND SYSDATE < NVL(ACS.INACTIVE_DATE
, SYSDATE+1)
AND SYSDATE < NVL(ABA.INACTIVE_DATE
, SYSDATE+1)
AND SYSDATE < NVL(ABB.END_DATE
, SYSDATE+1)
AND ABA.ACCOUNT_TYPE = 'INTERNAL'