View: CST_DETAIL_COSTS_FOR_GL_VIEW

Product:	BOM - Bills of Material
Description:	Item cost details used by General Ledger : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_DETAIL_COSTS_FOR_GL_VIEW

View Text

SELECT CICD.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
, MP.COST_ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.OPERATION_SEQUENCE_ID
, CICD.OPERATION_SEQ_NUM
, CICD.DEPARTMENT_ID
, CICD.LEVEL_TYPE
, CICD.ACTIVITY_ID
, CICD.RESOURCE_SEQ_NUM
, CICD.RESOURCE_ID
, CICD.RESOURCE_RATE
, CICD.ITEM_UNITS
, CICD.ACTIVITY_UNITS
, CICD.USAGE_RATE_OR_AMOUNT
, CICD.BASIS_TYPE
, CICD.BASIS_RESOURCE_ID
, CICD.BASIS_FACTOR
, CICD.NET_YIELD_OR_SHRINKAGE_FACTOR
, CICD.ITEM_COST
, CICD.COST_ELEMENT_ID
, CICD.ROLLUP_SOURCE_TYPE
, CICD.ACTIVITY_CONTEXT
, 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
FROM CST_ITEM_COST_DETAILS CICD
, MTL_PARAMETERS MP
WHERE CICD.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
AND CICD.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Columns