View: CHV_PLANNERS_VAL_V

Product:	CHV - Supplier Scheduling
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CHV_PLANNERS_VAL_V

View Text

SELECT HRE.FULL_NAME
, HRE.EMPLOYEE_NUM
, HRE.LOCATION_ID
, MTP.PLANNER_CODE
, MTP.EMPLOYEE_ID PLANNER_ID
FROM MTL_PLANNERS MTP
, HR_EMPLOYEES_CURRENT_V HRE
WHERE MTP.EMPLOYEE_ID = HRE.EMPLOYEE_ID
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE + 1)

Columns