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_CLAIM_ACCRUAL_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 279: FROM ozf_funds_utilized_all_b

275: , reference_id
276: , plan_id
277: , plan_type
278: , plan_currency_code
279: FROM ozf_funds_utilized_all_b
280: WHERE utilization_id = cv_utilization_id;
281:
282: --csr_object_class added for Ship - Debit claims / Pranay
283: --Bug# 8513457 fixed by ateotia (+)

Line 549: /*UPDATE ozf_funds_utilized_all_b

545: px_upd_line_util_tbl(l_counter).utilization_id := l_line_util_rec.utilization_id;
546:
547:
548:
549: /*UPDATE ozf_funds_utilized_all_b
550: SET amount_remaining = amount_remaining - l_fu_amt_rem
551: , acctd_amount_remaining = acctd_amount_remaining - l_fu_acctd_amt_rem
552: , plan_curr_amount_remaining = plan_curr_amount_remaining - l_fu_plan_amt_rem
553: , univ_curr_amount_remaining = univ_curr_amount_remaining - l_fu_univ_amt_rem

Line 1302: 'FROM ozf_funds_utilized_all_b fu, ozf_offers o ');

1298: FND_DSQL.add_text('DECODE(NVL('''||l_currency_rec.claim_currency_code||''',fu.PLAN_CURRENCY_CODE), fu.PLAN_CURRENCY_CODE, fu.PLAN_CURRENCY_CODE, '''||l_currency_rec.functional_currency_code||''') currency_code, ');
1299: END IF;
1300:
1301: FND_DSQL.add_text( 'fu.bill_to_site_use_id, fu.plan_curr_amount, fu.plan_curr_amount_remaining, fu.plan_currency_code ' || --ninarasi fix for bug 13550004
1302: 'FROM ozf_funds_utilized_all_b fu, ozf_offers o ');
1303: --Fix for Bug 11793070
1304: IF(l_funds_util_flt.period_name IS NOT NULL)THEN
1305: FND_DSQL.add_text( ', OZF_TIME_ENT_QTR teq ');
1306: END IF;

Line 1389: ' FROM ozf_funds_utilized_all_b fu ');

1385: FND_DSQL.add_text('DECODE(NVL('''||l_currency_rec.claim_currency_code||''',fu.PLAN_CURRENCY_CODE), fu.PLAN_CURRENCY_CODE, fu.PLAN_CURRENCY_CODE, '''||l_currency_rec.functional_currency_code||''') currency_code, ');
1386: END IF;
1387:
1388: FND_DSQL.add_text('fu.bill_to_site_use_id , fu.plan_curr_amount, fu.plan_curr_amount_remaining, fu.plan_currency_code' ||
1389: ' FROM ozf_funds_utilized_all_b fu ');
1390:
1391: --Fix for Bug 11793070
1392: IF(l_funds_util_flt.period_name IS NOT NULL)THEN
1393: FND_DSQL.add_text( ', OZF_TIME_ENT_QTR teq ');

Line 2054: FROM ozf_funds_utilized_all_b

2050:
2051: CURSOR csr_acc_adjustment(cv_offer_id IN NUMBER, cv_cust_account_id IN NUMBER, cv_fund_id IN NUMBER,
2052: cv_product_id IN NUMBER, cv_product_level_type IN VARCHAR2) IS
2053: SELECT utilization_id
2054: FROM ozf_funds_utilized_all_b
2055: WHERE plan_type = 'OFFR'
2056: AND org_id = l_currOrgId
2057: AND plan_id = cv_offer_id
2058: AND fund_id = cv_fund_id

Line 2417: UPDATE ozf_funds_utilized_all_b

2413: );
2414:
2415: IF l_upd_fund_util_tbl.COUNT = G_BULK_LIMIT OR i = p_line_util_tbl.LAST THEN --ninarasi fix for bug 13530939
2416: FORALL i IN NVL(l_upd_fund_util_tbl.FIRST,1) .. NVL(l_upd_fund_util_tbl.LAST,0)
2417: UPDATE ozf_funds_utilized_all_b
2418: SET amount_remaining = amount_remaining - l_upd_fund_util_tbl(i).amount_remaining
2419: , acctd_amount_remaining = acctd_amount_remaining - l_upd_fund_util_tbl(i).acctd_amount_remaining
2420: , plan_curr_amount_remaining = plan_curr_amount_remaining - l_upd_fund_util_tbl(i).plan_curr_amount_remaining
2421: , univ_curr_amount_remaining = univ_curr_amount_remaining - l_upd_fund_util_tbl(i).univ_curr_amount_remaining

Line 3072: UPDATE ozf_funds_utilized_all_b

3068: RAISE FND_API.g_exc_unexpected_error;
3069: END IF;
3070: IF l_upd_fund_util_tbl.COUNT = G_BULK_LIMIT OR i = p_line_util_tbl.LAST THEN --ninarasi fix for bug 13530939
3071: FORALL i IN NVL(l_upd_fund_util_tbl.FIRST,1) .. NVL(l_upd_fund_util_tbl.LAST,0)
3072: UPDATE ozf_funds_utilized_all_b
3073: SET amount_remaining = amount_remaining - l_upd_fund_util_tbl(i).amount_remaining
3074: , acctd_amount_remaining = acctd_amount_remaining - l_upd_fund_util_tbl(i).acctd_amount_remaining
3075: , plan_curr_amount_remaining = plan_curr_amount_remaining - l_upd_fund_util_tbl(i).plan_curr_amount_remaining
3076: , univ_curr_amount_remaining = univ_curr_amount_remaining - l_upd_fund_util_tbl(i).univ_curr_amount_remaining

Line 3207: , ozf_funds_utilized_all_b fu

3203: , lu.util_curr_amount
3204: , lu.currency_code
3205: , fu.plan_currency_code
3206: FROM ozf_claim_lines_util lu
3207: , ozf_funds_utilized_all_b fu
3208: WHERE lu.claim_line_util_id = cv_line_util_id
3209: AND fu.utilization_id = lu.utilization_id;
3210:
3211: CURSOR csr_total_exist_util_amt(cv_claim_line_id IN NUMBER) IS

Line 3618: UPDATE ozf_funds_utilized_all_b

3614: );
3615:
3616: IF l_upd_fund_util_tbl.COUNT = G_BULK_LIMIT THEN --ninarasi fix for bug 13530939
3617: FORALL i IN NVL(l_upd_fund_util_tbl.FIRST,1) .. NVL(l_upd_fund_util_tbl.LAST,0)
3618: UPDATE ozf_funds_utilized_all_b
3619: SET amount_remaining = amount_remaining - l_upd_fund_util_tbl(i).amount_remaining
3620: , acctd_amount_remaining = acctd_amount_remaining - l_upd_fund_util_tbl(i).acctd_amount_remaining
3621: , plan_curr_amount_remaining = plan_curr_amount_remaining - l_upd_fund_util_tbl(i).plan_curr_amount_remaining
3622: , univ_curr_amount_remaining = univ_curr_amount_remaining - l_upd_fund_util_tbl(i).univ_curr_amount_remaining

Line 3638: UPDATE ozf_funds_utilized_all_b

3634: END IF;
3635: ELSE
3636: IF l_upd_fund_util_tbl.COUNT > 0 THEN
3637: FORALL i IN NVL(l_upd_fund_util_tbl.FIRST,1) .. NVL(l_upd_fund_util_tbl.LAST,0) --ninarasi fix for bug 13530939
3638: UPDATE ozf_funds_utilized_all_b
3639: SET amount_remaining = amount_remaining - l_upd_fund_util_tbl(i).amount_remaining
3640: , acctd_amount_remaining = acctd_amount_remaining - l_upd_fund_util_tbl(i).acctd_amount_remaining
3641: , plan_curr_amount_remaining = plan_curr_amount_remaining - l_upd_fund_util_tbl(i).plan_curr_amount_remaining
3642: , univ_curr_amount_remaining = univ_curr_amount_remaining - l_upd_fund_util_tbl(i).univ_curr_amount_remaining

Line 3829: UPDATE ozf_funds_utilized_all_b

3825: );
3826:
3827: IF l_upd_fund_util_tbl.COUNT = G_BULK_LIMIT OR i = p_line_util_tbl.LAST THEN --ninarasi fix for bug 13530939
3828: FORALL i IN NVL(l_upd_fund_util_tbl.FIRST,1) .. NVL(l_upd_fund_util_tbl.LAST,0)
3829: UPDATE ozf_funds_utilized_all_b
3830: SET amount_remaining = amount_remaining - l_upd_fund_util_tbl(i).amount_remaining
3831: , acctd_amount_remaining = acctd_amount_remaining - l_upd_fund_util_tbl(i).acctd_amount_remaining
3832: , plan_curr_amount_remaining = plan_curr_amount_remaining - l_upd_fund_util_tbl(i).plan_curr_amount_remaining
3833: , univ_curr_amount_remaining = univ_curr_amount_remaining - l_upd_fund_util_tbl(i).univ_curr_amount_remaining

Line 3972: , ozf_funds_utilized_all_b fu

3968: , lu.utilization_id
3969: , Decode(lu.currency_code,fu.plan_currency_code, lu.plan_curr_amount, lu.acctd_amount)
3970: , lu.scan_unit
3971: FROM ozf_claim_lines_util lu
3972: , ozf_funds_utilized_all_b fu
3973: WHERE claim_line_util_id = cv_line_util_id
3974: AND lu.utilization_id = fu.utilization_id;
3975:
3976:

Line 5558: FROM ozf_funds_utilized_all_b fu

5554: CURSOR csr_get_utils(p_cust_account_id IN NUMBER, p_fund_id IN VARCHAR2, p_product_id IN NUMBER)
5555: IS
5556: SELECT fu.cust_account_id cust_account_id, fu.plan_type plan_type, fu.plan_id plan_id,
5557: fu.product_id product_id, sum(fu.acctd_amount_remaining) amount, fu.currency_code currency_code
5558: FROM ozf_funds_utilized_all_b fu
5559: WHERE fu.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
5560: AND fu.acctd_amount_remaining <> 0
5561: AND fu.utilization_type IN ('ACCRUAL', 'ADJUSTMENT')
5562: AND fu.cust_account_id = p_cust_account_id

Line 8015: FROM ozf_funds_utilized_all_b

8011:
8012: CURSOR csr_earnings(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
8013: SELECT SUM(DECODE(p_currency_rec.association_currency_code,p_currency_rec.transaction_currency_code, plan_curr_amount,acctd_amount))
8014: , SUM(DECODE(p_currency_rec.association_currency_code,p_currency_rec.transaction_currency_code, plan_curr_amount_remaining,acctd_amount_remaining))
8015: FROM ozf_funds_utilized_all_b
8016: WHERE utilization_type IN ('ACCRUAL', 'ADJUSTMENT')
8017: AND org_id =l_currOrgId
8018: AND plan_type = 'OFFR'
8019: AND plan_id = cv_plan_id

Line 8254: FROM ozf_funds_utilized_all_b

8250: SELECT product_level_type
8251: , product_id
8252: , fund_id
8253: , SUM(amount)
8254: FROM ozf_funds_utilized_all_b
8255: WHERE utilization_type = 'ACCRUAL'
8256: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
8257: AND gl_posted_flag = 'Y'
8258: AND plan_type = 'OFFR'

Line 8268: FROM ozf_funds_utilized_all_b

8264: GROUP BY product_level_type,product_id,fund_id;
8265:
8266: CURSOR csr_funds_util_info(cv_utilization_id IN NUMBER) IS
8267: SELECT product_id, product_level_type, fund_id
8268: FROM ozf_funds_utilized_all_b
8269: WHERE utilization_id = cv_utilization_id;
8270:
8271: CURSOR csr_source_fund_tot ( cv_offer_id NUMBER ) IS
8272: SELECT SUM(approved_original_amount)

Line 8689: FROM ozf_funds_utilized_all_b util

8685: ) IS
8686: SELECT util.utilization_id
8687: , line.batch_curr_claim_amount
8688: , offr.transaction_currency_code
8689: FROM ozf_funds_utilized_all_b util
8690: , ozf_sd_batch_lines_all line
8691: , ozf_offers offr
8692: WHERE util.utilization_id = line.utilization_id
8693: AND util.plan_id = offr.qp_list_header_id

Line 8712: FROM ozf_funds_utilized_all_b util

8708: , util.exchange_rate
8709: , util.exchange_rate_date
8710: , util.exchange_rate_type
8711: , line.batch_curr_claim_amount
8712: FROM ozf_funds_utilized_all_b util
8713: , ozf_sd_batch_lines_all line
8714: WHERE util.utilization_id = line.utilization_id
8715: AND line.status_code ='APPROVED' --//Bugfix: 9794989
8716: AND line.purge_flag ='N'

Line 9175: FROM ozf_funds_utilized_all_b

9171: l_offer_status VARCHAR2(30);
9172:
9173: CURSOR csr_activity_product_id(cv_plan_id IN NUMBER, cv_product_id IN NUMBER) IS
9174: SELECT activity_product_id
9175: FROM ozf_funds_utilized_all_b
9176: WHERE plan_type = 'OFFR'
9177: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
9178: AND plan_id = cv_plan_id
9179: AND product_level_type = 'PRODUCT'

Line 9443: FROM ozf_funds_utilized_all_b util

9439: SELECT plan_currency_code
9440: , plan_curr_amount_remaining
9441: , plan_curr_amount
9442: , acctd_amount_remaining
9443: FROM ozf_funds_utilized_all_b util
9444: WHERE utilization_id = cv_util_id;*/
9445:
9446:
9447: BEGIN

Line 10457: , ozf_funds_utilized_all_b fu

10453:
10454: CURSOR csr_utiz_amount(cv_line_util_id IN NUMBER) IS
10455: SELECT DECODE(ln.currency_code,fu.plan_currency_code,ln.plan_curr_amount,ln.acctd_amount)
10456: FROM ozf_claim_lines_util ln
10457: , ozf_funds_utilized_all_b fu
10458: WHERE claim_line_util_id = cv_line_util_id
10459: AND fu.utilization_id = ln.utilization_id;
10460:
10461: BEGIN

Line 10743: UPDATE ozf_funds_utilized_all_b

10739: );
10740:
10741: IF l_upd_fund_util_tbl.COUNT = G_BULK_LIMIT OR i = l_line_util_tbl.LAST THEN --ninarasi fix for bug 13530939
10742: FORALL i IN NVL(l_upd_fund_util_tbl.FIRST,1) .. NVL(l_upd_fund_util_tbl.LAST,0)
10743: UPDATE ozf_funds_utilized_all_b
10744: SET amount_remaining = amount_remaining - l_upd_fund_util_tbl(i).amount_remaining
10745: , acctd_amount_remaining = acctd_amount_remaining - l_upd_fund_util_tbl(i).acctd_amount_remaining
10746: , plan_curr_amount_remaining = plan_curr_amount_remaining - l_upd_fund_util_tbl(i).plan_curr_amount_remaining
10747: , univ_curr_amount_remaining = univ_curr_amount_remaining - l_upd_fund_util_tbl(i).univ_curr_amount_remaining

