[Home] [Help] [Dependency Information]
Object Name: | ISC_MAINT_LAB_BLG_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier from BIV_MAINT_WORK_ORDERS_F.ORGANIZATION_ID | |
USER_DEFINED_STATUS_ID | NUMBER | User Defined Status ID from EAM_WO_STATUSES.STATUS_ID | ||
WORK_ORDER_ID | NUMBER | Work Order Identifier from BIV_MAINT_WORK_ORDERS_F.WORK_ORDER_ID | ||
STATUS_TYPE | NUMBER | Work Order Status type from BIV_MAINT_WORK_ORDERS_F.STATUS_TYPE | ||
DEPARTMENT_ID | NUMBER | Department Identifier from WIP_OPERATIONS.DEPARTMENT_ID | ||
OPERATION_SEQ_NUMBER | NUMBER | Operation Sequence Number from WIP_OPERATIONS.OPERATION_SEQ_NUMBER | ||
RESOURCE_ID | NUMBER | Resource Identifier from WIP_OPERATION_RESOURCES.RESOURCE_ID | ||
OP_START_DATE | DATE | Operation Start Date from WIP_OPERATIONS.FIRST_UNIT_START_DATE | ||
OP_END_DATE | DATE | Operation End Date from WIP_OPERATIONS.FIRST_UNIT_COMPLETION_DATE | ||
HOURS_REQUIRED | NUMBER | Hours Required by the resource | ||
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 | Yes | Standard who column | |
HOURS_CHARGED | NUMBER | Hours Charged for the resource | ||
WORK_ORDER_NAME | VARCHAR2 | (240) | Work Order Name from BIV_MAINT_WORK_ORDERS_F.WORK_ORDER_NAME | |
PROGRAM_ID | NUMBER | Standard who column | ||
PROGRAM_LOGIN_ID | NUMBER | Standard who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard who column | ||
REQUEST_ID | NUMBER | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, USER_DEFINED_STATUS_ID
, WORK_ORDER_ID
, STATUS_TYPE
, DEPARTMENT_ID
, OPERATION_SEQ_NUMBER
, RESOURCE_ID
, OP_START_DATE
, OP_END_DATE
, HOURS_REQUIRED
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, HOURS_CHARGED
, WORK_ORDER_NAME
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM ISC.ISC_MAINT_LAB_BLG_F;
ISC.ISC_MAINT_LAB_BLG_F does not reference any database object
ISC.ISC_MAINT_LAB_BLG_F is referenced by following:
|
|
|