VIEW: APPS.MSD_SR_ORG_OU_V

Source

View Text - Preformatted

SELECT distinct ood.organization_id, ood.organization_name, ood.organization_code || ':' || ood.organization_name, nvl(bouv.organization_id, msd_sr_util.get_null_pk), nvl(bouv.name, msd_sr_util.get_null_desc), nvl(bouv.name, msd_sr_util.get_null_desc), null, null, null, null, null from hr_all_organization_units bouv, msd_organization_definitions ood, msd_app_instance_orgs orgs WHERE orgs.organization_id = ood.organization_id and bouv.organization_id (+) = to_char(ood.operating_unit) /*union select msd_sr_util.get_null_pk , msd_sr_util.get_null_desc, msd_sr_util.get_null_desc, msd_sr_util.get_null_pk , msd_sr_util.get_null_desc, msd_sr_util.get_null_desc, null, null, null, null, null from dual */

View Text - HTML Formatted

SELECT DISTINCT OOD.ORGANIZATION_ID
, OOD.ORGANIZATION_NAME
, OOD.ORGANIZATION_CODE || ':' || OOD.ORGANIZATION_NAME
, NVL(BOUV.ORGANIZATION_ID
, MSD_SR_UTIL.GET_NULL_PK)
, NVL(BOUV.NAME
, MSD_SR_UTIL.GET_NULL_DESC)
, NVL(BOUV.NAME
, MSD_SR_UTIL.GET_NULL_DESC)
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_ALL_ORGANIZATION_UNITS BOUV
, MSD_ORGANIZATION_DEFINITIONS OOD
, MSD_APP_INSTANCE_ORGS ORGS
WHERE ORGS.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND BOUV.ORGANIZATION_ID (+) = TO_CHAR(OOD.OPERATING_UNIT) /*UNION SELECT MSD_SR_UTIL.GET_NULL_PK
, MSD_SR_UTIL.GET_NULL_DESC
, MSD_SR_UTIL.GET_NULL_DESC
, MSD_SR_UTIL.GET_NULL_PK
, MSD_SR_UTIL.GET_NULL_DESC
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL */