VIEW: APPS.CST_CG_ITEM_COSTS_VIEW

Source

View Text - Preformatted

SELECT nvl(CQL.LAYER_ID, 1) LAYER_ID, decode(cql.inventory_item_id, null, decode(mp.primary_cost_method, 1, 1, nvl(mp.default_cost_group_id,1)), cql.COST_GROUP_ID) COST_GROUP_ID, nvl(CQL.LAYER_QUANTITY, 1) LAYER_QUANTITY, CIC.INVENTORY_ITEM_ID, MP.ORGANIZATION_ID, CIC.INVENTORY_ASSET_FLAG, CIC.LOT_SIZE, CIC.BASED_ON_ROLLUP_FLAG, CIC.SHRINKAGE_RATE, CIC.DEFAULTED_FLAG, CIC.COST_UPDATE_ID, decode(cql.inventory_item_id, null, cic.PL_MATERIAL, cql.PL_MATERIAL) PL_MATERIAL, decode(cql.inventory_item_id, null, cic.PL_MATERIAL_OVERHEAD, cql.PL_MATERIAL_OVERHEAD) PL_MATERIAL_OVERHEAD, decode(cql.inventory_item_id, null, cic.PL_RESOURCE, cql.PL_RESOURCE) PL_RESOURCE, decode(cql.inventory_item_id, null, cic.PL_OUTSIDE_PROCESSING, cql.PL_OUTSIDE_PROCESSING) PL_OUTSIDE_PROCESSING, decode(cql.inventory_item_id, null, cic.PL_OVERHEAD, cql.PL_OVERHEAD) PL_OVERHEAD, decode(cql.inventory_item_id, null, cic.TL_MATERIAL, cql.TL_MATERIAL) TL_MATERIAL, decode(cql.inventory_item_id, null, cic.TL_MATERIAL_OVERHEAD, cql.TL_MATERIAL_OVERHEAD) TL_MATERIAL_OVERHEAD, decode(cql.inventory_item_id, null, cic.TL_RESOURCE, cql.TL_RESOURCE) TL_RESOURCE, decode(cql.inventory_item_id, null, cic.TL_OUTSIDE_PROCESSING, cql.TL_OUTSIDE_PROCESSING) TL_OUTSIDE_PROCESSING, decode(cql.inventory_item_id, null, cic.TL_OVERHEAD, cql.TL_OVERHEAD) TL_OVERHEAD, decode(cql.inventory_item_id, null, cic.MATERIAL_COST, cql.MATERIAL_COST) MATERIAL_COST, decode(cql.inventory_item_id, null, cic.MATERIAL_OVERHEAD_COST, cql.MATERIAL_OVERHEAD_COST) MATERIAL_OVERHEAD_COST, decode(cql.inventory_item_id, null, cic.RESOURCE_COST, cql.RESOURCE_COST) RESOURCE_COST, decode(cql.inventory_item_id, null, cic.OUTSIDE_PROCESSING_COST, cql.OUTSIDE_PROCESSING_COST) OUTSIDE_PROCESSING_COST, decode(cql.inventory_item_id, null, cic.OVERHEAD_COST, cql.OVERHEAD_COST) OVERHEAD_COST, decode(cql.inventory_item_id, null, cic.PL_ITEM_COST, cql.PL_ITEM_COST) PL_ITEM_COST, decode(cql.inventory_item_id, null, cic.TL_ITEM_COST, cql.TL_ITEM_COST) TL_ITEM_COST, nvl( decode(cql.inventory_item_id, null, cic.ITEM_COST, cql.ITEM_COST),0) ITEM_COST, decode(cql.inventory_item_id, null, cic.UNBURDENED_COST, cql.UNBURDENED_COST) UNBURDENED_COST, decode(cql.inventory_item_id, null, cic.BURDEN_COST, cql.BURDEN_COST) BURDEN_COST, CIC.ATTRIBUTE1, CIC.ATTRIBUTE2, CIC.ATTRIBUTE3, CIC.ATTRIBUTE4, CIC.ATTRIBUTE5, CIC.ATTRIBUTE6, CIC.ATTRIBUTE7, CIC.ATTRIBUTE8, CIC.ATTRIBUTE9, CIC.ATTRIBUTE10, CIC.ATTRIBUTE11, CIC.ATTRIBUTE12, CIC.ATTRIBUTE13, CIC.ATTRIBUTE14, CIC.ATTRIBUTE15 FROM CST_QUANTITY_LAYERS CQL, MTL_PARAMETERS MP, CST_ITEM_COSTS CIC WHERE CQL.INVENTORY_ITEM_ID(+) = CIC.INVENTORY_ITEM_ID AND CQL.ORGANIZATION_ID(+) = CIC.ORGANIZATION_ID AND MP.COST_ORGANIZATION_ID = CIC.ORGANIZATION_ID AND MP.PRIMARY_COST_METHOD = CIC.COST_TYPE_ID

