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

VIEW: APPS.AST_PLIST_NAMES_UWQ_V

Object Details
Object Name: AST_PLIST_NAMES_UWQ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAST.AST_PLIST_NAMES_UWQ_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
IEU_OBJECT_FUNCTION VARCHAR2 (0)
IEU_OBJECT_PARAMETERS VARCHAR2 (0)
IEU_MEDIA_TYPE_UUID VARCHAR2 (0)
IEU_PARAM_PK_COL VARCHAR2 (0)
IEU_PARAM_PK_VALUE VARCHAR2 (0)
RESOURCE_TYPE CHAR (13)
RESOURCE_ID NUMBER (15) Yes
LIST_HEADER_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER (9)
VIEW_APPLICATION_ID NUMBER

LIST_NAME VARCHAR2 (300) Yes
LIST_USED_BY_ID NUMBER
Yes
ARC_LIST_USED_BY VARCHAR2 (30) Yes
LIST_TYPE VARCHAR2 (30) Yes
USER_STATUS_ID NUMBER

STATUS_CODE VARCHAR2 (30) Yes
STATUS_DATE DATE
Yes
GENERATION_TYPE VARCHAR2 (30) Yes
REPEAT_EXCLUDE_TYPE VARCHAR2 (240)
ROW_SELECTION_TYPE VARCHAR2 (30) Yes
OWNER_USER_ID NUMBER (15) Yes
CUSTOM_SETUP_ID NUMBER

COUNTRY NUMBER

ACCESS_LEVEL VARCHAR2 (30)
ENABLE_LOG_FLAG VARCHAR2 (1)
ENABLE_WORD_REPLACEMENT_FLAG VARCHAR2 (1)
ENABLE_PARALLEL_DML_FLAG VARCHAR2 (1)
DEDUPE_DURING_GENERATION_FLAG VARCHAR2 (1)
GENERATE_CONTROL_GROUP_FLAG VARCHAR2 (1)
LAST_GENERATION_SUCCESS_FLAG VARCHAR2 (1)
FORECASTED_START_DATE DATE

FORECASTED_END_DATE DATE

ACTUAL_END_DATE DATE

SENT_OUT_DATE DATE

NO_OF_ROWS_DUPLICATES NUMBER (15)
NO_OF_ROWS_IN_LIST NUMBER (15)
NO_OF_ROWS_ACTIVE NUMBER (15)
NO_OF_ROWS_INACTIVE NUMBER

ORG_ID NUMBER (32)
Organization identifier
DESCRIPTION VARCHAR2 (4000)
LIST_PRIORITY NUMBER (15)
ASSIGN_PERSON_ID NUMBER

LIST_SOURCE VARCHAR2 (240)
LIST_SOURCE_TYPE VARCHAR2 (30)
ENABLED_FLAG VARCHAR2 (1)
ASSIGNED_TO NUMBER

QUERY_ID NUMBER (15)
OWNER_PERSON_ID NUMBER

PURGE_FLAG VARCHAR2 (1)
Query Text

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


SELECT IEU_OBJECT_FUNCTION
,      IEU_OBJECT_PARAMETERS
,      IEU_MEDIA_TYPE_UUID
,      IEU_PARAM_PK_COL
,      IEU_PARAM_PK_VALUE
,      RESOURCE_TYPE
,      RESOURCE_ID
,      LIST_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      VIEW_APPLICATION_ID
,      LIST_NAME
,      LIST_USED_BY_ID
,      ARC_LIST_USED_BY
,      LIST_TYPE
,      USER_STATUS_ID
,      STATUS_CODE
,      STATUS_DATE
,      GENERATION_TYPE
,      REPEAT_EXCLUDE_TYPE
,      ROW_SELECTION_TYPE
,      OWNER_USER_ID
,      CUSTOM_SETUP_ID
,      COUNTRY
,      ACCESS_LEVEL
,      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
,      NO_OF_ROWS_DUPLICATES
,      NO_OF_ROWS_IN_LIST
,      NO_OF_ROWS_ACTIVE
,      NO_OF_ROWS_INACTIVE
,      ORG_ID
,      DESCRIPTION
,      LIST_PRIORITY
,      ASSIGN_PERSON_ID
,      LIST_SOURCE
,      LIST_SOURCE_TYPE
,      ENABLED_FLAG
,      ASSIGNED_TO
,      QUERY_ID
,      OWNER_PERSON_ID
,      PURGE_FLAG
FROM APPS.AST_PLIST_NAMES_UWQ_V;

Dependencies

[top of page]

APPS.AST_PLIST_NAMES_UWQ_V references the following:

SchemaAPPS
ViewAMS_LIST_HEADERS_VL

APPS.AST_PLIST_NAMES_UWQ_V is not referenced by any database object