VIEW: APPS.PA_ONLINE_EXPENDITURE_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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