View Text - HTML Formatted

SELECT NVL(CQL.LAYER_ID
, 1) LAYER_ID
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MP.DEFAULT_COST_GROUP_ID
, 1))
, CQL.COST_GROUP_ID) COST_GROUP_ID
, NVL(CQL.LAYER_QUANTITY
, 1) LAYER_QUANTITY
, CIC.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
, CIC.INVENTORY_ASSET_FLAG
, CIC.LOT_SIZE
, CIC.BASED_ON_ROLLUP_FLAG
, CIC.SHRINKAGE_RATE
, CIC.DEFAULTED_FLAG
, CIC.COST_UPDATE_ID
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_MATERIAL
, CQL.PL_MATERIAL) PL_MATERIAL
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_MATERIAL_OVERHEAD
, CQL.PL_MATERIAL_OVERHEAD) PL_MATERIAL_OVERHEAD
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_RESOURCE
, CQL.PL_RESOURCE) PL_RESOURCE
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_OUTSIDE_PROCESSING
, CQL.PL_OUTSIDE_PROCESSING) PL_OUTSIDE_PROCESSING
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_OVERHEAD
, CQL.PL_OVERHEAD) PL_OVERHEAD
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_MATERIAL
, CQL.TL_MATERIAL) TL_MATERIAL
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_MATERIAL_OVERHEAD
, CQL.TL_MATERIAL_OVERHEAD) TL_MATERIAL_OVERHEAD
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_RESOURCE
, CQL.TL_RESOURCE) TL_RESOURCE
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_OUTSIDE_PROCESSING
, CQL.TL_OUTSIDE_PROCESSING) TL_OUTSIDE_PROCESSING
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_OVERHEAD
, CQL.TL_OVERHEAD) TL_OVERHEAD
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.MATERIAL_COST
, CQL.MATERIAL_COST) MATERIAL_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.MATERIAL_OVERHEAD_COST
, CQL.MATERIAL_OVERHEAD_COST) MATERIAL_OVERHEAD_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.RESOURCE_COST
, CQL.RESOURCE_COST) RESOURCE_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.OUTSIDE_PROCESSING_COST
, CQL.OUTSIDE_PROCESSING_COST) OUTSIDE_PROCESSING_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.OVERHEAD_COST
, CQL.OVERHEAD_COST) OVERHEAD_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_ITEM_COST
, CQL.PL_ITEM_COST) PL_ITEM_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_ITEM_COST
, CQL.TL_ITEM_COST) TL_ITEM_COST
, NVL( DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.ITEM_COST
, CQL.ITEM_COST)
, 0) ITEM_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.UNBURDENED_COST
, CQL.UNBURDENED_COST) UNBURDENED_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.BURDEN_COST
, CQL.BURDEN_COST) BURDEN_COST
, CIC.ATTRIBUTE1
, CIC.ATTRIBUTE2
, CIC.ATTRIBUTE3
, CIC.ATTRIBUTE4
, CIC.ATTRIBUTE5
, CIC.ATTRIBUTE6
, CIC.ATTRIBUTE7
, CIC.ATTRIBUTE8
, CIC.ATTRIBUTE9
, CIC.ATTRIBUTE10
, CIC.ATTRIBUTE11
, CIC.ATTRIBUTE12
, CIC.ATTRIBUTE13
, CIC.ATTRIBUTE14
, CIC.ATTRIBUTE15
FROM CST_QUANTITY_LAYERS CQL
, MTL_PARAMETERS MP
, CST_ITEM_COSTS CIC
WHERE CQL.INVENTORY_ITEM_ID(+) = CIC.INVENTORY_ITEM_ID
AND CQL.ORGANIZATION_ID(+) = CIC.ORGANIZATION_ID
AND MP.COST_ORGANIZATION_ID = CIC.ORGANIZATION_ID
AND MP.PRIMARY_COST_METHOD = CIC.COST_TYPE_ID