VIEW: APPS.CSP_PART_CATEGORIES_V

Source

View Text - Preformatted

SELECT fl.meaning, decode(lookup_code,'101',101,0), decode(lookup_code,'101',101,100) from fnd_lookups fl where lookup_type = 'CSP_PARTS_CATEGORY' and lookup_code in ('101','0') union select meaning,lower_range+0.000001,upper_range from csp_part_priorities_v

View Text - HTML Formatted

SELECT FL.MEANING
, DECODE(LOOKUP_CODE
, '101'
, 101
, 0)
, DECODE(LOOKUP_CODE
, '101'
, 101
, 100)
FROM FND_LOOKUPS FL
WHERE LOOKUP_TYPE = 'CSP_PARTS_CATEGORY'
AND LOOKUP_CODE IN ('101'
, '0') UNION SELECT MEANING
, LOWER_RANGE+0.000001
, UPPER_RANGE
FROM CSP_PART_PRIORITIES_V