View: PA_DLVR_ACTIONS_AMG_V

Product:	PA - Projects
Description:	PA_DLVR_ACTIONS_AMG_V selects all the attributes of a Deliverable Action.
Implementation/DBA Data:	APPS.PA_DLVR_ACTIONS_AMG_V

View Text

SELECT PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPE.DESCRIPTION
, PPF.FULL_NAME
, PPE.MANAGER_PERSON_ID
, PSC.SCHEDULED_FINISH_DATE
, PSC.ACTUAL_FINISH_DATE
, DECODE(PPE.STATUS_CODE
, 'DLVR_COMPLETED'
, 'Y'
, 'N')
, PPE.FUNCTION_CODE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DLVR_ACTION_FUNCTION'
, PPE.FUNCTION_CODE)
, PPE.RECORD_VERSION_NUMBER
, PPE.PM_SOURCE_REFERENCE
, PPE.PM_SOURCE_CODE
, OBJ.OBJECT_ID_FROM2
, DLV.NAME
, DLV.ELEMENT_NUMBER
, PPE.PROJECT_ID
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEM_VER_SCHEDULE PSC
, PA_OBJECT_RELATIONSHIPS OBJ
, PER_ALL_PEOPLE_F PPF
, PA_PROJ_ELEMENTS DLV
WHERE PPE.OBJECT_TYPE = 'PA_ACTIONS'
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPV.PROJECT_ID
AND PSC.ELEMENT_VERSION_ID = PPV.ELEMENT_VERSION_ID
AND PPE.PROJ_ELEMENT_ID = OBJ.OBJECT_ID_TO2
AND OBJ.RELATIONSHIP_TYPE = 'A'
AND OBJ.RELATIONSHIP_SUBTYPE = 'DELIVERABLE_TO_ACTION'
AND PPE.MANAGER_PERSON_ID = PPF.PERSON_ID(+)
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE(+)
AND PPF.EFFECTIVE_END_DATE(+)
AND DLV.OBJECT_TYPE = 'PA_DELIVERABLES'
AND DLV.PROJECT_ID=PPE.PROJECT_ID
AND DLV.PROJ_ELEMENT_ID = OBJ.OBJECT_ID_FROM2

Columns