View: MSD_SR_OU_LE_V

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

View Text

SELECT BOUV.ORGANIZATION_ID
, BOUV.NAME
, BLEV.ID
, BLEV.VALUE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM (SELECT DISTINCT ORGANIZATION_ID
, NAME
FROM HR_ALL_ORGANIZATION_UNITS) BOUV
, (SELECT DISTINCT ID
, VALUE
FROM MSD_LEGAL_ENTITIES_V) BLEV
, (SELECT DISTINCT OPERATING_UNIT
, LEGAL_ENTITY
FROM MSD_ORGANIZATION_DEFINITIONS MOD
, MSD_APP_INSTANCE_ORGS ORGS
WHERE MOD.ORGANIZATION_ID = ORGS.ORGANIZATION_ID) OOD
WHERE BOUV.ORGANIZATION_ID = OOD.OPERATING_UNIT
AND BLEV.ID = OOD.LEGAL_ENTITY 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