View: ENGFV_ENG_CHANGE_APPROVERS

Product:	ENG - Engineering
Description:	- Retrofitted
Implementation/DBA Data:	APPS.ENGFV_ENG_CHANGE_APPROVERS

View Text

SELECT LI.APPROVAL_LIST_NAME
, EM.FULL_NAME EMPLOYEE_NAME
, AP.SEQUENCE1 SEQUENCE_NUMBER
, AP.DESCRIPTION
, AP.DISABLE_DATE INACTIVE_DATE
, '_DF:ENG:ENG_ECN_APPROVERS:AP'
, AP.APPROVAL_LIST_ID
, AP.EMPLOYEE_ID
, AP.LAST_UPDATE_DATE UPDATED_ON
, AP.LAST_UPDATED_BY UPDATED_BY
, AP.CREATION_DATE CREATED_ON
, AP.CREATED_BY
FROM HR_EMPLOYEES EM
, ENG_ECN_APPROVAL_LISTS LI
, ENG_ECN_APPROVERS AP
WHERE AP.APPROVAL_LIST_ID = LI.APPROVAL_LIST_ID
AND AP.EMPLOYEE_ID = EM.EMPLOYEE_ID WITH READ ONLY

Columns