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
APPS.CE_PAYMENT_DOCUMENTS pd,
APPS.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;
Helping Oracle community with Technical and Functional helps on Oracle Applications R12
Nov 17, 2022
Query to find Check Number Setups
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment