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

VIEW: APPS.AMS_LIST_SCH_UWQ_V

Object Details
Object Name: AMS_LIST_SCH_UWQ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_LIST_SCH_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 CHAR (0)
IEU_OBJECT_PARAMETERS CHAR (0)
IEU_MEDIA_TYPE_UUID CHAR (0)
IEU_PARAM_PK_COL CHAR (0)
IEU_PARAM_PK_VALUE VARCHAR2 (0)
RESOURCE_TYPE CHAR (13)
SCHEDULE_ID NUMBER
Yes
SCHEDULE_NAME VARCHAR2 (240) Yes
SCHEDULE_STATUS VARCHAR2 (30) Yes
SOURCE_CODE VARCHAR2 (30) Yes
ACTIVITY_ID NUMBER

ACTIVITY_TYPE_CODE VARCHAR2 (30) Yes
ARC_MARKETING_MEDIUM_FROM VARCHAR2 (30)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
START_DATE_TIME DATE

END_DATE_TIME DATE

RESOURCE_ID NUMBER
Yes
LIST_SOURCE_TYPE VARCHAR2 (30)
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
,      SCHEDULE_ID
,      SCHEDULE_NAME
,      SCHEDULE_STATUS
,      SOURCE_CODE
,      ACTIVITY_ID
,      ACTIVITY_TYPE_CODE
,      ARC_MARKETING_MEDIUM_FROM
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      START_DATE_TIME
,      END_DATE_TIME
,      RESOURCE_ID
,      LIST_SOURCE_TYPE
FROM APPS.AMS_LIST_SCH_UWQ_V;

Dependencies

[top of page]

APPS.AMS_LIST_SCH_UWQ_V references the following:

SchemaAPPS
SynonymAMS_ACT_LISTS
ViewAMS_CAMPAIGN_SCHEDULES_VL
SynonymAMS_LIST_ENTRIES
SynonymAMS_LIST_HEADERS_ALL
SynonymJTF_RS_RESOURCE_EXTNS
APPS.AMS_LIST_SCH_UWQ_V is referenced by following:

SchemaAPPS
Package BodyAMS_UWQ_LIST_ENUM_PVT - show dependent code