Results for “pref_functional_currency”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AST_ORG_PROFILES_V is a TeleSales (AST) view owned by the APPS schema. It presents a consolidated, denormalized projection of organization-level party data used by the Oracle TeleSales application. The view joins the Trading Community Architecture (TCA) party registry to organization profile information and decodes numerous lookup codes into their human-readable meanings, producing a single reporting surface for organizational customers.
Within Oracle EBS 12.1.1 and 12.2.2, TeleSales relies on TCA as the system of record for parties and organization profiles. Rather than requiring reporting and integration consumers to reconstruct the multi-table join themselves, AST_ORG_PROFILES_V exposes party identity, organization firmographics, financial indicators, and decoded reference values in one relational row per organization party. Because one of the projected columns is REGISTRATION_TYPE, this view is frequently surfaced when searching for registration type data in an AST context.
Underlying Base Objects
The view is defined over the following documented base objects:
HZ_PARTIES(SYNONYM) — the master party entity; drives party name, number, type, status, category, and order history metrics.HZ_ORGANIZATION_PROFILES(SYNONYM) — the organization-specific profile extension holding firmographic and financial attributes, outer-joined toHZ_PARTIESvia aPARTY_ID(+)outer join.AR_LOOKUPS(VIEW) — used repeatedly (aliased LKUP through LKUP7) as a lookup decode source for category, ownership, legal status, registration type, and certification level.
The view restricts PARTY.PARTY_TYPE to 'ORGANIZATION', and all lookup joins are outer joins keyed on their respective LOOKUP_TYPE and LOOKUP_CODE pairs.
Key Columns
- Party identity:
PARTY_ID,PARTY_NUMBER,PARTY_NAME,PARTY_TYPE,STATUS,CATEGORY_CODE. - Organization profile:
ORGANIZATION_PROFILE_ID,ORGANIZATION_NAME,KNOWN_AS,SIC_CODE,DUNS_NUMBER,YEAR_ESTABLISHED. - Registration and legal:
REGISTRATION_TYPE,TAX_REFERENCE,JGZZ_FISCAL_CODE,LEGAL_STATUS,PUBLIC_PRIVATE_OWNERSHIP_FLAG. - Commercial metrics:
TOTAL_NUM_OF_ORDERS,LAST_ORDERED_DATE,TOTAL_ORDERED_AMOUNT,CURR_FY_POTENTIAL_REVENUE,NEXT_FY_POTENTIAL_REVENUE. - Decoded meanings: the
MEANINGcolumns returned by the AR_LOOKUPS aliases, includingCERT_LEVEL_MEAN. - TCA bookkeeping:
LAST_UPDATE_DATE,CREATED_BY,OBJECT_VERSION_NUMBER,ORIG_SYSTEM_REFERENCE.
Common Use Cases and Queries
The view supports organization directory reporting, TeleSales scoring and marketing segmentation, and integration extracts that need decoded organization attributes. Filtering on REGISTRATION_TYPE is a typical requirement.
SELECT party_number,
organization_name,
registration_type,
legal_status,
duns_number
FROM apps.ast_org_profiles_v
WHERE registration_type IS NOT NULL
ORDER BY organization_name;
A second pattern aggregates order metrics for a specific organization category:
SELECT category_code,
COUNT(*) organization_count,
SUM(total_ordered_amount) total_revenue
FROM apps.ast_org_profiles_v
WHERE internal_flag = 'Y'
GROUP BY category_code;
Because the view is read-only and based on TCA synonyms, it should be queried rather than modified. For REST or interface extraction, the unique PARTY_ID is the recommended key for correlating rows back to HZ_PARTIES.
-
View: AST_ORG_PROFILES_V 12.1.1
APPS.AST_ORG_PROFILES_V·↳ AR_LOOKUPS·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AST module →
-
Table: HZ_IMP_PARTIES_INT 12.1.1
TCA import table for HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES
-
Customer credit information
-
Customer credit information
-
View: AMS_P_ORG_PROFILES_V 12.1.1
This public view returns an organization profile for an organization. Used for list generation.
APPS.AMS_P_ORG_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
JTF_CUSTOMER_PROFILES_V retrieves credit information for your customer accounts and customer account sites.
APPS.JTF_CUSTOMER_PROFILES_V·↳ HZ_CUSTOMER_PROFILES·Explore JTF module →
-
View: AMS_ORG_PROFILES_V 12.2.2
This public view returns an organization profile for an organization. Used for list generation.
APPS.AMS_ORG_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
Credit information for customer accounts and customer account sites
-
View: AMS_P_ORG_PROFILES_V 12.2.2
This public view returns an organization profile for an organization. Used for list generation.
APPS.AMS_P_ORG_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
Table: HZ_IMP_PARTIES_INT 12.2.2
TCA import table for HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES
-
Information about party retrieved from external source
-
View: AMS_ORG_PROFILES_V 12.1.1
This public view returns an organization profile for an organization. Used for list generation.
APPS.AMS_ORG_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
JTF_HZ_ORGANIZATION_PROFILES_V retrieves information about people as contacts for organizations. The table includes information about the person in the context of the organization such as their job title or rank.
APPS.JTF_HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore JTF module →
-
View: AMS_LT_ORG_PROFILES_V 12.1.1
Data Source view based on hz_organization_profiles
APPS.AMS_LT_ORG_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
JTF_CUSTOMER_PROFILES_V retrieves credit information for your customer accounts and customer account sites.
APPS.JTF_CUSTOMER_PROFILES_V·↳ HZ_CUSTOMER_PROFILES·Explore JTF module →
-
View: AMS_LT_ORG_PROFILES_V 12.2.2
Data Source view based on hz_organization_profiles
APPS.AMS_LT_ORG_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
JTF_HZ_ORGANIZATION_PROFILES_V retrieves information about people as contacts for organizations. The table includes information about the person in the context of the organization such as their job title or rank.
APPS.JTF_HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·Explore JTF module →
-
View: HZ_ORG_PROFILES_CPUI_V 12.1.1
Organization Profiles
APPS.HZ_ORG_PROFILES_CPUI_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
Customer profile class information
-
APPS.HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
Credit information for customer accounts and customer account sites
-
View: AST_ORG_PROFILES_V 12.2.2
APPS.AST_ORG_PROFILES_V·↳ AR_LOOKUPS·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AST module →
-
Standard credit profile classes
-
View: HZ_ORG_PROFILES_CPUI_V 12.2.2
Organization Profiles
APPS.HZ_ORG_PROFILES_CPUI_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
Customer profile class information
-
APPS.HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
View: AMS_ORG_DETAILS_V 12.2.2
This view list the details of an Organization
APPS.AMS_ORG_DETAILS_V·↳ HZ_CONTACT_POINTS·↳ HZ_LOCATIONS·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
View: AMS_ORG_DETAILS_V 12.1.1
This view list the details of an Organization
APPS.AMS_ORG_DETAILS_V·↳ HZ_CONTACT_POINTS·↳ HZ_LOCATIONS·↳ HZ_ORGANIZATION_PROFILES·Explore AMS module →
-
Information about party retrieved from external source
-
Standard credit profile classes
-
Detailed information about organizations
-
Detailed information about organizations
-
Lookup Type: COMPL_ORG_TAX 12.1.1
Select Attributes for Tax and Financial Information
-
VIEW: AR.HZ_IMP_PARTIES_INT# 12.2.2
-
Lookup Type: COMPL_ORG_TAX 12.2.2
Select Attributes for Tax and Financial Information