View: PA_DLVR_ACTIONS_V

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

View Text

SELECT PPE.ELEMENT_NUMBER
, PPE.NAME
, PPE.DESCRIPTION
, PPE.OBJECT_TYPE
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPV.ELEMENT_VERSION_ID
, PPF.PERSON_ID
, PPE.STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PSC.SCHEDULED_FINISH_DATE
, PSC.ACTUAL_FINISH_DATE
, PPE.FUNCTION_CODE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_DLVR_ACTION_FUNCTION'
, PPE.FUNCTION_CODE)
, PPE.RECORD_VERSION_NUMBER
, PPV.RECORD_VERSION_NUMBER
, OBJ.OBJECT_ID_FROM2
, OBJ.OBJECT_ID_FROM1
, OBJ.RECORD_VERSION_NUMBER
, OBJ.OBJECT_RELATIONSHIP_ID
, OBJ.OBJECT_TYPE_FROM
, PPF.FULL_NAME
, PPE.ATTRIBUTE_CATEGORY
, PPE.ATTRIBUTE1
, PPE.ATTRIBUTE2
, PPE.ATTRIBUTE3
, PPE.ATTRIBUTE4
, PPE.ATTRIBUTE5
, PPE.ATTRIBUTE6
, PPE.ATTRIBUTE7
, PPE.ATTRIBUTE8
, PPE.ATTRIBUTE9
, PPE.ATTRIBUTE10
, PPE.ATTRIBUTE11
, PPE.ATTRIBUTE12
, PPE.ATTRIBUTE13
, PPE.ATTRIBUTE14
, PPE.ATTRIBUTE15
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEM_VER_SCHEDULE PSC
, PA_PROJECT_STATUSES PPS
, PA_OBJECT_RELATIONSHIPS OBJ
, PER_ALL_PEOPLE_F PPF
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.STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PPE.PROJ_ELEMENT_ID = OBJ.OBJECT_ID_TO2
AND OBJ.OBJECT_ID_TO1 = PPV.ELEMENT_VERSION_ID
AND OBJ.OBJECT_TYPE_FROM = 'PA_DELIVERABLES'
AND OBJ.OBJECT_TYPE_TO = 'PA_ACTIONS'
AND OBJ.RELATIONSHIP_TYPE = 'A'
AND PPE.MANAGER_PERSON_ID = PPF.PERSON_ID(+)
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE(+)
AND PPF.EFFECTIVE_END_DATE(+)

Columns