View: OKX_LEGAL_ENTITIES_V

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

View Text

SELECT HRTL.ORGANIZATION_ID ID1
, '#' ID2
, HRTL.NAME NAME
, HRTL.NAME DESCRIPTION
, OP.ORGANIZATION_ID OPERATING_UNIT_ID
, OP.NAME OPERATING_UNIT_NAME
, OP.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(HR.DATE_FROM
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(HR.DATE_TO
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL COUNTRY
, NULL ADDRESS1
, NULL ADDRESS2
, NULL ADDRESS3
, NULL ADDRESS4
, NULL POSTAL_CODE
, NULL STATE
, NULL COUNTY
, NULL CITY
FROM HR_OPERATING_UNITS OP
, HR_ALL_ORGANIZATION_UNITS_TL HRTL
, HR_ALL_ORGANIZATION_UNITS HR
WHERE OP.DEFAULT_LEGAL_CONTEXT_ID = TO_CHAR(HRTL.ORGANIZATION_ID)
AND USERENV('LANG') = HRTL.LANGUAGE
AND HRTL.ORGANIZATION_ID = HR.ORGANIZATION_ID

Columns