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 97: FROM ozf_funds_utilized_all_b fu

93: SELECT transaction_currency_code
94: , conversion_type
95: , conversion_date
96: , conversion_rate
97: FROM ozf_funds_utilized_all_b fu
98: , ozf_offers offr
99: , gl_daily_rates gl
100: WHERE utilization_id = cv_utilization_id
101: AND fu.plan_id = offr.qp_list_header_id

Line 249: FROM ozf_funds_utilized_all_b

245: , component_type
246: , component_id
247: , fund_id
248: , reference_id
249: FROM ozf_funds_utilized_all_b
250: WHERE utilization_id = cv_utilization_id;
251:
252: --csr_object_class added for Ship - Debit claims / Pranay
253: CURSOR csr_object_class (cv_request_id IN NUMBER) IS

Line 400: UPDATE ozf_funds_utilized_all_b

396: END IF;
397:
398:
399: --- Update Funds Utilized
400: UPDATE ozf_funds_utilized_all_b
401: SET amount_remaining = l_fu_new_amt_rem
402: , acctd_amount_remaining = l_fu_new_acctd_amt_rem
403: , plan_curr_amount_remaining = l_fu_new_plan_amt_rem
404: , univ_curr_amount_remaining = l_fu_new_univ_amt_rem

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

1129: ', fu.plan_type, fu.plan_id, o.offer_type, o.autopay_method '||
1130: ', fu.product_level_type, fu.product_id '||
1131: ', fu.acctd_amount_remaining, fu.amount_remaining, fu.scan_unit_remaining '||
1132: ', fu.creation_date , fu.currency_code , fu.bill_to_site_use_id '||
1133: 'FROM ozf_funds_utilized_all_b fu, ozf_offers o ');
1134:
1135: --Modified for Bugfix 5346249
1136: FND_DSQL.add_text('WHERE fu.plan_type = ''OFFR'' '||
1137: 'AND fu.plan_id = o.qp_list_header_id ' ||

Line 1199: 'FROM ozf_funds_utilized_all_b fu '||

1195: ', fu.plan_type, fu.plan_id, null, null '||
1196: ', fu.product_level_type, fu.product_id '||
1197: ', fu.acctd_amount_remaining, fu.amount_remaining, fu.scan_unit_remaining '||
1198: ', fu.creation_date , fu.currency_code , fu.bill_to_site_use_id '||
1199: 'FROM ozf_funds_utilized_all_b fu '||
1200: 'WHERE fu.plan_type = ''PRIC'' ' ||
1201: 'AND fu.org_id =');
1202: FND_DSQL.add_bind(l_orgId);
1203: FND_DSQL.add_text(' AND fu.cust_account_id = ');

Line 1735: FROM ozf_funds_utilized_all_b

1731:
1732: CURSOR csr_acc_adjustment(cv_offer_id IN NUMBER, cv_cust_account_id IN NUMBER, cv_fund_id IN NUMBER,
1733: cv_product_id IN NUMBER, cv_product_level_type IN VARCHAR2) IS
1734: SELECT utilization_id
1735: FROM ozf_funds_utilized_all_b
1736: WHERE plan_type = 'OFFR'
1737: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
1738: AND plan_id = cv_offer_id
1739: AND fund_id = cv_fund_id

Line 2257: FROM ozf_funds_utilized_all_b

2253:
2254: -- Get Accrual Currency
2255: CURSOR csr_acc_currency(cv_utilization_id IN NUMBER) IS
2256: SELECT currency_code
2257: FROM ozf_funds_utilized_all_b
2258: where utilization_id = cv_utilization_id;
2259:
2260: BEGIN
2261: --------------------- initialize -----------------------

Line 2855: FROM ozf_funds_utilized_all_b fu

2851: l_update_fund_amount NUMBER;
2852:
2853: CURSOR csr_utiz_currency(cv_utilization_id IN NUMBER) IS
2854: SELECT fu.currency_code
2855: FROM ozf_funds_utilized_all_b fu
2856: where fu.utilization_id = cv_utilization_id;
2857:
2858:
2859: -- fix for bug 5042046

Line 3606: FROM ozf_funds_utilized_all_b fu

3602: WHERE claim_line_util_id = cv_line_util_id;
3603:
3604: CURSOR csr_utiz_currency(cv_utilization_id IN NUMBER) IS
3605: SELECT fu.currency_code
3606: FROM ozf_funds_utilized_all_b fu
3607: where fu.utilization_id = cv_utilization_id;
3608:
3609: CURSOR csr_claim_id(cv_claim_line_id IN NUMBER) IS
3610: SELECT claim_id

