[Home] [Help]
95: rpad(count(utiz.utilization_id) ,20, ' ')||
96: rpad(sum(utiz.fund_request_amount),20, ' ')||
97: rpad(utiz.fund_request_currency_code ,20, ' '), utiz.plan_id
98: FROM
99: ozf_offers off,
100: qp_list_headers_all qpl,
101: ozf_funds_utilized_all_b utiz
102: WHERE
103: off.qp_list_header_id = utiz.plan_id
142: UPDATE /* PARALLEL */ ozf_funds_utilized_all_b
143: SET fund_request_amount = plan_curr_amount,
144: fund_request_amount_remaining = plan_curr_amount_remaining,
145: fund_request_currency_code = DECODE(plan_type,'OFFR', (SELECT NVL(transaction_currency_code,fund_request_curr_code)
146: FROM ozf_offers
147: WHERE qp_list_header_id=plan_id)
148: ,'CAMP', (SELECT transaction_currency_code
149: FROM ams_campaigns_vl
150: WHERE campaign_id = plan_id)
183: ,'DM', (SELECT invoice_currency_code
184: FROM ra_customer_trx_all
185: WHERE customer_trx_id = object_id)
186: ,(SELECT NVL(transaction_currency_code,fund_request_curr_code)
187: FROM ozf_offers
188: WHERE qp_list_header_id=plan_id)
189: )
190: ,'CAMP', (SELECT transaction_currency_code
191: FROM ams_campaigns_vl
251: plan_curr_amount_remaining,
252: exchange_rate
253: FROM ozf_funds_utilized_all_b
254: WHERE NVL(plan_curr_amount,0) <> 0
255: AND plan_currency_code <> (SELECT fund_request_curr_code FROM ozf_offers WHERE qp_list_header_id=plan_id AND transaction_currency_code IS NULL)
256: AND plan_type='OFFR'
257: AND last_updated_by = -2);
258:
259: IF p_debug_flag = 'Y' THEN
267: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount_remaining,-1),
268: exchange_rate = gl_currency_api.get_closest_rate(plan_currency_code,get_functional_curr(org_id),exchange_rate_date,exchange_rate_type,0),
269: last_updated_by = -2,
270: last_update_date = sysdate
271: WHERE plan_currency_code <> (SELECT fund_request_curr_code FROM ozf_offers WHERE qp_list_header_id=plan_id AND transaction_currency_code IS NULL)
272: AND NVL(plan_curr_amount,0) <> 0
273: AND plan_type='OFFR'
274: AND last_updated_by = -2;
275: