eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CST_ITEM_COST_TYPE_V

Product:	BOM - Bills of Material
Description:	Item cost information for a cost type in an organization : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_ITEM_COST_TYPE_V

View Text

SELECT CIC.ROWID
, CIC.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.PADDED_CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, CIC.ORGANIZATION_ID
, CIC.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CCT.ALLOW_UPDATES_FLAG
, CCT.FROZEN_STANDARD_FLAG
, CCT.DEFAULT_COST_TYPE_ID
, CCT2.COST_TYPE
, CIC.LAST_UPDATE_DATE
, CIC.LAST_UPDATED_BY
, CIC.CREATION_DATE
, CIC.CREATED_BY
, CIC.LAST_UPDATE_LOGIN
, CIC.INVENTORY_ASSET_FLAG
, CIC.LOT_SIZE
, CIC.BASED_ON_ROLLUP_FLAG
, CIC.SHRINKAGE_RATE
, CIC.DEFAULTED_FLAG
, CIC.ITEM_COST
, CIC.MATERIAL_COST
, CIC.MATERIAL_OVERHEAD_COST
, CIC.RESOURCE_COST
, CIC.OUTSIDE_PROCESSING_COST
, CIC.OVERHEAD_COST
, LU1.MEANING
, MSI.DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, MSI.COST_OF_SALES_ACCOUNT
, MSI.SALES_ACCOUNT
, MIC.CATEGORY_ID
, CIC.ATTRIBUTE_CATEGORY
, CIC.ATTRIBUTE1
, CIC.ATTRIBUTE2
, CIC.ATTRIBUTE3
, CIC.ATTRIBUTE4
, CIC.ATTRIBUTE5
, CIC.ATTRIBUTE6
, CIC.ATTRIBUTE7
, CIC.ATTRIBUTE8
, CIC.ATTRIBUTE9
, CIC.ATTRIBUTE10
, CIC.ATTRIBUTE11
, CIC.ATTRIBUTE12
, CIC.ATTRIBUTE13
, CIC.ATTRIBUTE14
, CIC.ATTRIBUTE15
, CIC.REQUEST_ID
, CIC.PROGRAM_APPLICATION_ID
, CIC.PROGRAM_ID
, CIC.PROGRAM_UPDATE_DATE
FROM CST_ITEM_COSTS CIC
, CST_COST_TYPES CCT
, CST_COST_TYPES CCT2
, MTL_SYSTEM_ITEMS_VL MSI
, MTL_ITEM_CATEGORIES MIC
, MTL_DEFAULT_CATEGORY_SETS MDC
, MFG_LOOKUPS LU1
WHERE CCT.COST_TYPE_ID = CIC.COST_TYPE_ID
AND CCT2.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID
AND MSI.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CIC.ORGANIZATION_ID
AND MSI.COSTING_ENABLED_FLAG = 'Y'
AND MIC.INVENTORY_ITEM_ID (+) = CIC.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID (+) = CIC.ORGANIZATION_ID
AND MDC.FUNCTIONAL_AREA_ID = 5
AND NVL(MIC.CATEGORY_SET_ID
, MDC.CATEGORY_SET_ID) = MDC.CATEGORY_SET_ID
AND LU1.LOOKUP_CODE(+) = MSI.PLANNING_MAKE_BUY_CODE
AND LU1.LOOKUP_TYPE(+) = 'MTL_PLANNING_MAKE_BUY'

Columns

Name
ROW_ID
INVENTORY_ITEM_ID
ITEM_NUMBER
PADDED_ITEM_NUMBER
DESCRIPTION
PRIMARY_UOM_CODE
ORGANIZATION_ID
COST_TYPE_ID
COST_TYPE
COST_TYPE_DESCRIPTION
ALLOW_UPDATES_FLAG
FROZEN_STANDARD_FLAG
DEFAULT_COST_TYPE_ID
DEFAULT_COST_TYPE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
INVENTORY_ASSET
LOT_SIZE
BASED_ON_ROLLUP
SHRINKAGE_RATE
DEFAULTED_FLAG
ITEM_COST
MATERIAL_COST
MATERIAL_OVERHEAD_COST
RESOURCE_COST
OUTSIDE_PROCESSING_COST
OVERHEAD_COST
PLANNING_MAKE_BUY_CODE
DEFAULT_INCLUDE_IN_ROLLUP_FLAG
COST_OF_SALES_ACCOUNT
SALES_ACCOUNT
CATEGORY_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE