VIEW: APPS.MSD_SR_BG_ALL_V

Source

View Text - Preformatted

SELECT bbgv.organization_id id, bbgv.name value, bbgv.name, MSD_SR_UTIL.get_all_org_pk, MSD_SR_UTIL.get_all_org_desc, MSD_SR_UTIL.get_all_org_desc, null, null, null, null, null from (select distinct organization_id, name from hr_all_organization_units) bbgv, (select distinct business_group_id from msd_organization_definitions mod, msd_app_instance_orgs orgs where mod.organization_id = orgs.organization_id) ood WHERE bbgv.organization_id = to_char(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_all_org_pk, MSD_SR_UTIL.get_all_org_desc, MSD_SR_UTIL.get_all_org_desc, null, null, null, null, null from dual

View Text - HTML Formatted

SELECT BBGV.ORGANIZATION_ID ID
, BBGV.NAME VALUE
, BBGV.NAME
, MSD_SR_UTIL.GET_ALL_ORG_PK
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM (SELECT DISTINCT ORGANIZATION_ID
, NAME
FROM HR_ALL_ORGANIZATION_UNITS) BBGV
, (SELECT DISTINCT BUSINESS_GROUP_ID
FROM MSD_ORGANIZATION_DEFINITIONS MOD
, MSD_APP_INSTANCE_ORGS ORGS
WHERE MOD.ORGANIZATION_ID = ORGS.ORGANIZATION_ID) OOD
WHERE BBGV.ORGANIZATION_ID = TO_CHAR(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_ALL_ORG_PK
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL