Product: | PA - Projects |
---|---|
Description: | View of Items linked with Project or Task |
Implementation/DBA Data: | Not implemented in this database |
SELECT ITEM_PROJECTS.ITEM_PROJECT_ID
, ITEM_PROJECTS.ITEM_ID
, ITEM_PROJECTS.PROJECT_ID
, ITEM_PROJECTS.TASK_ID
, ITEM_PROJECTS.ASSOCIATION_TYPE
, ITEM_PROJECTS.ASSOCIATION_DESCRIPTION
, ITEM_PROJECTS.CREATED_BY
, ITEM_PROJECTS.CREATION_DATE
, ITEM_PROJECTS.LAST_UPDATED_BY
, ITEM_PROJECTS.LAST_UPDATE_DATE
, ITEM_PROJECTS.LAST_UPDATE_LOGIN
, ITEMS.A1
, ITEMS.A3
, ITEMS_TL.A7
, ITEM_PROJECTS.REVISION_ID
, ITEMS_TL.LANGUAGE
, ITEMS_TL.SOURCE_LANG
FROM IPD_ITEM_PROJECTS_VL ITEM_PROJECTS
, ICX_POR_ITEMS ITEMS
, ICX_POR_ITEMS_TL ITEMS_TL
WHERE ITEM_PROJECTS.ITEM_ID = ITEMS.RT_ITEM_ID
AND ITEMS.RT_ITEM_ID = ITEMS_TL.RT_ITEM_ID