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.APFV_EXPENSE_REPORTS

Object Details

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

View Type

A Business Intelligence System view

BIS view for AP Expense Reports detail and header level information.

[View Source]

Columns

Name	Datatype	Length	Mandatory
REPORT_DESCRIPTION	VARCHAR2	(240)
SOURCE	VARCHAR2	(25)
REPORT_INVOICE_NUMBER	VARCHAR2	(50)	Yes
VOUCHER_NUMBER	VARCHAR2	(50)
REPORT_WEEK_END_DATE	DATE
REPORT_TOTAL	NUMBER
REPORT_HOLD	VARCHAR2	(25)
_LA:REPORT_HOLD_DESCRIPTION	CHAR	(68)
MANAGER_EMPLOYEE_ID	NUMBER	(10)
MANAGER_EMPLOYEE_NUMBER	VARCHAR2	(30)
MANAGER_FIRST_NAME	VARCHAR2	(150)
MANAGER_LAST_NAME	VARCHAR2	(150)
MANAGER_FULL_NAME	VARCHAR2	(240)
EMPLOYEE_ID	NUMBER
EMPLOYEE_NUMBER	VARCHAR2	(30)
EMPLOYEE_FIRST_NAME	VARCHAR2	(150)
EMPLOYEE_LAST_NAME	VARCHAR2	(150)
EMPLOYEE_FULL_NAME	VARCHAR2	(240)
_DF:INV	CHAR	(25)
_DF:INV_GLBL	CHAR	(25)
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes
LINE_ITEM_DESCRIPTION	VARCHAR2	(240)
LINE_AMOUNT	NUMBER
LINE_CURRENCY_CODE	VARCHAR2	(15)
LINE_TYPE	VARCHAR2	(25)	Yes
_LA:LINE_TYPE_DESCRIPTION	CHAR	(88)
_DF:LINE	CHAR	(43)
_DF:LINE_GLBL	CHAR	(43)
_KF:ACCOUNT_NAME	CHAR	(21)
EXCHANGE_DATE	DATE
EXCHANGE_RATE	NUMBER
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
RECEIPT_MISSING_FLAG	VARCHAR2	(1)
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)
JUSTIFICATION	VARCHAR2	(240)
LINE_VAT	VARCHAR2	(15)
ORGANIZATION_ID	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
INVOICE_ID	NUMBER	(15)	Yes

Query Text

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


SELECT REPORT_DESCRIPTION
,      SOURCE
,      REPORT_INVOICE_NUMBER
,      VOUCHER_NUMBER
,      REPORT_WEEK_END_DATE
,      REPORT_TOTAL
,      REPORT_HOLD
,      _LA:REPORT_HOLD_DESCRIPTION
,      MANAGER_EMPLOYEE_ID
,      MANAGER_EMPLOYEE_NUMBER
,      MANAGER_FIRST_NAME
,      MANAGER_LAST_NAME
,      MANAGER_FULL_NAME
,      EMPLOYEE_ID
,      EMPLOYEE_NUMBER
,      EMPLOYEE_FIRST_NAME
,      EMPLOYEE_LAST_NAME
,      EMPLOYEE_FULL_NAME
,      _DF:INV
,      _DF:INV_GLBL
,      DISTRIBUTION_LINE_NUMBER
,      LINE_ITEM_DESCRIPTION
,      LINE_AMOUNT
,      LINE_CURRENCY_CODE
,      LINE_TYPE
,      _LA:LINE_TYPE_DESCRIPTION
,      _DF:LINE
,      _DF:LINE_GLBL
,      _KF:ACCOUNT_NAME
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      RECEIPT_MISSING_FLAG
,      RECEIPT_REQUIRED_FLAG
,      JUSTIFICATION
,      LINE_VAT
,      ORGANIZATION_ID
,      SET_OF_BOOKS_ID
,      INVOICE_ID
FROM APPS.APFV_EXPENSE_REPORTS;

Dependencies

[top of page]

APPS.APFV_EXPENSE_REPORTS references the following:

APPS: AP_HOLDS_ALL; AP_INVOICES; AP_INVOICE_DISTRIBUTIONS_ALL; GL_CODE_COMBINATIONS; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PO_VENDORS

APPS.APFV_EXPENSE_REPORTS is not referenced by any database object