VIEW: APPS.OKX_PM_ACTIVITIES_V

Source

View Text - Preformatted

SELECT MR.MR_HEADER_ID ID1, '#' ID2, MR.TITLE NAME, MR_TL.DESCRIPTION DESCRIPTION, MR.TYPE_CODE TYPE_CODE, TYPE.MEANING TYPE, MR.EFFECTIVE_FROM EFFECTIVE_FROM, MR.EFFECTIVE_TO EFFECTIVE_TO, MR.MR_STATUS_CODE MR_STATUS_CODE, STATUS.MEANING STATUS, MR.DOWN_TIME, UOM.MEANING UOM, amr.mr_header_id program_id From AHL_MR_HEADERS_B MR, AHL_MR_HEADERS_TL MR_TL, AHL_MR_RELATIONSHIPS amr, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS' AND LANGUAGE = USERENV('LANG')) STATUS, (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_TYPE' AND LANGUAGE = USERENV('LANG')) TYPE WHERE MR.MR_HEADER_ID = MR_TL.MR_HEADER_ID And MR_TL.LANGUAGE = USERENV('LANG') And MR.APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) And STATUS.lookup_code = MR.mr_status_code And TYPE.lookup_code(+) = MR.type_code And UOM.lookup_code(+) = MR.UOM_CODE And amr.related_mr_header_id = MR.mr_header_id AND mr.TYPE_CODE = 'ACTIVITY'

View Text - HTML Formatted

SELECT MR.MR_HEADER_ID ID1
, '#' ID2
, MR.TITLE NAME
, MR_TL.DESCRIPTION DESCRIPTION
, MR.TYPE_CODE TYPE_CODE
, TYPE.MEANING TYPE
, MR.EFFECTIVE_FROM EFFECTIVE_FROM
, MR.EFFECTIVE_TO EFFECTIVE_TO
, MR.MR_STATUS_CODE MR_STATUS_CODE
, STATUS.MEANING STATUS
, MR.DOWN_TIME
, UOM.MEANING UOM
, AMR.MR_HEADER_ID PROGRAM_ID
FROM AHL_MR_HEADERS_B MR
, AHL_MR_HEADERS_TL MR_TL
, AHL_MR_RELATIONSHIPS AMR
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
AND LANGUAGE = USERENV('LANG')) STATUS
, (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_TYPE'
AND LANGUAGE = USERENV('LANG')) TYPE
WHERE MR.MR_HEADER_ID = MR_TL.MR_HEADER_ID
AND MR_TL.LANGUAGE = USERENV('LANG')
AND MR.APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))
AND STATUS.LOOKUP_CODE = MR.MR_STATUS_CODE
AND TYPE.LOOKUP_CODE(+) = MR.TYPE_CODE
AND UOM.LOOKUP_CODE(+) = MR.UOM_CODE
AND AMR.RELATED_MR_HEADER_ID = MR.MR_HEADER_ID
AND MR.TYPE_CODE = 'ACTIVITY'