[Home] [Help] [Dependency Information]
Object Name: | ISC_MAINT_WO_CST_SUM_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_MAINT_WO_CST_SUM_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
WORK_ORDER_ID DEPARTMENT_ID MAINT_COST_CATEGORY |
ISC_MAINT_WO_CST_SUM_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
COMPLETION_DATE
ORGANIZATION_ID |
ISC_MAINT_WO_CST_SUM_F_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
WORK_ORDER_ID COMPLETION_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Maintenance Organization Id | |
WORK_ORDER_ID | NUMBER | Yes | Work Orders: WIP_Entity_Id | |
DEPARTMENT_ID | NUMBER | Yes | Work Order Operation: Assigned Department | |
MAINT_COST_CATEGORY | NUMBER | Yes | Work Order Operation: Cost Category | |
ESTIMATED_FLAG | VARCHAR2 | (1) | Yes | Indicate if entire Work Order has any estimates, Y has non zero estimates, N has only zero estimates |
COMPLETION_DATE | DATE | Work Orders: Completion_date | ||
CONVERSION_RATE1 | NUMBER | Primary Global Currency conversion rate based on completion date | ||
CONVERSION_RATE2 | NUMBER | Secondary Global Currency conversion rate based on completion date | ||
ACTUAL_MAT_COST_B | NUMBER | Actual Material Cost (base currency) | ||
ACTUAL_LAB_COST_B | NUMBER | Actual Labor Cost (base currency) | ||
ACTUAL_EQP_COST_B | NUMBER | Actual Equipment Cost (base currency) | ||
ESTIMATED_MAT_COST_B | NUMBER | Estimated Material Cost (base currency) | ||
ESTIMATED_LAB_COST_B | NUMBER | Estimated Labor Cost (base currency) | ||
ESTIMATED_EQP_COST_B | NUMBER | Estimated Equipment Cost (base currency) | ||
CREATION_DATE | DATE | Yes | Who Column | |
CREATED_BY | NUMBER | Yes | Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Who Column | ||
PROGRAM_ID | NUMBER | Who Column | ||
PROGRAM_LOGIN_ID | NUMBER | Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Who Column | ||
REQUEST_ID | NUMBER | Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, WORK_ORDER_ID
, DEPARTMENT_ID
, MAINT_COST_CATEGORY
, ESTIMATED_FLAG
, COMPLETION_DATE
, CONVERSION_RATE1
, CONVERSION_RATE2
, ACTUAL_MAT_COST_B
, ACTUAL_LAB_COST_B
, ACTUAL_EQP_COST_B
, ESTIMATED_MAT_COST_B
, ESTIMATED_LAB_COST_B
, ESTIMATED_EQP_COST_B
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM ISC.ISC_MAINT_WO_CST_SUM_F;
ISC.ISC_MAINT_WO_CST_SUM_F does not reference any database object
ISC.ISC_MAINT_WO_CST_SUM_F is referenced by following:
|
|
|