VIEW: APPS.PA_MU_BATCHES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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