View: CSTBV_STANDARD_ITEM_COST

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

View Text

SELECT /* UNIQUE ATTRIBUTES */ CIC.ORGANIZATION_ID
, CIC.INVENTORY_ITEM_ID
, CIC.COST_TYPE_ID /* REGULAR ATTRIBUTES */
, CIC.ITEM_COST
, CIC.MATERIAL_COST
, CIC.MATERIAL_OVERHEAD_COST
, CIC.OVERHEAD_COST
, CIC.RESOURCE_COST
, CIC.OUTSIDE_PROCESSING_COST
, ML1.MEANING
, CIC.LOT_SIZE
, ML2.MEANING
, CIC.SHRINKAGE_RATE
, ML3.MEANING /* FOREIGN KEYS RESOLVED */
, MP.ORGANIZATION_CODE
, HR.NAME
, '_KF:INV:MSTK:SY'
, CT.COST_TYPE /* IDS */ /* WHO */
, CIC.CREATION_DATE
, CIC.CREATED_BY
, CIC.LAST_UPDATE_DATE
, CIC.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS SY
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, CST_ITEM_COSTS CIC
, CST_COST_TYPES CT
WHERE CIC.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND CIC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CIC.COST_TYPE_ID = CT.COST_TYPE_ID
AND SY.ORGANIZATION_ID = CIC.ORGANIZATION_ID
AND SY.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
AND ML1.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML1.LOOKUP_CODE = CIC.INVENTORY_ASSET_FLAG
AND ML2.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML2.LOOKUP_CODE = CIC.BASED_ON_ROLLUP_FLAG
AND ML3.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML3.LOOKUP_CODE = CIC.DEFAULTED_FLAG
AND '_SEC:CIC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns