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]

VIEW: APPS.AP_EXPENSE_REPORT_VIOLATIONS_V

Object Details

Object Name:	AP_EXPENSE_REPORT_VIOLATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_EXPENSE_REPORT_VIOLATIONS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EMPLOYEE_ID	NUMBER	(10)		Employee identifier
PAID_ON_BEHALF_EMPLOYEE_ID	NUMBER	(15)		When an expense report gets split in Both Pay scenario, the new expense report's paid_on_behalf_employee_id gets populated with the original expense report's employee_id.
WEEK_END_DATE	DATE		Yes	Period ending date of expense report, used as invoice_date and GL_date for expense reports
INVOICE_NUM	VARCHAR2	(50)		Invoice number
REPORT_HEADER_ID	NUMBER		Yes	Expense report header identifier
AMOUNT	NUMBER			Amount
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Line number for invoice distribution line created from expense report line
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		Indicates the code for the currency in which the expense line was incurred.
RECEIPT_CURRENCY_AMOUNT	NUMBER			The amount that appears on the receipt.
DAILY_AMOUNT	NUMBER			Indicates the amount charged daily for a multi-day receipt, for example, the daily rate of a rental car or hotel room.
WEB_PARAMETER_ID	NUMBER			Expense report item type identifier
CATEGORY_CODE	VARCHAR2	(30)		Category Code
SUBMITTED_AMOUNT	NUMBER			The original reimbursement amount. This column is populated if the auditor adjusts the reimbursement amount
VIOLATION_NUMBER	NUMBER		Yes	Violation number.
VIOLATION_TYPE	VARCHAR2	(30)		Violation Type
VIOLATION_DATE	DATE			Date violation occurred
ALLOWABLE_AMOUNT	NUMBER
VIOLATION_AMOUNT	NUMBER
ITEMIZATION_PARENT_ID	NUMBER			Indicates a line's involvement in an itemization: if NULL, line is not involved in an itemization; if -1, line is a parent line for an itemization; if >0, line is an itemized child line and this value is the parent line's REPORT_LINE_ID.
REPORT_LINE_ID	NUMBER	(15)		Report Line Identifier

Query Text

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


SELECT EMPLOYEE_ID
,      PAID_ON_BEHALF_EMPLOYEE_ID
,      WEEK_END_DATE
,      INVOICE_NUM
,      REPORT_HEADER_ID
,      AMOUNT
,      CURRENCY_CODE
,      DISTRIBUTION_LINE_NUMBER
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      DAILY_AMOUNT
,      WEB_PARAMETER_ID
,      CATEGORY_CODE
,      SUBMITTED_AMOUNT
,      VIOLATION_NUMBER
,      VIOLATION_TYPE
,      VIOLATION_DATE
,      ALLOWABLE_AMOUNT
,      VIOLATION_AMOUNT
,      ITEMIZATION_PARENT_ID
,      REPORT_LINE_ID
FROM APPS.AP_EXPENSE_REPORT_VIOLATIONS_V;

Dependencies

[top of page]

APPS.AP_EXPENSE_REPORT_VIOLATIONS_V references the following:

APPS: AP_EXPENSE_REPORTS_ALL; AP_EXPENSE_REPORT_HEADERS_ALL; AP_EXPENSE_REPORT_LINES_ALL; AP_EXPENSE_REPORT_PARAMS_ALL; AP_POL_VIOLATIONS_ALL; AP_WEB_OA_ACTIVE_PKG - show dependent code

APPS.AP_EXPENSE_REPORT_VIOLATIONS_V is referenced by following:

APPS: AP_WEB_MANAGEMENT_REPORTS_PKG - show dependent code