VIEW: APPS.CST_ITEM_COST_DETAILS_V

Source

View Text - Preformatted

SELECT CICD.ROWID , CICD.INVENTORY_ITEM_ID , CICD.ORGANIZATION_ID , CICD.COST_TYPE_ID , CICD.LAST_UPDATE_DATE , CICD.LAST_UPDATED_BY , CICD.CREATION_DATE , CICD.CREATED_BY , CICD.LAST_UPDATE_LOGIN , CICD.OPERATION_SEQUENCE_ID , CICD.OPERATION_SEQ_NUM , CICD.DEPARTMENT_ID , CICD.LEVEL_TYPE , LU3.MEANING , CICD.ACTIVITY_ID , CA.ACTIVITY , CICD.RESOURCE_SEQ_NUM , CICD.RESOURCE_ID , BR.RESOURCE_CODE , BR.UNIT_OF_MEASURE , CICD.RESOURCE_RATE , CICD.ITEM_UNITS , CICD.ACTIVITY_UNITS , CICD.USAGE_RATE_OR_AMOUNT , CICD.BASIS_TYPE , LU1.MEANING , CICD.BASIS_RESOURCE_ID , CICD.BASIS_FACTOR , CICD.NET_YIELD_OR_SHRINKAGE_FACTOR , CICD.ITEM_COST , CICD.COST_ELEMENT_ID , CCE.COST_ELEMENT , LU2.MEANING , CICD.ROLLUP_SOURCE_TYPE , CICD.ACTIVITY_CONTEXT , CICD.REQUEST_ID , CICD.PROGRAM_APPLICATION_ID , CICD.PROGRAM_ID , CICD.PROGRAM_UPDATE_DATE , CICD.ATTRIBUTE_CATEGORY , CICD.ATTRIBUTE1 , CICD.ATTRIBUTE2 , CICD.ATTRIBUTE3 , CICD.ATTRIBUTE4 , CICD.ATTRIBUTE5 , CICD.ATTRIBUTE6 , CICD.ATTRIBUTE7 , CICD.ATTRIBUTE8 , CICD.ATTRIBUTE9 , CICD.ATTRIBUTE10 , CICD.ATTRIBUTE11 , CICD.ATTRIBUTE12 , CICD.ATTRIBUTE13 , CICD.ATTRIBUTE14 , CICD.ATTRIBUTE15, CICD.YIELDED_COST FROM CST_ITEM_COST_DETAILS CICD , CST_ACTIVITIES CA , BOM_RESOURCES BR , CST_COST_ELEMENTS CCE , MFG_LOOKUPS LU1 , MFG_LOOKUPS LU2 , MFG_LOOKUPS LU3 WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID AND NVL(CA.ORGANIZATION_ID (+), CICD.ORGANIZATION_ID) = CICD.ORGANIZATION_ID AND BR.RESOURCE_ID (+) = CICD.RESOURCE_ID AND CCE.COST_ELEMENT_ID = CICD.COST_ELEMENT_ID AND LU1.LOOKUP_TYPE = 'CST_BASIS' AND LU1.LOOKUP_CODE = CICD.BASIS_TYPE AND LU2.LOOKUP_TYPE = 'CST_SOURCE_TYPE' AND LU2.LOOKUP_CODE = CICD.ROLLUP_SOURCE_TYPE AND LU3.LOOKUP_TYPE = 'CST_LEVEL' AND LU3.LOOKUP_CODE = CICD.LEVEL_TYPE

View Text - HTML Formatted

SELECT CICD.ROWID
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.LAST_UPDATE_DATE
, CICD.LAST_UPDATED_BY
, CICD.CREATION_DATE
, CICD.CREATED_BY
, CICD.LAST_UPDATE_LOGIN
, CICD.OPERATION_SEQUENCE_ID
, CICD.OPERATION_SEQ_NUM
, CICD.DEPARTMENT_ID
, CICD.LEVEL_TYPE
, LU3.MEANING
, CICD.ACTIVITY_ID
, CA.ACTIVITY
, CICD.RESOURCE_SEQ_NUM
, CICD.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.UNIT_OF_MEASURE
, CICD.RESOURCE_RATE
, CICD.ITEM_UNITS
, CICD.ACTIVITY_UNITS
, CICD.USAGE_RATE_OR_AMOUNT
, CICD.BASIS_TYPE
, LU1.MEANING
, CICD.BASIS_RESOURCE_ID
, CICD.BASIS_FACTOR
, CICD.NET_YIELD_OR_SHRINKAGE_FACTOR
, CICD.ITEM_COST
, CICD.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, LU2.MEANING
, CICD.ROLLUP_SOURCE_TYPE
, CICD.ACTIVITY_CONTEXT
, CICD.REQUEST_ID
, CICD.PROGRAM_APPLICATION_ID
, CICD.PROGRAM_ID
, CICD.PROGRAM_UPDATE_DATE
, CICD.ATTRIBUTE_CATEGORY
, CICD.ATTRIBUTE1
, CICD.ATTRIBUTE2
, CICD.ATTRIBUTE3
, CICD.ATTRIBUTE4
, CICD.ATTRIBUTE5
, CICD.ATTRIBUTE6
, CICD.ATTRIBUTE7
, CICD.ATTRIBUTE8
, CICD.ATTRIBUTE9
, CICD.ATTRIBUTE10
, CICD.ATTRIBUTE11
, CICD.ATTRIBUTE12
, CICD.ATTRIBUTE13
, CICD.ATTRIBUTE14
, CICD.ATTRIBUTE15
, CICD.YIELDED_COST
FROM CST_ITEM_COST_DETAILS CICD
, CST_ACTIVITIES CA
, BOM_RESOURCES BR
, CST_COST_ELEMENTS CCE
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, MFG_LOOKUPS LU3
WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID
AND NVL(CA.ORGANIZATION_ID (+)
, CICD.ORGANIZATION_ID) = CICD.ORGANIZATION_ID
AND BR.RESOURCE_ID (+) = CICD.RESOURCE_ID
AND CCE.COST_ELEMENT_ID = CICD.COST_ELEMENT_ID
AND LU1.LOOKUP_TYPE = 'CST_BASIS'
AND LU1.LOOKUP_CODE = CICD.BASIS_TYPE
AND LU2.LOOKUP_TYPE = 'CST_SOURCE_TYPE'
AND LU2.LOOKUP_CODE = CICD.ROLLUP_SOURCE_TYPE
AND LU3.LOOKUP_TYPE = 'CST_LEVEL'
AND LU3.LOOKUP_CODE = CICD.LEVEL_TYPE