PJF_MASS_UPD_DETAILS_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
BATCH_ID LINE_ID OBJECT_VERSION_NUMBER PROJECT_ID TASK_ID EFFECTIVE_DATE OLD_ATTRIBUTE_VALUE NEW_ATTRIBUTE_VALUE UPDATE_FLAG RECALCULATE_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REJECTION_REASON REJECTION_CODE

Query

SQL_Statement

SELECT B.BATCH_ID BATCH_ID, B.LINE_ID LINE_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.PROJECT_ID PROJECT_ID, B.TASK_ID TASK_ID, B.EFFECTIVE_DATE EFFECTIVE_DATE, B.OLD_ATTRIBUTE_VALUE OLD_ATTRIBUTE_VALUE, B.NEW_ATTRIBUTE_VALUE NEW_ATTRIBUTE_VALUE, B.UPDATE_FLAG UPDATE_FLAG, B.RECALCULATE_FLAG RECALCULATE_FLAG, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TL.REJECTION_REASON REJECTION_REASON, B.REJECTION_CODE REJECTION_CODE FROM PJF_MASS_UPD_DETAILS_B B, PJF_MASS_UPD_DETAILS_TL TL WHERE B.LINE_ID = TL.LINE_ID AND TL.LANGUAGE = USERENV('LANG')