View: PA_CP_ASSET_NAMES_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_CP_ASSET_NAMES_V

View Text

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))

Columns