PJF_WORK_TYPE_EXPEND_V

Details

• Schema: FUSION

• Object owner: pjf

• Object type: VIEW

Columns

Name
WORK_TYPE_ID NAME DESCRIPTION START_DATE_ACTIVE END_DATE_ACTIVE PROJECT_UNIT_ID PROJECT_ID

Query

SQL_Statement

SELECT ET.WORK_TYPE_ID , ET.NAME , ET.DESCRIPTION , ET.START_DATE_ACTIVE AS START_DATE_ACTIVE , ET.END_DATE_ACTIVE AS END_DATE_ACTIVE , FSA.DETERMINANT_VALUE PROJECT_UNIT_ID , PPA.PROJECT_ID PROJECT_ID FROM PJF_WORK_TYPES_VL ET ,PJF_WORK_TYPES_B_ST PTS ,FND_SETID_ASSIGNMENTS FSA , PJF_PROJECTS_ALL_B PPA WHERE PTS.WORK_TYPE_ID = ET.WORK_TYPE_ID AND PTS.SET_ID = FSA.SET_ID AND FSA.DETERMINANT_TYPE = 'PU' AND FSA.REFERENCE_GROUP_NAME = 'PJF_TRANSACTION_TYPES' AND FSA.DETERMINANT_VALUE = PPA.PROJECT_UNIT_ID AND PPA.PROJECT_CATEGORY = 'FIN_EXEC'