Search Results ast_lm_org_quick_v




Overview
Explore in AI Chat

Overview

AST_LM_ORG_QUICK_V is a TeleSales (AST) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a lightweight, denormalized projection of organization-type parties registered in the Oracle Trading Community Architecture (TCA) registry, together with decoded lookup meanings and formatted telephony attributes. The view name reflects its design intent: a "quick" lookup list of organizations for List Manager and TeleSales agent interfaces, where rapid retrieval of party identity, address, contact and certification information is prioritized over completeness.

The view returns no transactional or account-level data. Specifically, CUST_ACCOUNT_ID and ACCOUNT_NUMBER are emitted as NULL and TO_NUMBER(NULL) respectively, so consumers must join to HZ_CUST_ACCOUNTS when customer account context is required. The view is therefore best understood as a party-centric directory rather than a customer master.

Underlying Base Objects

The view is defined over three documented base objects: HZ_PARTIES (synonym), FND_TERRITORIES_TL (synonym) and AR_LOOKUPS (view). HZ_PARTIES supplies the driving records and is restricted by the predicate PARTY_TYPE = 'ORGANIZATION', which excludes persons and relationships. FND_TERRITORIES_TL is outer-joined on COUNTRY = TERRITORY_CODE with the LANGUAGE and SOURCE_LANG attributes bound to USERENV('LANG'), so territory short names are returned in the session language where a translation exists. AR_LOOKUPS is referenced twice—once as ALK to decode CODE_STATUS and once as ALK1 to decode HZ_PARTY_CERT_LEVEL—both join paths being outer joins except for the mandatory status lookup.

Because AR_LOOKUPS is itself a view over FND_LOOKUP_VALUES, the join is effectively a lookup-resolution layer rather than a true transactional dependency. The status predicate restricts output rows to parties whose STATUS is 'A' (Active) or 'I' (Inactive).

Key Columns

The view exposes twenty-five columns. Identity columns include PARTY_ID, PARTY_NUMBER and PARTY_NAME. ADDRESS is a concatenation of ADDRESS1 through ADDRESS4, accompanied by discrete CITY, COUNTY, STATE, POSTAL_CODE, PROVINCE and COUNTRY columns, with COUNTRY_NAME resolving the territory short name from FND_TERRITORIES_TL. Contact columns include EMAIL_ADDRESS and URL.

Status handling is represented by STATUS (the raw lookup code) and STATUS_MEAN (the decoded CODE_STATUS meaning). The certification attributes, of direct relevance to searches such as cert_level_mean, are CERTIFICATION_LEVEL and CERT_LEVEL_MEAN, the latter decoded from the HZ_PARTY_CERT_LEVEL lookup type via ALK1. Telephony data is provided as PRIMARY_PHONE_COUNTRY_CODE, PRIMARY_PHONE_AREA_CODE, PRIMARY_PHONE_NUMBER and PRIMARY_PHONE_EXTENSION, plus two derived composites: FULL_PHONE_NUMBER (a hyphen-delimited concatenation with NVL defaults for missing country and area codes) and PHONE_AREA_NUMBER (area code concatenated with number).

Common Use Cases and Queries

Typical usage includes TeleSales organization pick lists, List Manager target verification, and inbound integration extracts where certification tier and status are required for routing or compliance checks. A representative query retrieving active organizations with decoded certification meaning is:

SELECT party_number, party_name, city, country_name, status_mean, cert_level_mean, full_phone_number FROM apps.ast_lm_org_quick_v WHERE status_mean = 'Active' AND cert_level_mean IS NOT NULL ORDER BY party_name;

To locate certified organizations by telephone area, the composite column avoids re-deriving formatting:

SELECT party_name, phone_area_number, cert_level_mean FROM apps.ast_lm_org_quick_v WHERE phone_area_code = '415';

Because CUST_ACCOUNT_ID is NULL, account-aware reporting requires an explicit join to HZ_CUST_ACCOUNTS on PARTY_ID. Users searching for cert_level_mean should also note that the column is null when CERTIFICATION_LEVEL is unpopulated or the lookup value is unmapped, since the join to AR_LOOKUPS is outer.