VIEW: APPS.BOM_EAM_DEPT_APPROVERS_VL

Source

View Text - Preformatted

SELECT beda.dept_id, beda.last_update_date, beda.last_updated_by, beda.creation_date, beda.created_by, beda.last_update_login, beda.responsibility_id, beda.responsibility_application_id, bd.department_code, bd.description, beda.rowid, beda.organization_id, beda.primary_approver_id, fu.user_name as primary_approver_name FROM bom_eam_dept_approvers beda, bom_departments bd, fnd_user fu WHERE beda.dept_id=bd.department_id and beda.primary_approver_id = fu.user_id(+)

View Text - HTML Formatted

SELECT BEDA.DEPT_ID
, BEDA.LAST_UPDATE_DATE
, BEDA.LAST_UPDATED_BY
, BEDA.CREATION_DATE
, BEDA.CREATED_BY
, BEDA.LAST_UPDATE_LOGIN
, BEDA.RESPONSIBILITY_ID
, BEDA.RESPONSIBILITY_APPLICATION_ID
, BD.DEPARTMENT_CODE
, BD.DESCRIPTION
, BEDA.ROWID
, BEDA.ORGANIZATION_ID
, BEDA.PRIMARY_APPROVER_ID
, FU.USER_NAME AS PRIMARY_APPROVER_NAME
FROM BOM_EAM_DEPT_APPROVERS BEDA
, BOM_DEPARTMENTS BD
, FND_USER FU
WHERE BEDA.DEPT_ID=BD.DEPARTMENT_ID
AND BEDA.PRIMARY_APPROVER_ID = FU.USER_ID(+)