VIEW: AP.AP_POL_HEADERS#

Source

View Text - Preformatted

select POLICY_ID POLICY_ID, CATEGORY_CODE CATEGORY_CODE, POLICY_NAME POLICY_NAME, DESCRIPTION DESCRIPTION, CURRENCY_CODE CURRENCY_CODE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, JOB_GROUP_ID JOB_GROUP_ID, ROLE_CODE ROLE_CODE, DISTANCE_UOM DISTANCE_UOM, CURRENCY_PREFERENCE CURRENCY_PREFERENCE, ALLOW_RATE_CONVERSION_CODE ALLOW_RATE_CONVERSION_CODE, DAILY_LIMITS_CODE DAILY_LIMITS_CODE, START_DATE START_DATE, END_DATE END_DATE, DISTANCE_THRESHOLDS_FLAG DISTANCE_THRESHOLDS_FLAG, VEHICLE_CATEGORY_FLAG VEHICLE_CATEGORY_FLAG, VEHICLE_TYPE_FLAG VEHICLE_TYPE_FLAG, FUEL_TYPE_FLAG FUEL_TYPE_FLAG, PASSENGERS_FLAG PASSENGERS_FLAG, EMPLOYEE_ROLE_FLAG EMPLOYEE_ROLE_FLAG, TIME_BASED_ENTRY_FLAG TIME_BASED_ENTRY_FLAG, FREE_MEALS_FLAG FREE_MEALS_FLAG, FREE_ACCOMMODATIONS_FLAG FREE_ACCOMMODATIONS_FLAG, TOLERANCE_LIMITS_FLAG TOLERANCE_LIMITS_FLAG, DAILY_LIMITS_FLAG DAILY_LIMITS_FLAG, LOCATION_FLAG LOCATION_FLAG, TOLERANCE_LIMIT_CODE TOLERANCE_LIMIT_CODE, FREE_MEALS_CODE FREE_MEALS_CODE, FREE_ACCOMMODATIONS_CODE FREE_ACCOMMODATIONS_CODE, DAY_PERIOD_CODE DAY_PERIOD_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, ADDON_MILEAGE_RATES_FLAG ADDON_MILEAGE_RATES_FLAG, SCHEDULE_TYPE_CODE SCHEDULE_TYPE_CODE, MIN_TRIP_DURATION MIN_TRIP_DURATION, SAME_DAY_RATE_CODE SAME_DAY_RATE_CODE, NIGHT_RATES_CODE NIGHT_RATES_CODE, NIGHT_RATE_ELIGIBILITY NIGHT_RATE_ELIGIBILITY, NIGHT_RATE_START_TIME NIGHT_RATE_START_TIME, NIGHT_RATE_END_TIME NIGHT_RATE_END_TIME, MULTI_DEST_RULE_CODE MULTI_DEST_RULE_CODE, MULTI_DEST_START_TIME MULTI_DEST_START_TIME, MULTI_DEST_END_TIME MULTI_DEST_END_TIME, RATE_PERIOD_TYPE_CODE RATE_PERIOD_TYPE_CODE, SOURCE SOURCE, PER_DIEM_TYPE_CODE PER_DIEM_TYPE_CODE, MEALS_TYPE_CODE MEALS_TYPE_CODE, ALLOWANCE_TIME_RULE_CODE ALLOWANCE_TIME_RULE_CODE, BREAKFAST_START_TIME BREAKFAST_START_TIME, BREAKFAST_END_TIME BREAKFAST_END_TIME, LUNCH_START_TIME LUNCH_START_TIME, LUNCH_END_TIME LUNCH_END_TIME, DINNER_START_TIME DINNER_START_TIME, DINNER_END_TIME DINNER_END_TIME, USE_MAX_DEST_RATE_FLAG USE_MAX_DEST_RATE_FLAG, REIMBURSEMENT_PERCENTAGE_FLAG REIMBURSEMENT_PERCENTAGE_FLAG, REIMBURSEMENT_PERCENTAGE_CODE REIMBURSEMENT_PERCENTAGE_CODE from "AP"."AP_POL_HEADERS"

