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;
1 comment:
Very interesting article and definitely worth reading. I appreciate the amount of useful information included here, especially the practical points that readers can easily understand. The writing feels natural and engaging. Keep up the good work and continue sharing informative content. Kalyan Morning Chart
Kalyan Morning Panel Chart
Karnataka Day Chart
Post a Comment