[Home] [Help] [Dependency Information]
Object Name: | AP_POL_LINES# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POLICY_LINE_ID | NUMBER | (15) | Yes | |
POLICY_ID | NUMBER | (15) | Yes | |
SCHEDULE_PERIOD_ID | NUMBER | (15) | Yes | |
STATUS | VARCHAR2 | (30) | ||
ROLE_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
MEAL_LIMIT | NUMBER | |||
RATE | NUMBER | |||
TOLERANCE | NUMBER | |||
TICKET_CLASS_DOMESTIC | VARCHAR2 | (30) | ||
TICKET_CLASS_INTERNATIONAL | VARCHAR2 | (30) | ||
VEHICLE_CATEGORY | VARCHAR2 | (30) | ||
VEHICLE_TYPE | VARCHAR2 | (30) | ||
FUEL_TYPE | VARCHAR2 | (30) | ||
RANGE_LOW | NUMBER | |||
RANGE_HIGH | NUMBER | |||
CALCULATION_METHOD | VARCHAR2 | (30) | ||
MEALS_DEDUCTION | NUMBER | |||
BREAKFAST_DEDUCTION | NUMBER | |||
LUNCH_DEDUCTION | NUMBER | |||
DINNER_DEDUCTION | NUMBER | |||
ACCOMMODATION_ADJUSTMENT | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
PARENT_LINE_ID | NUMBER | (15) | ||
ADDON_MILEAGE_RATE_CODE | VARCHAR2 | (30) | ||
RATE_PER_PASSENGER | NUMBER | |||
RATE_TYPE_CODE | VARCHAR2 | (30) | ||
ONE_MEAL_DEDUCTION_AMT | NUMBER | |||
TWO_MEALS_DEDUCTION_AMT | NUMBER | |||
THREE_MEALS_DEDUCTION_AMT | NUMBER | |||
NIGHT_RATE_TYPE_CODE | VARCHAR2 | (30) | ||
ACCOMMODATION_CALC_METHOD | VARCHAR2 | (30) | ||
START_OF_SEASON | VARCHAR2 | (5) | ||
END_OF_SEASON | VARCHAR2 | (5) | ||
MAX_LODGING_AMT | NUMBER | |||
NO_GOVT_MEALS_AMT | NUMBER | |||
PROP_MEALS_AMT | NUMBER | |||
OFF_BASE_INC_AMT | NUMBER | |||
FOOTNOTE_AMT | NUMBER | |||
FOOTNOTE_RATE_AMT | NUMBER | |||
MAX_PER_DIEM_AMT | NUMBER | |||
EFFECTIVE_START_DATE | DATE | |||
EFFECTIVE_END_DATE | DATE | |||
REIMBURSEMENT_PERCENTAGE | NUMBER | |||
MAX_RECEIPT_AMT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT POLICY_LINE_ID
, POLICY_ID
, SCHEDULE_PERIOD_ID
, STATUS
, ROLE_ID
, LOCATION_ID
, CURRENCY_CODE
, MEAL_LIMIT
, RATE
, TOLERANCE
, TICKET_CLASS_DOMESTIC
, TICKET_CLASS_INTERNATIONAL
, VEHICLE_CATEGORY
, VEHICLE_TYPE
, FUEL_TYPE
, RANGE_LOW
, RANGE_HIGH
, CALCULATION_METHOD
, MEALS_DEDUCTION
, BREAKFAST_DEDUCTION
, LUNCH_DEDUCTION
, DINNER_DEDUCTION
, ACCOMMODATION_ADJUSTMENT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PARENT_LINE_ID
, ADDON_MILEAGE_RATE_CODE
, RATE_PER_PASSENGER
, RATE_TYPE_CODE
, ONE_MEAL_DEDUCTION_AMT
, TWO_MEALS_DEDUCTION_AMT
, THREE_MEALS_DEDUCTION_AMT
, NIGHT_RATE_TYPE_CODE
, ACCOMMODATION_CALC_METHOD
, START_OF_SEASON
, END_OF_SEASON
, MAX_LODGING_AMT
, NO_GOVT_MEALS_AMT
, PROP_MEALS_AMT
, OFF_BASE_INC_AMT
, FOOTNOTE_AMT
, FOOTNOTE_RATE_AMT
, MAX_PER_DIEM_AMT
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, REIMBURSEMENT_PERCENTAGE
, MAX_RECEIPT_AMT
FROM AP.AP_POL_LINES#;
|
|
|