VIEW: APPS.CST_DETAIL_COST_VIEW

Source

View Text - Preformatted

SELECT cicd.inventory_item_id, cicd.organization_id, cicd.cost_type_id, ml3.meaning, ml1.meaning, cce.cost_element_id, cce.description, ml2.meaning, ca.activity, ca.description, br.resource_code, br.description, cicd.operation_seq_num, bos.operation_description, bd.department_code, bd.description, cicd.resource_rate, cicd.usage_rate_or_amount, cicd.basis_factor, cicd.net_yield_or_shrinkage_factor, cicd.item_units, cicd.activity_units, ca.output_uom, br.unit_of_measure, ca.value_added_activity_flag, cicd.item_cost, ml4.meaning, ca.attribute1, ca.attribute2, ca.attribute3, ca.attribute4, ca.attribute5, ca.attribute6, ca.attribute7, ca.attribute8, ca.attribute9, ca.attribute10, ca.attribute11, ca.attribute12, ca.attribute13, ca.attribute14, ca.attribute15, br.attribute1, br.attribute2, br.attribute3, br.attribute4, br.attribute5, br.attribute6, br.attribute7, br.attribute8, br.attribute9, br.attribute10, br.attribute11, br.attribute12, br.attribute13, br.attribute14, br.attribute15, cicd.level_type FROM cst_item_cost_details cicd, cst_activities ca, cst_cost_elements cce, bom_resources br, bom_departments bd, bom_operation_sequences bos, mfg_lookups ml1, mfg_lookups ml2, mfg_lookups ml3, mfg_lookups ml4 WHERE ca.activity_id (+) = cicd.activity_id AND br.organization_id (+) = cicd.organization_id AND bd.organization_id (+) = cicd.organization_id AND bd.department_id (+) = cicd.department_id AND br.resource_id (+) = cicd.resource_id AND cce.cost_element_id (+) = cicd.cost_element_id AND bos.operation_sequence_id (+) = cicd.operation_sequence_id AND ml1.lookup_type (+) = 'CST_COST_CODE_TYPE' AND ml1.lookup_code (+) = cicd.cost_element_id AND ml2.lookup_type (+) = 'CST_LEVEL' AND ml2.lookup_code (+) = cicd.level_type AND ml3.lookup_type (+) = 'CST_BASIS_SHORT' AND ml3.lookup_code (+) = cicd.basis_type AND ml4.lookup_type (+) = 'CST_SOURCE_TYPE' AND ml4.lookup_code (+) = cicd.rollup_source_type

View Text - HTML Formatted

SELECT CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, ML3.MEANING
, ML1.MEANING
, CCE.COST_ELEMENT_ID
, CCE.DESCRIPTION
, ML2.MEANING
, CA.ACTIVITY
, CA.DESCRIPTION
, BR.RESOURCE_CODE
, BR.DESCRIPTION
, CICD.OPERATION_SEQ_NUM
, BOS.OPERATION_DESCRIPTION
, BD.DEPARTMENT_CODE
, BD.DESCRIPTION
, CICD.RESOURCE_RATE
, CICD.USAGE_RATE_OR_AMOUNT
, CICD.BASIS_FACTOR
, CICD.NET_YIELD_OR_SHRINKAGE_FACTOR
, CICD.ITEM_UNITS
, CICD.ACTIVITY_UNITS
, CA.OUTPUT_UOM
, BR.UNIT_OF_MEASURE
, CA.VALUE_ADDED_ACTIVITY_FLAG
, CICD.ITEM_COST
, ML4.MEANING
, CA.ATTRIBUTE1
, CA.ATTRIBUTE2
, CA.ATTRIBUTE3
, CA.ATTRIBUTE4
, CA.ATTRIBUTE5
, CA.ATTRIBUTE6
, CA.ATTRIBUTE7
, CA.ATTRIBUTE8
, CA.ATTRIBUTE9
, CA.ATTRIBUTE10
, CA.ATTRIBUTE11
, CA.ATTRIBUTE12
, CA.ATTRIBUTE13
, CA.ATTRIBUTE14
, CA.ATTRIBUTE15
, BR.ATTRIBUTE1
, BR.ATTRIBUTE2
, BR.ATTRIBUTE3
, BR.ATTRIBUTE4
, BR.ATTRIBUTE5
, BR.ATTRIBUTE6
, BR.ATTRIBUTE7
, BR.ATTRIBUTE8
, BR.ATTRIBUTE9
, BR.ATTRIBUTE10
, BR.ATTRIBUTE11
, BR.ATTRIBUTE12
, BR.ATTRIBUTE13
, BR.ATTRIBUTE14
, BR.ATTRIBUTE15
, CICD.LEVEL_TYPE
FROM CST_ITEM_COST_DETAILS CICD
, CST_ACTIVITIES CA
, CST_COST_ELEMENTS CCE
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, BOM_OPERATION_SEQUENCES BOS
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID
AND BR.ORGANIZATION_ID (+) = CICD.ORGANIZATION_ID
AND BD.ORGANIZATION_ID (+) = CICD.ORGANIZATION_ID
AND BD.DEPARTMENT_ID (+) = CICD.DEPARTMENT_ID
AND BR.RESOURCE_ID (+) = CICD.RESOURCE_ID
AND CCE.COST_ELEMENT_ID (+) = CICD.COST_ELEMENT_ID
AND BOS.OPERATION_SEQUENCE_ID (+) = CICD.OPERATION_SEQUENCE_ID
AND ML1.LOOKUP_TYPE (+) = 'CST_COST_CODE_TYPE'
AND ML1.LOOKUP_CODE (+) = CICD.COST_ELEMENT_ID
AND ML2.LOOKUP_TYPE (+) = 'CST_LEVEL'
AND ML2.LOOKUP_CODE (+) = CICD.LEVEL_TYPE
AND ML3.LOOKUP_TYPE (+) = 'CST_BASIS_SHORT'
AND ML3.LOOKUP_CODE (+) = CICD.BASIS_TYPE
AND ML4.LOOKUP_TYPE (+) = 'CST_SOURCE_TYPE'
AND ML4.LOOKUP_CODE (+) = CICD.ROLLUP_SOURCE_TYPE