VIEW: APPS.PA_DLVR_ACTIONS_AMG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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