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


VIEW: PA.PA_RES_ASGN_TIME_CHART#

Object Details
Object Name: PA_RES_ASGN_TIME_CHART#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Yes
PROJECT_ID NUMBER

ASSIGNMENT_ID NUMBER

START_DATE DATE
Yes
END_DATE DATE
Yes
ROW_LABEL_ID NUMBER

SCALE_TYPE VARCHAR2 (30) Yes
COLOR_PATTERN VARCHAR2 (30)
HELP_TEXT VARCHAR2 (150)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
NUMBER_OF_HOURS NUMBER

NUMBER_OF_DAYS NUMBER

AVG_NUM_OF_HOURS NUMBER

Query Text

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


SELECT RESOURCE_ID
,      PROJECT_ID
,      ASSIGNMENT_ID
,      START_DATE
,      END_DATE
,      ROW_LABEL_ID
,      SCALE_TYPE
,      COLOR_PATTERN
,      HELP_TEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      NUMBER_OF_HOURS
,      NUMBER_OF_DAYS
,      AVG_NUM_OF_HOURS
FROM PA.PA_RES_ASGN_TIME_CHART#;

Dependencies

[top of page]

PA.PA_RES_ASGN_TIME_CHART# references the following:

SchemaPA
TablePA_RES_ASGN_TIME_CHART
PA.PA_RES_ASGN_TIME_CHART# is referenced by following:

SchemaAPPS
SynonymPA_RES_ASGN_TIME_CHART