EXM_ALL_POLICIES

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

Name

POLICY_ID

POLICY_NAME

DESCRIPTION

STATUS

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

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