View: JTF_RS_PROBLEM_CODES_V

Product:	JTF - CRM Foundation
Description:	Stores all valid problem codes for which resource skills can be assigned.
Implementation/DBA Data:	APPS.JTF_RS_PROBLEM_CODES_V

View Text

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))))

Columns