VIEW: APPS.PA_MU_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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