eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_POL_LINES

Object Details

Object Name:	AP_POL_LINES
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_POL_LINES
Subobject Name:
Status:	VALID

AP_POL_HEADERS is a Policy Compliance-specific table that contains line level information for a policy schedule. The data in this table is used on the expense report validation to determine whether the report violates a company policy. Rows in this table are automatically generated based on the rules defined for a policy schedule in the table AP_POL_SCHEDULE_OPTIONS. The primary key for this table is POLICY_LINE_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_POL_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	POLICY_LINE_ID
AP_POL_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POLICY_ID
AP_POL_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCHEDULE_PERIOD_ID
AP_POL_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POLICY_ID SCHEDULE_PERIOD_ID LOCATION_ID START_OF_SEASON END_OF_SEASON EFFECTIVE_START_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
POLICY_LINE_ID	NUMBER	(15)	Yes	Policy schedule line unique identifier.
POLICY_ID	NUMBER	(15)	Yes	Policy schedule identifier
SCHEDULE_PERIOD_ID	NUMBER	(15)	Yes	Policy schedule period identifier.
STATUS	VARCHAR2	(30)		Status of the policy schedule line.
ROLE_ID	NUMBER	(15)		Employee role identifier, can be a link to job, grade, or position.
LOCATION_ID	NUMBER	(15)		Location identifier.
CURRENCY_CODE	VARCHAR2	(15)		Policy schedule currency.
MEAL_LIMIT	NUMBER			Limit per meal.
RATE	NUMBER			Daily limit.
TOLERANCE	NUMBER			Tolerance for the amounts.
TICKET_CLASS_DOMESTIC	VARCHAR2	(30)		Airfare domestic ticket class.
TICKET_CLASS_INTERNATIONAL	VARCHAR2	(30)		Airfare international ticket class.
VEHICLE_CATEGORY	VARCHAR2	(30)		Vehicle category.
VEHICLE_TYPE	VARCHAR2	(30)		Vehicle type.
FUEL_TYPE	VARCHAR2	(30)		Fuel type.
RANGE_LOW	NUMBER			Threshold low range.
RANGE_HIGH	NUMBER			Threshold high range.
CALCULATION_METHOD	VARCHAR2	(30)		Calculation method used with the rates.
MEALS_DEDUCTION	NUMBER			Meal deduction rate.
BREAKFAST_DEDUCTION	NUMBER			Breakfast deduction rate.
LUNCH_DEDUCTION	NUMBER			Lunch deduction rate.
DINNER_DEDUCTION	NUMBER			Dinner deduction rate.
ACCOMMODATION_ADJUSTMENT	NUMBER			Accommodation deduction rate.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PARENT_LINE_ID	NUMBER	(15)		Contains policy Id of current modified state of active policy
ADDON_MILEAGE_RATE_CODE	VARCHAR2	(30)		Indicates the additional mileage rate option; example TRAILER, DIRT ROAD.
RATE_PER_PASSENGER	NUMBER			This column stores the rate per passenger
RATE_TYPE_CODE	VARCHAR2	(30)		Indicates if the rate is a standard, first day rate, last day rate, nightly rate
ONE_MEAL_DEDUCTION_AMT	NUMBER			Stores the meals deduction amount for single free meal
TWO_MEALS_DEDUCTION_AMT	NUMBER			Stores the meals deduction amount for two free meals
THREE_MEALS_DEDUCTION_AMT	NUMBER			Stores the meals deduction amount for three free meals
NIGHT_RATE_TYPE_CODE	VARCHAR2	(30)		Stores the night rate type in case of multiple night rates implementation
ACCOMMODATION_CALC_METHOD	VARCHAR2	(30)		Stores the calculation method for accommodations deduction/addition
START_OF_SEASON	VARCHAR2	(5)		Start of Season
END_OF_SEASON	VARCHAR2	(5)		End of Season
MAX_LODGING_AMT	NUMBER			Lodging
NO_GOVT_MEALS_AMT	NUMBER			Government Meals
PROP_MEALS_AMT	NUMBER			Proportional Meals
OFF_BASE_INC_AMT	NUMBER			Off Base Incidentals
FOOTNOTE_AMT	NUMBER			Footnote
FOOTNOTE_RATE_AMT	NUMBER			Footnote Rate
MAX_PER_DIEM_AMT	NUMBER			Max Per Diem
EFFECTIVE_START_DATE	DATE			Effective Start Date
EFFECTIVE_END_DATE	DATE			Effective End Date
REIMBURSEMENT_PERCENTAGE	NUMBER			Reimbursement Percentage
MAX_RECEIPT_AMT	NUMBER			Max Receipt amount for reimbursement percentage calculation

Query Text

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;

Dependencies

[top of page]

AP.AP_POL_LINES does not reference any database object

AP.AP_POL_LINES is referenced by following:

AP: AP_POL_LINES#