PJF_EXP_TYPES_EXPEND_T

Details

Schema: FUSION
Object owner: PJF
Object type: VIEW

Columns

Name
EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_NAME SYSTEM_LINKAGE_M SYSTEM_LINKAGE_FUNCTION DESCRIPTION EXPENDITURE_CATEGORY_NAME EXPENDITURE_CATEGORY_ID UOM_CODE UNIT_OF_MEASURE PROCEEDS_FLAG COST_RATE_FLAG SYS_LINK_START_DATE_ACTIVE SYS_LINK_END_DATE_ACTIVE EXPND_TYP_START_DATE_ACTIVE EXPND_TYP_END_DATE_ACTIVE PROJECT_UNIT_ID

Name

EXPENDITURE_TYPE_ID

EXPENDITURE_TYPE_NAME

SYSTEM_LINKAGE_M

SYSTEM_LINKAGE_FUNCTION

DESCRIPTION

EXPENDITURE_CATEGORY_NAME

EXPENDITURE_CATEGORY_ID

UOM_CODE

UNIT_OF_MEASURE

PROCEEDS_FLAG

COST_RATE_FLAG

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 \|\| ' - ' \|\| SL.MEANING AS EXPENDITURE_TYPE_NAME, SL.MEANING AS SYSTEM_LINKAGE_M , ES.SYSTEM_LINKAGE_FUNCTION , 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 , 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' AND es.system_linkage_function IN ('OT','ST') ORDER BY et.expenditure_type_name, es.system_linkage_function

SQL_Statement

SELECT

ET.EXPENDITURE_TYPE_ID,

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

SL.MEANING AS SYSTEM_LINKAGE_M ,

ES.SYSTEM_LINKAGE_FUNCTION ,

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 ,

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'

AND es.system_linkage_function IN ('OT','ST')

ORDER BY et.expenditure_type_name,

es.system_linkage_function