View Text - HTML Formatted

SELECT POLICY_ID POLICY_ID
, CATEGORY_CODE CATEGORY_CODE
, POLICY_NAME POLICY_NAME
, DESCRIPTION DESCRIPTION
, CURRENCY_CODE CURRENCY_CODE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, JOB_GROUP_ID JOB_GROUP_ID
, ROLE_CODE ROLE_CODE
, DISTANCE_UOM DISTANCE_UOM
, CURRENCY_PREFERENCE CURRENCY_PREFERENCE
, ALLOW_RATE_CONVERSION_CODE ALLOW_RATE_CONVERSION_CODE
, DAILY_LIMITS_CODE DAILY_LIMITS_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, DISTANCE_THRESHOLDS_FLAG DISTANCE_THRESHOLDS_FLAG
, VEHICLE_CATEGORY_FLAG VEHICLE_CATEGORY_FLAG
, VEHICLE_TYPE_FLAG VEHICLE_TYPE_FLAG
, FUEL_TYPE_FLAG FUEL_TYPE_FLAG
, PASSENGERS_FLAG PASSENGERS_FLAG
, EMPLOYEE_ROLE_FLAG EMPLOYEE_ROLE_FLAG
, TIME_BASED_ENTRY_FLAG TIME_BASED_ENTRY_FLAG
, FREE_MEALS_FLAG FREE_MEALS_FLAG
, FREE_ACCOMMODATIONS_FLAG FREE_ACCOMMODATIONS_FLAG
, TOLERANCE_LIMITS_FLAG TOLERANCE_LIMITS_FLAG
, DAILY_LIMITS_FLAG DAILY_LIMITS_FLAG
, LOCATION_FLAG LOCATION_FLAG
, TOLERANCE_LIMIT_CODE TOLERANCE_LIMIT_CODE
, FREE_MEALS_CODE FREE_MEALS_CODE
, FREE_ACCOMMODATIONS_CODE FREE_ACCOMMODATIONS_CODE
, DAY_PERIOD_CODE DAY_PERIOD_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ADDON_MILEAGE_RATES_FLAG ADDON_MILEAGE_RATES_FLAG
, SCHEDULE_TYPE_CODE SCHEDULE_TYPE_CODE
, MIN_TRIP_DURATION MIN_TRIP_DURATION
, SAME_DAY_RATE_CODE SAME_DAY_RATE_CODE
, NIGHT_RATES_CODE NIGHT_RATES_CODE
, NIGHT_RATE_ELIGIBILITY NIGHT_RATE_ELIGIBILITY
, NIGHT_RATE_START_TIME NIGHT_RATE_START_TIME
, NIGHT_RATE_END_TIME NIGHT_RATE_END_TIME
, MULTI_DEST_RULE_CODE MULTI_DEST_RULE_CODE
, MULTI_DEST_START_TIME MULTI_DEST_START_TIME
, MULTI_DEST_END_TIME MULTI_DEST_END_TIME
, RATE_PERIOD_TYPE_CODE RATE_PERIOD_TYPE_CODE
, SOURCE SOURCE
, PER_DIEM_TYPE_CODE PER_DIEM_TYPE_CODE
, MEALS_TYPE_CODE MEALS_TYPE_CODE
, ALLOWANCE_TIME_RULE_CODE ALLOWANCE_TIME_RULE_CODE
, BREAKFAST_START_TIME BREAKFAST_START_TIME
, BREAKFAST_END_TIME BREAKFAST_END_TIME
, LUNCH_START_TIME LUNCH_START_TIME
, LUNCH_END_TIME LUNCH_END_TIME
, DINNER_START_TIME DINNER_START_TIME
, DINNER_END_TIME DINNER_END_TIME
, USE_MAX_DEST_RATE_FLAG USE_MAX_DEST_RATE_FLAG
, REIMBURSEMENT_PERCENTAGE_FLAG REIMBURSEMENT_PERCENTAGE_FLAG
, REIMBURSEMENT_PERCENTAGE_CODE REIMBURSEMENT_PERCENTAGE_CODE
FROM "AP"."AP_POL_HEADERS"