VIEW: AP.AP_POL_LINES#

Source

View Text - Preformatted

select POLICY_LINE_ID POLICY_LINE_ID, POLICY_ID POLICY_ID, SCHEDULE_PERIOD_ID SCHEDULE_PERIOD_ID, STATUS STATUS, ROLE_ID ROLE_ID, LOCATION_ID LOCATION_ID, CURRENCY_CODE CURRENCY_CODE, MEAL_LIMIT MEAL_LIMIT, RATE RATE, TOLERANCE TOLERANCE, TICKET_CLASS_DOMESTIC TICKET_CLASS_DOMESTIC, TICKET_CLASS_INTERNATIONAL TICKET_CLASS_INTERNATIONAL, VEHICLE_CATEGORY VEHICLE_CATEGORY, VEHICLE_TYPE VEHICLE_TYPE, FUEL_TYPE FUEL_TYPE, RANGE_LOW RANGE_LOW, RANGE_HIGH RANGE_HIGH, CALCULATION_METHOD CALCULATION_METHOD, MEALS_DEDUCTION MEALS_DEDUCTION, BREAKFAST_DEDUCTION BREAKFAST_DEDUCTION, LUNCH_DEDUCTION LUNCH_DEDUCTION, DINNER_DEDUCTION DINNER_DEDUCTION, ACCOMMODATION_ADJUSTMENT ACCOMMODATION_ADJUSTMENT, 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, PARENT_LINE_ID PARENT_LINE_ID, ADDON_MILEAGE_RATE_CODE ADDON_MILEAGE_RATE_CODE, RATE_PER_PASSENGER RATE_PER_PASSENGER, RATE_TYPE_CODE RATE_TYPE_CODE, ONE_MEAL_DEDUCTION_AMT ONE_MEAL_DEDUCTION_AMT, TWO_MEALS_DEDUCTION_AMT TWO_MEALS_DEDUCTION_AMT, THREE_MEALS_DEDUCTION_AMT THREE_MEALS_DEDUCTION_AMT, NIGHT_RATE_TYPE_CODE NIGHT_RATE_TYPE_CODE, ACCOMMODATION_CALC_METHOD ACCOMMODATION_CALC_METHOD, START_OF_SEASON START_OF_SEASON, END_OF_SEASON END_OF_SEASON, MAX_LODGING_AMT MAX_LODGING_AMT, NO_GOVT_MEALS_AMT NO_GOVT_MEALS_AMT, PROP_MEALS_AMT PROP_MEALS_AMT, OFF_BASE_INC_AMT OFF_BASE_INC_AMT, FOOTNOTE_AMT FOOTNOTE_AMT, FOOTNOTE_RATE_AMT FOOTNOTE_RATE_AMT, MAX_PER_DIEM_AMT MAX_PER_DIEM_AMT, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, REIMBURSEMENT_PERCENTAGE REIMBURSEMENT_PERCENTAGE, MAX_RECEIPT_AMT MAX_RECEIPT_AMT from "AP"."AP_POL_LINES"

View Text - HTML Formatted

SELECT POLICY_LINE_ID POLICY_LINE_ID
, POLICY_ID POLICY_ID
, SCHEDULE_PERIOD_ID SCHEDULE_PERIOD_ID
, STATUS STATUS
, ROLE_ID ROLE_ID
, LOCATION_ID LOCATION_ID
, CURRENCY_CODE CURRENCY_CODE
, MEAL_LIMIT MEAL_LIMIT
, RATE RATE
, TOLERANCE TOLERANCE
, TICKET_CLASS_DOMESTIC TICKET_CLASS_DOMESTIC
, TICKET_CLASS_INTERNATIONAL TICKET_CLASS_INTERNATIONAL
, VEHICLE_CATEGORY VEHICLE_CATEGORY
, VEHICLE_TYPE VEHICLE_TYPE
, FUEL_TYPE FUEL_TYPE
, RANGE_LOW RANGE_LOW
, RANGE_HIGH RANGE_HIGH
, CALCULATION_METHOD CALCULATION_METHOD
, MEALS_DEDUCTION MEALS_DEDUCTION
, BREAKFAST_DEDUCTION BREAKFAST_DEDUCTION
, LUNCH_DEDUCTION LUNCH_DEDUCTION
, DINNER_DEDUCTION DINNER_DEDUCTION
, ACCOMMODATION_ADJUSTMENT ACCOMMODATION_ADJUSTMENT
, 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
, PARENT_LINE_ID PARENT_LINE_ID
, ADDON_MILEAGE_RATE_CODE ADDON_MILEAGE_RATE_CODE
, RATE_PER_PASSENGER RATE_PER_PASSENGER
, RATE_TYPE_CODE RATE_TYPE_CODE
, ONE_MEAL_DEDUCTION_AMT ONE_MEAL_DEDUCTION_AMT
, TWO_MEALS_DEDUCTION_AMT TWO_MEALS_DEDUCTION_AMT
, THREE_MEALS_DEDUCTION_AMT THREE_MEALS_DEDUCTION_AMT
, NIGHT_RATE_TYPE_CODE NIGHT_RATE_TYPE_CODE
, ACCOMMODATION_CALC_METHOD ACCOMMODATION_CALC_METHOD
, START_OF_SEASON START_OF_SEASON
, END_OF_SEASON END_OF_SEASON
, MAX_LODGING_AMT MAX_LODGING_AMT
, NO_GOVT_MEALS_AMT NO_GOVT_MEALS_AMT
, PROP_MEALS_AMT PROP_MEALS_AMT
, OFF_BASE_INC_AMT OFF_BASE_INC_AMT
, FOOTNOTE_AMT FOOTNOTE_AMT
, FOOTNOTE_RATE_AMT FOOTNOTE_RATE_AMT
, MAX_PER_DIEM_AMT MAX_PER_DIEM_AMT
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, REIMBURSEMENT_PERCENTAGE REIMBURSEMENT_PERCENTAGE
, MAX_RECEIPT_AMT MAX_RECEIPT_AMT
FROM "AP"."AP_POL_LINES"