View: MSD_SR_BG_ALL_V

Product:	MSD - Demand Planning
Description:	This is the Source View that associates the Business Group level to Top level in the Organization Dimension. This view would be applied to an Oracle Applications 11i instance from which the Business Group to Top level association informati
Implementation/DBA Data:	APPS.MSD_SR_BG_ALL_V

View Text

SELECT BBGV.ORGANIZATION_ID ID
, BBGV.NAME VALUE
, MSD_SR_UTIL.GET_ALL_ORG_PK
, 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_ALL_ORG_PK
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL

Columns