VIEW: APPS.AHL_MR_INST_RELATIONSHIPS_V

Source

View Text - Preformatted

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.SCHEDULED_START_DATE, P.SCHEDULED_END_DATE, P.ACTUAL_START_DATE, 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.SCHEDULED_START_DATE, C.SCHEDULED_END_DATE, C.ACTUAL_START_DATE, 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

View Text - HTML Formatted

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.SCHEDULED_START_DATE
, P.SCHEDULED_END_DATE
, P.ACTUAL_START_DATE
, 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.SCHEDULED_START_DATE
, C.SCHEDULED_END_DATE
, C.ACTUAL_START_DATE
, 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