[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: |
APPS.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 |