VIEW: APPS.CST_COST_UPDATES_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))