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: ViewSQLAP.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:

SchemaAPPS
SynonymAP_EXPENSE_REPORT_PARAMS

APPS.AP_EXPENSE_TYPES_V is not referenced by any database object