Cost Budget Approval - Pending with Query

https://oracleprojectsebs.blogspot.com/2025/08/cost-budget-approval-pending-with-query.html

select distinct a.project_id,

                a.project_number,

                a.project_name,

                c.version_number,

                c.version_name,

                c.change_reason_code,

                c.budget_status_code,

                a.itemtype,

                a.itemkey,

                decode(wf_directory.getroledisplayname2(b.ASSIGNED_USER),

                       null,

                       'ERROR,No Approver Found',

                       wf_directory.getroledisplayname2(b.ASSIGNED_USER)

                       

                       )AS PENDING_WITH

                       --,b.*,c.*

                       -- wf_directory.getroledisplayname2(b.ASSIGNED_USER) AS PENDING_WITH

  from Xxfin.Xxpa_Budget_Notification a,

       WF_ITEM_ACTIVITY_STATUSES      b,

       pa_budget_versions             c

 where a.itemtype = b.item_type

   and a.itemkey = b.item_key

   and a.project_id = c.project_id

   AND c.budget_status_code = 'S'

   and b.activity_status in ('NOTIFIED', 'ERROR')

   and c.version_type='COST'

-- and a.itemkey ='40968' --'39566' --'40036'

-- a.project_name = '210048'

--and a.project_id = 24962

--select * from pa_projects_all p where p.segment1='230044'