[Home] [Help] [Dependency Information]
Object Name: | HRI_CS_TRNEVTACT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Creates a structure linking OTA Events to Activity Versions & Definitions with Security Flags.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_ID | NUMBER | |||
ACTIVITY_VERSION_ID | NUMBER | |||
EVENT_ID | NUMBER | (9) | Yes | |
EVENT_ENROLMENT_START_DATE | DATE | |||
EVENT_ENROLMENT_END_DATE | DATE | |||
EVENT_START_DATE | DATE | |||
EVENT_END_DATE | DATE | |||
EVENT_START_TIME | VARCHAR2 | (5) | ||
EVENT_END_TIME | VARCHAR2 | (5) | ||
ACTVT_DEF_BUSINESS_GROUP_ID | NUMBER | |||
ACTVT_DEF_NAME | VARCHAR2 | (240) | ||
ACTVT_DEF_COMMENTS | VARCHAR2 | (2000) | ||
ACTVT_DEF_DESCRIPTION | VARCHAR2 | (4000) | ||
ACTVT_DEF_MULTI_CON_VER_FLAG | VARCHAR2 | (30) | ||
ACTVT_VRSN_ORGANIZATION_ID | NUMBER | |||
ACTVT_VRSN_USER_STATUS_CODE | VARCHAR2 | (30) | ||
EVENT_BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
EVENT_TYPE_CODE | VARCHAR2 | (30) | Yes | |
EVENT_VENDOR_ID | NUMBER | |||
EVENT_PUBLIC_EVENT_FLAG | VARCHAR2 | (30) | ||
DEVELOPMENT_EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
EVENT_OFFERING_ID | NUMBER | |||
EVENT_STATUS_CODE | VARCHAR2 | (30) | ||
LAST_CHANGE_DATE | DATE | |||
BG_SECURITY_FLAG_CODE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_ID
, ACTIVITY_VERSION_ID
, EVENT_ID
, EVENT_ENROLMENT_START_DATE
, EVENT_ENROLMENT_END_DATE
, EVENT_START_DATE
, EVENT_END_DATE
, EVENT_START_TIME
, EVENT_END_TIME
, ACTVT_DEF_BUSINESS_GROUP_ID
, ACTVT_DEF_NAME
, ACTVT_DEF_COMMENTS
, ACTVT_DEF_DESCRIPTION
, ACTVT_DEF_MULTI_CON_VER_FLAG
, ACTVT_VRSN_ORGANIZATION_ID
, ACTVT_VRSN_USER_STATUS_CODE
, EVENT_BUSINESS_GROUP_ID
, EVENT_TYPE_CODE
, EVENT_VENDOR_ID
, EVENT_PUBLIC_EVENT_FLAG
, DEVELOPMENT_EVENT_TYPE_CODE
, EVENT_OFFERING_ID
, EVENT_STATUS_CODE
, LAST_CHANGE_DATE
, BG_SECURITY_FLAG_CODE
FROM APPS.HRI_CS_TRNEVTACT_V;
|
|
|