View: PA_DLVR_TYPE_ACTIONS_V

Product:	PA - Projects
Description:	PA_DLVR_TYPE_ACTIONS_V selects all the attributes of a Deliverable Type Action
Implementation/DBA Data:	APPS.PA_DLVR_TYPE_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
, PPE.STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PSC.SCHEDULED_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
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEM_VER_SCHEDULE PSC
, PA_PROJECT_STATUSES PPS
, PA_OBJECT_RELATIONSHIPS OBJ
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_TYPE_FROM = 'PA_DLVR_TYPES'
AND OBJ.OBJECT_TYPE_TO = 'PA_ACTIONS'
AND OBJ.RELATIONSHIP_TYPE = 'A'

Columns