VIEW: APPS.OKX_PM_PROGRAMS_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 FROM ahl_mr_headers_b mr, ahl_mr_headers_tl mr_tl, (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_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 mr.type_code = 'PROGRAM'

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
FROM AHL_MR_HEADERS_B MR
, AHL_MR_HEADERS_TL MR_TL
, (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_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 MR.TYPE_CODE = 'PROGRAM'