Search Results account_activation_date

Overview

AMS_TAR_ACCOUNT_V is an Oracle E-Business Suite database view owned by the APPS schema and classified under the AMS (Marketing) product family. Its documented purpose is to present the information stored for a list source type identified as "AMS_ACCOUNT." In Oracle Marketing, a "list" is a reusable collection of source records used for campaign targeting, list import, and audience selection. Because list sources are highly configurable, the underlying storage is denormalized: each list source definition maps its fields into generic positional columns (COL1 through COL53) in the AMS_LIST_ENTRIES table. AMS_TAR_ACCOUNT_V resolves those positional columns into meaningful, business-friendly column names, giving the appearance of a conventional account-oriented table. Users searching for terminology such as "account_activation_date" will find that the view exposes a column literally named ACCOUNT_ACTIVATION_DATE, which is aliased from the positional column COL8. This makes the view the primary way to read account list source data without decoding generic column positions manually, and it is useful in reporting, concurrent program development, and integration extracts.

Underlying Base Objects

The ETRM metadata records the referenced base object for AMS_TAR_ACCOUNT_V as AMS_LIST_ENTRIES (documented as a SYNONYM pointing to the underlying AMS table). The view is a thin projection over that object: nearly every column in the view is an alias of a positional column in AMS_LIST_ENTRIES, while an additional set of columns is passed through unchanged. This design is significant because it means the view only returns rows belonging to the "AMS_ACCOUNT" list source; rows for other list source types stored in the same table are not reinterpreted by this view. Consequently, the view should be treated as a source-type-specific facade, and any query against it should be understood as filtering or joining back to AMS_LIST_ENTRIES on list entry and list header identifiers.

Key Columns

ACCOUNT_ACTIVATION_DATE, ACCOUNT_ESTABLISHED_DATE, ACCOUNT_TERMINATION_DATE, STATUS, CUSTOMER_TYPE, CUSTOMER_CLASS_CODE, MAJOR_ACCOUNT_NUMBER — account and status attributes derived from COL8, COL7, COL9, COL3, COL4, COL5 and COL6 respectively.
ACCOUNT_NAME, ACCOUNT_NUMBER — the primary account identifiers, aliased from COL1 and COL2.
Bill-To, Ship-To, Contact and Guarantor blocks — address, name, city, state, postal code, and title attributes mapped from COL10 through COL53 and already-named columns such as ADDRESS_LINE1, CITY, STATE, ZIPCODE, FIRST_NAME, LAST_NAME, SUFFIX and TITLE.
LIST_ENTRY_ID, LIST_HEADER_ID, OBJECT_VERSION_NUMBER, LIST_SELECT_ACTION_ID — technical keys identifying the specific list entry and its parent list, and supporting optimistic locking.
SOURCE_CODE, ARC_LIST_USED_BY_SOURCE, ARC_LIST_SELECT_ACTION_FROM — list source and selection action metadata describing how the entry was selected and which source consumed it.
PARTY_ID — the trading community party identifier, allowing joins to party and customer master data.
PIN_CODE and source system columns — LIST_ENTRY_SOURCE_SYSTEM_ID and LIST_ENTRY_SOURCE_SYSTEM_TYPE identify the external system that supplied the entry.

Common Use Cases and Queries

The view is typically queried to validate and extract account-based list entries for a specific list header, or to locate accounts by activation criteria. For example, to retrieve accounts and their activation dates for a given list:

SELECT account_number, account_name, account_activation_date, status FROM apps.ams_tar_account_v WHERE list_header_id = :header_id;
SELECT account_number, account_activation_date FROM apps.ams_tar_account_v WHERE account_activation_date >= :from_date ORDER BY account_activation_date;
Joining to party master: SELECT v.account_name, v.party_id FROM apps.ams_tar_account_v v, apps.hz_parties p WHERE v.party_id = p.party_id;

Typical scenarios include auditing list source population, extracting audiences for campaign execution, reconciling list entries imported from external source systems, and reporting on account lifecycle dates. Because the view is built on AMS_LIST_ENTRIES, performance improves when queries constrain LIST_HEADER_ID or LIST_ENTRY_ID, allowing the database to use the underlying indexes rather than scanning all list source rows.

View: AMS_TAR_ACCOUNT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_TAR_ACCOUNT_V, object_name:AMS_TAR_ACCOUNT_V, status:VALID, product: AMS - Marketing , description: This View shows the information stored for an "AMS_ACCOUNT" List source type. , implementation_dba_data: APPS.AMS_TAR_ACCOUNT_V ,
View: AMS_TAR_ACCOUNT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_TAR_ACCOUNT_V, object_name:AMS_TAR_ACCOUNT_V, status:VALID, product: AMS - Marketing , description: This View shows the information stored for an "AMS_ACCOUNT" List source type. , implementation_dba_data: APPS.AMS_TAR_ACCOUNT_V ,
View: AMS_ORG_ACCT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_ORG_ACCT_V, object_name:AMS_ORG_ACCT_V, status:VALID, product: AMS - Marketing , description: Customer account information , implementation_dba_data: APPS.AMS_ORG_ACCT_V ,
View: AMS_PERSON_ACCT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_PERSON_ACCT_V, object_name:AMS_PERSON_ACCT_V, status:VALID, product: AMS - Marketing , implementation_dba_data: APPS.AMS_PERSON_ACCT_V ,
View: AMS_P_ACCT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_P_ACCT_V, object_name:AMS_P_ACCT_V, status:VALID, product: AMS - Marketing , description: This view returns all entries from the HZ_CUST_ACCOUNTS_ALL table. Used for list generation only. , implementation_dba_data: APPS.AMS_P_ACCT_V ,
View: AMS_P_ACCT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_P_ACCT_V, object_name:AMS_P_ACCT_V, status:VALID, product: AMS - Marketing , description: This view returns all entries from the HZ_CUST_ACCOUNTS_ALL table. Used for list generation only. , implementation_dba_data: APPS.AMS_P_ACCT_V ,
View: AMS_ORG_ACCT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_ORG_ACCT_V, object_name:AMS_ORG_ACCT_V, status:VALID, product: AMS - Marketing , description: Customer account information , implementation_dba_data: APPS.AMS_ORG_ACCT_V ,
View: AMS_PERSON_ACCT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_PERSON_ACCT_V, object_name:AMS_PERSON_ACCT_V, status:VALID, product: AMS - Marketing , implementation_dba_data: APPS.AMS_PERSON_ACCT_V ,