VIEW: APPS.MSD_DEM_ORG_GROUPS_V

Source

View Text - Preformatted

SELECT DISTINCT mio.org_group ORG_GROUP , msd_dem_common_utilities.get_all_orgs(mio.org_group,mio.sr_instance_id) ORG_STRING, mio.sr_instance_id INSTANCE_ID , mio.org_group CODE FROM msc_instance_orgs mio, msc_apps_instances mai WHERE mio.org_group IS NOT NULL AND mio.sr_instance_id = mai.instance_id AND mai.apps_ver >=3 AND NVL(mio.dp_enabled_flag, mio.enabled_flag) = 1 UNION ALL SELECT meaning ORG_GROUP , description ORG_STRING , to_number(NULL) INSTANCE_ID, TO_CHAR(lookup_code) CODE FROM mfg_lookups WHERE lookup_type='MSC_ALL_ORGANIZATIONS'

View Text - HTML Formatted

SELECT DISTINCT MIO.ORG_GROUP ORG_GROUP
, MSD_DEM_COMMON_UTILITIES.GET_ALL_ORGS(MIO.ORG_GROUP
, MIO.SR_INSTANCE_ID) ORG_STRING
, MIO.SR_INSTANCE_ID INSTANCE_ID
, MIO.ORG_GROUP CODE
FROM MSC_INSTANCE_ORGS MIO
, MSC_APPS_INSTANCES MAI
WHERE MIO.ORG_GROUP IS NOT NULL
AND MIO.SR_INSTANCE_ID = MAI.INSTANCE_ID
AND MAI.APPS_VER >=3
AND NVL(MIO.DP_ENABLED_FLAG
, MIO.ENABLED_FLAG) = 1 UNION ALL SELECT MEANING ORG_GROUP
, DESCRIPTION ORG_STRING
, TO_NUMBER(NULL) INSTANCE_ID
, TO_CHAR(LOOKUP_CODE) CODE
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE='MSC_ALL_ORGANIZATIONS'