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

VIEW: APPS.CSM_COV_ACTION_TIMES_V

Object Details
Object Name: CSM_COV_ACTION_TIMES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCESS_ID NUMBER

ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
BUS_PROCESS_CLE_ID NUMBER

LSE_ID NUMBER
Yes
LINE_NUMBER VARCHAR2 (150) Yes
DNZ_CHR_ID NUMBER
Yes
INCIDENT_SEVERITY_ID1 NUMBER

PROCESS_DEF_ID NUMBER

WORK_THRU_YN VARCHAR2 (1)
ACTIVE_YN VARCHAR2 (1)
REACTION_TIME_NAME VARCHAR2 (450)
ACTION_TYPE_CODE VARCHAR2 (30)
UOM_CODE VARCHAR2 (30)
SUN_DURATION NUMBER

MON_DURATION NUMBER

TUE_DURATION NUMBER

WED_DURATION NUMBER

THU_DURATION NUMBER

FRI_DURATION NUMBER

SAT_DURATION NUMBER

OBJECT_CODE VARCHAR2 (30)
BUSINESS_PROCESS_ID VARCHAR2 (40)
CONTRACT_SERVICE_ID VARCHAR2 (240)
Query Text

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


SELECT ACCESS_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      BUS_PROCESS_CLE_ID
,      LSE_ID
,      LINE_NUMBER
,      DNZ_CHR_ID
,      INCIDENT_SEVERITY_ID1
,      PROCESS_DEF_ID
,      WORK_THRU_YN
,      ACTIVE_YN
,      REACTION_TIME_NAME
,      ACTION_TYPE_CODE
,      UOM_CODE
,      SUN_DURATION
,      MON_DURATION
,      TUE_DURATION
,      WED_DURATION
,      THU_DURATION
,      FRI_DURATION
,      SAT_DURATION
,      OBJECT_CODE
,      BUSINESS_PROCESS_ID
,      CONTRACT_SERVICE_ID
FROM APPS.CSM_COV_ACTION_TIMES_V;

Dependencies

[top of page]

APPS.CSM_COV_ACTION_TIMES_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymCSM_COV_ACTION_TIMES_ACC
ViewOKS_COV_ACTION_TIMES_V

APPS.CSM_COV_ACTION_TIMES_V is not referenced by any database object