VIEW: APPS.CST_ACTIVITY_FLEX_COST_VIEW

Source

View Text - Preformatted

SELECT USERENV('SESSIONID') , CICD.INVENTORY_ITEM_ID , CICD.ORGANIZATION_ID , CICD.COST_TYPE_ID , NULL , NULL , NULL , NVL(CICD.ACTIVITY_ID,-1) , NULL , SUM(CICD.ITEM_COST) , NULL , SUM(DECODE(CICD.LEVEL_TYPE, '1',CICD.ITEM_COST,0)) , SUM(DECODE(CICD.LEVEL_TYPE, '2',CICD.ITEM_COST,0)) , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , CA.ATTRIBUTE_CATEGORY , CA.VALUE_ADDED_ACTIVITY_FLAG , CA.ATTRIBUTE1 , CA.ATTRIBUTE2 , CA.ATTRIBUTE3 , CA.ATTRIBUTE4 , CA.ATTRIBUTE5 , CA.ATTRIBUTE6 , CA.ATTRIBUTE7 , CA.ATTRIBUTE8 , CA.ATTRIBUTE9 , CA.ATTRIBUTE10 , CA.ATTRIBUTE11 , CA.ATTRIBUTE12 , CA.ATTRIBUTE13 , CA.ATTRIBUTE14 , CA.ATTRIBUTE15 FROM CST_ITEM_COST_DETAILS CICD , CST_ACTIVITIES CA WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID GROUP BY USERENV('SESSIONID') ,CICD.INVENTORY_ITEM_ID , CICD.ORGANIZATION_ID ,CICD.COST_TYPE_ID , CICD.ACTIVITY_ID , CA.ATTRIBUTE_CATEGORY , CA.ATTRIBUTE1 , CA.ATTRIBUTE2 , CA.ATTRIBUTE3 , CA.ATTRIBUTE4 , CA.ATTRIBUTE5 , CA.ATTRIBUTE6 , CA.ATTRIBUTE7 , CA.ATTRIBUTE8 , CA.ATTRIBUTE9 , CA.ATTRIBUTE10 , CA.ATTRIBUTE11 , CA.ATTRIBUTE12 , CA.ATTRIBUTE13 , CA.ATTRIBUTE14 , CA.ATTRIBUTE15 , CA.VALUE_ADDED_ACTIVITY_FLAG

View Text - HTML Formatted

SELECT USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, NULL
, NULL
, NULL
, NVL(CICD.ACTIVITY_ID
, -1)
, NULL
, SUM(CICD.ITEM_COST)
, NULL
, SUM(DECODE(CICD.LEVEL_TYPE
, '1'
, CICD.ITEM_COST
, 0))
, SUM(DECODE(CICD.LEVEL_TYPE
, '2'
, CICD.ITEM_COST
, 0))
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, CA.ATTRIBUTE_CATEGORY
, CA.VALUE_ADDED_ACTIVITY_FLAG
, CA.ATTRIBUTE1
, CA.ATTRIBUTE2
, CA.ATTRIBUTE3
, CA.ATTRIBUTE4
, CA.ATTRIBUTE5
, CA.ATTRIBUTE6
, CA.ATTRIBUTE7
, CA.ATTRIBUTE8
, CA.ATTRIBUTE9
, CA.ATTRIBUTE10
, CA.ATTRIBUTE11
, CA.ATTRIBUTE12
, CA.ATTRIBUTE13
, CA.ATTRIBUTE14
, CA.ATTRIBUTE15
FROM CST_ITEM_COST_DETAILS CICD
, CST_ACTIVITIES CA
WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID GROUP BY USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.ACTIVITY_ID
, CA.ATTRIBUTE_CATEGORY
, CA.ATTRIBUTE1
, CA.ATTRIBUTE2
, CA.ATTRIBUTE3
, CA.ATTRIBUTE4
, CA.ATTRIBUTE5
, CA.ATTRIBUTE6
, CA.ATTRIBUTE7
, CA.ATTRIBUTE8
, CA.ATTRIBUTE9
, CA.ATTRIBUTE10
, CA.ATTRIBUTE11
, CA.ATTRIBUTE12
, CA.ATTRIBUTE13
, CA.ATTRIBUTE14
, CA.ATTRIBUTE15
, CA.VALUE_ADDED_ACTIVITY_FLAG