Line 6327: FROM ozf_funds_utilized_all_b

6323: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6324:
6325: CURSOR csr_earnings(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
6326: SELECT SUM(acctd_amount), SUM(acctd_amount_remaining)
6327: FROM ozf_funds_utilized_all_b
6328: WHERE utilization_type IN ('ACCRUAL', 'ADJUSTMENT')
6329: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
6330: AND plan_type = 'OFFR'
6331: AND plan_id = cv_plan_id

Line 6749: FROM ozf_funds_utilized_all_b

6745: AND lu.utilization_id <> -1;
6746:
6747: CURSOR csr_activity_product_id(cv_plan_id IN NUMBER, cv_product_id IN NUMBER) IS
6748: SELECT activity_product_id
6749: FROM ozf_funds_utilized_all_b
6750: WHERE plan_type = 'OFFR'
6751: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
6752: AND plan_id = cv_plan_id
6753: AND product_level_type = 'PRODUCT'

Line 6796: FROM ozf_funds_utilized_all_b

6792: l_rate NUMBER;
6793:
6794: CURSOR csr_funds_util_info(cv_utilization_id IN NUMBER) IS
6795: SELECT product_id, product_level_type, fund_id
6796: FROM ozf_funds_utilized_all_b
6797: WHERE utilization_id = cv_utilization_id;
6798:
6799: -- Introduced for Bug4493735
6800: -- Modified for Multi-curr ER: need to use only accruals in claim currency

Line 6836: FROM ozf_funds_utilized_all_b

6832: SELECT product_level_type,
6833: product_id,
6834: fund_id,
6835: SUM(amount)
6836: FROM ozf_funds_utilized_all_b
6837: WHERE utilization_type = 'ACCRUAL'
6838: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
6839: AND gl_posted_flag = 'Y'
6840: AND plan_type = 'OFFR'

Line 6865: FROM ozf_funds_utilized_all_b util

6861: ) IS
6862: SELECT util.utilization_id
6863: , line.batch_curr_claim_amount
6864: , offr.transaction_currency_code
6865: FROM ozf_funds_utilized_all_b util
6866: , ozf_sd_batch_lines_all line
6867: , ozf_offers offr
6868: WHERE util.utilization_id = line.utilization_id
6869: AND util.plan_id = offr.qp_list_header_id

Line 8062: from ozf_funds_utilized_all_b

8058: l_lu_currency_code VARCHAR2(15);
8059:
8060: CURSOR csr_utiz_currency(cv_utilization_id IN NUMBER) IS
8061: SELECT currency_code
8062: from ozf_funds_utilized_all_b
8063: where utilization_id = cv_utilization_id ;
8064:
8065: CURSOR csr_final_lu_amt(cv_claim_line_id IN NUMBER) IS
8066: SELECT SUM(amount)

Line 8830: FROM ozf_funds_utilized_all_b fu

8826: CURSOR csr_source_fund(cv_offer_id IN NUMBER) IS
8827: SELECT fu.fund_id
8828: ,fu.currency_code
8829: ,qp.currency_code
8830: FROM ozf_funds_utilized_all_b fu
8831: ,qp_list_headers_vl qp
8832: WHERE fu.component_id = cv_offer_id
8833: AND fu.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
8834: AND fu.component_type = 'OFFR'

Line 9047: UPDATE ozf_funds_utilized_all_b

9043: EXIT WHEN csr_line_utils%NOTFOUND;
9044:
9045: IF l_total_scan_unit IS NOT NULL THEN
9046:
9047: UPDATE ozf_funds_utilized_all_b
9048: SET scan_unit_remaining = scan_unit_remaining - l_total_scan_unit
9049: WHERE utilization_id = l_utilization_id;
9050: END IF;
9051:

Line 9124: from ozf_funds_utilized_all_b

9120: IS
9121:
9122: CURSOR csr_funds_util_details(cv_utilization_id IN NUMBER) IS
9123: select CURRENCY_CODE , EXCHANGE_RATE_TYPE , EXCHANGE_RATE_DATE , EXCHANGE_RATE
9124: from ozf_funds_utilized_all_b
9125: where utilization_id = cv_utilization_id;
9126:
9127:
9128: CURSOR csr_function_currency IS

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

