SELECT description, lookup_code, 'Partial' partial_or_full FROM fv_lookup_codes WHERE lookup_type='FV_SF224_BUSINESS_ACTIVITY' UNION SELECT 'ALL', 'ALL', 'Partial' partial_or_full FROM dual UNION SELECT 'NA', 'NA', 'Full' partial_or_full FROM dual
SELECT DESCRIPTION
, LOOKUP_CODE
, 'PARTIAL' PARTIAL_OR_FULL
FROM FV_LOOKUP_CODES
WHERE LOOKUP_TYPE='FV_SF224_BUSINESS_ACTIVITY' UNION SELECT 'ALL'
, 'ALL'
, 'PARTIAL' PARTIAL_OR_FULL
FROM DUAL UNION SELECT 'NA'
, 'NA'
, 'FULL' PARTIAL_OR_FULL
FROM DUAL
|
|
|