View: CSTBV_ITEM_UNIT_COST_DETAILS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTBV_ITEM_UNIT_COST_DETAILS

View Text

SELECT /* UNIQUE ATTRIBUTES */ ICD.ORGANIZATION_ID
, ICD.INVENTORY_ITEM_ID
, ICD.COST_TYPE_ID /* REGULAR ATTRIBUTES */
, ICD.ITEM_UNITS
, ICD.ACTIVITY_UNITS
, ICD.USAGE_RATE_OR_AMOUNT
, ICD.BASIS_FACTOR
, ICD.NET_YIELD_OR_SHRINKAGE_FACTOR
, '_LA:ICD.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, ICD.ITEM_COST
, '_LA:ICD.LEVEL_TYPE:MFG_LOOKUPS:CST_LEVEL:MEANING' /* FOREIGN KEYS RESOLVED*/
, MP.ORGANIZATION_CODE
, HR.NAME
, '_KF:INV:MSTK:SY'
, CT.COST_TYPE /* IDS */
, ICD.COST_ELEMENT_ID
, ICD.DEPARTMENT_ID
, ICD.ACTIVITY_ID
, ICD.RESOURCE_ID
, ICD.BASIS_RESOURCE_ID
, ICD.OPERATION_SEQUENCE_ID /* WHO */
, ICD.CREATION_DATE
, ICD.CREATED_BY
, ICD.LAST_UPDATE_DATE
, ICD.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS SY
, CST_COST_TYPES CT
, CST_ITEM_COST_DETAILS ICD
WHERE ICD.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND ICD.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND SY.ORGANIZATION_ID = ICD.ORGANIZATION_ID
AND SY.INVENTORY_ITEM_ID = ICD.INVENTORY_ITEM_ID
AND ICD.COST_TYPE_ID = CT.COST_TYPE_ID
AND '_SEC:ICD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns