VIEW: APPS.OKX_LEGAL_ENTITIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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