DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AHL_SRH_MR_HISTORY_ALL_V

Object Details
Object Name: AHL_SRH_MR_HISTORY_ALL_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.AHL_SRH_MR_HISTORY_ALL_V references the following:

SchemaAPPS
PL/SQL PackageAHL_COMPLETIONS_PVT - show dependent code
SynonymAHL_MR_HEADERS_B
SynonymAHL_MR_HEADERS_TL
SynonymAHL_OSP_ACCOMPLISHMENTS
ViewAHL_OSP_ORDERS_VL
SynonymAHL_OSP_ORDER_LINES
SynonymAHL_UNIT_CONFIG_HEADERS
SynonymAHL_UNIT_DEFERRALS_B
SynonymAHL_UNIT_EFFECTIVITIES_B
SynonymAHL_VISITS_TL
ViewAHL_VISITS_VL
SynonymAHL_VISIT_TASKS_TL
ViewAHL_VISIT_TASKS_VL
SynonymAHL_WORKORDERS
SynonymBOM_DEPARTMENTS
SynonymCSI_ITEM_INSTANCES
SynonymCS_INCIDENTS_ALL_B
SynonymFND_LOOKUP_VALUES
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
ViewORG_ORGANIZATION_DEFINITIONS
SynonymWIP_DISCRETE_JOBS

APPS.AHL_SRH_MR_HISTORY_ALL_V is not referenced by any database object