The blog provides the Oracle Apps R12 SQL Query to retrieve the Oracle Projects rejected Purchase Order based on Project_id and Task_id parameters

SELECT PO_HEADERS_ALL_TBL.SEGMENT1,
       PO_HEADERS_ALL_TBL.AUTHORIZATION_STATUS,
       PO_HEADERS_ALL_TBL.CREATION_DATE,
       PO_HEADERS_ALL_TBL.LAST_UPDATE_DATE,
       (SELECT PA_PROJECTS_ALL_TBL.SEGMENT1
        FROM   APPS.PA_PROJECTS_ALL_TBL_PROJECTS_ALL PA_PROJECTS_ALL_TBL
        WHERE  PA_PROJECTS_ALL_TBL.PROJECT_ID = PO_DIST_ALL_TBL.PROJECT_ID) PROJECT_NAME,
       (SELECT TASK_NAME
        FROM   APPS.PA_PROJECTS_ALL_TBL_TASKS PA_PROJECTS_ALL_TBL_TASKS_TBL
        WHERE  PA_PROJECTS_ALL_TBL_TASKS_TBL.PROJECT_ID = PO_DIST_ALL_TBL.PROJECT_ID
               AND PA_PROJECTS_ALL_TBL_TASKS_TBL.TASK_ID = PO_DIST_ALL_TBL.TASK_ID)   TASK_NAME
FROM   APPS.PO_HEADERS_ALL PO_HEADERS_ALL_TBL,
       APPS.PO_LINES_ALL PO_LINES_ALL_TBL,
       APPS.PO_DISTRIBUTIONS_ALL PO_DIST_ALL_TBL
WHERE  PO_HEADERS_ALL_TBL.PO_HEADER_ID = PO_LINES_ALL_TBL.PO_HEADER_ID
       AND PO_LINES_ALL_TBL.PO_LINE_ID = PO_DIST_ALL_TBL.PO_LINE_ID
       AND PO_HEADERS_ALL_TBL.LAST_UPDATE_DATE > SYSDATE - 60
       AND PO_HEADERS_ALL_TBL.AUTHORIZATION_STATUS IN ( 'IN PROCESS', 'REJECTED' )
ORDER  BY LAST_UPDATE_DATE DESC