Product: | PA - Projects |
---|---|
Description: | Only - Retrofitted |
Implementation/DBA Data: | APPS.PA_EGO_LIFECYCLES_V |
SELECT PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, PPEV.ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE
, PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.CREATION_DATE
, PPE.CREATED_BY
, PPE.LAST_UPDATE_DATE
, PPE.LAST_UPDATED_BY
, PPE.LAST_UPDATE_LOGIN
, PPE.DESCRIPTION
, PPE.PHASE_CODE
, PPEV.DISPLAY_SEQUENCE
, PPEV.WBS_LEVEL
, PPEV.WBS_NUMBER
, PLU.LIFECYCLE_USAGE_ID
, PLU.USAGE_TYPE FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_LIFECYCLE_USAGES PLU
WHERE PPE.PROJECT_ID = 0
AND PPE.OBJECT_TYPE = 'PA_STRUCTURES'AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPE.PROJ_ELEMENT_ID = PLU.LIFECYCLE_ID
AND PLU.USAGE_TYPE = 'PRODUCTS'