View: CSTBV_AVERAGE_ITEM_COSTS

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

View Text

SELECT /* UNIQUE ATTRIBUTES */ CQL.LAYER_ID
, CQL.ORGANIZATION_ID
, CQL.INVENTORY_ITEM_ID /* REGULAR ATTRIBUTES */
, CQL.ITEM_COST
, CQL.MATERIAL_COST
, CQL.MATERIAL_OVERHEAD_COST
, CQL.OVERHEAD_COST
, CQL.RESOURCE_COST
, CQL.OUTSIDE_PROCESSING_COST /* FOREIGN KEYS RESOLVED */
, MP.ORGANIZATION_CODE
, HR.NAME
, '_KF:INV:MSTK:SY' /* IDS */
, CQL.COST_GROUP_ID /* WHO */
, CQL.CREATION_DATE
, CQL.CREATED_BY
, CQL.LAST_UPDATE_DATE
, CQL.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, CST_QUANTITY_LAYERS CQL
WHERE CQL.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND CQL.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND SY.ORGANIZATION_ID = CQL.ORGANIZATION_ID
AND SY.INVENTORY_ITEM_ID = CQL.INVENTORY_ITEM_ID
AND '_SEC:CQL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns