View: MSD_SR_LE_BG_V

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

View Text

SELECT BLEV.ID
, BLEV.VALUE
, BBGV.ORGANIZATION_ID
, 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_PK
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL

Columns