SELECT pd.payment_document_name "Payment Document Name",
pd.first_available_document_num "Check Number Begin",
pd.last_available_document_number "Check Number End",
(pd.last_available_document_number -
pd.first_available_document_num) + 1 "Num of Total Checks",
pd.last_issued_document_number "Last Issued Check Number",
(pd.last_issued_document_number -
pd.first_available_document_num) + 1 "Num Of Checks Used",
(pd.last_available_document_number -
pd.last_issued_document_number) "Num Of Checks Remaining",
pd.format_code "Format Code",
ba.bank_account_name "Bank Account Name"
FROM CE_PAYMENT_DOCUMENTS pd,
CE_BANK_ACCOUNTS ba
WHERE TRUNC (NVL (pd.inactive_date, SYSDATE)) >= TRUNC (SYSDATE) -- active ones
AND pd.internal_bank_account_id = ba.bank_account_id
ORDER BY pd.payment_document_name;
pd.first_available_document_num "Check Number Begin",
pd.last_available_document_number "Check Number End",
(pd.last_available_document_number -
pd.first_available_document_num) + 1 "Num of Total Checks",
pd.last_issued_document_number "Last Issued Check Number",
(pd.last_issued_document_number -
pd.first_available_document_num) + 1 "Num Of Checks Used",
(pd.last_available_document_number -
pd.last_issued_document_number) "Num Of Checks Remaining",
pd.format_code "Format Code",
ba.bank_account_name "Bank Account Name"
FROM CE_PAYMENT_DOCUMENTS pd,
CE_BANK_ACCOUNTS ba
WHERE TRUNC (NVL (pd.inactive_date, SYSDATE)) >= TRUNC (SYSDATE) -- active ones
AND pd.internal_bank_account_id = ba.bank_account_id
ORDER BY pd.payment_document_name;
No comments:
Post a Comment