Product: | BOM - Bills of Material |
---|---|
Description: | Detail cost for reports : SINGLE-ORG view |
Implementation/DBA Data: | APPS.CST_DETAIL_COST_VIEW |
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