View: CST_COST_UPDATES_V

Product:	BOM - Bills of Material
Description:	Cost update information : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_COST_UPDATES_V

View Text

SELECT CCU.COST_UPDATE_ID
, TRUNC(FND_DATE.ADJUST_DATETIME(CCU.UPDATE_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE
, FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE))
, CCU.STATUS
, CCU.ORGANIZATION_ID
, CCU.COST_TYPE_ID
, CCT.COST_TYPE
, CCU.SNAPSHOT_SAVED_FLAG
, UPD.MEANING
, CCU.DESCRIPTION
, CCU.INV_ADJUSTMENT_ACCOUNT
, GCC.CODE_COMBINATION_ID
, CCU.UPDATE_RESOURCE_OVHD_FLAG /* LOOKUP YES_NO */
, CCU.UPDATE_ACTIVITY_FLAG /* YES_NO */
, LRANGE.MEANING
, CCU.SINGLE_ITEM
, MSI.INVENTORY_ITEM_ID
, CCU.ITEM_RANGE_LOW
, CCU.ITEM_RANGE_HIGH
, CCU.CATEGORY_ID
, MC.CONCATENATED_SEGMENTS
, CCU.CATEGORY_SET_ID
, MCS.CATEGORY_SET_NAME
, CCU.REQUEST_ID
, LU3.MEANING
, LU4.MEANING
, FCR.COMPLETION_TEXT
, CCU.LAST_UPDATE_DATE
, CCU.LAST_UPDATED_BY
, CCU.CREATION_DATE
, CCU.CREATED_BY
, CCU.LAST_UPDATE_LOGIN
, CCU.PROGRAM_APPLICATION_ID
, CCU.PROGRAM_ID
, CCU.PROGRAM_UPDATE_DATE
, CCU.ROWID
FROM CST_COST_UPDATES CCU
, CST_COST_TYPES CCT
, MTL_CATEGORY_SETS_TL MCS
, MFG_LOOKUPS LRANGE
, MFG_LOOKUPS UPD
, FND_CONCURRENT_REQUESTS FCR
, FND_LOOKUPS LU3
, FND_LOOKUPS LU4
, MTL_ITEM_FLEXFIELDS MSI
, MTL_CATEGORIES_KFV MC
, GL_CODE_COMBINATIONS GCC
WHERE CCT.COST_TYPE_ID = CCU.COST_TYPE_ID
AND MCS.CATEGORY_SET_ID(+) = CCU.CATEGORY_SET_ID
AND NVL(MCS.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND LRANGE.LOOKUP_TYPE(+) = 'CST_ITEM_RANGE'
AND LRANGE.LOOKUP_CODE (+) = CCU.RANGE_OPTION
AND FCR.REQUEST_ID (+) = CCU.REQUEST_ID
AND LU3.LOOKUP_TYPE (+) = 'CP_PHASE_CODE'
AND LU3.LOOKUP_CODE (+) = FCR.PHASE_CODE
AND LU4.LOOKUP_TYPE (+) = 'CP_STATUS_CODE'
AND LU4.LOOKUP_CODE (+) = FCR.STATUS_CODE
AND MSI.INVENTORY_ITEM_ID (+) = CCU.SINGLE_ITEM
AND MSI.ORGANIZATION_ID (+) = CCU.ORGANIZATION_ID
AND MC.CATEGORY_ID (+) = CCU.CATEGORY_ID
AND GCC.CODE_COMBINATION_ID (+) = CCU.INV_ADJUSTMENT_ACCOUNT
AND UPD.LOOKUP_TYPE (+) = 'CST_UPDATE_OPTION'
AND UPD.LOOKUP_CODE(+) = (DECODE(CCU.UPDATE_RESOURCE_OVHD_FLAG
, 1
, 2
, 0) + DECODE(CCU.UPDATE_ACTIVITY_FLAG
, 1
, 1
, 0))

Columns