VIEW: APPS.MSD_SR_CAT_ALL_LB_V

Source

View Text - Preformatted

SELECT DISTINCT msi.plan_id , 2, MSD_COMMON_UTILITIES_LB.get_item_cat_name(msi.inventory_item_id,prf_value) , MSD_COMMON_UTILITIES_LB.get_item_cat_desc(msi.inventory_item_id,prf_value), MSD_COMMON_UTILITIES_LB.get_item_cat_name(msi.inventory_item_id,prf_value), 28, MSD_SR_UTIL.get_all_prd_desc, MSD_SR_UTIL.get_all_prd_desc, MSD_SR_UTIL.get_all_prd_pk FROM MSC_SYSTEM_ITEMS msi , MSC_ASL_AUTH_DETAILS maad , msc_item_suppliers mis , msc_plans mp , (select fnd_profile.value('MSC_CATEGORY_SET_NAME') prf_value from dual) cat_set WHERE mis.inventory_item_id = maad.inventory_item_id and mis.organization_id = maad.organization_id and mis.sr_instance_id = maad.sr_instance_id and maad.inventory_item_id = msi.inventory_item_id and maad.organization_id = msi.organization_id and maad.sr_instance_id = msi.sr_instance_id and msi.plan_id = mis.plan_id and ( mp.plan_id = msi.plan_id or mp.plan_id = -1 )

View Text - HTML Formatted

SELECT DISTINCT MSI.PLAN_ID
, 2
, MSD_COMMON_UTILITIES_LB.GET_ITEM_CAT_NAME(MSI.INVENTORY_ITEM_ID
, PRF_VALUE)
, MSD_COMMON_UTILITIES_LB.GET_ITEM_CAT_DESC(MSI.INVENTORY_ITEM_ID
, PRF_VALUE)
, MSD_COMMON_UTILITIES_LB.GET_ITEM_CAT_NAME(MSI.INVENTORY_ITEM_ID
, PRF_VALUE)
, 28
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, MSD_SR_UTIL.GET_ALL_PRD_PK
FROM MSC_SYSTEM_ITEMS MSI
, MSC_ASL_AUTH_DETAILS MAAD
, MSC_ITEM_SUPPLIERS MIS
, MSC_PLANS MP
, (SELECT FND_PROFILE.VALUE('MSC_CATEGORY_SET_NAME') PRF_VALUE
FROM DUAL) CAT_SET
WHERE MIS.INVENTORY_ITEM_ID = MAAD.INVENTORY_ITEM_ID
AND MIS.ORGANIZATION_ID = MAAD.ORGANIZATION_ID
AND MIS.SR_INSTANCE_ID = MAAD.SR_INSTANCE_ID
AND MAAD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MAAD.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MAAD.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MSI.PLAN_ID = MIS.PLAN_ID
AND ( MP.PLAN_ID = MSI.PLAN_ID OR MP.PLAN_ID = -1 )