DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_P_LIST_HEADERS_V

Object Details
Object Name: AMS_P_LIST_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_P_LIST_HEADERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_NAME VARCHAR2 (4000)
The Name of The Marketing Activity which Owns The List.
ACTIVITY_TYPE VARCHAR2 (80) Yes The Type of Marketing Activity which Owns The List.
LIST_HEADER_ID NUMBER
Yes Unique Identifier.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column.
CREATION_DATE DATE
Yes Standard WHO column.
CREATED_BY NUMBER (15) Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes.
REQUEST_ID NUMBER (15)
Standard WHO column.
PROGRAM_ID NUMBER (15)
Identifier of last concurrent program to update record.
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update record.
PROGRAM_UPDATE_DATE DATE

Las date concurrent program updated record.
VIEW_APPLICATION_ID NUMBER

The Oracle Applications Product Identifier which Owns the list.
LIST_NAME VARCHAR2 (240)
The List Name which must be unique for a View_Application_Id.
LIST_USED_BY_ID NUMBER
Yes The Foreign Key to The Oracle Marketing Activity which Owns the list.
ARC_LIST_USED_BY VARCHAR2 (30) Yes The Type of Marketing Activity which Owns The List.
LIST_TYPE VARCHAR2 (30) Yes This field is used to categorize the list.
STATUS_CODE VARCHAR2 (30) Yes The Current Status of The List.
STATUS_DATE DATE
Yes The Date on which the current status was set.
GENERATION_TYPE VARCHAR2 (30) Yes Determines if The List will be Refreshed or Repeated each time a generation is Requested.
ROW_SELECTION_TYPE VARCHAR2 (30) Yes The List Entries can be selected using a Standard, Random or Nth Record Selection criteria.
OWNER_USER_ID NUMBER (15) Yes The Oracle Applications User Id of The List Owner.
OWNER_NAME VARCHAR2 (240)
The Oracle Applications Logon Name of The List Owner.
OWNER_EMAIL_ADDRESS VARCHAR2 (240)
The Email address of The List Owner.
OWNER_EMPLOYEE_ID VARCHAR2 (30)
The Employee Id of The List Owner.
ACCESS_LEVEL VARCHAR2 (30)
The Security Access Level for this list.
ACCESS_LEVEL_MEANING VARCHAR2 (80) Yes The description of The Security access level for the list.
ENABLE_LOG_FLAG VARCHAR2 (1)
A Detailed Log of The List generation process will be written to The AMS_ACTIVITY_LOGS table.
ENABLE_WORD_REPLACEMENT_FLAG VARCHAR2 (1)
Word Replacement will be used during The List De Duplication Process.
ENABLE_PARALLEL_DML_FLAG VARCHAR2 (1)
The List Generation Process will be use Parallel Processing(recommened for large lists only) .
DEDUPE_DURING_GENERATION_FLAG VARCHAR2 (1)
De Duplicate The Lists set of Entries during The generation process.
GENERATE_CONTROL_GROUP_FLAG VARCHAR2 (1)
Generate a Control Group set of list entries .
LAST_GENERATION_SUCCESS_FLAG VARCHAR2 (1)
The Last Generation of The List was successful.
FORECASTED_START_DATE DATE

The Forecasted Execution start date of The List.
FORECASTED_END_DATE DATE

The Forecasted Execution end date of The List.
ACTUAL_END_DATE DATE

The Execution end date of The List.
SENT_OUT_DATE DATE

The Date on which The List was Executed.
DEDUPE_START_DATE DATE

The scheduled start date for De Duplication of the list.
LAST_DEDUPE_DATE DATE

The previous date on which De Duplication of The List Occured.
LAST_DEDUPED_BY_USER_ID NUMBER (15)
The Oracle Applications User who Last performed De Duplication of the list.
WORKFLOW_ITEM_KEY NUMBER

not implemented.
NO_OF_ROWS_DUPLICATES NUMBER (15)
The number of duplicate entries generated in this list.
NO_OF_ROWS_MIN_REQUESTED NUMBER (15)
The Minimum number of list entries that must be generated .
NO_OF_ROWS_MAX_REQUESTED NUMBER (15)
The Maximum number of list entries that must be generated .
NO_OF_ROWS_IN_LIST NUMBER (15)
The number of entries excluding duplicates in the list.
NO_OF_ROWS_IN_CTRL_GROUP NUMBER (15)
The number of control group entries in the list .
NO_OF_ROWS_ACTIVE NUMBER (15)
The number of active entries in the list.
ORG_ID NUMBER (32)
Operating Unit which performed this transaction.
TIMEZONE_ID NUMBER (15)
USER_ENTERED_START_TIME DATE

