DBA Data[Home] [Help] [Dependency Information]

VIEW: AP.AP_POL_HEADERS#

Object Details
Object Name: AP_POL_HEADERS#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
POLICY_ID NUMBER (15) Yes
CATEGORY_CODE VARCHAR2 (30) Yes
POLICY_NAME VARCHAR2 (60) Yes
DESCRIPTION VARCHAR2 (240)
CURRENCY_CODE VARCHAR2 (15)
BUSINESS_GROUP_ID NUMBER (15)
JOB_GROUP_ID NUMBER (15)
ROLE_CODE VARCHAR2 (30)
DISTANCE_UOM VARCHAR2 (30)
CURRENCY_PREFERENCE VARCHAR2 (30)
ALLOW_RATE_CONVERSION_CODE VARCHAR2 (30)
DAILY_LIMITS_CODE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

DISTANCE_THRESHOLDS_FLAG VARCHAR2 (1)
VEHICLE_CATEGORY_FLAG VARCHAR2 (1)
VEHICLE_TYPE_FLAG VARCHAR2 (1)
FUEL_TYPE_FLAG VARCHAR2 (1)
PASSENGERS_FLAG VARCHAR2 (1)
EMPLOYEE_ROLE_FLAG VARCHAR2 (1)
TIME_BASED_ENTRY_FLAG VARCHAR2 (1)
FREE_MEALS_FLAG VARCHAR2 (1)
FREE_ACCOMMODATIONS_FLAG VARCHAR2 (1)
TOLERANCE_LIMITS_FLAG VARCHAR2 (1)
DAILY_LIMITS_FLAG VARCHAR2 (1)
LOCATION_FLAG VARCHAR2 (1)
TOLERANCE_LIMIT_CODE VARCHAR2 (30)
FREE_MEALS_CODE VARCHAR2 (30)
FREE_ACCOMMODATIONS_CODE VARCHAR2 (30)
DAY_PERIOD_CODE VARCHAR2 (30)
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
ADDON_MILEAGE_RATES_FLAG VARCHAR2 (1)
SCHEDULE_TYPE_CODE VARCHAR2 (30)
MIN_TRIP_DURATION NUMBER

SAME_DAY_RATE_CODE VARCHAR2 (30)
NIGHT_RATES_CODE VARCHAR2 (30)
NIGHT_RATE_ELIGIBILITY NUMBER

NIGHT_RATE_START_TIME NUMBER

NIGHT_RATE_END_TIME NUMBER

MULTI_DEST_RULE_CODE VARCHAR2 (30)
MULTI_DEST_START_TIME NUMBER

MULTI_DEST_END_TIME NUMBER

RATE_PERIOD_TYPE_CODE VARCHAR2 (30)
SOURCE VARCHAR2 (30)
PER_DIEM_TYPE_CODE VARCHAR2 (30)
MEALS_TYPE_CODE VARCHAR2 (30)
ALLOWANCE_TIME_RULE_CODE VARCHAR2 (30)
BREAKFAST_START_TIME NUMBER (15)
BREAKFAST_END_TIME NUMBER (15)
LUNCH_START_TIME NUMBER (15)
LUNCH_END_TIME NUMBER (15)
DINNER_START_TIME NUMBER (15)
DINNER_END_TIME NUMBER (15)
USE_MAX_DEST_RATE_FLAG VARCHAR2 (1)
REIMBURSEMENT_PERCENTAGE_FLAG VARCHAR2 (1)
REIMBURSEMENT_PERCENTAGE_CODE VARCHAR2 (30)
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# references the following:

SchemaAP
TableAP_POL_HEADERS
AP.AP_POL_HEADERS# is referenced by following:

SchemaAPPS
SynonymAP_POL_HEADERS