View: MSD_SR_ORG_OU_V

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

View Text

SELECT DISTINCT OOD.ORGANIZATION_ID
, OOD.ORGANIZATION_NAME
, BOUV.ORGANIZATION_ID
, BOUV.NAME
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_ALL_ORGANIZATION_UNITS BOUV
, MSD_ORGANIZATION_DEFINITIONS OOD
, MSD_APP_INSTANCE_ORGS ORGS
WHERE ORGS.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND BOUV.ORGANIZATION_ID = TO_CHAR(OOD.OPERATING_UNIT) 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