EXM_ALL_POLICIES_VIEW
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: VIEW
Columns
Name |
---|
POLICY_ID POLICY_NAME DESCRIPTION STATUS CATEGORY POLICY_TYPE LAST_UPDATED CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY |
Query
SQL_Statement |
---|
SELECT airfare_policy_id as policy_id, policy_name, description, status, 'AIRFARE' as category, 'AIRFARE' as policy_type, trunc(LAST_UPDATE_DATE) as last_updated, creation_date, created_by, last_update_date, last_updated_by FROM exm_airfare_policies UNION ALL SELECT accom_policy_id as policy_id, policy_name, description, status, 'ACCOMMODATIONS' as category, nvl(rates_source_code,'ACCOMMODATIONS') as policy_type, trunc(LAST_UPDATE_DATE) as last_updated, creation_date, created_by, last_update_date, last_updated_by FROM exm_accom_policies UNION ALL SELECT carrental_policy_id as policy_id, policy_name, description, status, 'CAR_RENTAL' as category, 'CAR_RENTAL' as policy_type, trunc(LAST_UPDATE_DATE) as last_updated, creation_date, created_by, last_update_date, last_updated_by FROM exm_carrental_policies UNION ALL SELECT entertainment_policy_id as policy_id, policy_name, description, status, 'ENTERTAINMENT' as category, 'ENTERTAINMENT' as policy_type, trunc(LAST_UPDATE_DATE) as last_updated, creation_date, created_by, last_update_date, last_updated_by FROM exm_entertainment_policies UNION ALL SELECT meals_policy_id as policy_id, policy_name, description, status, 'MEALS' as category, nvl(rates_source_code,'MEALS') as policy_type, trunc(LAST_UPDATE_DATE) as last_updated, creation_date, created_by, last_update_date, last_updated_by FROM exm_meals_policies UNION ALL SELECT mileage_policy_id as policy_id, policy_name, description, status, 'MILEAGE' as category, 'MILEAGE' as policy_type, trunc(LAST_UPDATE_DATE) as last_updated, creation_date, created_by, last_update_date, last_updated_by FROM exm_mileage_policies UNION ALL SELECT misc_policy_id as policy_id, policy_name, description, status, 'MISC' as category, 'MISC' as policy_type, trunc(LAST_UPDATE_DATE) as last_updated, creation_date, created_by, last_update_date, last_updated_by FROM exm_misc_policies UNION ALL SELECT perdiem_policy_id as policy_id, policy_name, description, status, 'PER_DIEM' as category, nvl(rates_source_code,'PER_DIEM') as policy_type, trunc(LAST_UPDATE_DATE) as last_updated, creation_date, created_by, last_update_date, last_updated_by FROM exm_perdiem_policies |