VIEW: APPS.PA_CP_ASSET_NAMES_V

Source

View Text - Preformatted

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 OR (aa.project_asset_id = 0 AND aa.project_id = a.project_id))

View Text - HTML Formatted

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 OR (AA.PROJECT_ASSET_ID = 0
AND AA.PROJECT_ID = A.PROJECT_ID))