Results for “ap_check_stocks_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_CHECK_STOCKS_V is a Payables (AP) view in Oracle E-Business Suite that presents bank check stock master data together with human-readable descriptions of the associated disbursement type and payment method. Its documented purpose in the ETRM metadata is tied specifically to Release 10SC, and the documentation states explicitly that it is "Not implemented in this database." This notation indicates that the view was shipped or catalogued for an earlier, localized release context (10SC) and that the seeded definition may not exist in a standard 12.1.1 or 12.2.2 instance unless it has been carried forward through upgrade or manually created.

Functionally, the view serves a reporting and integration role: it denormalizes the internal lookup codes already stored on the base check stock and check format records into their displayed meanings. Downstream applications, custom reports, and interfaces that need to present check stock configuration without performing their own lookup joins can consume a single, flat result set. Because it exposes only the identifiers, stock name, disbursement type, and payment method, its scope is deliberately narrow — it is a descriptive reference view rather than a transactional payment view.

Underlying Base Objects

The ETRM metadata for 12.2.2 documents no owner and no referenced base objects. The view text supplied in the documentation, however, defines the view over four AP tables:

• AP_CHECK_STOCKS (ACS) — the driving table holding bank account, check stock, name, disbursement type code, and check format references.
• AP_CHECK_FORMATS (ACF) — supplies the payment method lookup code for the stock's assigned format.
• AP_LOOKUP_CODES (ALC1) — joined for LOOKUP_TYPE = 'DISBURSEMENT TYPE', resolving the disbursement type code to its displayed field.
• AP_LOOKUP_CODES (ALC2) — joined with the outer-join operator (+) for LOOKUP_TYPE = 'PAYMENT METHOD', resolving the format's payment method code to its displayed field.

The joins key AP_CHECK_STOCKS to AP_CHECK_FORMATS on CHECK_FORMAT_ID, and each lookup table to its respective coded column. The outer join on ALC2 means a check stock is still returned when no valid payment method lookup exists, with PAYMENT_METHOD null.

Key Columns

• BANK_ACCOUNT_ID — the internal identifier of the bank account to which the check stock belongs.
• CHECK_STOCK_ID — the unique identifier of the check stock record.
• NAME — the user-defined name of the check stock, the primary descriptive attribute for reporting.
• DISBURSEMENT_TYPE — the displayed meaning derived from AP_LOOKUP_CODES for the stock's disbursement type lookup code.
• PAYMENT_METHOD — the displayed meaning derived from AP_LOOKUP_CODES for the payment method associated with the stock's check format; may be null.

Common Use Cases and Queries

Typical uses include verifying which check stocks exist for a given bank account, confirming the disbursement type and payment method configured against each stock, and feeding configuration extracts into reconciliation or print-management tooling.

• Listing all check stocks with their descriptive attributes.
• Filtering check stocks by bank account for a specific payment program.
• Identifying stocks whose payment method could not be resolved (null PAYMENT_METHOD), signalling a lookup or format configuration gap.

Sample query:

SELECT bank_account_id,
       check_stock_id,
       name,
       disbursement_type,
       payment_method
FROM   ap_check_stocks_v
WHERE  bank_account_id = :p_bank_account_id
ORDER BY name;

Because the view is documented as not implemented in the reference database, verify its existence before relying on it: query ALL_VIEWS for VIEW_NAME = 'AP_CHECK_STOCKS_V' or ALL_OBJECTS for OBJECT_NAME = 'AP_CHECK_STOCKS_V'. If absent, the equivalent query can be constructed directly against AP_CHECK_STOCKS, AP_CHECK_FORMATS, and AP_LOOKUP_CODES as shown in the documented view text.