Results for “next_fy_potential_revenue”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AMS_LT_PERSON_DETAILS_V is an APPS-owned database view within the Oracle E-Business Suite marketing product family (AMS — Marketing). It is documented as a data source view whose purpose is to retrieve information about business-to-consumer (B2C) contacts. In the ETRM metadata for release 12.2.2 the object is registered with a status of VALID and is cataloged as a VIEW under the APPS schema, the standard owner for shared, cross-module database objects in Oracle EBS.
Functionally, the view acts as a flattened, read-only projection of person-type party records, exposing name, title, salutation, contact, address, and firmographic attributes in a single denormalized structure. Its "LT" naming convention and the presence of categorization columns such as CATEGORY_CODE and REFERENCE_USE_FLAG indicate that it is intended as a list-management or list-treatment data source, allowing marketing users to build target lists, personalization tokens, and campaign audiences from B2C contact data without joining the full normalized Trading Community Architecture (TCA) model. Because it selects only active person parties, it is well suited to operational marketing reporting and integration extracts.
Underlying Base Objects
Per the documented view text, the sole referenced base object is HZ_PARTIES, exposed in the APPS schema as a synonym. The view is defined as a straightforward SELECT over that table with two hard-coded filter predicates: STATUS = 'A' (active parties only) and PARTY_TYPE = 'PERSON' (individuals, not organizations or groups). The view therefore inherits the TCA party model's authoritative identity and contact columns and does not perform any joins to HZ_PERSON_PROFILES, HZ_LOCATIONS, or HZ_CONTACTS in the excerpted definition; the contact and address columns are drawn directly from HZ_PARTIES. Because the definition is a simple projection over a single base object, no aggregation or set operators are involved, and row counts mirror the qualifying HZ_PARTIES rows.
Key Columns
Given the user's search term "person_title", the most directly relevant column is PERSON_TITLE, which carries the party's professional or courtesy title (for example, Mr., Ms., Dr.), complemented by PERSON_ACADEMIC_TITLE for academic credentials and SALUTATION for the formatted greeting. Person name components are exposed individually: PERSON_FIRST_NAME, PERSON_LAST_NAME, PERSON_PRE_NAME_ADJUNCT, PERSON_MIDDLE_NAME, and PERSON_NAME_SUFFIX, alongside PARTY_NAME (the concatenated display name) and KNOWN_AS. Identity and reference columns include PARTY_ID, PARTY_NUMBER, ORIG_SYSTEM_REFERENCE, CUSTOMER_KEY, TAX_REFERENCE, JGZZ_FISCAL_CODE, and DUNS_NUMBER_C.
- Contact and location: EMAIL_ADDRESS, URL, COUNTRY, ADDRESS1–ADDRESS4, CITY, STATE, PROVINCE, COUNTY, POSTAL_CODE.
- Classification: SIC_CODE, SIC_CODE_TYPE, CATEGORY_CODE, REFERENCE_USE_FLAG, HQ_BRANCH_IND, GSA_INDICATOR_FLAG.
- Firmographic and transactional: TOTAL_NUM_OF_ORDERS, TOTAL_ORDERED_AMOUNT, LAST_ORDERED_DATE, EMPLOYEES_TOTAL, YEAR_ESTABLISHED, ANALYSIS_FY, FISCAL_YEAREND_MONTH, CURR_FY_POTENTIAL_REVENUE, NEXT_FY_POTENTIAL_REVENUE, TAX_NAME, LANGUAGE_NAME.
- Phonetic search: ORGANIZATION_NAME_PHONETIC, PERSON_FIRST_NAME_PHONETIC, PERSON_LAST_NAME_PHONETIC.
Common Use Cases and Queries
Typical scenarios include building B2C target lists for campaigns, supplying personalization values to marketing templates, and extracting person contact data for downstream analytics. The filter on PARTY_TYPE = 'PERSON' means organization parties are excluded automatically, so no additional predicate is required for consumer-only extracts.
Retrieve titled contacts for a mailing list:
- SELECT party_id, party_name, person_first_name, person_last_name, person_title, email_address FROM ams_lt_person_details_v WHERE person_title IS NOT NULL;
Filter by fiscal analysis period and revenue potential:
- SELECT party_number, party_name, analysis_fy, curr_fy_potential_revenue, next_fy_potential_revenue FROM ams_lt_person_details_v WHERE analysis_fy = :p_fy ORDER BY next_fy_potential_revenue DESC;
Identify high-value consumers by order history:
- SELECT party_id, party_name, total_num_of_orders, total_ordered_amount, last_ordered_date FROM ams_lt_person_details_v WHERE total_num_of_orders > 0 ORDER BY total_ordered_amount DESC;
Because the view is a synonym-backed projection, queries benefit from indexing on HZ_PARTIES primary and alternate keys; PARTY_ID remains the reliable join key back to TCA for any attributes not exposed here.
-
Data Source view to get information about b2c contacts
APPS.AMS_LT_PERSON_DETAILS_V·↳ HZ_PARTIES·Explore AMS module →
-
View: IGS_AD_ACK_LETTER_V 12.1.1
It would return the Acknowledgement Details of a student
APPS.IGS_AD_ACK_LETTER_V·↳ HZ_PARTIES·↳ IGS_AD_APPL_ADMAPPL_V·↳ IGS_AD_APPL_STAT·Explore IGS module →
-
View: UMX_ORGANIZATION_PVT_V 12.1.1
Private view used by UMX
APPS.UMX_ORGANIZATION_PVT_V·↳ HZ_PARTIES·Explore FND module →
-
Returns the missing items. For processing application of the student, few documents are required by the admission module. When student forget to send any document or miss out any document , then these documents are treated as missing items
APPS.IGS_AD_MISSING_ITEMS_LETTER_V·↳ HZ_PARTIES·↳ IGS_AD_APLINS_ADMREQ·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
View: AMS_ORGANIZATION_V 12.2.2
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
The validations for the individual letters are placed at the SQLl query level that we attach to master document
APPS.IGS_AD_OUTCOME_LETTERS_V·↳ HZ_PARTIES·↳ IGS_AD_APPL_ADMAPPL_V·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
View: IGF_AW_PER_LIST_V 12.1.1
Stores person details used for correspondence
APPS.IGF_AW_PER_LIST_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
View: AMS_P_ORGANIZATION_V 12.2.2
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
View: AMS_P_ORGANIZATION_V 12.1.1
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
Table: HZ_IMP_PARTIES_INT 12.2.2
TCA import table for HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES
-
View: IGF_AW_AWD_LTR_V 12.1.1
This view selects relevant data for the Award Notification Letter to be sent to a Student
APPS.IGF_AW_AWD_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWD_LTR_TMP·Explore IGF module →
-
View: AST_ORG_PARTIES_V 12.2.2
-
Information about parties such as organizations, people, and groups
-
View: AMS_ORGANIZATION_V 12.1.1
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
It returns the Missing items for Post Admission Requirements
APPS.IGS_AD_POSTADM_MISS_ITM_LTR_V·↳ HZ_PARTIES·↳ IGS_AD_APLINS_ADMREQ·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
View: AMS_DM_ORGANIZATIONS_V 12.1.1
This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for organizations and organization contacts in the Trading Community Architecture.
APPS.AMS_DM_ORGANIZATIONS_V·↳ AMS_DM_PARTY_DETAILS·↳ AMS_DM_PARTY_DETAILS_TIME·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 →
-
View: IGF_AP_MIS_ITMS_LTR_V 12.1.1
This view is used to return the missing items (missing documents) which are required for Financial Aid processing
APPS.IGF_AP_MIS_ITMS_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AP_ST_CORR_TEXT·Explore IGF module →
-
View: AST_ORG_PROFILES_V 12.1.1
APPS.AST_ORG_PROFILES_V·↳ AR_LOOKUPS·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AST 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 →
-
View: AMS_DM_ORGANIZATIONS_V 12.2.2
This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for organizations and organization contacts in the Trading Community Architecture.
APPS.AMS_DM_ORGANIZATIONS_V·↳ AMS_DM_PARTY_DETAILS·↳ AMS_DM_PARTY_DETAILS_TIME·Explore AMS module →
-
Data Source view to get information about b2c contacts
APPS.AMS_LT_PERSON_DETAILS_V·↳ HZ_PARTIES·Explore AMS module →
-
View: UMX_ORGANIZATION_PVT_V 12.2.2
Private view used by UMX
APPS.UMX_ORGANIZATION_PVT_V·↳ HZ_PARTIES·Explore FND module →
-
View: IGF_SL_DISB_LTR_V 12.1.1
Stores persons loan details used for correspondence
APPS.IGF_SL_DISB_LTR_V·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF 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 →
-
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 →
-
Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack. This is a staging table.
-
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_HZ_B2B_MAPPING_V 12.1.1
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_HZ_B2B_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
Table: HZ_IMP_PARTIES_INT 12.1.1
TCA import table for HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES
-
APPS.HZ_PARTY_CONTACT_POINTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_PARTIES·Explore AR module →
-
APPS.HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
View: AST_ORG_PARTIES_V 12.1.1
-
Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack. This is a staging table.
-
View: IGS_AD_RESI_LETTER_V 12.1.1
It would return the Residency Details of a student
APPS.IGS_AD_RESI_LETTER_V·↳ HZ_PARTIES·↳ IGS_AD_APPL·↳ IGS_CA_INST·Explore IGS module →
-
View: AST_ORG_PROFILES_V 12.2.2
APPS.AST_ORG_PROFILES_V·↳ AR_LOOKUPS·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AST module →
-
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 →
-
View: AMS_HZ_B2B_MAPPING_V 12.2.2
This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
APPS.AMS_HZ_B2B_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
APPS.HZ_PARTY_CONTACT_POINTS_V·↳ HZ_CONTACT_POINTS·↳ HZ_PARTIES·Explore AR module →
-
Detailed information about organizations
-
APPS.HZ_ORGANIZATION_PROFILES_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore AR module →
-
Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack. This is a staging table.
-
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 parties such as organizations, people, and groups
-
Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack. This is a staging table.
-
Detailed information about organizations