PJF_EXP_TYPES_EXPEND_V

Details

• Schema: FUSION

• Object owner: pjf

• Object type: VIEW

Columns

Name
EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_NAME DESCRIPTION EXPENDITURE_CATEGORY_NAME EXPENDITURE_CATEGORY_ID UOM_CODE UNIT_OF_MEASURE PROCEEDS_FLAG 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_UNIT_ID

Query

SQL_Statement

SELECT ET.EXPENDITURE_TYPE_ID , ET.EXPENDITURE_TYPE_NAME , ET.DESCRIPTION , EC.EXPENDITURE_CATEGORY_NAME , EC.EXPENDITURE_CATEGORY_ID , ET.UNIT_OF_MEASURE AS UOM_CODE , UNIT.UNIT_OF_MEASURE AS UNIT_OF_MEASURE , ET.PROCEEDS_FLAG , ET.COST_RATE_FLAG , SL.MEANING AS SYSTEM_LINKAGE_M , ES.SYSTEM_LINKAGE_FUNCTION , ES.START_DATE_ACTIVE AS SYS_LINK_START_DATE_ACTIVE , ES.END_DATE_ACTIVE AS SYS_LINK_END_DATE_ACTIVE , ET.START_DATE_ACTIVE AS EXPND_TYP_START_DATE_ACTIVE , ET.END_DATE_ACTIVE AS EXPND_TYP_END_DATE_ACTIVE , FSA.DETERMINANT_VALUE PROJECT_UNIT_ID FROM PJF_UNITS_OF_MEASURE_V UNIT ,PJF_SYSTEM_LINKAGES_VL SL ,PJF_EXP_TYPES_VL ET ,PJF_EXPEND_TYP_SYS_LINKS ES ,PJF_EXP_TYPES_B_ST PTS ,FND_SETID_ASSIGNMENTS FSA ,PJF_EXP_CATEGORIES_VL EC WHERE UNIT.UOM_CODE = ET.UNIT_OF_MEASURE AND ES.EXPENDITURE_TYPE_ID = ET.EXPENDITURE_TYPE_ID AND ES.SYSTEM_LINKAGE_FUNCTION = SL.FUNCTION AND ET.EXPENDITURE_CATEGORY_ID = EC.EXPENDITURE_CATEGORY_ID AND PTS.EXPENDITURE_TYPE_ID = ET.EXPENDITURE_TYPE_ID AND PTS.SET_ID = FSA.SET_ID AND FSA.DETERMINANT_TYPE = 'PU' AND FSA.REFERENCE_GROUP_NAME = 'PJF_TRANSACTION_TYPES'