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_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 ,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(+)

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
, 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(+)