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

TABLE: EAM.EAM_CONSTRUCTION_UNIT_DETAILS

Object Details
Object Name: EAM_CONSTRUCTION_UNIT_DETAILS
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_CONSTRUCTION_UNIT_DETAILS
Subobject Name:
Status: VALID


This contains all the activities and activity related details which are part of the construction unit. The information include
- Activity
- Activity effectivity period
- Activity qty
- Accouting class code


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_CU_DTL_ID_N01 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCU_DETAIL_ID
Columns
Name Datatype Length Mandatory Comments
CU_DETAIL_ID NUMBER
Yes Unique Identifier to construction unit detail
CU_ID NUMBER
Yes Construction unit ID
ACCT_CLASS_CODE VARCHAR2 (10)
Accounting Class Code
ACTIVITY_ID NUMBER
Yes Activity Identifier.
CU_ACTIVITY_QTY NUMBER

Quantity associated with that activity to build the defined CU
CU_ACTIVITY_EFFECTIVE_FROM DATE

Date the activity associated to the CU started
CU_ACTIVITY_EFFECTIVE_TO DATE

Date the activity associated to the CU terminated
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY VARCHAR2 (240) 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 CU_DETAIL_ID
,      CU_ID
,      ACCT_CLASS_CODE
,      ACTIVITY_ID
,      CU_ACTIVITY_QTY
,      CU_ACTIVITY_EFFECTIVE_FROM
,      CU_ACTIVITY_EFFECTIVE_TO
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_CONSTRUCTION_UNIT_DETAILS;

Dependencies

[top of page]

EAM.EAM_CONSTRUCTION_UNIT_DETAILS does not reference any database object

EAM.EAM_CONSTRUCTION_UNIT_DETAILS is referenced by following:

SchemaAPPS
SynonymEAM_CONSTRUCTION_UNIT_DETAILS