VIEW: APPS.AHL_MR_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT A.MR_RELATIONSHIP_ID, A.OBJECT_VERSION_NUMBER, A.LAST_UPDATE_DATE LAST_UPDATED_DATE, A.LAST_UPDATED_BY LAST_UPDATE_BY, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATE_LOGIN, A.RELATIONSHIP_CODE, A.MR_HEADER_ID, P.TITLE MR_TITLE, P.MR_STATUS_CODE, PSTATUS.MEANING STATUS, P.PROGRAM_TYPE_CODE, PPROGTYPE.MEANING PROGRAM_TYPE, P.EFFECTIVE_FROM, P.EFFECTIVE_TO, P.REVISION MR_REVISION, P_TL.DESCRIPTION, P.TYPE_CODE, TYPEP.MEANING TYPE, A.RELATED_MR_HEADER_ID, C.TITLE RELATED_MR_TITLE, C.MR_STATUS_CODE RELATED_MR_STATUS_CODE, CSTATUS.MEANING RELATED_STATUS, C.PROGRAM_TYPE_CODE RELATED_PROGRAM_TYPE_CODE, CPROGTYPE.MEANING RELATED_PROGRAM_TYPE, C.EFFECTIVE_FROM RELATED_EFFECTIVE_FROM, C.EFFECTIVE_TO RELATED_EFFECTIVE_TO, C.REVISION RELATED_MR_REVISION, C_TL.DESCRIPTION RELATED_DESCRIPTION, C.TYPE_CODE RELATED_TYPE_CODE, TYPEC.MEANING RELATED_TYPE, P.DOWN_TIME DOWNTIME, P.uom_code, UOM.MEANING UOM, A.ATTRIBUTE_CATEGORY, A.ATTRIBUTE1, A.ATTRIBUTE2, A.ATTRIBUTE3, A.ATTRIBUTE4, A.ATTRIBUTE5, A.ATTRIBUTE6, A.ATTRIBUTE7, A.ATTRIBUTE8, A.ATTRIBUTE9, A.ATTRIBUTE10, A.ATTRIBUTE11, A.ATTRIBUTE12, A.ATTRIBUTE13, A.ATTRIBUTE14, A.ATTRIBUTE15 FROM AHL_MR_RELATIONSHIPS A, AHL_MR_HEADERS_B P, AHL_MR_HEADERS_TL P_TL, AHL_MR_HEADERS_B C, AHL_MR_HEADERS_TL C_TL, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_FMP_PM_DOWNTIME_UOM' AND LANGUAGE = USERENV('LANG')) UOM, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_FMP_MR_PROGRAM_TYPE' AND LANGUAGE = USERENV('LANG')) PPROGTYPE, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_FMP_MR_PROGRAM_TYPE' AND LANGUAGE = USERENV('LANG')) CPROGTYPE, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS' AND LANGUAGE = USERENV('LANG')) PSTATUS, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_FMP_MR_TYPE' AND LANGUAGE = USERENV('LANG')) TYPEP, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS' AND LANGUAGE = USERENV('LANG')) CSTATUS, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_FMP_MR_TYPE' AND LANGUAGE = USERENV('LANG')) TYPEC WHERE A.MR_HEADER_ID = P.MR_HEADER_ID AND P.APPLICATION_USG_CODE = FND_PROFILE.VALUE('AHL_APPLN_USAGE') AND P.MR_HEADER_ID = P_TL.MR_HEADER_ID AND P_TL.LANGUAGE = USERENV('LANG') AND A.RELATED_MR_HEADER_ID = C.MR_HEADER_ID AND C.MR_HEADER_ID = C_TL.MR_HEADER_ID AND C_TL.LANGUAGE = USERENV('LANG') AND UOM.lookup_code (+) = P.UOM_CODE AND PPROGTYPE.lookup_code = P.program_type_code AND CPROGTYPE.lookup_code = C.program_type_code AND TYPEP.lookup_code (+) = P.type_code AND PSTATUS.lookup_code = P.mr_status_code AND TYPEC.lookup_code (+) = C.type_code AND CSTATUS.lookup_code = C.mr_status_code

