eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 471: FROM ozf_funds_utilized_all_b a1

467: FROM (SELECT a1.fund_id parent_source
468: ,a1.currency_code parent_curr
469: ,SUM(NVL(a1.amount, 0)) amount
470: ,SUM(NVL(a1.acctd_amount,0)) acctd_amount
471: FROM ozf_funds_utilized_all_b a1
472: WHERE a1.component_id = p_budget_source_id
473: AND a1.component_type = p_budget_source_type
474: AND a1.utilization_type NOT IN
475: ('ADJUSTMENT', 'ACCRUAL', 'UTILIZED', 'SALES_ACCRUAL', 'CHARGEBACK')

Line 482: FROM ozf_funds_utilized_all_b a2

478: SELECT a2.fund_id parent_source
479: ,a2.currency_code parent_curr
480: ,-SUM(NVL(a2.amount, 0)) amount,
481: -SUM(NVL(a2.acctd_amount,0)) acctd_amount
482: FROM ozf_funds_utilized_all_b a2
483: WHERE a2.plan_id = p_budget_source_id
484: AND a2.plan_type =p_budget_source_type
485: GROUP BY a2.fund_id, a2.currency_code)
486: GROUP BY parent_source, parent_curr

Line 498: FROM ozf_funds_utilized_all_b a1

494:
495: /*
496: SELECT SUM(acctd_amount) total_acctd_amount
497: FROM (SELECT SUM(NVL(a1.acctd_amount,0)) acctd_amount
498: FROM ozf_funds_utilized_all_b a1
499: WHERE a1.component_id = p_budget_source_id
500: AND a1.component_type =p_budget_source_type
501: AND a1.utilization_type NOT IN
502: ('ADJUSTMENT', 'ACCRUAL', 'UTILIZED', 'SALES_ACCRUAL', 'CHARGEBACK')

Line 505: FROM ozf_funds_utilized_all_b a2

501: AND a1.utilization_type NOT IN
502: ('ADJUSTMENT', 'ACCRUAL', 'UTILIZED', 'SALES_ACCRUAL', 'CHARGEBACK')
503: UNION
504: SELECT -SUM(NVL(a2.acctd_amount,0)) acctd_amount
505: FROM ozf_funds_utilized_all_b a2
506: WHERE a2.plan_id = p_budget_source_id
507: AND a2.plan_type = p_budget_source_type);
508: */
509: l_parent_source_rec c_parent_source%ROWTYPE;

Line 2381: FROM ozf_funds_utilized_all_b

