VIEW: APPS.MSD_SR_PRD_CAT_LB_V

Source

View Text - Preformatted

SELECT DISTINCT msi.plan_id , 1, msi.item_name, msi.description, msi.inventory_item_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) 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 mis.plan_id = mp.plan_id and ( mp.CALCULATE_LIABILITY = 1 or mp.plan_id = -1)

View Text - HTML Formatted

SELECT DISTINCT MSI.PLAN_ID
, 1
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MSI.INVENTORY_ITEM_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)
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 MIS.PLAN_ID = MP.PLAN_ID
AND ( MP.CALCULATE_LIABILITY = 1 OR MP.PLAN_ID = -1)