Results for “dates_positive_tolerance”

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

Overview

APPS.JTF_CUST_ACCOUNTS_V is a CRM Foundation (JTF) view that exposes customer account information for parties that have been established as customers within Oracle E-Business Suite. The view is documented in ETRM for both release 12.1.1 and 12.2.2 with a status of VALID. Its stated purpose is to retrieve information about customer relationships: when a party becomes a customer, the corresponding customer account details are surfaced through this view.

Functionally, the view presents a denormalized projection of the customer account entity, including identity, account numbering, classification, sales and order-default attributes, tax, freight, credit, and balance information, together with the standard EBS audit columns (LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID, and so on) and the DFF/global DFF attribute sets (ATTRIBUTE1–ATTRIBUTE20, GLOBAL_ATTRIBUTE1–GLOBAL_ATTRIBUTE20). Because it is a view owned by APPS, it is typically consumed by reports, concurrent programs, OA Framework/forms logic, and integration interfaces without requiring direct access to the underlying customer model.

Underlying Base Objects

Per the documented ETRM metadata, the view's referenced base object is HZ_CUST_ACCOUNTS (exposed in the APPS schema as a synonym). HZ_CUST_ACCOUNTS is the Oracle Trading Community Architecture (TCA) entity that stores customer accounts, where each account row links a PARTY_ID to an account number and the associated financial and operational attributes.

The view text shows a direct, column-level projection with no joins to other customer tables. Several columns are supplied as literals rather than sourced from the base table: ORG_ID, CATEGORY_CODE, REFERENCE_USE_FLAG, THIRD_PARTY_FLAG, and COMPETITOR_FLAG are all returned as NULL. This means that although these attributes exist in the broader customer model, they are not populated through this particular view, and any consumer that depends on them must obtain them elsewhere. Notably, REFERENCE_USE_FLAG — the term matched in the user's search — is hard-coded to NULL in JTF_CUST_ACCOUNTS_V. ROWID is also projected as ROW_ID.

Key Columns

• CUST_ACCOUNT_ID — Primary identifier of the customer account; the principal join key to related TCA and order-management entities.
• PARTY_ID — The party (organization or person) that owns the account; links to HZ_PARTIES.
• ACCOUNT_NUMBER — The user-visible customer account number.
• STATUS — Account status indicator (for example, active or inactive).
• CUSTOMER_TYPE / CUSTOMER_CLASS_CODE / SUBCATEGORY_CODE — Customer classification attributes used in reporting and segmentation.
• ORIG_SYSTEM_REFERENCE — Identifier of the account in the originating (legacy or external) system; central to data migration and cross-system reconciliation.
• PRIMARY_SALESREP_ID, PRIMARY_SPECIALIST_ID, SECONDARY_SPECIALIST_ID, SALES_CHANNEL_CODE — Sales ownership and channel attributes.
• ORDER_TYPE_ID, PRICE_LIST_ID, PAYMENT_TERM_ID, FREIGHT_TERM, SHIP_VIA, SHIP_PARTIAL, FOB_POINT, WAREHOUSE_ID — Order-management defaults applied when transactions are created for the account.
• TAX_CODE, TAX_HEADER_LEVEL_FLAG, TAX_ROUNDING_RULE — Tax determination attributes.
• CREDIT_CLASSIFICATION_CODE, RESTRICTION_LIMIT_AMOUNT, CURRENT_BALANCE, ACCOUNT_LIABLE_FLAG — Credit and exposure information.
• ACCOUNT_ESTABLISHED_DATE, ACCOUNT_ACTIVATION_DATE, ACCOUNT_TERMINATION_DATE — Account lifecycle dates.
• ORG_ID, CATEGORY_CODE, REFERENCE_USE_FLAG, THIRD_PARTY_FLAG, COMPETITOR_FLAG — Returned as NULL by this view and therefore not usable for filtering or reporting through JTF_CUST_ACCOUNTS_V.

Common Use Cases and Queries

The view is most commonly used to report on the customer account population and to look up account-level defaults by account number, party, or originating-system reference.

• Retrieve core account details for a known account:

SELECT cust_account_id, account_number, party_id, status,
       customer_type, customer_class_code
FROM   apps.jtf_cust_accounts_v
WHERE  account_number = :p_account_number;

• Reconcile migrated or interfaced accounts back to their source system:

SELECT cust_account_id, account_number, orig_system_reference
FROM   apps.jtf_cust_accounts_v
WHERE  orig_system_reference IS NOT NULL;

• Report all accounts belonging to a party, including credit and lifecycle information:

SELECT account_number, status, credit_classification_code,
       current_balance, account_activation_date, account_termination_date
FROM   apps.jtf_cust_accounts_v
WHERE  party_id = :p_party_id
ORDER BY account_number;

Because ORG_ID is projected as NULL, the view is not a reliable source for multi-org (operating unit) filtering; consumers requiring ORG_ID scoping, or the attributes carried as NULL including REFERENCE_USE_FLAG, must query the base HZ_CUST_ACCOUNTS table or an alternative view that supplies those columns.