[Home] [Help] [Dependency Information]
Object Name: | AHL_SRH_MR_HISTORY_ALL_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 | Internal identifier for Unit Effectivity | ||
ACCOMPLISHMENT_TYPE | VARCHAR2 | (3) | Work order or OSP Accomplishment Type | |
OBJECT_VERSION_NUMBER | NUMBER | Record locking sequence number | ||
CSI_ITEM_INSTANCE_ID | NUMBER | 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) | Installed Base Item Instance Number | |
EFFECTIVE_FROM | DATE | Start date of the MR | ||
EFFECTIVE_TO | DATE | End date of the MR | ||
STATUS_CODE | VARCHAR2 | (4000) | MR status | |
STATUS | VARCHAR2 | (80) | MR status description | |
VISIT_ID | NUMBER | Internal identifier for Visit | ||
VISIT_NAME | VARCHAR2 | (80) | User-defined Visit Name | |
VISIT_NUMBER | NUMBER | Visit Number | ||
VISIT_TYPE_CODE | VARCHAR2 | (30) | User-defined Visit type | |
VISIT_TYPE_MEAN | VARCHAR2 | (80) | User-defined Visit type description | |
PLANNING_TYPE_MEAN | VARCHAR2 | (80) | Accomplishment Type for OSP Accomplishment | |
VISIT_START_DATE | DATE | Visit start date | ||
QA_INSPECTION_TYPE | VARCHAR2 | (150) | Quality inspection type | |
UNIT_NAME | VARCHAR2 | (80) | Unit Name | |
ORGANIZATION_ID | NUMBER | Internal identifier for Organization | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | 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 | ||
COLLECTION_ID | NUMBER | Internal identifier for Quality Collections | ||
WORKORDER_ID | NUMBER | Internal identifier for Workorder | ||
JOB_NUMBER | VARCHAR2 | (80) | Job Number | |
INVENTORY_ITEM_ID | NUMBER | 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) | Workorder Item Instance Number | |
SERIAL_NUMBER | VARCHAR2 | (30) | Workorder Item Serial Number | |
JOB_STATUS_CODE | VARCHAR2 | (30) | Job Status | |
JOB_STATUS_MEANING | VARCHAR2 | (80) | Job Status Description | |
JOB_DESCRIPTION | VARCHAR2 | (240) | Job Description | |
VISIT_TASK_ID | NUMBER | Internal identifier for Visit Task | ||
VISIT_TASK_NUMBER | NUMBER | Visit Task Number | ||
VISIT_TASK_NAME | VARCHAR2 | (80) | Visit Task Name | |
ACCOMPLISHMENT_ID | NUMBER | Internal Id of OSP Accomplishment | ||
PLANNING_TYPE_CODE | VARCHAR2 | (30) | OSP Accomplishment Type Code | |
OSP_ORDER_LINE_ID | NUMBER | OSP Order Line Id for OSP Accomplishment | ||
OSP_ORDER_ID | NUMBER | OSP Order Id for OSP Accomplishment | ||
OSP_LINE_NUMBER | NUMBER | OSP Order Line number for OSP Accomplishment | ||
OSP_ORDER_NUMBER | NUMBER | OSP Order number for OSP Accomplishment |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_EFFECTIVITY_ID
, ACCOMPLISHMENT_TYPE
, 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
, PLANNING_TYPE_MEAN
, VISIT_START_DATE
, QA_INSPECTION_TYPE
, UNIT_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, DEPARTMENT_ID
, DEPARTMENT_NAME
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, 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
, ACCOMPLISHMENT_ID
, PLANNING_TYPE_CODE
, OSP_ORDER_LINE_ID
, OSP_ORDER_ID
, OSP_LINE_NUMBER
, OSP_ORDER_NUMBER
FROM APPS.AHL_SRH_MR_HISTORY_ALL_V;
APPS.AHL_SRH_MR_HISTORY_ALL_V is not referenced by any database object
|
|
|