View: PA_MU_BATCHES_V

Product:	PA - Projects
Description:	View used to display information about the batches created for mass update of a project/task attributes
Implementation/DBA Data:	APPS.PA_MU_BATCHES_V

View Text

SELECT B.ROWID
, B.BATCH_ID
, B.BATCH_NAME
, B.DESCRIPTION
, B.PROJECT_ATTRIBUTE
, B.BATCH_STATUS_CODE
, B.PROCESS_RUN_DATE
, B.PROCESS_RUN_BY
, B.EFFECTIVE_DATE
, B.REJECTION_CODE
, L2.MEANING
, B.ORG_ID
, POU.OPERATING_UNIT
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, P.FULL_NAME
, L.MEANING BATCH_STATUS_M
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
FROM PA_MASS_UPDATE_BATCHES_ALL B
, PER_PEOPLE_F P
, FND_USER F
, PA_LOOKUPS L
, PA_LOOKUPS L2
, PA_OPERATING_UNITS_V POU
WHERE B.PROCESS_RUN_BY = F.USER_ID (+)
AND F.EMPLOYEE_ID = P.PERSON_ID (+)
AND NVL(B.PROCESS_RUN_DATE
, SYSDATE) BETWEEN NVL(P.EFFECTIVE_START_DATE
, NVL(B.PROCESS_RUN_DATE
, SYSDATE))
AND NVL(P.EFFECTIVE_END_DATE
, NVL(B.PROCESS_RUN_DATE
, SYSDATE))
AND B.BATCH_STATUS_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'MASS_UPDATE_BATCH_STATUS'
AND B.REJECTION_CODE = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE(+) = 'MASS_UPDATE_REJECTION_CODE'
AND B.ORG_ID = POU.ORG_ID

Columns