VIEW: APPS.MSD_SR_DC_ALL_V

Source

View Text - Preformatted

SELECT distinct fl.LOOKUP_CODE, fl.MEANING DEMAND_CLASS, fl.DESCRIPTION, MSD_SR_UTIL.get_all_dcs_pk, MSD_SR_UTIL.get_all_dcs_desc, MSD_SR_UTIL.get_all_dcs_desc, NULL, NULL, NULL, NULL, NULL FROM FND_COMMON_LOOKUPS fl WHERE LOOKUP_TYPE = 'DEMAND_CLASS' AND APPLICATION_ID = 700 AND ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE, TRUNC(SYSDATE)) union all select to_char( msd_sr_util.get_null_pk), msd_sr_util.get_null_desc, msd_sr_util.get_null_desc, MSD_SR_UTIL.get_all_dcs_pk, MSD_SR_UTIL.get_all_dcs_desc, MSD_SR_UTIL.get_all_dcs_desc, null, null, null, null, null from dual

View Text - HTML Formatted

SELECT DISTINCT FL.LOOKUP_CODE
, FL.MEANING DEMAND_CLASS
, FL.DESCRIPTION
, MSD_SR_UTIL.GET_ALL_DCS_PK
, MSD_SR_UTIL.GET_ALL_DCS_DESC
, MSD_SR_UTIL.GET_ALL_DCS_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM FND_COMMON_LOOKUPS FL
WHERE LOOKUP_TYPE = 'DEMAND_CLASS'
AND APPLICATION_ID = 700
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE)) UNION ALL SELECT TO_CHAR( MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_DESC
, MSD_SR_UTIL.GET_NULL_DESC
, MSD_SR_UTIL.GET_ALL_DCS_PK
, MSD_SR_UTIL.GET_ALL_DCS_DESC
, MSD_SR_UTIL.GET_ALL_DCS_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL