[Home] [Help]
| Product: | AX - Global Accounting Engine |
|---|---|
| Description: | Bank, clearing, and future clearing asset accounts for an Oracle Payables check |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AC.CHECK_ID
, DECODE(AC.PAYMENT_TYPE_FLAG
, 'R'
, DECODE(ASP.RECON_ACCOUNTING_FLAG
, 'Y'
, ABA.CASH_CLEARING_CCID
, ABA.ASSET_CODE_COMBINATION_ID)
, DECODE(AC.FUTURE_PAY_DUE_DATE
, NULL
, DECODE(ASP.RECON_ACCOUNTING_FLAG
, 'Y'
, ACS.CASH_CLEARING_CCID
, ABA.ASSET_CODE_COMBINATION_ID)
, DECODE(ASP.FUTURE_DATED_PMT_ACCT_SOURCE
, 'SUPPLIER SITE'
, NVL(PVS.FUTURE_DATED_PAYMENT_CCID
, NVL(ACS.FUTURE_PAY_CODE_COMBINATION_ID
, ABA.ASSET_CODE_COMBINATION_ID) )
, NVL(ACS.FUTURE_PAY_CODE_COMBINATION_ID
, ABA.ASSET_CODE_COMBINATION_ID) ) ) ) ASSET_CCID
, AC.PAYMENT_TYPE_FLAG AC_PAYMENT_TYPE_FLAG
, AC.FUTURE_PAY_DUE_DATE AC_FUTURE_PAY_DUE_DATE
, ACS.FUTURE_PAY_CODE_COMBINATION_ID ACS_FUTURE_PAY_CCID
, ACS.CASH_CLEARING_CCID ACS_CASH_CLEARING_CCID
, ABA.CASH_CLEARING_CCID ABA_CASH_CLEARING_CCID
, ABA.ASSET_CODE_COMBINATION_ID ABA_ASSET_CCID
, PVS.FUTURE_DATED_PAYMENT_CCID PVS_FUTURE_DATED_PAYMENT_CCID
, ASP.RECON_ACCOUNTING_FLAG ASP_RECON_ACCOUNTING_FLAG
, ASP.FUTURE_DATED_PMT_ACCT_SOURCE ASP_FUTURE_PMT_ACCT_SOURCE
FROM AP_CHECKS_ALL AC
, AP_CHECK_STOCKS_ALL ACS
, AP_BANK_ACCOUNTS_ALL ABA
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, AP_SYSTEM_PARAMETERS_ALL ASP
WHERE AC.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND AC.CHECK_STOCK_ID = ACS.CHECK_STOCK_ID
AND AC.VENDOR_ID = PV.VENDOR_ID
AND AC.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND AC.ORG_ID = PVS.ORG_ID
AND AC.ORG_ID = ASP.ORG_ID
AND ABA.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID