VIEW: APPS.MSC_ORG_GROUPS_V

Source

View Text - Preformatted

SELECT distinct mio.org_group ORG_GROUP, msc_cl_function.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 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
, MSC_CL_FUNCTION.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 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'