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

VIEW: APPS.AP_EXPENSE_REPORT_LINES_V

Object Details
Object Name: AP_EXPENSE_REPORT_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_EXPENSE_REPORT_LINES_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
DISTRIBUTION_LINE_NUMBER NUMBER (15)
Line number for invoice distribution line created from expense report line
AMOUNT NUMBER

Amount
CURRENCY_CODE VARCHAR2 (15) Yes Currency code
RECEIPT_CURRENCY_AMOUNT NUMBER

The amount that appears on the receipt.
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
Indicates the code for the currency in which the expense line was incurred.
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
ORG_ID NUMBER (15)
Organization identifier
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
,      DISTRIBUTION_LINE_NUMBER
,      AMOUNT
,      CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_CURRENCY_CODE
,      DAILY_AMOUNT
,      WEB_PARAMETER_ID
,      CATEGORY_CODE
,      SUBMITTED_AMOUNT
,      ORG_ID
,      ITEMIZATION_PARENT_ID
,      REPORT_LINE_ID
FROM APPS.AP_EXPENSE_REPORT_LINES_V;

Dependencies

[top of page]

APPS.AP_EXPENSE_REPORT_LINES_V references the following:

SchemaAPPS
SynonymAP_EXPENSE_REPORTS_ALL
SynonymAP_EXPENSE_REPORT_HEADERS_ALL
SynonymAP_EXPENSE_REPORT_LINES_ALL
SynonymAP_EXPENSE_REPORT_PARAMS_ALL
PL/SQL PackageAP_WEB_OA_ACTIVE_PKG - show dependent code
APPS.AP_EXPENSE_REPORT_LINES_V is referenced by following:

SchemaAPPS
Package BodyAP_WEB_MANAGEMENT_REPORTS_PKG - show dependent code