VIEW: APPS.ENGBV_ENG_CHANGE_APPROVERS

Source

View Text - Preformatted

SELECT LI.APPROVAL_LIST_NAME , EM.FULL_NAME EMPLOYEE_NAME , AP.SEQUENCE1 SEQUENCE_NUMBER , AP.DESCRIPTION , AP.DISABLE_DATE INACTIVE_DATE , AP.APPROVAL_LIST_ID , AP.EMPLOYEE_ID , AP.LAST_UPDATE_DATE UPDATED_ON , AP.LAST_UPDATED_BY UPADTED_BY , AP.CREATION_DATE CREATED_ON , AP.CREATED_BY 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

View Text - HTML Formatted

SELECT LI.APPROVAL_LIST_NAME
, EM.FULL_NAME EMPLOYEE_NAME
, AP.SEQUENCE1 SEQUENCE_NUMBER
, AP.DESCRIPTION
, AP.DISABLE_DATE INACTIVE_DATE
, AP.APPROVAL_LIST_ID
, AP.EMPLOYEE_ID
, AP.LAST_UPDATE_DATE UPDATED_ON
, AP.LAST_UPDATED_BY UPADTED_BY
, AP.CREATION_DATE CREATED_ON
, AP.CREATED_BY 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