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