VIEW: APPS.JTF_RS_PROBLEM_CODES_V

Source

View Text - Preformatted

SELECT lv.lookup_code problem_code, lv.meaning problem_name, lv.description, lv.enabled_flag, lv.start_date_active, lv.end_date_active from fnd_lookup_values lv WHERE lv.LANGUAGE = userenv('LANG') AND lv.View_APPLICATION_ID = 170 AND lv.lookup_type = 'REQUEST_PROBLEM_CODE' AND lv.SECURITY_GROUP_ID = greatest (0, to_number(decode(substrb(userenv('CLIENT_INFO'),55,1), ' ', '0', null, '0', substrb(userenv('CLIENT_INFO'),55,10))))

View Text - HTML Formatted

SELECT LV.LOOKUP_CODE PROBLEM_CODE
, LV.MEANING PROBLEM_NAME
, LV.DESCRIPTION
, LV.ENABLED_FLAG
, LV.START_DATE_ACTIVE
, LV.END_DATE_ACTIVE
FROM FND_LOOKUP_VALUES LV
WHERE LV.LANGUAGE = USERENV('LANG')
AND LV.VIEW_APPLICATION_ID = 170
AND LV.LOOKUP_TYPE = 'REQUEST_PROBLEM_CODE'
AND LV.SECURITY_GROUP_ID = GREATEST (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10))))