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


VIEW: EAM.EAM_ESTIMATE_ASSOCIATIONS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ESTIMATE_ASSOCIATION_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
ESTIMATE_ID NUMBER
Yes
CU_ID NUMBER

CU_QTY NUMBER

ACCT_CLASS_CODE VARCHAR2 (10)
ACTIVITY_ID NUMBER
Yes
ACTIVITY_QTY NUMBER
Yes
DIFFICULTY_ID NUMBER

RESOURCE_MULTIPLIER NUMBER
Yes
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 ESTIMATE_ASSOCIATION_ID
,      ORGANIZATION_ID
,      ESTIMATE_ID
,      CU_ID
,      CU_QTY
,      ACCT_CLASS_CODE
,      ACTIVITY_ID
,      ACTIVITY_QTY
,      DIFFICULTY_ID
,      RESOURCE_MULTIPLIER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_ESTIMATE_ASSOCIATIONS#;

Dependencies

[top of page]

EAM.EAM_ESTIMATE_ASSOCIATIONS# references the following:

SchemaEAM
TableEAM_ESTIMATE_ASSOCIATIONS
EAM.EAM_ESTIMATE_ASSOCIATIONS# is referenced by following:

SchemaAPPS
SynonymEAM_ESTIMATE_ASSOCIATIONS