View Text - HTML Formatted

SELECT A.MR_RELATIONSHIP_ID
, A.OBJECT_VERSION_NUMBER
, A.LAST_UPDATE_DATE LAST_UPDATED_DATE
, A.LAST_UPDATED_BY LAST_UPDATE_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.RELATIONSHIP_CODE
, A.MR_HEADER_ID
, P.TITLE MR_TITLE
, P.MR_STATUS_CODE
, PSTATUS.MEANING STATUS
, P.PROGRAM_TYPE_CODE
, PPROGTYPE.MEANING PROGRAM_TYPE
, P.EFFECTIVE_FROM
, P.EFFECTIVE_TO
, P.REVISION MR_REVISION
, P_TL.DESCRIPTION
, P.TYPE_CODE
, TYPEP.MEANING TYPE
, A.RELATED_MR_HEADER_ID
, C.TITLE RELATED_MR_TITLE
, C.MR_STATUS_CODE RELATED_MR_STATUS_CODE
, CSTATUS.MEANING RELATED_STATUS
, C.PROGRAM_TYPE_CODE RELATED_PROGRAM_TYPE_CODE
, CPROGTYPE.MEANING RELATED_PROGRAM_TYPE
, C.EFFECTIVE_FROM RELATED_EFFECTIVE_FROM
, C.EFFECTIVE_TO RELATED_EFFECTIVE_TO
, C.REVISION RELATED_MR_REVISION
, C_TL.DESCRIPTION RELATED_DESCRIPTION
, C.TYPE_CODE RELATED_TYPE_CODE
, TYPEC.MEANING RELATED_TYPE
, P.DOWN_TIME DOWNTIME
, P.UOM_CODE
, UOM.MEANING UOM
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
FROM AHL_MR_RELATIONSHIPS A
, AHL_MR_HEADERS_B P
, AHL_MR_HEADERS_TL P_TL
, AHL_MR_HEADERS_B C
, AHL_MR_HEADERS_TL C_TL
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_FMP_PM_DOWNTIME_UOM'
AND LANGUAGE = USERENV('LANG')) UOM
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_FMP_MR_PROGRAM_TYPE'
AND LANGUAGE = USERENV('LANG')) PPROGTYPE
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_FMP_MR_PROGRAM_TYPE'
AND LANGUAGE = USERENV('LANG')) CPROGTYPE
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
AND LANGUAGE = USERENV('LANG')) PSTATUS
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_FMP_MR_TYPE'
AND LANGUAGE = USERENV('LANG')) TYPEP
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
AND LANGUAGE = USERENV('LANG')) CSTATUS
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_FMP_MR_TYPE'
AND LANGUAGE = USERENV('LANG')) TYPEC
WHERE A.MR_HEADER_ID = P.MR_HEADER_ID
AND P.APPLICATION_USG_CODE = FND_PROFILE.VALUE('AHL_APPLN_USAGE')
AND P.MR_HEADER_ID = P_TL.MR_HEADER_ID
AND P_TL.LANGUAGE = USERENV('LANG')
AND A.RELATED_MR_HEADER_ID = C.MR_HEADER_ID
AND C.MR_HEADER_ID = C_TL.MR_HEADER_ID
AND C_TL.LANGUAGE = USERENV('LANG')
AND UOM.LOOKUP_CODE (+) = P.UOM_CODE
AND PPROGTYPE.LOOKUP_CODE = P.PROGRAM_TYPE_CODE
AND CPROGTYPE.LOOKUP_CODE = C.PROGRAM_TYPE_CODE
AND TYPEP.LOOKUP_CODE (+) = P.TYPE_CODE
AND PSTATUS.LOOKUP_CODE = P.MR_STATUS_CODE
AND TYPEC.LOOKUP_CODE (+) = C.TYPE_CODE
AND CSTATUS.LOOKUP_CODE = C.MR_STATUS_CODE