Search Results org_id_1

Overview

OKL_BPD_RCPT_MTHDS_UV is a read-only view owned by the APPS schema within the OKL (Leasing and Finance Management) product family. It presents a filtered, denormalized list of receipt methods that are eligible for use against bank accounts within Oracle Receivables and Oracle Leasing workflows. In essence, it resolves the intersection between receipt methods, receipt classes, and internal bank account uses, and exposes that combined data as a single flattened row set.

The view is not a substitute for the underlying AR and CE setup tables; rather it is a convenience access point intended for LOV (List of Values) queries, concurrent report data sources, and integration lookups where a caller needs to know which receipt methods map to which bank accounts under the current organization context. Because it embeds a call to MO_GLOBAL.CHECK_ACCESS, it is multi-org aware and returns only rows belonging to organizations the current session is permitted to see.

Underlying Base Objects

The view is defined over seven underlying objects, six of which are synonyms to base tables and two of which are database programs:

• AR_LOOKUPS (VIEW) — supplies the lookup meaning for receipt class creation status.
• AR_RECEIPT_CLASSES (SYNONYM) — provides receipt class attributes including REMIT_FLAG, CONFIRM_FLAG, NOTES_RECEIVABLE, and CREATION_METHOD_CODE.
• AR_RECEIPT_METHODS (SYNONYM) — the primary receipt method definition, including start and end dates and payment type.
• AR_RECEIPT_METHOD_ACCOUNTS (SYNONYM) — the association between receipt methods and remit bank account uses.
• CE_BANK_ACCOUNTS (SYNONYM) — internal bank account master data.
• CE_BANK_ACCT_USES_ALL (SYNONYM) — bank account use assignments by org, including the AR use allowed flag.
• CE_BANK_BRANCHES_V (VIEW) — bank name and branch name attributes.
• CE_BANK_AND_ACCOUNT_UTIL (PACKAGE) — provides the masked bank account number via GET_MASKED_BANK_ACCT_NUM.
• MO_GLOBAL (PACKAGE) — enforces multi-org access control through CHECK_ACCESS.

Key Columns

The view exposes a mixture of identifiers, descriptive attributes, and derived values:

• ROW_ID and RECEIPT_METHOD_ID — the row identifier and the AR receipt method primary key.
• RECEIPT_METHOD_NAME — descriptive name of the receipt method.
• MEANING — decoded creation status meaning from AR_LOOKUPS.
• BANK_ACCOUNT_ID and BANK_ACCOUNT_NUM — the remit bank account use identifier and the masked account number.
• BANK_NAME, BANK_BRANCH_NAME, BANK_BRANCH_ID — branch and bank descriptive data.
• CURRENCY_CODE and MULTI_CURRENCY_FLAG — currency context and whether multiple currencies are permitted.
• CREATION_STATUS, RECEIPT_CLASS_NAME, REMIT_FLAG, NOTES_RECEIVABLE — receipt class behavior attributes; REMIT_FLAG in particular signals whether remittance is required for automatic receipt creation.
• ORG_ID and ORG_ID_1 — organization identifiers from the bank account use and receipt method account rows.
• RECEIPT_METHOD_START_DATE, RECEIPT_METHOD_END_DATE, INACTIVE_DATE — effective dating columns.

Common Use Cases and Queries

The most frequent use of this view is to populate receipt method and bank account selections for receipts entered against leases. A typical query filters by receipt method name and organization:

• SELECT receipt_method_name, bank_account_num, bank_name, remit_flag FROM okl_bpd_rcpt_mths_uv WHERE org_id = :p_org_id ORDER BY receipt_method_name;
• SELECT receipt_method_id, receipt_method_name FROM okl_bpd_rcpt_mths_uv WHERE remit_flag = 'Y' AND rownum < 100;
• SELECT DISTINCT bank_account_id, bank_account_num, currency_code FROM okl_bpd_rcpt_mths_uv WHERE receipt_method_id = :p_method_id;

Because the view already applies SYSDATE-based filtering on receipt method and bank account use effective dates, callers do not need to add their own date predicates. The embedded exclusion of receipt classes with NOTES_RECEIVABLE or BILL_OF_EXCHANGE_FLAG set to Y means those classes will never appear, which is important when reconciling against AR_RECEIPT_CLASSES directly.