Customer Data

Dear All,

im trying to build a query to list all the customer in a selected date , currency and Operating unit

i takes to much time to run, the result is correct but i want to optimize it so it will take less time to run

the query in the procedure is :

CREATE OR REPLACE PROCEDURE XX_CUST_LIST(  P_ORG_ID number ,P_CUSTOMER_NUM char,  p_currency_code char , P_TRX_FROM_DATE char  ,P_TRX_TO_DATE char ) IS

cust_num varchar2(100);

cust_name varchar2(100);

k number(38) :=0;

CURSOR C_CUST is

select

cust.rac_bill_to_customer_num ,