DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 469: FROM ozf_funds_utilized_all_b a1

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

Line 480: FROM ozf_funds_utilized_all_b a2

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

Line 496: FROM ozf_funds_utilized_all_b a1

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

Line 503: FROM ozf_funds_utilized_all_b a2

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

Line 1859: FROM ozf_funds_utilized_all_b

1855: /*
1856: SELECT SUM (approved_amount) approved_amount, fund_id, currency_code
1857: FROM (
1858: SELECT NVL(plan_curr_amount,0) approved_amount, fund_id, currency_code
1859: FROM ozf_funds_utilized_all_b
1860: WHERE utilization_type = 'REQUEST'
1861: AND component_type = 'OFFR'
1862: AND component_id = p_offer_id
1863: UNION ALL

Line 1865: FROM ozf_funds_utilized_all_b

1861: AND component_type = 'OFFR'
1862: AND component_id = p_offer_id
1863: UNION ALL
1864: SELECT NVL(-plan_curr_amount,0) approved_amount, fund_id, currency_code
1865: FROM ozf_funds_utilized_all_b
1866: WHERE utilization_type = 'TRANSFER'
1867: AND plan_type = 'OFFR'
1868: AND plan_id = p_offer_id
1869: ) GROUP BY fund_id, currency_code;

Line 1875: FROM ozf_funds_utilized_all_b util

1871:
1872: CURSOR c_prod_budgets (p_offer_id IN NUMBER) IS
1873: SELECT SUM(NVL(DECODE(utilization_type, 'REQUEST',util.plan_curr_amount,-util.plan_curr_amount),0)) approved_amount,
1874: util.fund_id,util.currency_code
1875: FROM ozf_funds_utilized_all_b util
1876: WHERE util.utilization_type IN ('REQUEST','TRANSFER')
1877: AND DECODE(util.utilization_type,'REQUEST', util.component_type,util.plan_type) = 'OFFR'
1878: AND DECODE(util.utilization_type,'REQUEST', util.component_id,util.plan_id) = p_offer_id
1879: GROUP BY util.fund_id,util.currency_code;

Line 1892: FROM ozf_funds_utilized_all_b

1888: AND object_type = 'OFFR';
1889: /*
1890: SELECT SUM (approved_amount)
1891: FROM (SELECT NVL(plan_curr_amount,0) approved_amount
1892: FROM ozf_funds_utilized_all_b
1893: WHERE utilization_type = 'REQUEST'
1894: AND component_type = 'OFFR'
1895: AND component_id = p_offer_id
1896: UNION ALL

Line 1898: FROM ozf_funds_utilized_all_b

1894: AND component_type = 'OFFR'
1895: AND component_id = p_offer_id
1896: UNION ALL
1897: SELECT NVL(-plan_curr_amount,0) approved_amount
1898: FROM ozf_funds_utilized_all_b
1899: WHERE utilization_type = 'TRANSFER'
1900: AND plan_type = 'OFFR'
1901: AND plan_id = p_offer_id);
1902:

Line 1905: FROM ozf_funds_utilized_all_b

1901: AND plan_id = p_offer_id);
1902:
1903: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
1904: SELECT SUM(DECODE(utilization_type,'REQUEST',plan_curr_amount,'TRANSFER',-plan_curr_amount))
1905: FROM ozf_funds_utilized_all_b
1906: WHERE utilization_type IN ('REQUEST','TRANSFER')
1907: AND DECODE(utilization_type,'REQUEST', component_type,plan_type) = 'OFFR'
1908: AND DECODE(utilization_type,'REQUEST', component_id,plan_id) = p_offer_id;
1909: */

Line 1913: FROM ozf_funds_utilized_all_b

1909: */
1910:
1911: CURSOR c_utilized_budgets(p_offer_id IN NUMBER) IS
1912: SELECT NVL(SUM(plan_curr_amount),0)
1913: FROM ozf_funds_utilized_all_b
1914: WHERE plan_id = p_offer_id
1915: AND plan_type = 'OFFR'
1916: AND utilization_type ='ACCRUAL';
1917:

Line 2295: FROM ozf_funds_utilized_all_b

