VIEW: APPS.OKX_EMPLOYEES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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