[Home] [Help]
View: ICX_PO_APPROVER_VAL_V
View Text
SELECT HRE.FULL_NAME
, HRE.EMAIL_ADDRESS
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, HRE.DEFAULT_CODE_COMBINATION_ID
, HRE.LOCATION_ID
, HRL.LOCATION_CODE
, HRE.ORGANIZATION_ID
, HRE.BUSINESS_GROUP_ID
, HRE.EXPENSE_CHECK_ADDRESS_FLAG
FROM HR_EMPLOYEES_CURRENT_V HRE
, HR_LOCATIONS HRL
WHERE HRE.LOCATION_ID = HRL.LOCATION_ID(+)
Columns
Name |
FULL_NAME |
EMAIL_ADDRESS |
EMPLOYEE_NUM |
EMPLOYEE_ID |
DEFAULT_CODE_COMBINATION_ID |
LOCATION_ID |
LOCATION_CODE |
ORGANIZATION_ID |
BUSINESS_GROUP_ID |
EXPENSE_CHECK_ADDRESS_FLAG |