Product: | PA - Projects |
---|---|
Description: | Single currency MRC view |
Implementation/DBA Data: | Not implemented in this database |
SELECT MC.PROJ_ASSET_LINE_DTL_UNIQ_ID
, MC.CIP_COST
, PA.EXPENDITURE_ITEM_ID
, PA.LINE_NUM
, PA.PROJECT_ASSET_LINE_DETAIL_ID
, PA.REVERSED_FLAG
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.CREATED_BY
, PA.CREATION_DATE
, PA.LAST_UPDATE_LOGIN
, PA.REQUEST_ID
, PA.PROGRAM_APPLICATION_ID
, PA.PROGRAM_ID
, PA.PROGRAM_UPDATE_DATE
FROM PA_PROJECT_ASSET_LINE_DETAILS PA
, PA_MC_PRJ_AST_LINE_DTLS MC
WHERE PA.PROJ_ASSET_LINE_DTL_UNIQ_ID = MC.PROJ_ASSET_LINE_DTL_UNIQ_ID
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)