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

TABLE: BOM.CST_EAM_WO_ESTIMATE_DETAILS

Object Details
Object Name: CST_EAM_WO_ESTIMATE_DETAILS
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_EAM_WO_ESTIMATE_DETAILS
Subobject Name:
Status: VALID


CST_EAM_WO_ESTIMATE_DETAILS contains results from the EAM cost estimation process for EAM work orders.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_EAM_WO_ESTIMATE_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAINT_COST_CATEGORY
ColumnWIP_ENTITY_ID
ColumnOPERATIONS_SEQ_NUM
ColumnORGANIZATION_ID
CST_EAM_WO_ESTIMATE_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnOPERATIONS_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Yes WIP Entity Id - Identifier of Work Order
ORGANIZATION_ID NUMBER
Yes Organization Identifier of Work Order
OPERATIONS_DEPT_ID NUMBER

Assigned Department Identifier of Operation
OPERATIONS_SEQ_NUM NUMBER

Operation Sequence Number
MAINT_COST_CATEGORY NUMBER
Yes Maintenance Cost Category
OWNING_DEPT_ID NUMBER

Owning Department Identifier
DEPT_OVERHEAD_COST NUMBER

Overhead Cost for the Department
ESTIMATED_COST NUMBER
Yes Estimated Cost
RESOURCE_ID NUMBER

Resource Identifier
RESOURCE_RATE NUMBER

Resource Rate
USAGE_RATE NUMBER

Usage Rate
UOM VARCHAR2 (15)
Unit of Measure
RESOURCE_INSTANCE_ID NUMBER

Instance Identifier of the Resource
RESOURCE_INSTANCE_RATE NUMBER

Instance Rate for the Resource
RESOURCE_USAGE NUMBER

Resource Usage
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM_COST NUMBER

Item Cost
REQUIRED_QUANTITY NUMBER

Required Quantity of Material
REQUISITION_HEADER_ID NUMBER

Requisition Header Id
PO_HEADER_ID NUMBER

Purchase Order header ID
RATE NUMBER

Conversion rate
DIRECT_ITEM VARCHAR2 (1)
Flag to determine whether it is a direct item
REQUISITION_LINE_ID NUMBER

Requisition Line Identifier
PO_DISTRIBUTION_ID NUMBER

Purchase Order Distribution Identifier
LINE_LOCATION_ID NUMBER

Line Location Identifier
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
PO_LINE_CANCEL_FLAG VARCHAR2 (1)
Cancel flag for Purchase Order Line
REQ_LINE_CANCEL_FLAG VARCHAR2 (1)
Cancel flag for Requisition Line
REQ_AUTH_STATUS VARCHAR2 (30)
Requisition Authorization Status
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      OPERATIONS_DEPT_ID
,      OPERATIONS_SEQ_NUM
,      MAINT_COST_CATEGORY
,      OWNING_DEPT_ID
,      DEPT_OVERHEAD_COST
,      ESTIMATED_COST
,      RESOURCE_ID
,      RESOURCE_RATE
,      USAGE_RATE
,      UOM
,      RESOURCE_INSTANCE_ID
,      RESOURCE_INSTANCE_RATE
,      RESOURCE_USAGE
,      INVENTORY_ITEM_ID
,      ITEM_COST
,      REQUIRED_QUANTITY
,      REQUISITION_HEADER_ID
,      PO_HEADER_ID
,      RATE
,      DIRECT_ITEM
,      REQUISITION_LINE_ID
,      PO_DISTRIBUTION_ID
,      LINE_LOCATION_ID
,      ITEM_DESCRIPTION
,      PO_LINE_CANCEL_FLAG
,      REQ_LINE_CANCEL_FLAG
,      REQ_AUTH_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_EAM_WO_ESTIMATE_DETAILS;

Dependencies

[top of page]

BOM.CST_EAM_WO_ESTIMATE_DETAILS does not reference any database object

BOM.CST_EAM_WO_ESTIMATE_DETAILS is referenced by following:

SchemaBOM
ViewCST_EAM_WO_ESTIMATE_DETAILS#