VIEW: APPS.MSD_SR_OU_BG_V

Source

View Text - Preformatted

SELECT bouv.organization_id, bouv.name, bouv.name, bbgv.organization_id, bbgv.name, bbgv.name, null, null, null, null, null FROM (select distinct organization_id,name from hr_all_organization_units) bouv, (select distinct organization_id, name from hr_all_organization_units WHERE organization_id = business_group_id) bbgv, (select distinct operating_unit, business_group_id from msd_organization_definitions mod, msd_app_instance_orgs orgs WHERE mod.organization_id = orgs.organization_id) ood WHERE bouv.organization_id = ood.operating_unit and bbgv.organization_id = ood.business_group_id 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 BOUV.ORGANIZATION_ID
, BOUV.NAME
, BOUV.NAME
, BBGV.ORGANIZATION_ID
, BBGV.NAME
, BBGV.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
FROM (SELECT DISTINCT ORGANIZATION_ID
, NAME
FROM HR_ALL_ORGANIZATION_UNITS) BOUV
, (SELECT DISTINCT ORGANIZATION_ID
, NAME
FROM HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = BUSINESS_GROUP_ID) BBGV
, (SELECT DISTINCT OPERATING_UNIT
, BUSINESS_GROUP_ID
FROM MSD_ORGANIZATION_DEFINITIONS MOD
, MSD_APP_INSTANCE_ORGS ORGS
WHERE MOD.ORGANIZATION_ID = ORGS.ORGANIZATION_ID) OOD
WHERE BOUV.ORGANIZATION_ID = OOD.OPERATING_UNIT
AND BBGV.ORGANIZATION_ID = OOD.BUSINESS_GROUP_ID 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