2291:
2292: SELECT SUM (approved_amount) approved_amount, fund_id, currency_code
2293: FROM (
2294: SELECT NVL(plan_curr_amount,0) approved_amount, fund_id, currency_code
2295: FROM ozf_funds_utilized_all_b
2296: WHERE utilization_type = 'REQUEST'
2297: AND component_type = 'OFFR'
2298: AND component_id = p_offer_id
2299: UNION ALL

Line 2301: FROM ozf_funds_utilized_all_b

2297: AND component_type = 'OFFR'
2298: AND component_id = p_offer_id
2299: UNION ALL
2300: SELECT NVL(-plan_curr_amount,0) approved_amount, fund_id, currency_code
2301: FROM ozf_funds_utilized_all_b
2302: WHERE utilization_type = 'TRANSFER'
2303: AND plan_type = 'OFFR'
2304: AND plan_id = p_offer_id
2305: ) GROUP BY fund_id, currency_code;

Line 2311: FROM ozf_funds_utilized_all_b util

2307:
2308: CURSOR c_prod_budgets (p_offer_id IN NUMBER) IS
2309: SELECT SUM(NVL(DECODE(utilization_type, 'REQUEST',util.plan_curr_amount,-util.plan_curr_amount),0)) approved_amount,
2310: util.fund_id,util.currency_code
2311: FROM ozf_funds_utilized_all_b util
2312: WHERE util.utilization_type IN ('REQUEST','TRANSFER')
2313: AND DECODE(util.utilization_type,'REQUEST', util.component_type,util.plan_type) = 'OFFR'
2314: AND DECODE(util.utilization_type,'REQUEST', util.component_id,util.plan_id) = p_offer_id
2315: GROUP BY util.fund_id,util.currency_code;

Line 2328: FROM ozf_funds_utilized_all_b

2324: AND object_type = 'OFFR';
2325: /*
2326: SELECT SUM (approved_amount)
2327: FROM (SELECT NVL(plan_curr_amount,0) approved_amount
2328: FROM ozf_funds_utilized_all_b
2329: WHERE utilization_type = 'REQUEST'
2330: AND component_type = 'OFFR'
2331: AND component_id = p_offer_id
2332: UNION ALL

Line 2334: FROM ozf_funds_utilized_all_b

2330: AND component_type = 'OFFR'
2331: AND component_id = p_offer_id
2332: UNION ALL
2333: SELECT NVL(-plan_curr_amount,0) approved_amount
2334: FROM ozf_funds_utilized_all_b
2335: WHERE utilization_type = 'TRANSFER'
2336: AND plan_type = 'OFFR'
2337: AND plan_id = p_offer_id);
2338:

Line 2341: FROM ozf_funds_utilized_all_b

2337: AND plan_id = p_offer_id);
2338:
2339: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
2340: SELECT SUM(DECODE(utilization_type,'REQUEST',plan_curr_amount,'TRANSFER',-plan_curr_amount))
2341: FROM ozf_funds_utilized_all_b
2342: WHERE utilization_type IN ('REQUEST','TRANSFER')
2343: AND DECODE(utilization_type,'REQUEST', component_type,plan_type) = 'OFFR'
2344: AND DECODE(utilization_type,'REQUEST', component_id,plan_id) = p_offer_id;
2345: */

Line 2349: FROM ozf_funds_utilized_all_b

2345: */
2346:
2347: CURSOR c_utilization_budgets(p_offer_id IN NUMBER) IS
2348: SELECT NVL(SUM(plan_curr_amount),0)
2349: FROM ozf_funds_utilized_all_b
2350: WHERE plan_id = p_offer_id
2351: AND plan_type = 'OFFR'
2352: AND utilization_type ='ACCRUAL';
2353:

Line 2357: FROM ozf_funds_utilized_all_b util

2353:
2354: -- get total utilized amount for this product and this budget.
2355: CURSOR c_utilized_budgets(p_offer_id IN NUMBER, p_product_id IN NUMBER,p_fund_id IN NUMBER) IS
2356: SELECT SUM(util.plan_curr_amount)
2357: FROM ozf_funds_utilized_all_b util
2358: WHERE util.component_id = p_offer_id
2359: AND util.component_type = 'OFFR'
2360: AND util.utilization_type ='ACCRUAL'
2361: AND product_id =p_product_id

Line 2918: FROM ozf_funds_utilized_all_b

