Search Results ast_lm_org_quick_w_acc_v




Overview
Explore in AI Chat

Overview

The APPS.AST_LM_ORG_QUICK_W_ACC_V view is a TeleSales (AST) module database object that exposes a consolidated, denormalized recordset of organization-type parties together with their customer account information. Its name — "Organization Quick With Account" — signals its purpose: to provide a fast, ready-to-query projection of party and account data suitable for list-of-values (LOV) windows, quick-search screens, and lookup utilities within the Oracle TeleSales application. Rather than joining several HZ and AR tables at runtime, applications and reports can query this single view to retrieve party identity, address, contact, status, and account attributes in one pass.

The view is owned by the APPS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. Because it is a view rather than a table, it holds no data of its own; it is a stored query executed against the underlying TCA (Trading Community Architecture) and AR entities whenever it is referenced.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects:

  • HZ_PARTIES (SYNONYM) — The primary driver table, supplying organization party records.
  • HZ_CUST_ACCOUNTS (SYNONYM) — Joined on PARTY_ID to supply customer account details; the outer join (+) permits organizations without an active account.
  • FND_TERRITORIES_TL (SYNONYM) — Provides the translated country/territory short name for the party's country code.
  • AR_LOOKUPS (VIEW) — Referenced twice (aliases ALK and ALK1) to decode the party STATUS and CERTIFICATION_LEVEL into their meaningful display values.

The WHERE clause restricts output to PARTY_TYPE = 'ORGANIZATION' and to parties whose STATUS is 'I' or 'A' (Inactive or Active). Customer accounts are filtered to HCA.STATUS(+) = 'A', and language-sensitive joins on FND_TERRITORIES_TL use USERENV('LANG') for both LANGUAGE and SOURCE_LANG.

Key Columns

The view exposes the following significant columns:

Common Use Cases and Queries

Typical uses include TeleSales quick-search LOVs, party/account verification screens, and ad hoc reporting on organizations and their accounts. A representative query:

  • SELECT party_id, party_name, account_number, city, status_mean FROM apps.ast_lm_org_quick_w_acc_v WHERE party_name LIKE :name;
  • SELECT cust_account_id, party_name, full_phone_number FROM apps.ast_lm_org_quick_w_acc_v WHERE country_name = :territory;
  • SELECT party_id, account_number, cert_level_mean FROM apps.ast_lm_org_quick_w_acc_v WHERE status = 'A';

Because it is a view, no DML should target it directly; changes must be made to the underlying HZ_PARTIES and HZ_CUST_ACCOUNTS records.