[Home] [Help] [Dependency Information]
Object Name: | ISC_MAINT_WO_CST_SUM_STG |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_MAINT_WO_CST_SUM_STG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ORGANIZATION_ID
COMPLETION_DATE COMPLETED_FLAG |
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 | Who Column | ||
COMPLETED_FLAG | VARCHAR2 | (1) | Indicates if Work Order is actually completed "Y" for complete, complete no charges or closed "N" for un-completed | |
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
, COMPLETED_FLAG
, 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_STG;
ISC.ISC_MAINT_WO_CST_SUM_STG does not reference any database object
ISC.ISC_MAINT_WO_CST_SUM_STG is referenced by following:
|
|
|