View: PA_MU_DETAILS_V

Product:	PA - Projects
Description:	View to display detail information for batch created for mass update of a project/task attribute. - Retrofitted
Implementation/DBA Data:	APPS.PA_MU_DETAILS_V

View Text

SELECT D.ROWID
, D.BATCH_ID
, D.LINE_ID
, D.PROJECT_ID
, D.TASK_ID
, D.REJECTION_REASON
, D.OLD_ATTRIBUTE_VALUE
, D.NEW_ATTRIBUTE_VALUE
, D.UPDATE_FLAG
, D.RECALCULATE_FLAG
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.CREATED_BY
, D.CREATION_DATE
, T.TASK_NAME
, P.NAME
, TO_CHAR(P.CARRYING_OUT_ORGANIZATION_ID)
, O.NAME
, O2.NAME
, O3.NAME
, PA_SECURITY.ALLOW_UPDATE(D.PROJECT_ID)
, DECODE(D.REJECTION_REASON
, NULL
, 'N'
, 'Y')
FROM PA_MASS_UPDATE_DETAILS D
, PA_PROJECTS P
, PA_TASKS T
, HR_ORGANIZATION_UNITS O
, HR_ORGANIZATION_UNITS O2
, HR_ORGANIZATION_UNITS O3
WHERE D.PROJECT_ID = P.PROJECT_ID
AND D.TASK_ID = T.TASK_ID (+)
AND TO_NUMBER(D.OLD_ATTRIBUTE_VALUE) = O.ORGANIZATION_ID
AND TO_NUMBER(D.NEW_ATTRIBUTE_VALUE) = O2.ORGANIZATION_ID
AND P.CARRYING_OUT_ORGANIZATION_ID = O3.ORGANIZATION_ID

Columns