VIEW: APPS.FV_SF224_GWA_REPORT_CATEGORY_V

Source

View Text - Preformatted

SELECT fmap.business_activity_code, fmap.gwa_reporter_category_code, flc.description, 'Partial' partial_or_full FROM fv_sf224_map fmap, fv_lookup_codes flc WHERE flc.lookup_type = 'FV_SF224_GWA_REPORTER_CATEGORY' AND flc.lookup_code = fmap.gwa_reporter_category_code UNION SELECT 'ALL', 'ALL', 'ALL', 'Partial' partial_or_full FROM dual UNION SELECT 'ALL', lookup_code, description, 'Partial' partial_or_full FROM fv_lookup_codes WHERE lookup_type='FV_SF224_GWA_REPORTER_CATEGORY' UNION SELECT 'NA', 'NA', 'NA', 'Full' partial_or_full FROM dual

View Text - HTML Formatted

SELECT FMAP.BUSINESS_ACTIVITY_CODE
, FMAP.GWA_REPORTER_CATEGORY_CODE
, FLC.DESCRIPTION
, 'PARTIAL' PARTIAL_OR_FULL
FROM FV_SF224_MAP FMAP
, FV_LOOKUP_CODES FLC
WHERE FLC.LOOKUP_TYPE = 'FV_SF224_GWA_REPORTER_CATEGORY'
AND FLC.LOOKUP_CODE = FMAP.GWA_REPORTER_CATEGORY_CODE UNION SELECT 'ALL'
, 'ALL'
, 'ALL'
, 'PARTIAL' PARTIAL_OR_FULL
FROM DUAL UNION SELECT 'ALL'
, LOOKUP_CODE
, DESCRIPTION
, 'PARTIAL' PARTIAL_OR_FULL
FROM FV_LOOKUP_CODES
WHERE LOOKUP_TYPE='FV_SF224_GWA_REPORTER_CATEGORY' UNION SELECT 'NA'
, 'NA'
, 'NA'
, 'FULL' PARTIAL_OR_FULL
FROM DUAL