Line 10805: UPDATE ozf_funds_utilized_all_b

10801: ,px_upd_line_util_tbl => l_upd_fund_util_tbl
10802: );
10803:
10804: FORALL i IN NVL(l_upd_fund_util_tbl.FIRST,1) .. NVL(l_upd_fund_util_tbl.LAST,0) --ninarasi fix for bug 13530939
10805: UPDATE ozf_funds_utilized_all_b
10806: SET amount_remaining = amount_remaining - l_upd_fund_util_tbl(i).amount_remaining
10807: , acctd_amount_remaining = acctd_amount_remaining - l_upd_fund_util_tbl(i).acctd_amount_remaining
10808: , plan_curr_amount_remaining = plan_curr_amount_remaining - l_upd_fund_util_tbl(i).plan_curr_amount_remaining
10809: , univ_curr_amount_remaining = univ_curr_amount_remaining - l_upd_fund_util_tbl(i).univ_curr_amount_remaining

Line 11333: UPDATE ozf_funds_utilized_all_b

11329: EXIT WHEN csr_line_utils%NOTFOUND;
11330:
11331: IF l_total_scan_unit IS NOT NULL THEN
11332:
11333: UPDATE ozf_funds_utilized_all_b
11334: SET scan_unit_remaining = scan_unit_remaining - l_total_scan_unit
11335: WHERE utilization_id = l_utilization_id;
11336: END IF;
11337:

