[Home] [Help] [Dependency Information]

VIEW: AP.AP_POL_HEADERS#

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

AP

AP_POL_HEADERS

APPS

AP_POL_HEADERS