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_OFFERS

Line 98: , ozf_offers offr

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
102: AND fu.exchange_rate_type = gl.conversion_type

Line 226: FROM ozf_offers

222: l_source_object_class VARCHAR2(15);
223:
224: CURSOR csr_offer_currency(cv_plan_id IN NUMBER) IS
225: SELECT transaction_currency_code
226: FROM ozf_offers
227: WHERE qp_list_header_id = cv_plan_id;
228:
229: --reference_id added for Ship - Debit claims / Pranay
230: CURSOR csr_fu_old_amt_rem(cv_utilization_id IN NUMBER) IS

Line 736: FROM ozf_offers

732: WHERE request_header_id = cv_request_id;
733:
734: CURSOR csr_offer_type(cv_offer_id IN NUMBER) IS
735: SELECT offer_type
736: FROM ozf_offers
737: WHERE qp_list_header_id = cv_offer_id;
738:
739: --Ship - Debit Enhancements / Added by Pranay
740: CURSOR csr_sd_offer_id(cv_request_id IN NUMBER) IS

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 1267: FROM ozf_offers o

1263:
1264: CURSOR csr_request_offer(cv_request_id IN NUMBER) IS
1265: SELECT o.qp_list_header_id
1266: , o.offer_type
1267: FROM ozf_offers o
1268: , ozf_request_headers_all_b r
1269: WHERE o.qp_list_header_id = r.offer_id
1270: AND r.request_header_id = cv_request_id;
1271:

Line 5868: from ozf_offers off , ams_act_products act

5864:
5865: -- added for Bugfix 5404951
5866: CURSOR csr_ams_act_products(cv_agreement_number IN VARCHAR2 ,cv_product_id IN NUMBER) IS
5867: select act.SCAN_VALUE ,act.UOM_CODE , act.Quantity , off.TRANSACTION_CURRENCY_CODE
5868: from ozf_offers off , ams_act_products act
5869: where offer_code = cv_agreement_number
5870: and ARC_ACT_PRODUCT_USED_BY = 'OFFR'
5871: AND ACT_PRODUCT_USED_BY_ID = off.qp_list_header_id
5872: AND INVENTORY_ITEM_ID = cv_product_id;

Line 6716: FROM ozf_offers

6712: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
6713:
6714: CURSOR csr_offer_currency(cv_plan_id IN NUMBER) IS
6715: SELECT transaction_currency_code
6716: FROM ozf_offers
6717: WHERE qp_list_header_id = cv_plan_id;
6718:
6719: CURSOR csr_offer_profile(cv_activity_product_id IN NUMBER) IS
6720: SELECT uom_code

Line 6729: FROM ozf_offers

6725: WHERE activity_product_id = cv_activity_product_id;
6726:
6727: CURSOR csr_offer_status(cv_offer_id IN NUMBER) IS
6728: SELECT status_code
6729: FROM ozf_offers
6730: WHERE qp_list_header_id = cv_offer_id;
6731:
6732: -- Modified for Bug 4926327: Adjustment Amounts are doubled for scan data
6733: -- Modified for Bug 5101106 quantity = coupon count * offer qty

Line 6867: , ozf_offers offr

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
6870: AND line.batch_id = cv_batch_id
6871: AND line.item_id = cv_product_id

Line 8084: FROM ozf_offers

8080: where claim_line_id = cv_claim_line_id;
8081:
8082: CURSOR csr_offer_currency(cv_plan_id IN NUMBER) IS
8083: SELECT transaction_currency_code
8084: FROM ozf_offers
8085: WHERE qp_list_header_id = cv_plan_id;
8086:
8087: CURSOR csr_over_util(cv_claim_line_id IN NUMBER, cv_act_product_id IN NUMBER) IS
8088: SELECT claim_line_util_id, acctd_amount, scan_unit

Line 9723: , ozf_offers offr

9719: -- , acctd_amount
9720: , amount --7169388
9721: , fund.approved_in_currency --7231613
9722: FROM ozf_claim_lines_all lines
9723: , ozf_offers offr
9724: , ozf_act_budgets fund
9725: , ozf_sd_request_headers_all_b req
9726: WHERE claim_id = cv_claim_id
9727: AND lines.activity_id = req.request_header_id

Line 9774: , ozf_offers offr

9770:
9771: CURSOR cur_offer_currency(cv_request_id IN NUMBER) IS
9772: SELECT offr.transaction_currency_code
9773: FROM ozf_sd_request_headers_all_b req
9774: , ozf_offers offr
9775: WHERE offr.qp_list_header_id = req.offer_id
9776: AND req.request_header_id = cv_request_id;
9777:
9778: --Vendor details added for bug 6921727