We have ORC Offers Transactions Report but need to add country column for below query ?

Summary:

Hi Team,

We have ORC Offers Transactions Report but need to add country column for ?

Content (please ensure you mask any confidential information):

select

a.OBJECT_NAME as Transaction_Name,

b.attribute1 as T_Name,

a.PROCESS_CATEGORY as process_type,

--a.STATUS_CATEGORY as status,

b.SUBMITTED_BY as submitted_by,

TO_CHAR(b.SUBMITTED_DATE,'MM/DD/YYYY') as sub_date,

TO_CHAR(b.COMPLETED_DATE,'MM/DD/YYYY') as transaction_completed_date,

b.STATUS as txn_status,

--tc.STATE,

tc.ASSIGNEDDATE,

tc.ASSIGNEESDISPLAYNAME,

ic.CANDIDATE_NUMBER,

ISub.REQUISITION_ID,

irv.requisition_number AS Requisition_Number,

irv.title AS Requisition_Name,