Line 11414: FROM ozf_funds_utilized_all_b

11410: CURSOR csr_funds_util_details(cv_utilization_id IN NUMBER) IS
11411: SELECT exchange_rate_type
11412: , exchange_rate_date
11413: , exchange_rate
11414: FROM ozf_funds_utilized_all_b
11415: WHERE utilization_id = cv_utilization_id;
11416:
11417: l_fu_plan_currency_code VARCHAR2(15);
11418: l_fu_exc_rate NUMBER;

Line 11493: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln

11489: l_cust_setup_id NUMBER;
11490:
11491: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
11492: SELECT fu.plan_id, fu.cust_account_id, ln.activity_type
11493: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln
11494: WHERE lu.utilization_id = fu.utilization_id
11495: AND lu.claim_line_id = ln.claim_line_id
11496: AND ln.claim_id = cv_claim_id
11497: GROUP BY fu.plan_id, fu.cust_account_id, ln.activity_type;

Line 11629: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu

11625: WHERE org_id = l_currOrgId;
11626:
11627: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
11628: SELECT fu.plan_id, fu.cust_account_id, sum(lu.acctd_amount)
11629: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu
11630: , ozf_claim_lines ln
11631: WHERE lu.utilization_id = fu.utilization_id
11632: AND lu.claim_line_id = ln.claim_line_id
11633: AND ln.claim_id = cv_claim_id

