VIEW: APPS.BIV_DBI_REPAIR_TYPES_V

Source

View Text - Preformatted

SELECT decode(lookup_code,'REFURBISHMENT','-2','-1') id, decode(lookup_code,'REFURBISHMENT','_ ','-- ') ||meaning value, meaning value2, null pval from fnd_lookups WHERE lookup_type = 'CSD_REPAIR_TYPE_CLASSIFICATION' union all select to_char(repair_type_id) , '__ ' || Name , Name , to_char(-2) from csd_repair_types_vl WHERE repair_type_ref = 'RF' union all select to_char(repair_type_id) , '----  ' || Name, Name , to_char(-1) from csd_repair_types_vl where repair_type_ref <> 'RF' order by 2

View Text - HTML Formatted

SELECT DECODE(LOOKUP_CODE
, 'REFURBISHMENT'
, '-2'
, '-1') ID
, DECODE(LOOKUP_CODE
, 'REFURBISHMENT'
, '_ '
, '-- ') ||MEANING VALUE
, MEANING VALUE2
, NULL PVAL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CSD_REPAIR_TYPE_CLASSIFICATION' UNION ALL SELECT TO_CHAR(REPAIR_TYPE_ID)
, '__ ' || NAME
, NAME
, TO_CHAR(-2)
FROM CSD_REPAIR_TYPES_VL
WHERE REPAIR_TYPE_REF = 'RF' UNION ALL SELECT TO_CHAR(REPAIR_TYPE_ID)
, '---- ' || NAME
, NAME
, TO_CHAR(-1)
FROM CSD_REPAIR_TYPES_VL
WHERE REPAIR_TYPE_REF <> 'RF' ORDER BY 2