9238: l_cust_setup_id NUMBER;
9239:
9240: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
9241: SELECT fu.plan_id, fu.cust_account_id, ln.activity_type
9242: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln
9243: WHERE lu.utilization_id = fu.utilization_id
9244: AND lu.claim_line_id = ln.claim_line_id
9245: AND ln.claim_id = cv_claim_id
9246: GROUP BY fu.plan_id, fu.cust_account_id, ln.activity_type;

Line 9377: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu

9373: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
9374:
9375: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
9376: SELECT fu.plan_id, fu.cust_account_id, sum(lu.acctd_amount)
9377: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu
9378: , ozf_claim_lines ln
9379: WHERE lu.utilization_id = fu.utilization_id
9380: AND lu.claim_line_id = ln.claim_line_id
9381: AND ln.claim_id = cv_claim_id

Line 9386: FROM ozf_funds_utilized_all_b

9382: GROUP BY fu.plan_id, fu.cust_account_id;
9383:
9384: CURSOR csr_funds_util(cv_cust_account_id IN NUMBER, cv_plan_id IN NUMBER) IS
9385: SELECT sum(acctd_amount), sum(acctd_amount_remaining)
9386: FROM ozf_funds_utilized_all_b
9387: WHERE utilization_type in ('ACCRUAL', 'ADJUSTMENT')
9388: AND org_id = MO_GLOBAL.GET_CURRENT_ORG_ID()
9389: AND gl_posted_flag = 'Y'
9390: AND plan_type = 'OFFR'

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

9489: l_counter PLS_INTEGER := 0;
9490:
9491: CURSOR csr_line_util(cv_claim_id IN NUMBER) IS
9492: SELECT fu.plan_id, fu.cust_account_id, ln.activity_type
9493: FROM ozf_claim_lines_util lu, ozf_funds_utilized_all_b fu, ozf_claim_lines ln
9494: WHERE lu.utilization_id = fu.utilization_id
9495: AND lu.claim_line_id = ln.claim_line_id
9496: AND ln.claim_id = cv_claim_id
9497: GROUP BY fu.plan_id, fu.cust_account_id, ln.activity_type;

Line 9743: FROM ozf_funds_utilized_all_b util

9739: CURSOR csr_request_header(cv_request_id IN NUMBER) IS
9740: SELECT DISTINCT
9741: util.cust_account_id
9742: , util.bill_to_site_use_id
9743: FROM ozf_funds_utilized_all_b util
9744: WHERE util.reference_id = cv_request_id;
9745:
9746: --RMA (-ive accruals) support for bugfix: 6913855
9747: CURSOR csr_request_lines(cv_request_id IN NUMBER

Line 9757: FROM ozf_funds_utilized_all_b

9753: , bill_to_site_use_id
9754: , product_level_type
9755: , product_id
9756: , sum(plan_curr_amount_remaining)
9757: FROM ozf_funds_utilized_all_b
9758: WHERE reference_id = cv_request_id
9759: AND cust_account_id = cv_cust_account_id
9760: AND NVL(bill_to_site_use_id,1) = NVL(cv_bill_to_site_id,1)
9761: AND reference_type = 'SD_REQUEST'

Line 9790: FROM ozf_funds_utilized_all_b util

9786: SELECT DISTINCT
9787: util.cust_account_id
9788: , util.bill_to_site_use_id
9789: , head.claim_number
9790: FROM ozf_funds_utilized_all_b util
9791: , ozf_sd_batch_headers_all head
9792: , ozf_sd_batch_lines_all line
9793: WHERE head.batch_id = cv_batch_id
9794: AND head.batch_id = line.batch_id

Line 9807: FROM ozf_funds_utilized_all_b util

9803: , util.bill_to_site_use_id
9804: , util.product_level_type
9805: , util.product_id
9806: , sum(line.batch_curr_claim_amount)
9807: FROM ozf_funds_utilized_all_b util
9808: , ozf_sd_batch_lines_all line
9809: WHERE line.batch_id = cv_batch_id
9810: AND util.cust_account_id = cv_cust_account_id
9811: AND NVL(util.bill_to_site_use_id,1) = NVL(cv_bill_to_site_id,1)

Line 9832: FROM ozf_funds_utilized_all_b util

9828: , util.product_level_type
9829: , util.product_id
9830: , line.batch_curr_claim_amount
9831: , line.batch_line_id
9832: FROM ozf_funds_utilized_all_b util
9833: , ozf_sd_batch_lines_all line
9834: WHERE line.batch_id = cv_batch_id
9835: AND util.cust_account_id = cv_cust_account_id
9836: AND NVL(util.bill_to_site_use_id,1) = NVL(cv_bill_to_site_id,1)