VIEW: APPS.CST_ITEM_COST_TYPE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'