[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EAM_CONSTRUCTION_ESTIMATES |
|---|---|
| Object Type: | TABLE |
| Owner: | EAM |
| FND Design Data: |  EAM.EAM_CONSTRUCTION_ESTIMATES
|
| Subobject Name: | |
| Status: | VALID |
This table contains all the estimates header information. The header information include
- Estimate name
- Grouping option for the estimate
- Parent work order for the estimate (if any)
- Organization in which the estimate was created
- Flexfields information
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ESTIMATE_ID | NUMBER | Yes | Unique Identifier for a Construction Estimate | |
| ORGANIZATION_ID | NUMBER | Yes | Associated organization ID | |
| ESTIMATE_NUMBER | VARCHAR2 | (30) | Yes | A unique number to identify the construction estimate |
| ESTIMATE_DESCRIPTION | VARCHAR2 | (240) | Description of the Construction Estimate | |
| GROUPING_OPTION | NUMBER | (1) | Grouping option for creating work orders | |
| PARENT_WO_ID | NUMBER | Parent work order ID, can be an existing WIP entity ID or an estimate work order ID | ||
| CREATE_PARENT_WO_FLAG | VARCHAR2 | (1) | Flag indicate whether to create a parent work order or using an existing work order | |
| 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 | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard DFF Column |
Cut, paste (and edit) the following text to query this object:
SELECT ESTIMATE_ID
, ORGANIZATION_ID
, ESTIMATE_NUMBER
, ESTIMATE_DESCRIPTION
, GROUPING_OPTION
, PARENT_WO_ID
, CREATE_PARENT_WO_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
FROM EAM.EAM_CONSTRUCTION_ESTIMATES;
EAM.EAM_CONSTRUCTION_ESTIMATES does not reference any database object
EAM.EAM_CONSTRUCTION_ESTIMATES is referenced by following:
APPS
EAM_CONSTRUCTION_ESTIMATES
|
|
|
|