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

VIEW: APPS.PA_ONLINE_EXPENDITURE_TYPES_V

Object Details
Object Name: PA_ONLINE_EXPENDITURE_TYPES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_ONLINE_EXPENDITURE_TYPES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Customizable view for expenditure types used in the Self-Service Time application.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DISPLAY_COLUMN VARCHAR2 (115)
Concatenation of expenditure type and system linkage function.
EXPENDITURE_TYPE VARCHAR2 (30) Yes Refer to base table.
DESCRIPTION VARCHAR2 (250)
Refer to base table.
UOM_CODE VARCHAR2 (30) Yes Refer to base table.
UNIT_OF_MEASURE VARCHAR2 (80)
Refer to base table.
COST_RATE_FLAG VARCHAR2 (1) Yes Refer to base table.
SYSTEM_LINKAGE_M VARCHAR2 (80)
Refer to base table.
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Yes Refer to base table.
SYS_LINK_START_DATE_ACTIVE DATE
Yes Refer to base table.
SYS_LINK_END_DATE_ACTIVE DATE

Refer to base table.
EXPND_TYP_START_DATE_ACTIVE DATE
Yes Refer to base table.
EXPND_TYP_END_DATE_ACTIVE DATE

Refer to base table.
PROJECT_ID NUMBER

Refer to base table.
Query Text

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


SELECT DISPLAY_COLUMN
,      EXPENDITURE_TYPE
,      DESCRIPTION
,      UOM_CODE
,      UNIT_OF_MEASURE
,      COST_RATE_FLAG
,      SYSTEM_LINKAGE_M
,      SYSTEM_LINKAGE_FUNCTION
,      SYS_LINK_START_DATE_ACTIVE
,      SYS_LINK_END_DATE_ACTIVE
,      EXPND_TYP_START_DATE_ACTIVE
,      EXPND_TYP_END_DATE_ACTIVE
,      PROJECT_ID
FROM APPS.PA_ONLINE_EXPENDITURE_TYPES_V;

Dependencies

[top of page]

APPS.PA_ONLINE_EXPENDITURE_TYPES_V references the following:

SchemaAPPS
ViewPA_EXPENDITURE_TYPES_EXPEND_V
APPS.PA_ONLINE_EXPENDITURE_TYPES_V is referenced by following:

SchemaAPPS
Package BodyPA_OTC_API - show dependent code