VIEW: APPS.HRI_OBI_CL_ORG_ORGANZTN_V

Source

View Text - Preformatted

SELECT ORG.ORGANIZATION_ID ORG_ORGANZTN_PK ,ORGTL.NAME ORG_ORGANZTN_NAME ,ORGTL.NAME||' ('||ORG.BUSINESS_GROUP_ID||')' ORG_ORGANZTN_NAME_UNQ ,ORGTL.NAME ORG_ORDER_BY ,ORG.DATE_FROM ORG_DATE_VALID_FROM ,NVL(ORG.DATE_TO,HR_GENERAL.END_OF_TIME) ORG_DATE_VALID_TO FROM HR_ALL_ORGANIZATION_UNITS ORG, HR_ALL_ORGANIZATION_UNITS_TL ORGTL WHERE ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID AND ORGTL.LANGUAGE = USERENV('LANG') UNION ALL SELECT id ORG_ORGANZTN_PK, hri_oltp_view_message.get_unassigned_msg ORG_ORGANZTN_NAME, hri_oltp_view_message.get_unassigned_msg || ' (' || to_char(id) || ')' ORG_ORGANZTN_NAME_UNQ, VALUE ORG_ORDER_BY, hr_general.start_of_time ORG_DATE_VALID_FROM, hr_general.end_of_time ORG_DATE_VALID_TO FROM hri_unassigned WITH READ ONLY

View Text - HTML Formatted

SELECT ORG.ORGANIZATION_ID ORG_ORGANZTN_PK
, ORGTL.NAME ORG_ORGANZTN_NAME
, ORGTL.NAME||' ('||ORG.BUSINESS_GROUP_ID||')' ORG_ORGANZTN_NAME_UNQ
, ORGTL.NAME ORG_ORDER_BY
, ORG.DATE_FROM ORG_DATE_VALID_FROM
, NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) ORG_DATE_VALID_TO
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
WHERE ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID
AND ORGTL.LANGUAGE = USERENV('LANG') UNION ALL SELECT ID ORG_ORGANZTN_PK
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG ORG_ORGANZTN_NAME
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG || ' (' || TO_CHAR(ID) || ')' ORG_ORGANZTN_NAME_UNQ
, VALUE ORG_ORDER_BY
, HR_GENERAL.START_OF_TIME ORG_DATE_VALID_FROM
, HR_GENERAL.END_OF_TIME ORG_DATE_VALID_TO
FROM HRI_UNASSIGNED WITH READ ONLY