eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_DLVR_TYPE_ACTIONS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'