VIEW: APPS.MSD_SR_IT_ALL_V

Source

View Text - Preformatted

SELECT
distinct
 to_char(mc.category_id),
 mc.concatenated_segments,
 mc_tl.description,
 msd_sr_util.get_all_prd_pk,
 msd_sr_util.get_all_prd_desc,
 msd_sr_util.get_all_prd_desc,
 null, null, null, null, null
from
  eni_denorm_hierarchies edh,
  mtl_default_category_sets dcs,
  mtl_categories_tl mc_tl,
  mtl_categories_b_kfv mc
WHERE
    dcs.functional_area_id = 11
and dcs.category_set_id = edh.object_id
and edh.parent_id = mc.category_id
and edh.object_type = 'CATEGORY_SET'
and edh.OLTP_flag = 'Y'
and edh.top_node_flag = 'Y'
and edh.parent_id = edh.child_id
and mc.category_id = mc_tl.category_id
and mc_tl.language = USERENV('LANG')
union
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_prd_pk,
msd_sr_util.get_all_prd_desc,
msd_sr_util.get_all_prd_desc,
null, null, null, null, null
from dual

View Text - HTML Formatted

SELECT DISTINCT TO_CHAR(MC.CATEGORY_ID)
, MC.CONCATENATED_SEGMENTS
, MC_TL.DESCRIPTION
, MSD_SR_UTIL.GET_ALL_PRD_PK
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL FROM ENI_DENORM_HIERARCHIES EDH
, MTL_DEFAULT_CATEGORY_SETS DCS
, MTL_CATEGORIES_TL MC_TL
, MTL_CATEGORIES_B_KFV MC WHERE DCS.FUNCTIONAL_AREA_ID = 11 AND DCS.CATEGORY_SET_ID = EDH.OBJECT_ID AND EDH.PARENT_ID = MC.CATEGORY_ID AND EDH.OBJECT_TYPE = 'CATEGORY_SET' AND EDH.OLTP_FLAG = 'Y' AND EDH.TOP_NODE_FLAG = 'Y' AND EDH.PARENT_ID = EDH.CHILD_ID AND MC.CATEGORY_ID = MC_TL.CATEGORY_ID AND MC_TL.LANGUAGE = USERENV('LANG') UNION 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_PRD_PK
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL FROM DUAL