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


VIEW: EAM.EAM_DIFFICULTY_CODES#

Object Details
Object Name: EAM_DIFFICULTY_CODES#
Object Type: VIEW
Owner: EAM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DIFFICULTY_ID NUMBER
Yes
DIFFICULTY_CODE VARCHAR2 (80) Yes
DIFFICULTY_DESCRIPTION VARCHAR2 (240)
DIFFICULTY_RESOURCE_MULTIPLIER NUMBER
Yes
EFFECTIVE_FROM_DATE DATE
Yes
EFFECTIVE_TO_DATE DATE

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT DIFFICULTY_ID
,      DIFFICULTY_CODE
,      DIFFICULTY_DESCRIPTION
,      DIFFICULTY_RESOURCE_MULTIPLIER
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_DIFFICULTY_CODES#;

Dependencies

[top of page]

EAM.EAM_DIFFICULTY_CODES# references the following:

SchemaEAM
TableEAM_DIFFICULTY_CODES
EAM.EAM_DIFFICULTY_CODES# is referenced by following:

SchemaAPPS
SynonymEAM_DIFFICULTY_CODES