VIEW: APPS.CST_DETAIL_COSTS_FOR_GL_VIEW

Source

View Text - Preformatted

SELECT CICD.INVENTORY_ITEM_ID, MP.ORGANIZATION_ID, MP.COST_ORGANIZATION_ID, CICD.COST_TYPE_ID, CICD.OPERATION_SEQUENCE_ID, CICD.OPERATION_SEQ_NUM, CICD.DEPARTMENT_ID, CICD.LEVEL_TYPE, CICD.ACTIVITY_ID, CICD.RESOURCE_SEQ_NUM, CICD.RESOURCE_ID, CICD.RESOURCE_RATE, CICD.ITEM_UNITS, CICD.ACTIVITY_UNITS, CICD.USAGE_RATE_OR_AMOUNT, CICD.BASIS_TYPE, CICD.BASIS_RESOURCE_ID, CICD.BASIS_FACTOR, CICD.NET_YIELD_OR_SHRINKAGE_FACTOR, CICD.ITEM_COST, CICD.COST_ELEMENT_ID, CICD.ROLLUP_SOURCE_TYPE, CICD.ACTIVITY_CONTEXT, 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 FROM CST_ITEM_COST_DETAILS CICD,MTL_PARAMETERS MP WHERE CICD.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID AND CICD.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

View Text - HTML Formatted

SELECT CICD.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
, MP.COST_ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.OPERATION_SEQUENCE_ID
, CICD.OPERATION_SEQ_NUM
, CICD.DEPARTMENT_ID
, CICD.LEVEL_TYPE
, CICD.ACTIVITY_ID
, CICD.RESOURCE_SEQ_NUM
, CICD.RESOURCE_ID
, CICD.RESOURCE_RATE
, CICD.ITEM_UNITS
, CICD.ACTIVITY_UNITS
, CICD.USAGE_RATE_OR_AMOUNT
, CICD.BASIS_TYPE
, CICD.BASIS_RESOURCE_ID
, CICD.BASIS_FACTOR
, CICD.NET_YIELD_OR_SHRINKAGE_FACTOR
, CICD.ITEM_COST
, CICD.COST_ELEMENT_ID
, CICD.ROLLUP_SOURCE_TYPE
, CICD.ACTIVITY_CONTEXT
, 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
FROM CST_ITEM_COST_DETAILS CICD
, MTL_PARAMETERS MP
WHERE CICD.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
AND CICD.COST_TYPE_ID = MP.PRIMARY_COST_METHOD