2914:
2915: --get utilized budget information.
2916: CURSOR c_utilized_budget(p_product_activity_id IN NUMBER) IS
2917: SELECT fund_id,plan_type,plan_id, currency_code
2918: FROM ozf_funds_utilized_all_b
2919: WHERE activity_product_Id = p_product_activity_id;
2920:
2921: --get total available budget amount.
2922: /*

Line 2953: FROM ozf_funds_utilized_all_b a1

2949: ,SUM (amount) committed_amt
2950: FROM (SELECT a1.fund_id fund_id
2951: ,a1.currency_code fund_currency
2952: ,NVL (SUM (a1.amount), 0) amount
2953: FROM ozf_funds_utilized_all_b a1
2954: WHERE a1.component_id = p_qp_list_header_id
2955: AND a1.component_type = 'OFFR'
2956: AND a1.utilization_type = 'REQUEST'
2957: GROUP BY a1.fund_id, a1.currency_code

Line 2962: FROM ozf_funds_utilized_all_b a2

2958: UNION
2959: SELECT a2.fund_id fund_id
2960: ,a2.currency_code fund_currency
2961: ,-NVL (SUM (a2.amount), 0) amount
2962: FROM ozf_funds_utilized_all_b a2
2963: WHERE a2.plan_id = p_qp_list_header_id
2964: AND a2.plan_type = 'OFFR'
2965: GROUP BY a2.fund_id, a2.currency_code)
2966: GROUP BY fund_id, fund_currency

Line 3461: FROM ozf_funds_utilized_all_b

3457: /*
3458: SELECT SUM (approved_amount) approved_amount, fund_id, currency_code
3459: FROM (
3460: SELECT NVL(plan_curr_amount,0) approved_amount, fund_id, currency_code
3461: FROM ozf_funds_utilized_all_b
3462: WHERE utilization_type = 'REQUEST'
3463: AND component_type = 'OFFR'
3464: AND component_id = p_offer_id
3465: UNION ALL

Line 3467: FROM ozf_funds_utilized_all_b

3463: AND component_type = 'OFFR'
3464: AND component_id = p_offer_id
3465: UNION ALL
3466: SELECT NVL(-plan_curr_amount,0) approved_amount, fund_id, currency_code
3467: FROM ozf_funds_utilized_all_b
3468: WHERE utilization_type = 'TRANSFER'
3469: AND plan_type = 'OFFR'
3470: AND plan_id = p_offer_id
3471: ) GROUP BY fund_id, currency_code;

Line 3477: FROM ozf_funds_utilized_all_b util

3473:
3474: CURSOR c_req_budgets (p_offer_id IN NUMBER) IS
3475: SELECT SUM(NVL(DECODE(utilization_type, 'REQUEST',util.plan_curr_amount,-util.plan_curr_amount),0)) approved_amount,
3476: util.fund_id,util.currency_code
3477: FROM ozf_funds_utilized_all_b util
3478: WHERE util.utilization_type IN ('REQUEST','TRANSFER')
3479: AND DECODE(util.utilization_type,'REQUEST', util.component_type,util.plan_type) = 'OFFR'
3480: AND DECODE(util.utilization_type,'REQUEST', util.component_id,util.plan_id) = p_offer_id
3481: GROUP BY util.fund_id,util.currency_code;

Line 3495: FROM ozf_funds_utilized_all_b

3491:
3492: /*
3493: SELECT SUM (approved_amount)
3494: FROM (SELECT NVL(plan_curr_amount,0) approved_amount
3495: FROM ozf_funds_utilized_all_b
3496: WHERE utilization_type = 'REQUEST'
3497: AND component_type = 'OFFR'
3498: AND component_id = p_offer_id
3499: UNION ALL

Line 3501: FROM ozf_funds_utilized_all_b

3497: AND component_type = 'OFFR'
3498: AND component_id = p_offer_id
3499: UNION ALL
3500: SELECT NVL(-plan_curr_amount,0) approved_amount
3501: FROM ozf_funds_utilized_all_b
3502: WHERE utilization_type = 'TRANSFER'
3503: AND plan_type = 'OFFR'
3504: AND plan_id = p_offer_id);
3505:

Line 3509: FROM ozf_funds_utilized_all_b

3505:
3506:
3507: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
3508: SELECT SUM(DECODE(utilization_type,'REQUEST',plan_curr_amount,'TRANSFER',-plan_curr_amount))
3509: FROM ozf_funds_utilized_all_b
3510: WHERE utilization_type IN ('REQUEST','TRANSFER')
3511: AND DECODE(utilization_type,'REQUEST', component_type,plan_type) = 'OFFR'
3512: AND DECODE(utilization_type,'REQUEST', component_id,plan_id) = p_offer_id;
3513: */