R12: Expenditure Inquiry Form Performance Issue (Doc ID 2563687.1)

SELECT EXPENDITURE_ITEM_ID,PROJECT_NUMBER,TASK_NUMBER,EXPENDITURE_TYPE,
  INVENTORY_ITEM,WIP_RESOURCE,EXPENDITURE_ITEM_DATE,QUANTITY,
  UNIT_OF_MEASURE_M,PROJECT_CURRENCY_CODE,BURDENED_COST,PROJECT_BURDENED_COST,
  ACCRUED_REVENUE,BILL_AMOUNT,EXPENDITURE_COMMENT,
  EXPENDITURE_ORGANIZATION_NAME,NON_LABOR_RESOURCE,WORK_TYPE_NAME,
  ASSIGNMENT_NAME,NLR_ORGANIZATION_NAME,DENOM_CURRENCY_CODE,DENOM_RAW_COST,
  DENOM_BURDENED_COST,ACCT_CURRENCY_CODE,ACCT_RATE_TYPE,USER_ACCT_RATE_TYPE,
  ACCT_RATE_DATE,ACCT_EXCHANGE_RATE,ACCT_RAW_COST,ACCT_BURDENED_COST,
  PROJECT_RATE_TYPE,USER_PROJFUNC_COST_RATE_TYPE,PROJFUNC_COST_RATE_TYPE,
  USER_PROJECT_RATE_TYPE,PROJECT_RATE_DATE,PROJFUNC_COST_RATE_DATE,
  PROJECT_EXCHANGE_RATE,PROJFUNC_COST_EXCHANGE_RATE,RECEIPT_CURRENCY_CODE,
  RECEIPT_CURRENCY_AMOUNT,RECEIPT_EXCHANGE_RATE,ACCT_EXCHANGE_ROUNDING_LIMIT,
  BILL_RATE,COST_DISTRIBUTED_FLAG,BILLABLE_FLAG,RAW_COST,PROJECT_RAW_COST,
  RAW_COST_RATE,COST_DIST_REJECTION_CODE,BURDENED_COST_RATE,
  LABOR_COST_MULTIPLIER_NAME,RAW_REVENUE,ACCRUAL_RATE,ADJUSTED_REVENUE,
  ADJUSTED_RATE,FORECAST_REVENUE,BILL_RATE_MULTIPLIER,PROJECT_NAME,
  PROJECT_TYPE,TASK_NAME,EXPENDITURE_CATEGORY,REVENUE_CATEGORY_CODE,
  EMPLOYEE_NAME,EMPLOYEE_NUMBER,JOB_NAME,USER_TRANSACTION_SOURCE,
  EXPENDITURE_GROUP,BILL_JOB_BILLING_TITLE,BILL_EMPLOYEE_BILLING_TITLE,
  NET_ZERO_ADJUSTMENT_FLAG,CONVERTED_FLAG,TRANSFERRED_ITEM_FLAG,
  COST_BURDEN_DISTRIBUTED_FLAG,CAPITALIZABLE_FLAG,GROUPED_CIP_FLAG,
  ALLOW_ADJUSTMENTS_FLAG,GL_ACCOUNTED_FLAG,ALLOW_BURDEN_FLAG,
  ALLOW_BURDEN_FLAG,COSTED_FLAG,PROJECT_STATUS_CODE,ROW_ID,EXPENDITURE_ID,
  PROJECT_ID,WIP_RESOURCE_ID,INVENTORY_ITEM_ID,WORK_TYPE_ID,ASSIGNMENT_ID,
  PROJECT_TYPE_CLASS_CODE,TASK_ID,INCURRED_BY_PERSON_ID,JOB_ID,
  INCURRED_BY_ORGANIZATION_ID,OVERRIDE_TO_ORGANIZATION_ID,VENDOR_ID,
  EXPENDITURE_ORGANIZATION_ID,BURDEN_SUM_DEST_RUN_ID,NLR_ORGANIZATION_ID,
  SYSTEM_LINKAGE_FUNCTION,ORIG_TRANSACTION_REFERENCE,ORIG_EXP_TXN_REFERENCE1,
  ORIG_EXP_TXN_REFERENCE2,ORIG_EXP_TXN_REFERENCE3,ORIG_USER_EXP_TXN_REFERENCE,
  EXPENDITURE_STATUS_CODE,EXPENDITURE_ENDING_DATE,UNIT_OF_MEASURE,
  IND_COST_DIST_REJECTION_CODE,COST_IND_COMPILED_SET_ID,
  REVENUE_DISTRIBUTED_FLAG,REV_DIST_REJECTION_CODE,REV_IND_COMPILED_SET_ID,
  INV_IND_COMPILED_SET_ID,EVENT_NUM,TRANSACTION_SOURCE,EVENT_TASK_ID,
  BILL_HOLD_FLAG,REVENUE_HOLD_FLAG,ADJUSTED_EXPENDITURE_ITEM_ID,

  LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
  ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,
  ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ORG_ID,
  EXPENDITURE_ORG_ID,CC_PRVDR_ORGANIZATION_NAME,PRVDR_ORG_NAME,
  CC_RECVR_ORGANIZATION_NAME,RECVR_ORG_NAME,PRVDR_ACCRUAL_DATE,
  RECVR_ACCRUAL_DATE,CC_PRVDR_ORGANIZATION_ID,PRVDR_ORG_ID,
  CC_RECVR_ORGANIZATION_ID,RECVR_ORG_ID,CC_CROSS_CHARGE_CODE,
  CC_CROSS_CHARGE_TYPE,CC_BL_DISTRIBUTED_CODE,CC_IC_PROCESSED_CODE,
  CC_REJECTION_CODE,DENOM_TRANSFER_PRICE,ACCT_TRANSFER_PRICE,
  PROJFUNC_TRANSFER_PRICE,DENOM_TP_CURRENCY_CODE,ACCT_TP_RATE_TYPE,
  USER_ACCT_TP_RATE_TYPE,ACCT_TP_RATE_DATE,ACCT_TP_EXCHANGE_RATE,cost_job_id,
  prov_proj_bill_job_id,tp_job_id,bill_job_id,cost_job_name,
  prov_proj_bill_job_name,tp_job_name,bill_job_name,
  bill_trans_forecast_curr_code,BILL_TRANS_FORECAST_REVENUE,
  BILL_TRANS_CURRENCY_CODE,BILL_TRANS_RAW_REVENUE,BILL_TRANS_BILL_AMOUNT,
  PROJECT_RAW_REVENUE,PROJECT_BILL_AMOUNT,PROJFUNC_CURRENCY_CODE,
  PROJFUNC_RAW_REVENUE,PROJFUNC_BILL_AMOUNT,INVPROC_CURRENCY_CODE,
  TP_AMT_TYPE_CODE,PROJECT_TP_RATE_TYPE,USER_PROJECT_TP_RATE_TYPE,
  PROJECT_TP_RATE_DATE,PROJECT_TP_EXCHANGE_RATE,PROJECT_TRANSFER_PRICE,
  PROJFUNC_TP_RATE_TYPE,USER_PROJFUNC_TP_RATE_TYPE,PROJFUNC_TP_RATE_DATE,
  PROJFUNC_TP_EXCHANGE_RATE,RETIREMENT_COST_FLAG,CAPITAL_EVENT_NUMBER,
  LATEST_GL_DATE,LATEST_PA_DATE,LATEST_RECVR_PA_DATE,LATEST_RECVR_GL_DATE,
  LATEST_PA_PERIOD_NAME,LATEST_GL_PERIOD_NAME,LATEST_RECVR_PA_PERIOD_NAME,
  LATEST_RECVR_GL_PERIOD_NAME,GROUPED_RWIP_FLAG,MRC_BURDENED_COST_RATE,
  MRC_RAW_COST_RATE,MRC_RAW_REVENUE,MRC_BILL_RATE,MRC_ACCRUED_REVENUE,
  MRC_ACCRUAL_RATE,MRC_ADJUSTED_REVENUE,MRC_ADJUSTED_RATE,MRC_BILL_AMOUNT,
  MRC_FORECAST_REVENUE,MRC_ACCT_CURRENCY_CODE,MRC_ACCT_RATE_DATE,
  MRC_ACCT_RATE_TYPE,MRC_USER_ACCT_RATE_TYPE,MRC_ACCT_EXCHANGE_RATE,
  MRC_ACCT_RAW_COST,MRC_ACCT_BURDENED_COST,MRC_ACCT_TP_RATE_TYPE,
  MRC_USER_ACCT_TP_RATE_TYPE,MRC_ACCT_TP_RATE_DATE,MRC_ACCT_TP_EXCHANGE_RATE,
  MRC_ACCT_TRANSFER_PRICE,PO_NUMBER,PO_LINE_NUMBER,PO_PRICE_TYPE_M,
  PA_PERSON_TYPE_M,PO_LINE_ID,PERSON_TYPE,PO_PRICE_TYPE,DOCUMENT_HEADER_ID,
  DOCUMENT_LINE_NUMBER,DOCUMENT_DISTRIBUTION_ID,DOCUMENT_PAYMENT_ID,
  DOCUMENT_TYPE,DOCUMENT_DISTRIBUTION_TYPE,EXPENSED,PROVIDER_LE_NAME,
  RECEIVER_LE_NAME,ADD_INV_GROUP,BILL_GROUP
FROM
 (select * from PA_EXPEND_ITEMS_ADJUST2_V where project_id in (select
  project_id from pa_projects_v_paxtrape)) pa_expend_items_adjust2_v WHERE
  (INCURRED_BY_PERSON_ID=:1) and (ORG_ID=:2) and (LATEST_RECVR_GL_DATE  
  BETWEEN to_date('2018/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS') AND
  to_date('2018/01/31 23:59:59', 'YYYY/MM/DD HH24:MI:SS')) order by
  EXPENDITURE_ITEM_ID, expenditure_item_date, task_id, expenditure_id,
  NVL(source_expenditure_item_id, NVL (adjusted_expenditure_item_id,
  NVL(transferred_from_exp_item_id, expenditure_item_id))),
  expenditure_item_id