View: MSD_SR_REP_GRP1_V

Product:	MSD - Demand Planning
Description:	This is the Source View that associates the Sales Representative Level to First level Sales Group in the Sales Representative Dimension. This view would be applied to an Oracle Applications 11i instance from which the Sales Representative t
Implementation/DBA Data:	APPS.MSD_SR_REP_GRP1_V

View Text

SELECT DISTINCT RA.SALESREP_ID
, NVL(RA.NAME
, MSD_SR_UTIL.GET_NULL_DESC)
, MSD_SR_UTIL.GET_NULL_PK
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM RA_SALESREPS_ALL RA
WHERE 1 = 1 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