SELECT distinct lookup_code, meaning, null, MSD_SR_UTIL.get_all_scs_pk, MSD_SR_UTIL.get_all_scs_desc, 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, null, MSD_SR_UTIL.get_all_scs_pk , MSD_SR_UTIL.get_all_scs_desc, MSD_SR_UTIL.get_all_scs_desc, null, null, null, null, null from dual
SELECT DISTINCT LOOKUP_CODE
, MEANING
, NULL
, MSD_SR_UTIL.GET_ALL_SCS_PK
, MSD_SR_UTIL.GET_ALL_SCS_DESC
, 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
, NULL
, MSD_SR_UTIL.GET_ALL_SCS_PK
, MSD_SR_UTIL.GET_ALL_SCS_DESC
, MSD_SR_UTIL.GET_ALL_SCS_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL
|
|
|