View: BOM_EAM_DEPT_APPROVERS_VL

Product:	BOM - Bills of Material
Description:	This view shows the association between the departments and resposibility which receive notifications when a work request is created.
Implementation/DBA Data:	APPS.BOM_EAM_DEPT_APPROVERS_VL

View Text

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(+)

Columns