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.

[Home] [Help]

View: AHL_MR_INST_RELATIONSHIPS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View to describe the Relationship between Maintenance Requirements in Production
Implementation/DBA Data:	APPS.AHL_MR_INST_RELATIONSHIPS_V

View Text

SELECT R.UE_RELATIONSHIP_ID
, R.RELATIONSHIP_CODE
, R.UE_ID
, P.OBJECT_VERSION_NUMBER
, P.CSI_ITEM_INSTANCE_ID
, P.MR_HEADER_ID
, P.CS_INCIDENT_ID
, P.MR_TITLE
, P.STATUS_CODE
, P.STATUS
, P.QA_INSPECTION_TYPE
, P.INCIDENT_NUMBER
, P.DEPARTMENT_ID
, P.DEPARTMENT_NAME
, P.ACTUAL_END_DATE
, P.PLAN_ID
, P.COLLECTION_ID
, R.RELATED_UE_ID
, C.OBJECT_VERSION_NUMBER
, C.CSI_ITEM_INSTANCE_ID
, C.MR_HEADER_ID
, C.CS_INCIDENT_ID
, C.MR_TITLE
, C.STATUS_CODE
, C.STATUS
, C.QA_INSPECTION_TYPE
, C.INCIDENT_NUMBER
, C.DEPARTMENT_ID
, C.DEPARTMENT_NAME
, C.ACTUAL_END_DATE
, C.PLAN_ID
, C.COLLECTION_ID
FROM AHL_UE_RELATIONSHIPS R
, AHL_MR_INSTANCES_V P
, AHL_MR_INSTANCES_V C
WHERE R.UE_ID = P.UNIT_EFFECTIVITY_ID
AND R.RELATED_UE_ID = C.UNIT_EFFECTIVITY_ID

Columns

Name
UE_RELATIONSHIP_ID
RELATIONSHIP_CODE
UE_ID
OBJECT_VERSION_NUMBER
ITEM_INSTANCE_ID
MR_HEADER_ID
CS_INCIDENT_ID
MR_TITLE
STATUS_CODE
STATUS
QA_INSPECTION_TYPE
INCIDENT_NUMBER
DEPARTMENT_ID
DEPARTMENT_NAME
ACTUAL_END_DATE
PLAN_ID
COLLECTION_ID
RELATED_UE_ID
REL_OBJECT_VERSION_NUMBER
REL_ITEM_INSTANCE_ID
REL_MR_HEADER_ID
REL_CS_INCIDENT_ID
REL_MR_TITLE
REL_STATUS_CODE
REL_STATUS
REL_QA_INSPECTION_TYPE
REL_INCIDENT_NUMBER
REL_DEPARTMENT_ID
REL_DEPARTMENT_NAME
REL_ACTUAL_END_DATE
REL_PLAN_ID
REL_COLLECTION_ID