VIEW: APPS.MSD_SR_OU_LE_V

Source

View Text - Preformatted

SELECT bouv.organization_id, bouv.name, bouv.name, blev.id, blev.value, blev.value, null, null, null, null, null from (select distinct organization_id, name from hr_all_organization_units) bouv, (select distinct id, value from msd_legal_entities_v) blev, (select distinct operating_unit, legal_entity 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 blev.id = ood.legal_entity 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
, BLEV.ID
, BLEV.VALUE
, BLEV.VALUE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM (SELECT DISTINCT ORGANIZATION_ID
, NAME
FROM HR_ALL_ORGANIZATION_UNITS) BOUV
, (SELECT DISTINCT ID
, VALUE
FROM MSD_LEGAL_ENTITIES_V) BLEV
, (SELECT DISTINCT OPERATING_UNIT
, LEGAL_ENTITY
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 BLEV.ID = OOD.LEGAL_ENTITY 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