1. Tables and Views for Project Management
  2. PJC_EXP_TYPES_CCW_V

PJC_EXP_TYPES_CCW_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

EXPENDITURE_TYPE_ID

SLF_EXPENDITURE_TYPE_KEY

EXPENDITURE_TYPE_NAME

SL_EXPENDITURE_TYPE_NAME

SYSTEM_LINKAGE_M

DESCRIPTION

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_ID || '-' || ES.SYSTEM_LINKAGE_FUNCTION AS SLF_EXPENDITURE_TYPE_KEY,

ET.EXPENDITURE_TYPE_NAME ,

ET.EXPENDITURE_TYPE_NAME || ' - ' || SL.MEANING AS SL_EXPENDITURE_TYPE_NAME,

SL.MEANING AS SYSTEM_LINKAGE_M ,

ET.DESCRIPTION,

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_EXP_TYPES_VL ET ,

PJF_SYSTEM_LINKAGES_VL SL ,

PJF_EXPEND_TYP_SYS_LINKS ES ,

PJF_EXP_TYPES_B_ST PTS ,

FND_SETID_ASSIGNMENTS FSA

WHERE ES.EXPENDITURE_TYPE_ID = ET.EXPENDITURE_TYPE_ID

AND ES.SYSTEM_LINKAGE_FUNCTION = SL.FUNCTION

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'