FND Design Data [Home] [Help]

View: PA_ONLINE_EXPENDITURE_TYPES_V

Product: PA - Projects
Description: Customizable view for expenditure types used in Self Service Time application.
Implementation/DBA Data: ViewAPPS.PA_ONLINE_EXPENDITURE_TYPES_V
View Text

SELECT ET.EXPENDITURE_TYPE || ' - (' || SYSTEM_LINKAGE_M || ')'
, ET.EXPENDITURE_TYPE
, ET.DESCRIPTION
, ET.UOM_CODE
, ET.UNIT_OF_MEASURE
, ET.COST_RATE_FLAG
, ET.SYSTEM_LINKAGE_M
, ET.SYSTEM_LINKAGE_FUNCTION
, ET.SYS_LINK_START_DATE_ACTIVE
, ET.SYS_LINK_END_DATE_ACTIVE
, ET.EXPND_TYP_START_DATE_ACTIVE
, ET.EXPND_TYP_END_DATE_ACTIVE
, ET.PROJECT_ID
FROM PA_EXPENDITURE_TYPES_EXPEND_V ET

Columns

Name
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