経費精算アプリの上司向けソース定義

expense_manager_report.sql

select 
    expe.expe_id
    ,expe.expe_justification
    ,expe.expe_amount
    ,expe.expe_status
    ,expe.expe_submitted_by
    ,expe.expe_submitted_on
    ,expe.expe_invoice_dd
    ,expe.expe_purpose
    ,tibx.link_text
    ,tibx.sbfl_prcs_id
    ,tibx.sbfl_step_key
from tuto_expenses expe 
    join flow_task_inbox_vw tibx on expe.expe_id = tibx.sbfl_business_ref 
where tibx.sbfl_dgrm_name = :APP_NAME
    and expe.expe_status = 'submitted' -- 状態はF4Aが管理しているため、この条件は必須ではない
    and tibx.sbfl_current = 'review_expense_mgr'