Line 11638: FROM ozf_funds_utilized_all_b

11634: GROUP BY fu.plan_id, fu.cust_account_id;
11635:
11636: CURSOR csr_funds_util(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
11637: SELECT sum(acctd_amount), sum(acctd_amount_remaining)
11638: FROM ozf_funds_utilized_all_b
11639: WHERE utilization_type in ('ACCRUAL', 'ADJUSTMENT')
11640: AND org_id = l_currOrgId
11641: AND gl_posted_flag = 'Y'
11642: AND plan_type = 'OFFR'

Line 11745: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln

11741: l_counter PLS_INTEGER := 0;
11742:
11743: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
11744: SELECT fu.plan_id, fu.cust_account_id, ln.activity_type
11745: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln
11746: WHERE lu.utilization_id = fu.utilization_id
11747: AND lu.claim_line_id = ln.claim_line_id
11748: AND ln.claim_id = cv_claim_id
11749: GROUP BY fu.plan_id, fu.cust_account_id, ln.activity_type;

Line 12019: FROM ozf_funds_utilized_all_b util

12015: CURSOR csr_request_header(cv_request_id IN NUMBER) IS
12016: SELECT DISTINCT
12017: util.cust_account_id
12018: , util.bill_to_site_use_id
12019: FROM ozf_funds_utilized_all_b util
12020: WHERE util.reference_id = cv_request_id;
12021:
12022: --RMA (-ive accruals) support for bugfix: 6913855
12023: CURSOR csr_request_lines(cv_request_id IN NUMBER

Line 12035: FROM ozf_funds_utilized_all_b

12031: , product_id
12032: , exchange_rate_type
12033: , SUM(plan_curr_amount_remaining)
12034: , SUM(acctd_amount_remaining) --// ER 9226258
12035: FROM ozf_funds_utilized_all_b
12036: WHERE reference_id = cv_request_id
12037: AND cust_account_id = cv_cust_account_id
12038: AND NVL(bill_to_site_use_id,1) = NVL(cv_bill_to_site_id,1)
12039: AND reference_type = 'SD_REQUEST'

Line 12069: FROM ozf_funds_utilized_all_b util

12065: SELECT DISTINCT
12066: util.cust_account_id
12067: , util.bill_to_site_use_id
12068: , head.claim_number
12069: FROM ozf_funds_utilized_all_b util
12070: , ozf_sd_batch_headers_all head
12071: , ozf_sd_batch_lines_all line
12072: WHERE head.batch_id = cv_batch_id
12073: AND head.batch_id = line.batch_id

Line 12089: FROM ozf_funds_utilized_all_b util

12085: , util.bill_to_site_use_id
12086: , util.product_level_type
12087: , util.product_id
12088: , sum(line.batch_curr_claim_amount)
12089: FROM ozf_funds_utilized_all_b util
12090: , ozf_sd_batch_lines_all line
12091: WHERE line.batch_id = cv_batch_id
12092: --Fix for Bug 10047209
12093: --AND line.status_code ='APPROVED' --//Bugfix: 9794989

Line 12117: FROM ozf_funds_utilized_all_b util

12113: , util.product_level_type
12114: , util.product_id
12115: , line.batch_curr_claim_amount
12116: , line.batch_line_id
12117: FROM ozf_funds_utilized_all_b util
12118: , ozf_sd_batch_lines_all line
12119: WHERE line.batch_id = cv_batch_id
12120: --Fix for Bug 10047209
12121: -- AND line.status_code ='APPROVED' --//Bugfix: 9794989