2377: /*
2378: SELECT SUM (approved_amount) approved_amount, fund_id, currency_code
2379: FROM (
2380: SELECT NVL(plan_curr_amount,0) approved_amount, fund_id, currency_code
2381: FROM ozf_funds_utilized_all_b
2382: WHERE utilization_type = 'REQUEST'
2383: AND component_type = 'OFFR'
2384: AND component_id = p_offer_id
2385: UNION ALL

Line 2387: FROM ozf_funds_utilized_all_b

2383: AND component_type = 'OFFR'
2384: AND component_id = p_offer_id
2385: UNION ALL
2386: SELECT NVL(-plan_curr_amount,0) approved_amount, fund_id, currency_code
2387: FROM ozf_funds_utilized_all_b
2388: WHERE utilization_type = 'TRANSFER'
2389: AND plan_type = 'OFFR'
2390: AND plan_id = p_offer_id
2391: ) GROUP BY fund_id, currency_code;

Line 2397: FROM ozf_funds_utilized_all_b util

2393:
2394: CURSOR c_prod_budgets (p_offer_id IN NUMBER) IS
2395: SELECT SUM(NVL(DECODE(utilization_type, 'REQUEST',util.plan_curr_amount,-util.plan_curr_amount),0)) approved_amount,
2396: util.fund_id,util.currency_code
2397: FROM ozf_funds_utilized_all_b util
2398: WHERE util.utilization_type IN ('REQUEST','TRANSFER')
2399: AND DECODE(util.utilization_type,'REQUEST', util.component_type,util.plan_type) = 'OFFR'
2400: AND DECODE(util.utilization_type,'REQUEST', util.component_id,util.plan_id) = p_offer_id
2401: GROUP BY util.fund_id,util.currency_code;

Line 2414: FROM ozf_funds_utilized_all_b

2410: AND object_type = 'OFFR';
2411: /*
2412: SELECT SUM (approved_amount)
2413: FROM (SELECT NVL(plan_curr_amount,0) approved_amount
2414: FROM ozf_funds_utilized_all_b
2415: WHERE utilization_type = 'REQUEST'
2416: AND component_type = 'OFFR'
2417: AND component_id = p_offer_id
2418: UNION ALL

Line 2420: FROM ozf_funds_utilized_all_b

2416: AND component_type = 'OFFR'
2417: AND component_id = p_offer_id
2418: UNION ALL
2419: SELECT NVL(-plan_curr_amount,0) approved_amount
2420: FROM ozf_funds_utilized_all_b
2421: WHERE utilization_type = 'TRANSFER'
2422: AND plan_type = 'OFFR'
2423: AND plan_id = p_offer_id);
2424:

Line 2427: FROM ozf_funds_utilized_all_b

2423: AND plan_id = p_offer_id);
2424:
2425: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
2426: SELECT SUM(DECODE(utilization_type,'REQUEST',plan_curr_amount,'TRANSFER',-plan_curr_amount))
2427: FROM ozf_funds_utilized_all_b
2428: WHERE utilization_type IN ('REQUEST','TRANSFER')
2429: AND DECODE(utilization_type,'REQUEST', component_type,plan_type) = 'OFFR'
2430: AND DECODE(utilization_type,'REQUEST', component_id,plan_id) = p_offer_id;
2431: */

Line 2435: FROM ozf_funds_utilized_all_b

2431: */
2432:
2433: CURSOR c_utilized_budgets(p_offer_id IN NUMBER) IS
2434: SELECT NVL(SUM(plan_curr_amount),0)
2435: FROM ozf_funds_utilized_all_b
2436: WHERE plan_id = p_offer_id
2437: AND plan_type = 'OFFR'
2438: AND utilization_type ='ACCRUAL';
2439:

Line 2823: FROM ozf_funds_utilized_all_b

2819:
2820: SELECT SUM (approved_amount) approved_amount, fund_id, currency_code
2821: FROM (
2822: SELECT NVL(plan_curr_amount,0) approved_amount, fund_id, currency_code
2823: FROM ozf_funds_utilized_all_b
2824: WHERE utilization_type = 'REQUEST'
2825: AND component_type = 'OFFR'
2826: AND component_id = p_offer_id
2827: UNION ALL

Line 2829: FROM ozf_funds_utilized_all_b

2825: AND component_type = 'OFFR'
2826: AND component_id = p_offer_id
2827: UNION ALL
2828: SELECT NVL(-plan_curr_amount,0) approved_amount, fund_id, currency_code
2829: FROM ozf_funds_utilized_all_b
2830: WHERE utilization_type = 'TRANSFER'
2831: AND plan_type = 'OFFR'
2832: AND plan_id = p_offer_id
2833: ) GROUP BY fund_id, currency_code;

Line 2839: FROM ozf_funds_utilized_all_b util

2835:
2836: CURSOR c_prod_budgets (p_offer_id IN NUMBER) IS
2837: SELECT SUM(NVL(DECODE(utilization_type, 'REQUEST',util.plan_curr_amount,-util.plan_curr_amount),0)) approved_amount,
2838: util.fund_id,util.currency_code
2839: FROM ozf_funds_utilized_all_b util
2840: WHERE util.utilization_type IN ('REQUEST','TRANSFER')
2841: AND DECODE(util.utilization_type,'REQUEST', util.component_type,util.plan_type) = 'OFFR'
2842: AND DECODE(util.utilization_type,'REQUEST', util.component_id,util.plan_id) = p_offer_id
2843: GROUP BY util.fund_id,util.currency_code;

