SELECT /*+ INDEX PA_PROJECTS_U2 */ A.PROJECT_ID ,A.PROJECT_NUMBER ,A.PROJECT_NAME ,A.START_DATE ,A.COMPLETION_DATE ,A.PROJECT_CURRENCY_CODE ,A.PROJECT_OU ,A.PROJECT_TYPE_CLASS_CODE ,A.PROJECT_DESCRIPTION ,A.PROJFUNC_CURRENCY_CODE FROM PA_PROJECTS_EXPEND_V A WHERE A.PROJECT_TYPE<> 'AWARD_PROJECT' GROUP BY A.PROJECT_ID ,A.PROJECT_NUMBER ,A.PROJECT_NAME ,A.START_DATE ,A.COMPLETION_DATE ,A.PROJECT_CURRENCY_CODE ,A.PROJECT_OU ,A.PROJECT_TYPE_CLASS_CODE ,A.PROJECT_DESCRIPTION ,A.PROJFUNC_CURRENCY_CODE
SELECT /*+ INDEX PA_PROJECTS_U2 */ A.PROJECT_ID
, A.PROJECT_NUMBER
, A.PROJECT_NAME
, A.START_DATE
, A.COMPLETION_DATE
, A.PROJECT_CURRENCY_CODE
, A.PROJECT_OU
, A.PROJECT_TYPE_CLASS_CODE
, A.PROJECT_DESCRIPTION
, A.PROJFUNC_CURRENCY_CODE
FROM PA_PROJECTS_EXPEND_V A
WHERE A.PROJECT_TYPE<> 'AWARD_PROJECT' GROUP BY A.PROJECT_ID
, A.PROJECT_NUMBER
, A.PROJECT_NAME
, A.START_DATE
, A.COMPLETION_DATE
, A.PROJECT_CURRENCY_CODE
, A.PROJECT_OU
, A.PROJECT_TYPE_CLASS_CODE
, A.PROJECT_DESCRIPTION
, A.PROJFUNC_CURRENCY_CODE
|
|
|