View: PJM_PROJECT_COST_HISTORY_V

Product:	PJM - Project Manufacturing
Description:	Item cost history information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_COST_HISTORY_V

View Text

SELECT CCCHV.INVENTORY_ITEM_ID
, CCCHV.TRANSACTION_ID
, CCCHV.ORGANIZATION_ID
, CCCHV.LAYER_ID
, CCCHV.TRANSACTION_COSTED_DATE
, CCCHV.TRANSACTION_DATE
, CCCHV.PRIOR_COSTED_QUANTITY
, CCCHV.PRIMARY_QUANTITY
, CCCHV.NEW_QUANTITY
, COST_GROUP_ID
, CCCHV.TRANSACTION_TYPE
, ROUND( CCCHV.ACTUAL_COST
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.ACTUAL_MATERIAL
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.ACTUAL_MATERIAL_OVERHEAD
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.ACTUAL_RESOURCE
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.ACTUAL_OUTSIDE_PROCESSING
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.ACTUAL_OVERHEAD
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.PRIOR_COST
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.PRIOR_MATERIAL
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.PRIOR_MATERIAL_OVERHEAD
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.PRIOR_RESOURCE
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.PRIOR_OUTSIDE_PROCESSING
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.PRIOR_OVERHEAD
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.NEW_COST
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.NEW_MATERIAL
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.NEW_MATERIAL_OVERHEAD
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.NEW_RESOURCE
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.NEW_OUTSIDE_PROCESSING
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, ROUND( CCCHV.NEW_OVERHEAD
, NVL( CURR.EXTENDED_PRECISION
, NVL( CURR.PRECISION
, 0 ) ) )
, CCCHV.CHANGE
FROM CST_CG_COST_HISTORY_V CCCHV
, HR_ORGANIZATION_INFORMATION ORGINFO
, GL_SETS_OF_BOOKS SOB
, FND_CURRENCIES CURR
WHERE ORGINFO.ORGANIZATION_ID = CCCHV.ORGANIZATION_ID
AND ORGINFO.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
AND SOB.SET_OF_BOOKS_ID = TO_NUMBER(ORGINFO.ORG_INFORMATION1)
AND CURR.CURRENCY_CODE = SOB.CURRENCY_CODE

Columns