Line 2856: FROM ozf_funds_utilized_all_b

2852: AND object_type = 'OFFR';
2853: /*
2854: SELECT SUM (approved_amount)
2855: FROM (SELECT NVL(plan_curr_amount,0) approved_amount
2856: FROM ozf_funds_utilized_all_b
2857: WHERE utilization_type = 'REQUEST'
2858: AND component_type = 'OFFR'
2859: AND component_id = p_offer_id
2860: UNION ALL

Line 2862: FROM ozf_funds_utilized_all_b

2858: AND component_type = 'OFFR'
2859: AND component_id = p_offer_id
2860: UNION ALL
2861: SELECT NVL(-plan_curr_amount,0) approved_amount
2862: FROM ozf_funds_utilized_all_b
2863: WHERE utilization_type = 'TRANSFER'
2864: AND plan_type = 'OFFR'
2865: AND plan_id = p_offer_id);
2866:

Line 2869: FROM ozf_funds_utilized_all_b

2865: AND plan_id = p_offer_id);
2866:
2867: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
2868: SELECT SUM(DECODE(utilization_type,'REQUEST',plan_curr_amount,'TRANSFER',-plan_curr_amount))
2869: FROM ozf_funds_utilized_all_b
2870: WHERE utilization_type IN ('REQUEST','TRANSFER')
2871: AND DECODE(utilization_type,'REQUEST', component_type,plan_type) = 'OFFR'
2872: AND DECODE(utilization_type,'REQUEST', component_id,plan_id) = p_offer_id;
2873: */

Line 2877: FROM ozf_funds_utilized_all_b

2873: */
2874:
2875: CURSOR c_utilization_budgets(p_offer_id IN NUMBER) IS
2876: SELECT NVL(SUM(plan_curr_amount),0), MAX(creation_date)
2877: FROM ozf_funds_utilized_all_b
2878: WHERE plan_id = p_offer_id
2879: AND plan_type = 'OFFR'
2880: AND utilization_type ='ACCRUAL';
2881:

Line 2885: FROM ozf_funds_utilized_all_b util

2881:
2882: -- get total utilized amount for this product and this budget.
2883: CURSOR c_utilized_budgets(p_offer_id IN NUMBER,p_fund_id IN NUMBER) IS
2884: SELECT SUM(util.plan_curr_amount)
2885: FROM ozf_funds_utilized_all_b util
2886: WHERE util.component_id = p_offer_id
2887: AND util.component_type = 'OFFR'
2888: AND util.utilization_type ='ACCRUAL'
2889: --AND product_id =p_product_id

Line 3269: FROM ozf_funds_utilized_all_b util, ams_act_products line,

3265: util.cust_account_id CustomerId,
3266: util.plan_curr_amount AccrualAmount,
3267: ''0'' ShippedQuantity,
3268: util.plan_curr_amount Revenue
3269: FROM ozf_funds_utilized_all_b util, ams_act_products line,
3270: ozf_xref_map map
3271: WHERE util.product_id = line.inventory_item_id
3272: AND util.plan_type = ''OFFR''
3273: AND util.plan_id = line.act_product_used_by_id

Line 3593: FROM ozf_funds_utilized_all_b

