Search Results reference_use_flag




Overview
Explore in AI Chat

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

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.

  • View: JTF_CUST_ACCOUNTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_CUST_ACCOUNTS_V,  object_name:JTF_CUST_ACCOUNTS_V,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_CUST_ACCOUNTS_V retrieves information about customer relationships. If a party becomes a customer, information about the customer account is shown. ,  implementation_dba_data: APPS.JTF_CUST_ACCOUNTS_V , 

  • View: JTF_CUST_ACCOUNTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_CUST_ACCOUNTS_V,  object_name:JTF_CUST_ACCOUNTS_V,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_CUST_ACCOUNTS_V retrieves information about customer relationships. If a party becomes a customer, information about the customer account is shown. ,  implementation_dba_data: APPS.JTF_CUST_ACCOUNTS_V , 

  • View: JTF_CUST_ACCOUNTS_ALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_CUST_ACCOUNTS_ALL_V,  object_name:JTF_CUST_ACCOUNTS_ALL_V,  status:VALID,  product: JTF - CRM Foundation ,  description: Account information of a Party. This view is identical to the underlying table HZ_CUST_ACCOUNTS. View is created so that it serves as a single poing of interface to the AR schema object. ,  implementation_dba_data: APPS.JTF_CUST_ACCOUNTS_ALL_V , 

  • View: JTF_CUST_ACCOUNTS_ALL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_CUST_ACCOUNTS_ALL_V,  object_name:JTF_CUST_ACCOUNTS_ALL_V,  status:VALID,  product: JTF - CRM Foundation ,  description: Account information of a Party. This view is identical to the underlying table HZ_CUST_ACCOUNTS. View is created so that it serves as a single poing of interface to the AR schema object. ,  implementation_dba_data: APPS.JTF_CUST_ACCOUNTS_ALL_V , 

  • View: JTF_PARTY_CONTACTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_PARTY_CONTACTS_V,  object_name:JTF_PARTY_CONTACTS_V,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_PARTY_CONTACTS_V retrieves all contacts for a party. ,  implementation_dba_data: APPS.JTF_PARTY_CONTACTS_V , 

  • View: JTF_PARTY_CONTACTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_PARTY_CONTACTS_V,  object_name:JTF_PARTY_CONTACTS_V,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_PARTY_CONTACTS_V retrieves all contacts for a party. ,  implementation_dba_data: APPS.JTF_PARTY_CONTACTS_V ,