View: CST_DEFAULT_DETAIL_COST_VIEW

Product:	BOM - Bills of Material
Description:	Detailed item default cost : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_DEFAULT_DETAIL_COST_VIEW

View Text

SELECT CCT.COST_TYPE_ID
, CIA.COST_TYPE_ID
, CIA.ORGANIZATION_ID
, CIA.INVENTORY_ITEM_ID
, CIA.INVENTORY_ASSET_FLAG
, CIA.LOT_SIZE
, CIA.BASED_ON_ROLLUP_FLAG
, CIA.SHRINKAGE_RATE
, CIA.DEFAULTED_FLAG
, CIA.COST_UPDATE_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.OPERATION_SEQUENCE_ID
FROM CST_COST_TYPES CCT
, CST_ITEM_COSTS CIA
, CST_ITEM_COST_DETAILS CICD
WHERE CIA.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID
, CIA.ORGANIZATION_ID)
AND ( (CIA.COST_TYPE_ID = CCT.COST_TYPE_ID) OR ( (CIA.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID)
AND (NOT EXISTS (SELECT 'X'
FROM CST_ITEM_COSTS CIA2
WHERE CIA2.INVENTORY_ITEM_ID = CIA.INVENTORY_ITEM_ID
AND CIA2.ORGANIZATION_ID = CIA.ORGANIZATION_ID
AND CIA2.COST_TYPE_ID = CCT.COST_TYPE_ID)) ) )
AND CICD.ORGANIZATION_ID (+) = CIA.ORGANIZATION_ID
AND CICD.INVENTORY_ITEM_ID (+) = CIA.INVENTORY_ITEM_ID
AND CICD.COST_TYPE_ID (+) = CIA.COST_TYPE_ID

Columns