3589:
3590: --get utilized budget information.
3591: CURSOR c_utilized_budget(p_product_activity_id IN NUMBER) IS
3592: SELECT fund_id,plan_type,plan_id, currency_code
3593: FROM ozf_funds_utilized_all_b
3594: WHERE activity_product_Id = p_product_activity_id;
3595:
3596: --get total available budget amount.
3597: /*

Line 3628: FROM ozf_funds_utilized_all_b a1

3624: ,SUM (amount) committed_amt
3625: FROM (SELECT a1.fund_id fund_id
3626: ,a1.currency_code fund_currency
3627: ,NVL (SUM (a1.amount), 0) amount
3628: FROM ozf_funds_utilized_all_b a1
3629: WHERE a1.component_id = p_qp_list_header_id
3630: AND a1.component_type = 'OFFR'
3631: AND a1.utilization_type = 'REQUEST'
3632: GROUP BY a1.fund_id, a1.currency_code

Line 3637: FROM ozf_funds_utilized_all_b a2

3633: UNION
3634: SELECT a2.fund_id fund_id
3635: ,a2.currency_code fund_currency
3636: ,-NVL (SUM (a2.amount), 0) amount
3637: FROM ozf_funds_utilized_all_b a2
3638: WHERE a2.plan_id = p_qp_list_header_id
3639: AND a2.plan_type = 'OFFR'
3640: GROUP BY a2.fund_id, a2.currency_code)
3641: GROUP BY fund_id, fund_currency

Line 4139: FROM ozf_funds_utilized_all_b

4135: /*
4136: SELECT SUM (approved_amount) approved_amount, fund_id, currency_code
4137: FROM (
4138: SELECT NVL(plan_curr_amount,0) approved_amount, fund_id, currency_code
4139: FROM ozf_funds_utilized_all_b
4140: WHERE utilization_type = 'REQUEST'
4141: AND component_type = 'OFFR'
4142: AND component_id = p_offer_id
4143: UNION ALL

Line 4145: FROM ozf_funds_utilized_all_b

4141: AND component_type = 'OFFR'
4142: AND component_id = p_offer_id
4143: UNION ALL
4144: SELECT NVL(-plan_curr_amount,0) approved_amount, fund_id, currency_code
4145: FROM ozf_funds_utilized_all_b
4146: WHERE utilization_type = 'TRANSFER'
4147: AND plan_type = 'OFFR'
4148: AND plan_id = p_offer_id
4149: ) GROUP BY fund_id, currency_code;

Line 4155: FROM ozf_funds_utilized_all_b util

4151:
4152: CURSOR c_req_budgets (p_offer_id IN NUMBER) IS
4153: SELECT SUM(NVL(DECODE(utilization_type, 'REQUEST',util.plan_curr_amount,-util.plan_curr_amount),0)) approved_amount,
4154: util.fund_id,util.currency_code
4155: FROM ozf_funds_utilized_all_b util
4156: WHERE util.utilization_type IN ('REQUEST','TRANSFER')
4157: AND DECODE(util.utilization_type,'REQUEST', util.component_type,util.plan_type) = 'OFFR'
4158: AND DECODE(util.utilization_type,'REQUEST', util.component_id,util.plan_id) = p_offer_id
4159: GROUP BY util.fund_id,util.currency_code;

Line 4173: FROM ozf_funds_utilized_all_b

4169:
4170: /*
4171: SELECT SUM (approved_amount)
4172: FROM (SELECT NVL(plan_curr_amount,0) approved_amount
4173: FROM ozf_funds_utilized_all_b
4174: WHERE utilization_type = 'REQUEST'
4175: AND component_type = 'OFFR'
4176: AND component_id = p_offer_id
4177: UNION ALL

Line 4179: FROM ozf_funds_utilized_all_b

4175: AND component_type = 'OFFR'
4176: AND component_id = p_offer_id
4177: UNION ALL
4178: SELECT NVL(-plan_curr_amount,0) approved_amount
4179: FROM ozf_funds_utilized_all_b
4180: WHERE utilization_type = 'TRANSFER'
4181: AND plan_type = 'OFFR'
4182: AND plan_id = p_offer_id);
4183:

Line 4187: FROM ozf_funds_utilized_all_b

4183:
4184:
4185: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
4186: SELECT SUM(DECODE(utilization_type,'REQUEST',plan_curr_amount,'TRANSFER',-plan_curr_amount))
4187: FROM ozf_funds_utilized_all_b
4188: WHERE utilization_type IN ('REQUEST','TRANSFER')
4189: AND DECODE(utilization_type,'REQUEST', component_type,plan_type) = 'OFFR'
4190: AND DECODE(utilization_type,'REQUEST', component_id,plan_id) = p_offer_id;
4191: */