VIEW: APPS.ISC_MSC_COST_BREAKDOWN_V

Source

View Text - Preformatted

SELECT sum(inv.carrying_cost) CARRYING_COST, sum(inv.inventory_value)/decode(avg(p.period_count),0,1,avg(p.period_count)) INVENTORY_VALUE, inv.plan_id PLAN_ID, p.owning_org_id OWNING_ORG_ID, inv.sr_instance_id||'-'||inv.organization_id ORGANIZATION_ID, nvl(to_char(ic.category_set_id),'NA') CATEGORY_SET_ID, nvl(ic.category_set_id||ic.category_name,'NA') CATEGORY_ID, inv.inventory_item_id ITEM_ID FROM msc_bis_inv_detail inv, msc_item_categories ic, isc_msc_bis_plans_v p WHERE p.id = inv.plan_id AND ic.inventory_item_id(+) = inv.inventory_item_id AND ic.organization_id(+) = inv.organization_id AND ic.sr_instance_id(+) = inv.sr_instance_id AND (inv.carrying_cost <> 0 or inv.inventory_value <> 0) GROUP BY inv.plan_id, p.owning_org_id, inv.sr_instance_id, inv.organization_id, ic.category_set_id, ic.category_name, inv.inventory_item_id

View Text - HTML Formatted

SELECT SUM(INV.CARRYING_COST) CARRYING_COST
, SUM(INV.INVENTORY_VALUE)/DECODE(AVG(P.PERIOD_COUNT)
, 0
, 1
, AVG(P.PERIOD_COUNT)) INVENTORY_VALUE
, INV.PLAN_ID PLAN_ID
, P.OWNING_ORG_ID OWNING_ORG_ID
, INV.SR_INSTANCE_ID||'-'||INV.ORGANIZATION_ID ORGANIZATION_ID
, NVL(TO_CHAR(IC.CATEGORY_SET_ID)
, 'NA') CATEGORY_SET_ID
, NVL(IC.CATEGORY_SET_ID||IC.CATEGORY_NAME
, 'NA') CATEGORY_ID
, INV.INVENTORY_ITEM_ID ITEM_ID
FROM MSC_BIS_INV_DETAIL INV
, MSC_ITEM_CATEGORIES IC
, ISC_MSC_BIS_PLANS_V P
WHERE P.ID = INV.PLAN_ID
AND IC.INVENTORY_ITEM_ID(+) = INV.INVENTORY_ITEM_ID
AND IC.ORGANIZATION_ID(+) = INV.ORGANIZATION_ID
AND IC.SR_INSTANCE_ID(+) = INV.SR_INSTANCE_ID
AND (INV.CARRYING_COST <> 0 OR INV.INVENTORY_VALUE <> 0) GROUP BY INV.PLAN_ID
, P.OWNING_ORG_ID
, INV.SR_INSTANCE_ID
, INV.ORGANIZATION_ID
, IC.CATEGORY_SET_ID
, IC.CATEGORY_NAME
, INV.INVENTORY_ITEM_ID