[Home] [Help] [Dependency Information]
Object Name: | ISC_MAINT_REQ_WO_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_REQ_WO_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
REQUEST_TYPE
MAINT_REQUEST_ID ASSOCIATION_ID |
ISC_MAINT_REQ_WO_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | COMPLETION_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_TYPE | VARCHAR2 | (30) | Yes | Request Type identifier: 1 = Work Request, 2 = Service Request |
MAINT_REQUEST_ID | NUMBER | Yes | Work Request or Service Request internal identifier | |
ASSOCIATION_ID | NUMBER | Yes | Work Request internal identifier or Service Request Association internal identifier | |
REQUEST_NUMBER | VARCHAR2 | (64) | Yes | Work Request or Service Request external identifier |
ORGANIZATION_ID | NUMBER | Yes | Maintenance Organization Id | |
DEPARTMENT_ID | NUMBER | Yes | Work Request or Service Request: Owning Department | |
ASSET_GROUP_ID | NUMBER | Yes | Work Request or Service Request: Asset Group | |
ASSET_NUMBER | VARCHAR2 | (30) | Obseleted in DBI-EAM R12 | |
INSTANCE_ID | NUMBER | Yes | Work Request or Service Request: Instance_id | |
REQUEST_START_DATE | DATE | Yes | Work Request creation date or Service Request incident date | |
REQUEST_SEVERITY_ID | NUMBER | Yes | Work Request or Service Request: Severity | |
WORK_ORDER_ID | NUMBER | Work Order internal identifier | ||
COMPLETION_DATE | DATE | Work Order completion date if this is the last completed Work Order associated with the Work Request or Service Request | ||
RESPONSE_DAYS | NUMBER | Elapsed days - Work Request creation date or Service Request incident date to Work Order creation date if this is the last completed Work Order associated with the Work Request or Service Request | ||
COMPLETION_DAYS | NUMBER | Elapsed days - Work Request creation date or Service Request incident date to Work Order completion date if this is the last completed Work Order associated with the Work Request or Service Request | ||
WORK_ORDER_COUNT | NUMBER | Number of Work Order associated with the Work Request or Service Request if this is the last completed Work Order associated with Work Request or Service Request | ||
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 REQUEST_TYPE
, MAINT_REQUEST_ID
, ASSOCIATION_ID
, REQUEST_NUMBER
, ORGANIZATION_ID
, DEPARTMENT_ID
, ASSET_GROUP_ID
, ASSET_NUMBER
, INSTANCE_ID
, REQUEST_START_DATE
, REQUEST_SEVERITY_ID
, WORK_ORDER_ID
, COMPLETION_DATE
, RESPONSE_DAYS
, COMPLETION_DAYS
, WORK_ORDER_COUNT
, 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_REQ_WO_F;
ISC.ISC_MAINT_REQ_WO_F does not reference any database object
ISC.ISC_MAINT_REQ_WO_F is referenced by following:
|
|
|