VIEW: APPS.MSC_COST_BREAKDOWN_NOTPCOST_V

Source

View Text - Preformatted

SELECT mbid.plan_id, msc_get_name.plan_name(mbid.plan_id), mbid.sr_instance_id, mbid.organization_id, msc_get_name.org_code(mbid.organization_id, mbid.sr_instance_id), mbid.detail_date, mic.category_set_id, mic.sr_category_id, mic.category_name, mbid.inventory_item_id, msc_get_name.item_name(mbid.inventory_item_id, null, null, null), sum(nvl(mbid.production_cost,0)), sum(nvl(mbid.carrying_cost,0)), sum(nvl(mbid.purchasing_cost,0)), 0, sum(nvl(mbid.int_repair_cost,0)), sum(nvl(mbid.ext_repair_cost,0)), sum(nvl(mbid.production_cost,0)) + sum(nvl(mbid.carrying_cost,0)) + sum(nvl(mbid.purchasing_cost,0)) + sum(nvl(mbid.int_repair_cost,0)) + sum(nvl(mbid.ext_repair_cost,0)), mbid.detail_level, mbid.period_type, decode(nvl(mbid.period_type,0), '1', decode(nvl(mbid.detail_level,0),0,'PeriodTypeUrl','PeriodTypeNoUrl'), 'PeriodTypeNoUrl'), sum(nvl(mbid.mds_price,0)), to_number(null) FROM msc_bis_inv_detail mbid, msc_item_categories mic WHERE mbid.sr_instance_id = mic.sr_instance_id and mbid.organization_id = mic.organization_id and mbid.inventory_item_id = mic.inventory_item_id GROUP BY mbid.plan_id, mbid.sr_instance_id, mbid.organization_id, mbid.detail_date, mic.category_set_id, mic.sr_category_id, mic.category_name, mbid.inventory_item_id, mbid.detail_level, mbid.period_type

View Text - HTML Formatted

SELECT MBID.PLAN_ID
, MSC_GET_NAME.PLAN_NAME(MBID.PLAN_ID)
, MBID.SR_INSTANCE_ID
, MBID.ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(MBID.ORGANIZATION_ID
, MBID.SR_INSTANCE_ID)
, MBID.DETAIL_DATE
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_NAME
, MBID.INVENTORY_ITEM_ID
, MSC_GET_NAME.ITEM_NAME(MBID.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL)
, SUM(NVL(MBID.PRODUCTION_COST
, 0))
, SUM(NVL(MBID.CARRYING_COST
, 0))
, SUM(NVL(MBID.PURCHASING_COST
, 0))
, 0
, SUM(NVL(MBID.INT_REPAIR_COST
, 0))
, SUM(NVL(MBID.EXT_REPAIR_COST
, 0))
, SUM(NVL(MBID.PRODUCTION_COST
, 0)) + SUM(NVL(MBID.CARRYING_COST
, 0)) + SUM(NVL(MBID.PURCHASING_COST
, 0)) + SUM(NVL(MBID.INT_REPAIR_COST
, 0)) + SUM(NVL(MBID.EXT_REPAIR_COST
, 0))
, MBID.DETAIL_LEVEL
, MBID.PERIOD_TYPE
, DECODE(NVL(MBID.PERIOD_TYPE
, 0)
, '1'
, DECODE(NVL(MBID.DETAIL_LEVEL
, 0)
, 0
, 'PERIODTYPEURL'
, 'PERIODTYPENOURL')
, 'PERIODTYPENOURL')
, SUM(NVL(MBID.MDS_PRICE
, 0))
, TO_NUMBER(NULL)
FROM MSC_BIS_INV_DETAIL MBID
, MSC_ITEM_CATEGORIES MIC
WHERE MBID.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND MBID.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MBID.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID GROUP BY MBID.PLAN_ID
, MBID.SR_INSTANCE_ID
, MBID.ORGANIZATION_ID
, MBID.DETAIL_DATE
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_NAME
, MBID.INVENTORY_ITEM_ID
, MBID.DETAIL_LEVEL
, MBID.PERIOD_TYPE