[Home] [Help] [Dependency Information]
Object Name: | AHL_SRH_MR_HISTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_EFFECTIVITY_ID | NUMBER | Yes | Internal identifier for Unit Effectivity | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Record locking sequence number | |
CSI_ITEM_INSTANCE_ID | NUMBER | Yes | Internal identifier for Installed Base Item Instance | |
MR_HEADER_ID | NUMBER | Internal identifier for Maintenance Requirement | ||
CS_INCIDENT_ID | NUMBER | Internal identifier for Service Request Incident | ||
MR_TITLE | VARCHAR2 | (80) | Maintenance Requirement title | |
MR_VERSION_NUMBER | NUMBER | System Defined Revision number of the Maintenance Requirement | ||
MR_DESCRIPTION | VARCHAR2 | (2000) | Maintenance Requirement description | |
MR_CATEGORY_CODE | VARCHAR2 | (30) | User-defined MR category | |
MR_CATEGORY | VARCHAR2 | (80) | User-defined MR category description | |
MR_PROGRAM_TYPE_CODE | VARCHAR2 | (30) | User-defined MR program type | |
MR_PROGRAM_TYPE | VARCHAR2 | (80) | User-defined MR program type description | |
MR_PROGRAM_SUBTYPE_CODE | VARCHAR2 | (30) | User-defined MR program subtype | |
MR_PROGRAM_SUBTYPE | VARCHAR2 | (80) | User-defined MR program subtype description | |
INCIDENT_NUMBER | VARCHAR2 | (64) | Service Request Incident Number | |
INSTANCE_NUMBER | VARCHAR2 | (30) | Yes | Installed Base Item Instance Number |
EFFECTIVE_FROM | DATE | Start date of the MR | ||
EFFECTIVE_TO | DATE | End date of the MR | ||
STATUS_CODE | VARCHAR2 | (30) | Yes | MR status |
STATUS | VARCHAR2 | (80) | Yes | MR status description |
VISIT_ID | NUMBER | Yes | Internal identifier for Visit | |
VISIT_NAME | VARCHAR2 | (80) | User-defined Visit Name | |
VISIT_NUMBER | NUMBER | (15) | Yes | Visit Number |
VISIT_TYPE_CODE | VARCHAR2 | (30) | User-defined Visit type | |
VISIT_TYPE_MEAN | VARCHAR2 | (80) | User-defined Visit type description | |
VISIT_START_DATE | DATE | User-defined Visit start date | ||
QA_INSPECTION_TYPE | VARCHAR2 | (150) | Quality inspection type | |
UNIT_NAME | VARCHAR2 | (80) | User-defined Unit Name | |
ORGANIZATION_ID | NUMBER | Internal identifier for Organization | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | User-defined Organization Name |
DEPARTMENT_ID | NUMBER | Internal identifier for Department | ||
DEPARTMENT_NAME | VARCHAR2 | (240) | User-defined department name | |
ACTUAL_START_DATE | DATE | Actual start date of the workorder | ||
ACTUAL_END_DATE | DATE | Actual end date of the workorder | ||
PLAN_ID | NUMBER | Internal identifier for Quality Plan | ||
COLLECTION_ID | NUMBER | Internal identifier for Quality Collections | ||
WORKORDER_ID | NUMBER | Yes | Internal identifier for Workorder | |
JOB_NUMBER | VARCHAR2 | (80) | Yes | Job Number |
INVENTORY_ITEM_ID | NUMBER | Yes | Internal identifier for Workorder Item | |
WO_PART_NUMBER | VARCHAR2 | (40) | Workorder Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Workorder Item Description | |
ITEM_INSTANCE_ID | NUMBER | Internal identifier for Workorder Item Instance | ||
ITEM_INSTANCE_NUMBER | VARCHAR2 | (30) | Yes | Workorder Item Instance Number |
SERIAL_NUMBER | VARCHAR2 | (30) | Workorder Item Serial Number | |
JOB_STATUS_CODE | VARCHAR2 | (30) | Yes | Job Status |
JOB_STATUS_MEANING | VARCHAR2 | (80) | Job Status Description | |
JOB_DESCRIPTION | VARCHAR2 | (240) | Job Description | |
VISIT_TASK_ID | NUMBER | Yes | Internal identifier for Visit Task | |
VISIT_TASK_NUMBER | NUMBER | (15) | Yes | Visit Task Number |
VISIT_TASK_NAME | VARCHAR2 | (80) | Yes | Visit Task Name |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_EFFECTIVITY_ID
, OBJECT_VERSION_NUMBER
, CSI_ITEM_INSTANCE_ID
, MR_HEADER_ID
, CS_INCIDENT_ID
, MR_TITLE
, MR_VERSION_NUMBER
, MR_DESCRIPTION
, MR_CATEGORY_CODE
, MR_CATEGORY
, MR_PROGRAM_TYPE_CODE
, MR_PROGRAM_TYPE
, MR_PROGRAM_SUBTYPE_CODE
, MR_PROGRAM_SUBTYPE
, INCIDENT_NUMBER
, INSTANCE_NUMBER
, EFFECTIVE_FROM
, EFFECTIVE_TO
, STATUS_CODE
, STATUS
, VISIT_ID
, VISIT_NAME
, VISIT_NUMBER
, VISIT_TYPE_CODE
, VISIT_TYPE_MEAN
, VISIT_START_DATE
, QA_INSPECTION_TYPE
, UNIT_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, DEPARTMENT_ID
, DEPARTMENT_NAME
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, PLAN_ID
, COLLECTION_ID
, WORKORDER_ID
, JOB_NUMBER
, INVENTORY_ITEM_ID
, WO_PART_NUMBER
, ITEM_DESCRIPTION
, ITEM_INSTANCE_ID
, ITEM_INSTANCE_NUMBER
, SERIAL_NUMBER
, JOB_STATUS_CODE
, JOB_STATUS_MEANING
, JOB_DESCRIPTION
, VISIT_TASK_ID
, VISIT_TASK_NUMBER
, VISIT_TASK_NAME
FROM APPS.AHL_SRH_MR_HISTORY_V;
APPS.AHL_SRH_MR_HISTORY_V is not referenced by any database object
|
|
|