eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AHL_SRH_MR_HISTORY_V

Object Details

Object Name:	AHL_SRH_MR_HISTORY_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		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

Query Text

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;

Dependencies

[top of page]

APPS.AHL_SRH_MR_HISTORY_V references the following:

APPS: AHL_COMPLETIONS_PVT - show dependent code; AHL_PRD_SERN_CHANGE_PVT - show dependent code; AHL_UE_DEFERRAL_DETAILS_V; AHL_UNIT_CONFIG_HEADERS; AHL_UTILITY_PVT - show dependent code; AHL_UTIL_UC_PKG - show dependent code; AHL_VISITS_INFO_V; AHL_VISIT_TASKS_V; AHL_WORKORDERS_V; BOM_DEPARTMENTS; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MO_GLOBAL - show dependent code; ORG_ORGANIZATION_DEFINITIONS

APPS.AHL_SRH_MR_HISTORY_V is not referenced by any database object