View: OKX_EMPLOYEES_V

Product:	OKX - Contracts Integration
Description:
Implementation/DBA Data:	APPS.OKX_EMPLOYEES_V

View Text

SELECT EMP.PERSON_ID ID1
, TO_CHAR(EMP.EFFECTIVE_START_DATE) || '#' || TO_CHAR(EFFECTIVE_END_DATE) ID2
, EMP.FULL_NAME NAME
, NULL DESCRIPTION
, EMP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, EMP.EFFECTIVE_START_DATE START_DATE_ACTIVE
, EMP.EFFECTIVE_END_DATE END_DATE_ACTIVE
, DECODE(SIGN(NVL(EMP.EFFECTIVE_START_DATE
, SYSDATE) -SYSDATE)
, 0
, 'I'
, DECODE(SIGN(NVL(EMP.EFFECTIVE_END_DATE
, SYSDATE) -SYSDATE)
, -1
, 'I'
, DECODE(SIGN(NVL(EMP.EFFECTIVE_START_DATE
, SYSDATE)- SYSDATE)
, 1
, 'I'
, 'A'))) STATUS
, EMP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EMP.PERSON_TYPE_ID PERSON_TYPE_ID
, EMP.LAST_NAME LAST_NAME
, EMP.FIRST_NAME FIRST_NAME
, EMP.START_DATE START_DATE
, EMP.EMAIL_ADDRESS EMAIL_ADDRESS
, EMP.INTERNAL_LOCATION INTERNAL_LOCATION
, NULL SMALL_BUSINESS_FLAG
, NULL WOMEN_OWNED_FLAG
, NULL MINORITY_GROUP_LOOKUP
FROM PER_ALL_PEOPLE_F EMP

Columns