Search Results competitor_flag

Overview

AMS_DM_PERSONS_V is a valid view owned by the APPS schema within the Oracle E-Business Suite, associated with the AMS (Marketing) product family. It is a denormalized reporting construct used by the seeded data mining data source for persons in the Trading Community Architecture (TCA). The view presents a wide, flattened profile of an individual party, combining the party identifier with personal names, addresses, demographic attributes, lifestyle and interest indicators, financial and credit-related flags, and an extensive set of behavioral metrics such as targeting frequency, order history, and contact activity. Its purpose is to expose a single, query-friendly row per person for analytical and marketing-campaign consumption without requiring the consumer to join numerous underlying TCA and transactional tables.

Per the documented metadata, an important caveat applies: the view is no longer used for seeded data sources as of 15-Jul-2004. It therefore persists as a legacy object. Its presence remains relevant to installations where custom reports, data mining configurations, or downstream extracts were built against it and may still reference it.

Underlying Base Objects

In Oracle EBS 12.2.2, AMS_DM_PERSONS_V is documented as being defined over two referenced base objects, both exposed to APPS as synonyms:

AMS_DM_PARTY_DETAILS (SYNONYM) — the primary source of party-level demographic, address, interest, financial, and credit detail.
AMS_DM_PARTY_DETAILS_TIME (SYNONYM) — a companion object supplying time-variant behavioral measures, such as days-since metrics, targeting counts across rolling windows, and aggregated order values.

The view joins these party detail structures to produce one row keyed by PARTY_ID. Because the referenced objects are presented as synonyms, the physical tables reside outside the APPS schema and are surfaced through public or APPS synonyms, consistent with standard EBS dictionary practice.

Key Columns

The view exposes well over eighty columns. Among the most significant:

PARTY_ID — the TCA party identifier, the view's principal key.
Identity columns — PERSON_FIRST_NAME, PERSON_MIDDLE_NAME, PERSON_LAST_NAME, PERSON_NAME_SUFFIX, PERSON_TITLE, PERSON_ACADEMIC_TITLE, PERSON_PRE_NAME_ADJUNCT, and EMAIL_ADDRESS.
Address columns — ADDRESS1, ADDRESS2, CITY, STATE, PROVINCE, COUNTY, ZIP_CODE, and COUNTRY.
Demographic and lifestyle columns — GENDER, ETHNICITY, MARITAL_STATUS, PERSONAL_INCOME, HOUSEHOLD_INCOME, HOUSEHOLD_SIZE, HOH_FLAG, DEGREE_RECEIVED, SCHOOL_TYPE, OCCUPATION, and the INTEREST_*_FLAG series.
Credit and financial columns — this is where the user's search term, CREDIT_CHECK_FLAG, resides, alongside related attributes such as CREDIT_HOLD_FLAG, CREDIT_RATING, RISK_CODE, TOLERANCE, DISCOUNT_TERMS_FLAG, DUNNING_LETTERS_FLAG, INTEREST_CHARGES_FLAG, and SEND_STATEMENTS_FLAG.
Behavioral and order metrics — NUM_TIMES_TARGETED, DAYS_SINCE_LAST_TARGETED, AVG_ORDER_AMOUNT, AVG_UNITS_PER_ORDER, TOT_NUM_ORDERS_YEAR, and the TOT_ORDER_AMOUNT_* rolling-window columns.
Classification flags — COMPETITOR_FLAG and THIRD_PARTY_FLAG.

Common Use Cases and Queries

The view supports party-level marketing analysis, credit profiling, and targeting studies. A common query retrieves persons flagged for a credit check together with their rating:

SELECT party_id, person_last_name, credit_check_flag, credit_rating, risk_code
FROM   apps.ams_dm_persons_v
WHERE  credit_check_flag = 'Y';

Analysts frequently combine targeting and interest attributes for campaign selection:

SELECT party_id, email_address, num_times_targeted, days_since_last_targeted
FROM   apps.ams_dm_persons_v
WHERE  interest_travel_flag = 'Y'
ORDER  BY num_times_targeted DESC;

Because the view is a legacy, non-seeded data mining object, consumers should confirm that retained custom reports still require it and evaluate whether newer TCA party and marketing data sources offer an equivalent, supported profile before relying on it for new development.

View: AMS_DM_PERSONS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_DM_PERSONS_V, object_name:AMS_DM_PERSONS_V, status:VALID, product: AMS - Marketing , description: This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for persons in the Trading Community Architecture. , implementation_dba_data: APPS.AMS_DM_PERSONS_V ,
View: AMS_DM_PERSONS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_DM_PERSONS_V, object_name:AMS_DM_PERSONS_V, status:VALID, product: AMS - Marketing , description: This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for persons in the Trading Community Architecture. , implementation_dba_data: APPS.AMS_DM_PERSONS_V ,
View: AMS_DM_ORGANIZATIONS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_DM_ORGANIZATIONS_V, object_name:AMS_DM_ORGANIZATIONS_V, status:VALID, product: AMS - Marketing , description: 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. , implementation_dba_data: APPS.AMS_DM_ORGANIZATIONS_V ,
View: AMS_DM_ORGANIZATIONS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_DM_ORGANIZATIONS_V, object_name:AMS_DM_ORGANIZATIONS_V, status:VALID, product: AMS - Marketing , description: 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. , implementation_dba_data: APPS.AMS_DM_ORGANIZATIONS_V ,
View: AMS_ORG_DETAILS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_ORG_DETAILS_V, object_name:AMS_ORG_DETAILS_V, status:VALID, product: AMS - Marketing , description: This view list the details of an Organization , implementation_dba_data: APPS.AMS_ORG_DETAILS_V ,
View: AMS_ORG_DETAILS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_ORG_DETAILS_V, object_name:AMS_ORG_DETAILS_V, status:VALID, product: AMS - Marketing , description: This view list the details of an Organization , implementation_dba_data: APPS.AMS_ORG_DETAILS_V ,