SELECT distinct ra.salesrep_id, nvl(ra.name,msd_sr_util.get_null_desc), null, msd_sr_util.get_null_pk, msd_sr_util.get_null_desc, null, null, null, null, null, null, 8, nvl(ra.org_id, msd_sr_util.get_null_pk) from RA_SALESREPS_ALL RA WHERE 1 = 1 union select msd_sr_util.get_null_pk, msd_sr_util.get_null_desc, null, msd_sr_util.get_null_pk, msd_sr_util.get_null_desc, null, null, null, null, null, null, 8, -777 from dual
SELECT DISTINCT RA.SALESREP_ID
, NVL(RA.NAME
, MSD_SR_UTIL.GET_NULL_DESC)
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 8
, NVL(RA.ORG_ID
, MSD_SR_UTIL.GET_NULL_PK)
FROM RA_SALESREPS_ALL RA
WHERE 1 = 1 UNION SELECT MSD_SR_UTIL.GET_NULL_PK
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 8
, -777
FROM DUAL
|
|
|