[Home] [Help]
View: ENGBV_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
, 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
Columns
Name |
APPROVAL_LIST_NAME |
EMPLOYEE_NAME |
SEQUENCE_NUMBER |
DESCRIPTION |
INACTIVE_DATE |
APPROVAL_LIST_ID |
EMPLOYEE_ID |
UPDATED_ON |
UPDATED_BY |
CREATED_BY |
CREATED_ON |