View: MSD_SR_SC_ALL_V

Product:	MSD - Demand Planning
Description:	This is the Source View that associates the Sales Channel level to the Top level in the Sales Channel Dimension. This view would be applied to an Oracle Applications 11i instance from which the Sales Channel level to the Top level associati
Implementation/DBA Data:	APPS.MSD_SR_SC_ALL_V

View Text

SELECT DISTINCT LOOKUP_CODE
, MEANING
, MSD_SR_UTIL.GET_ALL_SCS_PK
, MSD_SR_UTIL.GET_ALL_SCS_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM SO_LOOKUPS
WHERE LOOKUP_TYPE = 'SALES_CHANNEL' UNION SELECT TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_DESC
, MSD_SR_UTIL.GET_ALL_SCS_PK
, MSD_SR_UTIL.GET_ALL_SCS_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL

Columns