SELECT DISTINCT AA. PROJECT_ID , AA.TASK_ID , 0 , MEANING , SYSDATE , NULL , 0 , NULL FROM FND_LOOKUP_VALUES L , PA_PROJECT_ASSET_ASSIGNMENTS AA WHERE L.LOOKUP_TYPE = 'UNASSIGNED ASSET' AND L.LOOKUP_CODE = 'UNASSIGNED' AND L.VIEW_APPLICATION_ID = 275 AND L.LANGUAGE = USERENV('LANG') UNION ALL SELECT AA.PROJECT_ID , AA.TASK_ID , A.PROJECT_ASSET_ID , A.ASSET_NAME , A.DATE_PLACED_IN_SERVICE , A.PROJECT_ASSET_TYPE , A.CAPITAL_EVENT_ID , A.CAPITAL_HOLD_FLAG FROM PA_PROJECT_ASSETS A , PA_PROJECT_ASSET_ASSIGNMENTS AA WHERE (A.PROJECT_ASSET_ID = AA.PROJECT_ASSET_ID) UNION ALL SELECT AA.PROJECT_ID , AA.TASK_ID , A.PROJECT_ASSET_ID , A.ASSET_NAME , A.DATE_PLACED_IN_SERVICE , A.PROJECT_ASSET_TYPE , A.CAPITAL_EVENT_ID , A.CAPITAL_HOLD_FLAG FROM PA_PROJECT_ASSETS A , PA_PROJECT_ASSET_ASSIGNMENTS AA WHERE (AA.PROJECT_ASSET_ID = 0 AND AA.PROJECT_ID = A.PROJECT_ID)