VIEW: APPS.PJM_PROJECT_COST_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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