VIEW: APPS.MSD_SR_LE_BG_V

Source

View Text - Preformatted

SELECT blev.id, blev.value, blev.value, bbgv.organization_id, bbgv.name, bbgv.name, null, null, null, null, null from (select distinct id, value from msd_legal_entities_v) blev, (select distinct organization_id, name from hr_all_organization_units where organization_id = business_group_id) bbgv, (select distinct legal_entity, business_group_id from msd_organization_definitions mod, msd_app_instance_orgs orgs where orgs.organization_id = mod.organization_id) ood WHERE blev.id = to_char(ood.legal_entity) 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 BLEV.ID
, BLEV.VALUE
, BLEV.VALUE
, BBGV.ORGANIZATION_ID
, BBGV.NAME
, BBGV.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
FROM (SELECT DISTINCT ID
, VALUE
FROM MSD_LEGAL_ENTITIES_V) BLEV
, (SELECT DISTINCT ORGANIZATION_ID
, NAME
FROM HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = BUSINESS_GROUP_ID) BBGV
, (SELECT DISTINCT LEGAL_ENTITY
, BUSINESS_GROUP_ID
FROM MSD_ORGANIZATION_DEFINITIONS MOD
, MSD_APP_INSTANCE_ORGS ORGS
WHERE ORGS.ORGANIZATION_ID = MOD.ORGANIZATION_ID) OOD
WHERE BLEV.ID = TO_CHAR(OOD.LEGAL_ENTITY)
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