Item cost test
Description
SELECT ROW_ID,ITEM_NUMBER,COST_TYPE,DEFAULTED_FLAG,INVENTORY_ASSET,BASED_ON_ROLLUP,LOT_SIZE,SHRINKAGE_RATE,ITEM_COST,MATERIAL_COST,MATERIAL_OVERHEAD_COST,RESOURCE_COST,OUTSIDE_PROCESSING_COST,OVERHEAD_COST,PLANNING_MAKE_BUY_CODE,DEFAULT_INCLUDE_IN_ROLLUP_FLAG,DESCRIPTION,PRIMARY_UOM_CODE,COST_TYPE_DESCRIPTION,DEFAULT_COST_TYPE,INVENTORY_ITEM_ID,ORGANIZATION_ID,COST_TYPE_ID,DEFAULT_COST_TYPE_ID,ALLOW_UPDATES_FLAG,FROZEN_STANDARD_FLAG,COST_OF_SALES_ACCOUNT,SALES_ACCOUNT,CATEGORY_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,ATTRIBUTE_CATEGORY,LAST_UPDATE_LOGIN,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE FROM CST_ITEM_COST_TYPE_V WHERE organization_id = 207 and Organization_Id = 207 AND -1=-1 AND -1=-1 /*and (INVENTORY_ITEM_ID=:3) */ order by PADDED_ITEM_NUMBER,COST_TYPE |