View: CST_ITEM_COST_DETAILS_V

Product:	BOM - Bills of Material
Description:	Item cost details for an organization : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_ITEM_COST_DETAILS_V

View Text

SELECT CICD.ROWID
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.LAST_UPDATE_DATE
, CICD.LAST_UPDATED_BY
, CICD.CREATION_DATE
, CICD.CREATED_BY
, CICD.LAST_UPDATE_LOGIN
, CICD.OPERATION_SEQUENCE_ID
, CICD.OPERATION_SEQ_NUM
, CICD.DEPARTMENT_ID
, CICD.LEVEL_TYPE
, LU3.MEANING
, CICD.ACTIVITY_ID
, CA.ACTIVITY
, CICD.RESOURCE_SEQ_NUM
, CICD.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.UNIT_OF_MEASURE
, CICD.RESOURCE_RATE
, CICD.ITEM_UNITS
, CICD.ACTIVITY_UNITS
, CICD.USAGE_RATE_OR_AMOUNT
, CICD.BASIS_TYPE
, LU1.MEANING
, CICD.BASIS_RESOURCE_ID
, CICD.BASIS_FACTOR
, CICD.NET_YIELD_OR_SHRINKAGE_FACTOR
, CICD.ITEM_COST
, CICD.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, LU2.MEANING
, CICD.ROLLUP_SOURCE_TYPE
, CICD.ACTIVITY_CONTEXT
, CICD.REQUEST_ID
, CICD.PROGRAM_APPLICATION_ID
, CICD.PROGRAM_ID
, CICD.PROGRAM_UPDATE_DATE
, CICD.ATTRIBUTE_CATEGORY
, CICD.ATTRIBUTE1
, CICD.ATTRIBUTE2
, CICD.ATTRIBUTE3
, CICD.ATTRIBUTE4
, CICD.ATTRIBUTE5
, CICD.ATTRIBUTE6
, CICD.ATTRIBUTE7
, CICD.ATTRIBUTE8
, CICD.ATTRIBUTE9
, CICD.ATTRIBUTE10
, CICD.ATTRIBUTE11
, CICD.ATTRIBUTE12
, CICD.ATTRIBUTE13
, CICD.ATTRIBUTE14
, CICD.ATTRIBUTE15
, CICD.YIELDED_COST
FROM CST_ITEM_COST_DETAILS CICD
, CST_ACTIVITIES CA
, BOM_RESOURCES BR
, CST_COST_ELEMENTS CCE
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID
AND NVL(CA.ORGANIZATION_ID (+)
, CICD.ORGANIZATION_ID) = CICD.ORGANIZATION_ID
AND BR.RESOURCE_ID (+) = CICD.RESOURCE_ID
AND CCE.COST_ELEMENT_ID = CICD.COST_ELEMENT_ID
AND LU1.LOOKUP_TYPE = 'CST_BASIS'
AND LU1.LOOKUP_CODE = CICD.BASIS_TYPE
AND LU2.LOOKUP_TYPE = 'CST_SOURCE_TYPE'
AND LU2.LOOKUP_CODE = CICD.ROLLUP_SOURCE_TYPE
AND LU3.LOOKUP_TYPE = 'CST_LEVEL'
AND LU3.LOOKUP_CODE = CICD.LEVEL_TYPE

Columns