[Home] [Help]
View: 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
Name |
ID1 |
ID2 |
NAME |
DESCRIPTION |
OPERATING_UNIT_ID |
OPERATING_UNIT_NAME |
SET_OF_BOOKS_ID |
STATUS |
COUNTRY |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
POSTAL_CODE |
STATE |
COUNTY |
CITY |