VIEW: APPS.QPR_SR_SC_HIER_V

Source

View Text - Preformatted

SELECT distinct lookup_code, meaning, null, null, null, null, null, QPR_SR_UTIL.get_all_scs_pk, QPR_SR_UTIL.get_all_scs_desc, null, null, null, null, null, null from so_lookups WHERE lookup_type = 'SALES_CHANNEL' UNION ALL SELECT to_char(qpr_sr_util.get_null_pk), qpr_sr_util.get_null_desc, null, null, null, null, null, QPR_SR_UTIL.get_all_scs_pk , QPR_SR_UTIL.get_all_scs_desc, null, null, null, null, null, null FROM dual

View Text - HTML Formatted

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