MAIN_GEN_START_TIME DATE

The Scheduled start time for generation of the list.
MAIN_GEN_END_TIME DATE

The time that the list generation process finished for a list.
MAIN_RANDOM_NTH_ROW_SELECTION NUMBER (15)
The Nth row specifed for Random Generation.
MAIN_RANDOM_PCT_ROW_SELECTION NUMBER (15)
The Percentage of List Entries to Randomly generate.
CTRL_RANDOM_NTH_ROW_SELECTION NUMBER (15)
not implemented.
CTRL_RANDOM_PCT_ROW_SELECTION NUMBER (15)
not implemented.
RESULT_TEXT VARCHAR2 (4000)
The Result of The List Generation Process.
KEYWORDS VARCHAR2 (4000)
Keywords in a free text format are used to describe and categorize Lists.
DESCRIPTION VARCHAR2 (4000)
The List Description.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column.
REPEAT_SOURCE_LIST_HEADER_ID VARCHAR2 (4000)
The Foreign Key to The Parent List in a Repeating List set.
ROOT_LIST_NAME VARCHAR2 (240)
The Name of The Parent Repeating List.
ENABLED_FLAG VARCHAR2 (1)
Flag to determine if list is enabled.
REPEAT_EXCLUDE_TYPE VARCHAR2 (240)
not implemented.
ASSIGNED_TO NUMBER

For OSM upgrade only
ARCHIVED_BY NUMBER (15)
The User who performed The Archive.
ARCHIVED_DATE DATE

The date on which the list was archived.
LIST_RULE_ID NUMBER

Foreign key to deduplication table.
LIST_RULE_NAME VARCHAR2 (120)
List rule Name.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACTIVITY_NAME
,      ACTIVITY_TYPE
,      LIST_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      VIEW_APPLICATION_ID
,      LIST_NAME
,      LIST_USED_BY_ID
,      ARC_LIST_USED_BY
,      LIST_TYPE
,      STATUS_CODE
,      STATUS_DATE
,      GENERATION_TYPE
,      ROW_SELECTION_TYPE
,      OWNER_USER_ID
,      OWNER_NAME
,      OWNER_EMAIL_ADDRESS
,      OWNER_EMPLOYEE_ID
,      ACCESS_LEVEL
,      ACCESS_LEVEL_MEANING
,      ENABLE_LOG_FLAG
,      ENABLE_WORD_REPLACEMENT_FLAG
,      ENABLE_PARALLEL_DML_FLAG
,      DEDUPE_DURING_GENERATION_FLAG
,      GENERATE_CONTROL_GROUP_FLAG
,      LAST_GENERATION_SUCCESS_FLAG
,      FORECASTED_START_DATE
,      FORECASTED_END_DATE
,      ACTUAL_END_DATE
,      SENT_OUT_DATE
,      DEDUPE_START_DATE
,      LAST_DEDUPE_DATE
,      LAST_DEDUPED_BY_USER_ID
,      WORKFLOW_ITEM_KEY
,      NO_OF_ROWS_DUPLICATES
,      NO_OF_ROWS_MIN_REQUESTED
,      NO_OF_ROWS_MAX_REQUESTED
,      NO_OF_ROWS_IN_LIST
,      NO_OF_ROWS_IN_CTRL_GROUP
,      NO_OF_ROWS_ACTIVE
,      ORG_ID
,      TIMEZONE_ID
,      USER_ENTERED_START_TIME
,      MAIN_GEN_START_TIME
,      MAIN_GEN_END_TIME
,      MAIN_RANDOM_NTH_ROW_SELECTION
,      MAIN_RANDOM_PCT_ROW_SELECTION
,      CTRL_RANDOM_NTH_ROW_SELECTION
,      CTRL_RANDOM_PCT_ROW_SELECTION
,      RESULT_TEXT
,      KEYWORDS
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REPEAT_SOURCE_LIST_HEADER_ID
,      ROOT_LIST_NAME
,      ENABLED_FLAG
,      REPEAT_EXCLUDE_TYPE
,      ASSIGNED_TO
,      ARCHIVED_BY
,      ARCHIVED_DATE
,      LIST_RULE_ID
,      LIST_RULE_NAME
FROM APPS.AMS_P_LIST_HEADERS_V;

Dependencies

[top of page]

APPS.AMS_P_LIST_HEADERS_V references the following:

SchemaAPPS
SynonymAMS_LIST_HEADERS_ALL
ViewAMS_LOOKUPS
ViewAMS_P_LIST_RULES_V
PL/SQL PackageAMS_UTILITY_PVT - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewJTF_RS_RES_EMP_VL

APPS.AMS_P_LIST_HEADERS_V is not referenced by any database object