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_TYPES_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

Value Set for Expense Types in Details page in Oracle Internet Expenses is based on this view.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARAMETER_ID	NUMBER		Yes	Parameter Id of the Expense Type.
WEB_PROMPT	VARCHAR2	(80)		Web Friendly Prompt or the Display Value of the expense type.
PROMPT	VARCHAR2	(40)	Yes	Prompt or the internal code for Descriptive Flexfields of the expense type.
EXPENSE_REPORT_ID	NUMBER		Yes	Expense Report Id or the Template Id of the Expense Template for the expense type.
WEB_ENABLED_FLAG	VARCHAR2	(1)		Web Enabled Flag of the expense type.
PA_EXPENDITURE_TYPE	VARCHAR2	(30)		PA Expenditure Type of the expense type
CATEGORY_CODE	VARCHAR2	(30)		Category code
END_DATE	DATE			End date

Query Text

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


SELECT PARAMETER_ID
,      WEB_PROMPT
,      PROMPT
,      EXPENSE_REPORT_ID
,      WEB_ENABLED_FLAG
,      PA_EXPENDITURE_TYPE
,      CATEGORY_CODE
,      END_DATE
FROM APPS.AP_EXPENSE_TYPES_V;

Dependencies

[top of page]

APPS.AP_EXPENSE_TYPES_V references the following:

APPS: AP_EXPENSE_REPORT_PARAMS

APPS.AP_EXPENSE_TYPES_V is not referenced by any database object