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


VIEW: APPS.AST_RS_CAMPAIGNS_V

Object Details
Object Name: AST_RS_CAMPAIGNS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAST.AST_RS_CAMPAIGNS_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

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RS_CAMPAIGN_ID NUMBER
Yes
RESOURCE_ID NUMBER
Yes
CAMPAIGN_ID NUMBER
Yes
ASSIGN_START_DATE DATE

ASSIGN_END_DATE DATE

ASSIGN_STATUS VARCHAR2 (1) Yes
ASSIGN_ENABLED_FLAG VARCHAR2 (1) Yes
CAMPAIGN_NAME VARCHAR2 (240) Yes
CAMPAIGN_DESCRIPTION VARCHAR2 (4000)
CAMPAIGN_STATUS_CODE VARCHAR2 (30) Yes
CAMPAIGN_SOURCE_CODE VARCHAR2 (30) Yes
CAMPAIGN_INBOUND_SCRIPT VARCHAR2 (256)
CAMPAIGN_OUTBOUND_FLAG VARCHAR2 (0)
CAMPAIGN_INBOUND_FLAG VARCHAR2 (0)
CAMPAIGN_INBOUND_EMAIL VARCHAR2 (120)
CAMPAIGN_INBOUND_PHONE VARCHAR2 (25)
RESOURCE_NUMBER VARCHAR2 (30) Yes
RESOURCE_PERSON_ID NUMBER

RESOURCE_START_DATE_ACTIVE DATE
Yes
RESOURCE_END_DATE_ACTIVE DATE

RESOURCE_PRIMARY_LANGUAGE VARCHAR2 (30)
RESOURCE_SECONDARY_LANGUAGE VARCHAR2 (30)
RESOURCE_FIRST_NAME VARCHAR2 (360)
RESOURCE_LAST_NAME VARCHAR2 (360)
RESOURCE_MIDDLE_NAME VARCHAR2 (360)
RESOURCE_FULL_NAME VARCHAR2 (360)
RESOURCE_EFFECTIVE_START_DATE DATE
Yes
RESOURCE_EFFECTIVE_END_DATE DATE

Query Text

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


SELECT ROW_ID
,      RS_CAMPAIGN_ID
,      RESOURCE_ID
,      CAMPAIGN_ID
,      ASSIGN_START_DATE
,      ASSIGN_END_DATE
,      ASSIGN_STATUS
,      ASSIGN_ENABLED_FLAG
,      CAMPAIGN_NAME
,      CAMPAIGN_DESCRIPTION
,      CAMPAIGN_STATUS_CODE
,      CAMPAIGN_SOURCE_CODE
,      CAMPAIGN_INBOUND_SCRIPT
,      CAMPAIGN_OUTBOUND_FLAG
,      CAMPAIGN_INBOUND_FLAG
,      CAMPAIGN_INBOUND_EMAIL
,      CAMPAIGN_INBOUND_PHONE
,      RESOURCE_NUMBER
,      RESOURCE_PERSON_ID
,      RESOURCE_START_DATE_ACTIVE
,      RESOURCE_END_DATE_ACTIVE
,      RESOURCE_PRIMARY_LANGUAGE
,      RESOURCE_SECONDARY_LANGUAGE
,      RESOURCE_FIRST_NAME
,      RESOURCE_LAST_NAME
,      RESOURCE_MIDDLE_NAME
,      RESOURCE_FULL_NAME
,      RESOURCE_EFFECTIVE_START_DATE
,      RESOURCE_EFFECTIVE_END_DATE
FROM APPS.AST_RS_CAMPAIGNS_V;

Dependencies

[top of page]

APPS.AST_RS_CAMPAIGNS_V references the following:

SchemaAPPS
ViewAMS_P_CAMPAIGNS_V
SynonymAST_RS_CAMPAIGNS
ViewJTF_RS_EMP_DTLS_VL

APPS.AST_RS_CAMPAIGNS_V is not referenced by any database object