DBA Data[Home] [Help]

VIEW: APPS.MSD_SR_CAT_ALL_V

Source

View Text - Preformatted

SELECT 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, NULL FROM (SELECT mic.category_id category_id FROM msd_app_instance_orgs maio, mtl_item_categories mic WHERE /* Bug# 4157588 */ NOT EXISTS (SELECT 1 FROM msd_setup_parameters WHERE parameter_name = 'MSD_ITEM_ORG' AND parameter_value = 'MSD_MASTER_ORG') AND maio.organization_id = mic.organization_id AND to_char(mic.category_set_id) = (SELECT parameter_value FROM msd_setup_parameters WHERE parameter_name = 'MSD_CATEGORY_SET_NAME') GROUP BY mic.category_id) cat, mtl_categories_b_kfv mc, mtl_categories_tl mc_tl WHERE cat.category_id = mc.category_id AND mc.category_id = mc_tl.category_id AND mc_tl.LANGUAGE = userenv('LANG') /* Bug# 4157588 */ UNION ALL SELECT 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, NULL FROM dual /* Bug# 4157588 */ UNION ALL SELECT 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, NULL FROM (SELECT mic.category_id category_id FROM mtl_item_categories mic WHERE /* Bug# 4157588 */ EXISTS (SELECT 1 FROM msd_setup_parameters WHERE parameter_name = 'MSD_ITEM_ORG' AND parameter_value = 'MSD_MASTER_ORG') AND mic.organization_id = (SELECT parameter_value FROM msd_setup_parameters WHERE parameter_name = 'MSD_MASTER_ORG') AND to_char(mic.category_set_id) = (SELECT parameter_value FROM msd_setup_parameters WHERE parameter_name = 'MSD_CATEGORY_SET_NAME') GROUP BY mic.category_id) cat, mtl_categories_b_kfv mc, mtl_categories_tl mc_tl WHERE cat.category_id = mc.category_id AND mc.category_id = mc_tl.category_id AND mc_tl.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT 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
, NULL
FROM (SELECT MIC.CATEGORY_ID CATEGORY_ID
FROM MSD_APP_INSTANCE_ORGS MAIO
, MTL_ITEM_CATEGORIES MIC
WHERE /* BUG# 4157588 */ NOT EXISTS (SELECT 1
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_ITEM_ORG'
AND PARAMETER_VALUE = 'MSD_MASTER_ORG')
AND MAIO.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND TO_CHAR(MIC.CATEGORY_SET_ID) = (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CATEGORY_SET_NAME') GROUP BY MIC.CATEGORY_ID) CAT
, MTL_CATEGORIES_B_KFV MC
, MTL_CATEGORIES_TL MC_TL
WHERE CAT.CATEGORY_ID = MC.CATEGORY_ID
AND MC.CATEGORY_ID = MC_TL.CATEGORY_ID
AND MC_TL.LANGUAGE = USERENV('LANG') /* BUG# 4157588 */ UNION ALL SELECT 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
, NULL
FROM DUAL /* BUG# 4157588 */ UNION ALL SELECT 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
, NULL
FROM (SELECT MIC.CATEGORY_ID CATEGORY_ID
FROM MTL_ITEM_CATEGORIES MIC
WHERE /* BUG# 4157588 */ EXISTS (SELECT 1
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_ITEM_ORG'
AND PARAMETER_VALUE = 'MSD_MASTER_ORG')
AND MIC.ORGANIZATION_ID = (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_MASTER_ORG')
AND TO_CHAR(MIC.CATEGORY_SET_ID) = (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CATEGORY_SET_NAME') GROUP BY MIC.CATEGORY_ID) CAT
, MTL_CATEGORIES_B_KFV MC
, MTL_CATEGORIES_TL MC_TL
WHERE CAT.CATEGORY_ID = MC.CATEGORY_ID
AND MC.CATEGORY_ID = MC_TL.CATEGORY_ID
AND MC_TL.LANGUAGE = USERENV('LANG')