SELECT
substr(ti.batch_name,1,20) batch
, substr(ti.batch_name,1,20) batch_name
, NVL(pa_utils3.GetEmpNum(ti.person_id),ti.employee_number) employee_number
, substr(NVL(pa_utils.GetOrgName(ti.organization_id),ti.organization_name),1, 60) organization_name
, ti.expenditure_item_date
, ti.expenditure_type
, NVL(pa_utils3.getcachedprojnum(ti.PROJECT_ID),ti.project_number) project_number
, NVL(pa_utils3.getcachedtasknum(ti.TASK_ID),ti.task_number) task_number
, ti.non_labor_resource
, ti.transaction_rejection_code
, DECODE(ti.transaction_status_code, 'PR', 1, 'R', 2, 3) sort_c
FROM
pa_transaction_interface_all ti
WHERE
ti.transaction_status_code IN ('R', 'PR', 'PO')
AND ti.transaction_rejection_code IS NOT NULL
AND ti.batch_name = NVL( :P_batch_name, ti.batch_name )
AND ti.interface_id = :P_xface_id
AND ((mo_global.get_current_org_id IS NULL AND mo_global.check_access(ti.org_id) = 'Y')
OR ( mo_global.get_current_org_id is NOT NULL and ti.org_id = mo_global.get_current_org_id ))
GROUP BY
ti.transaction_status_code
, ti.batch_name
, ti.batch_name
, NVL(pa_utils3.GetEmpNum(ti.person_id),ti.employee_number)
, NVL(pa_utils.GetOrgName(ti.organization_id),ti.organization_name)
, ti.expenditure_item_date
, ti.expenditure_type
, NVL(pa_utils3.getcachedprojnum(ti.PROJECT_ID),ti.project_number)
, NVL(pa_utils3.getcachedtasknum(ti.TASK_ID),ti.task_number)
, ti.non_labor_resource
, ti.transaction_rejection_code
, ti.ROWID
ORDER BY sort_c |