eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: EAM.EAM_ESTIMATE_ASSOCIATIONS

Object Details

Object Name:	EAM_ESTIMATE_ASSOCIATIONS
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_ESTIMATE_ASSOCIATIONS
Subobject Name:
Status:	VALID

This table contains all the association data for an estimate. The association data include the following

- Construction unit
- Construction unit Qty
- Activity
- Activity Qty
- Difficulty Code and Resource Multiplier

Note: The association data is not retained after creating work order lines.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ESTIMATE_ASSOCIATION_ID	NUMBER		Yes	Unique Identifier for a construction estimate association
ORGANIZATION_ID	NUMBER		Yes	Associated organization ID
ESTIMATE_ID	NUMBER		Yes	Construction estimate ID
CU_ID	NUMBER			Construction unit ID
CU_QTY	NUMBER			Construction unit quantity
ACCT_CLASS_CODE	VARCHAR2	(10)		Accouting Class code of Activity or CU based on the association line
ACTIVITY_ID	NUMBER		Yes	Unique Identifier for an activity
ACTIVITY_QTY	NUMBER		Yes	Activity quantity
DIFFICULTY_ID	NUMBER			Difficulty Identifier
RESOURCE_MULTIPLIER	NUMBER		Yes	Resource Multiplier
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column

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 does not reference any database object

EAM.EAM_ESTIMATE_ASSOCIATIONS is referenced by following:

EAM: EAM_ESTIMATE_ASSOCIATIONS#