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_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFERS

Line 595: FROM ozf_offers

591: CURSOR c_offer_info IS
592: SELECT nvl(transaction_currency_code,fund_request_curr_code)offer_currency_code
593: ,transaction_currency_code
594: , beneficiary_account_id,autopay_party_attr,autopay_party_id -- Added for bug 7030415, correct org_id in accrual records
595: FROM ozf_offers
596: WHERE qp_list_header_id = p_list_header_id;
597:
598: CURSOR c_cust_number (p_header_id IN NUMBER) IS
599: SELECT cust.cust_account_id

Line 667: FROM ozf_offers

663: WHERE site_use_id = p_site_use_id;
664:
665: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
666: SELECT autopay_party_attr,autopay_party_id
667: FROM ozf_offers
668: WHERE qp_list_header_id = p_offer_id;
669:
670: l_offer_info c_offer_info%ROWTYPE;
671:

Line 1099: FROM ozf_offers

1095: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
1096: SELECT nvl(transaction_currency_code,fund_request_curr_code) offer_currency_code
1097: , transaction_currency_code
1098: , beneficiary_account_id, offer_id
1099: FROM ozf_offers
1100: WHERE qp_list_header_id = p_list_header_id;
1101:
1102: CURSOR c_cust_number (p_header_id IN NUMBER) IS
1103: SELECT cust.cust_account_id

Line 1948: --but we will need to join with ozf_offers table.Check and do it.

1944: --This was missing from R12+
1945: --2) Pick all lines for accrual/off-inv, promotional, order value and trade deal offes
1946: --3) pick volume offer lines since it uses diff. tables other than all offer types.
1947: --For trade deal its better to use case as in c_order_header cursor
1948: --but we will need to join with ozf_offers table.Check and do it.
1949:
1950: CURSOR c_adjusted_line_cur(p_offer_adjustment_id IN NUMBER) IS
1951: SELECT adj.offer_adjustment_line_id,
1952: adj.list_line_id to_list_line_id

Line 2047: ozf_offers off,

2043: FROM oe_order_lines_all line,
2044: ozf_adj_temp_eligibility temp,
2045: ozf_offer_adjustments_b adj,
2046: ozf_offer_adjustment_lines adj_line,
2047: ozf_offers off,
2048: qp_list_lines lines,
2049: qp_list_headers_all qp,
2050: qp_pricing_attributes qpa
2051: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date)))

Line 2146: ozf_offers off,

2142: FROM oe_order_lines_all line,
2143: ozf_adj_temp_eligibility temp,
2144: ozf_offer_adjustments_b adj,
2145: ozf_offer_adjustment_lines adj_line,
2146: ozf_offers off,
2147: qp_list_lines lines,
2148: qp_list_headers_all qp,
2149: qp_pricing_attributes qpa
2150: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date)))

Line 2252: ozf_offers off,

2248: FROM oe_order_lines_all line,
2249: ozf_adj_temp_eligibility temp,
2250: ozf_offer_adjustments_b adj,
2251: ozf_offer_adjustment_lines adj_line,
2252: ozf_offers off,
2253: qp_list_lines lines,
2254: qp_list_headers_all qp,
2255: qp_pricing_attributes qpa
2256: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date)))

Line 2351: ozf_offers off,

2347: ozf_adj_temp_eligibility temp,
2348: ozf_offer_adjustments_b adj,
2349: ozf_offer_adjustment_tiers adj_line,
2350: ozf_offer_discount_lines orig_disc,
2351: ozf_offers off,
2352: qp_list_headers_all qp,
2353: ozf_qp_discounts map_lines,
2354: qp_list_lines lines
2355: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date))) BETWEEN adj.effective_date

Line 2436: ozf_offers off,

2432: FROM oe_order_lines_all line,
2433: ozf_adj_temp_eligibility temp,
2434: ozf_offer_adjustments_b adj,
2435: ozf_offer_adjustment_lines adj_line,
2436: ozf_offers off,
2437: qp_list_lines lines,
2438: qp_list_headers_all qp,
2439: qp_pricing_attributes qpa
2440: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date)))

Line 2535: ozf_offers off,

2531: ozf_adj_temp_eligibility temp,
2532: ozf_offer_adjustments_b adj,
2533: ozf_offer_adjustment_tiers adj_line,
2534: ozf_offer_discount_lines orig_disc,
2535: ozf_offers off,
2536: qp_list_headers_all qp,
2537: ozf_qp_discounts map_lines,
2538: qp_list_lines lines
2539: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date))) BETWEEN adj.effective_date

Line 2608: FROM qp_list_headers_all qp, ozf_offers off

2604: --kdass 09-DEC-2005 fix for bug 4872799
2605: trunc(off.start_date) start_date
2606: ,off.volume_offer_type
2607: ,qp.orig_org_id offer_org_id, off.transaction_currency_code offer_currency
2608: FROM qp_list_headers_all qp, ozf_offers off
2609: WHERE qp.list_header_id = p_list_header_id
2610: AND qp.list_header_id = off.qp_list_header_id;
2611:
2612:

Line 2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;

2631: TYPE pricingDateTbl IS TABLE OF oe_order_lines_all.pricing_date%TYPE;
2632: TYPE actualShipDateTbl IS TABLE OF oe_order_lines_all.actual_shipment_date%TYPE;
2633: TYPE requestDateTbl IS TABLE OF oe_order_lines_all.request_date%TYPE;
2634: TYPE fulfillmentDateTbl IS TABLE OF oe_order_lines_all.fulfillment_date%TYPE;
2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
2636: TYPE arithOperTbl IS TABLE OF qp_list_lines.arithmetic_operator%TYPE;
2637:
2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;
2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;

Line 3997: FROM ozf_offers

3993: l_offer_type VARCHAR2(30) := NULL;
3994:
3995: CURSOR omo_offer_csr IS
3996: SELECT offer_id, offer_type
3997: FROM ozf_offers
3998: WHERE qp_list_header_id = p_list_header_id;
3999:
4000:
4001: CURSOR line_adjustment_csr IS

Line 4141: FROM ozf_offers

4137: SELECT nvl(transaction_currency_code, fund_request_curr_code) offer_currency_code,
4138: transaction_currency_code,
4139: beneficiary_account_id,
4140: offer_id
4141: FROM ozf_offers
4142: WHERE qp_list_header_id = p_list_header_id;
4143:
4144: CURSOR c_cust_number(p_header_id IN NUMBER) IS
4145: SELECT cust.cust_account_id

Line 4550: --So, changed it to offer_currency_code which is basically fund_request_curr_code from ozf_offers.

4546: l_act_budgets_rec.approved_in_currency := l_offer_info.transaction_currency_code;
4547: l_act_util_rec.plan_currency_code := p_line_rec.transactional_curr_code;
4548: END IF;
4549: --ninarasi: bug 15877269 - l_offer_info.transaction_currency_code will be NULL in case of a NULL currency offer.
4550: --So, changed it to offer_currency_code which is basically fund_request_curr_code from ozf_offers.
4551: l_act_util_rec.fund_request_currency_code := l_offer_info.offer_currency_code;
4552: --nirprasa,12.2
4553:
4554: l_act_util_rec.list_line_id := p_ldets_rec.list_line_id;

Line 4803: FROM ozf_offers off, qp_list_headers_all qp

4799: beneficiary_account_id,
4800: autopay_party_attr,
4801: autopay_party_id,
4802: description
4803: FROM ozf_offers off, qp_list_headers_all qp
4804: WHERE off.qp_list_header_id = p_list_header_id
4805: AND off.qp_list_header_id = qp.list_header_id;
4806:
4807: CURSOR c_adj_info(p_list_line_id IN NUMBER) IS

Line 5323: FROM ozf_offers

5319: transaction_currency_code,
5320: beneficiary_account_id,
5321: autopay_party_attr,
5322: autopay_party_id
5323: FROM ozf_offers
5324: WHERE qp_list_header_id = p_list_header_id;
5325:
5326: CURSOR c_adj_info(p_list_line_id IN NUMBER) IS
5327: SELECT created_from_adjustments

Line 5724: FROM ozf_offers

5720:
5721: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
5722: SELECT offer_type, volume_offer_type,
5723: custom_setup_id
5724: FROM ozf_offers
5725: WHERE qp_list_header_id = p_list_header_id;
5726:
5727: CURSOR line_ldets_tbl_csr(p_index IN NUMBER) IS
5728: SELECT *

Line 6478: FROM ozf_offers

6474: CURSOR c_offer_info IS
6475: SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code,
6476: reusable,
6477: offer_type
6478: FROM ozf_offers
6479: WHERE qp_list_header_id = p_qp_list_header_id;
6480:
6481: -- added by feliu to fix bug 4451500 and 4015372.
6482: --nirprasa, 12.1.1 enhancement, replace amount with plan_curr_amount

Line 6964: FROM ozf_offers

6960: IS
6961:
6962: CURSOR c_volume_off IS
6963: SELECT qp_list_header_id, volume_offer_type
6964: FROM ozf_offers
6965: WHERE offer_type = 'VOLUME_OFFER'
6966: AND status_code = 'ACTIVE';
6967:
6968: l_api_name CONSTANT VARCHAR2(30) := 'adjust_volume_offer';

Line 6975: TYPE qpListHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;

6971: l_return_status VARCHAR2 (20);
6972: l_msg_count NUMBER;
6973: l_msg_data VARCHAR2 (2000) := NULL;
6974:
6975: TYPE qpListHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
6976: TYPE volumeOfferTypeTbl IS TABLE OF ozf_offers.volume_offer_type%TYPE;
6977:
6978: l_qpListHeaderIdTbl qpListHeaderIdTbl;
6979: l_volumeOfferTypeTbl volumeOfferTypeTbl;

Line 6976: TYPE volumeOfferTypeTbl IS TABLE OF ozf_offers.volume_offer_type%TYPE;

6972: l_msg_count NUMBER;
6973: l_msg_data VARCHAR2 (2000) := NULL;
6974:
6975: TYPE qpListHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
6976: TYPE volumeOfferTypeTbl IS TABLE OF ozf_offers.volume_offer_type%TYPE;
6977:
6978: l_qpListHeaderIdTbl qpListHeaderIdTbl;
6979: l_volumeOfferTypeTbl volumeOfferTypeTbl;
6980:

Line 7135: FROM qp_list_headers_vl qp, ozf_offers ofr

7131:
7132: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
7133: ----- fix bug 5675871
7134: SELECT qp.description, qp.name ,nvl(ofr.transaction_currency_code, ofr.fund_request_curr_code)
7135: FROM qp_list_headers_vl qp, ozf_offers ofr
7136: WHERE qp.list_header_id = p_list_header_id
7137: AND qp.list_header_id = ofr.qp_list_header_id;
7138: /*
7139: SELECT description, name ,currency_code

Line 7604: FROM ozf_offers

7600: WHERE qp_list_header_id = p_list_header_id;
7601:
7602: CURSOR c_offer_curr IS
7603: SELECT nvl(transaction_currency_code,fund_request_curr_code)
7604: FROM ozf_offers
7605: WHERE qp_list_header_id = p_list_header_id;
7606:
7607: l_volume_type VARCHAR2(30);
7608: l_offer_curr VARCHAR2(30);

Line 7942: FROM ozf_offers

7938: CURSOR c_offer_curr IS
7939: SELECT nvl(transaction_currency_code,fund_request_curr_code),
7940: transaction_currency_code,
7941: offer_id
7942: FROM ozf_offers
7943: WHERE qp_list_header_id = p_qp_list_header_id;
7944:
7945: --22-FEB-2007 kdass bug 5759350 - changed datatype of p_product_id from NUMBER to VARCHAR2 based on Feng's suggestion
7946: --fix for bug 5979971

Line 8993: FROM ozf_offers

8989: AND line.resale_line_id = adj.resale_line_id;
8990:
8991: CURSOR c_offer_curr IS
8992: SELECT nvl(transaction_currency_code,fund_request_curr_code), offer_id
8993: FROM ozf_offers
8994: WHERE qp_list_header_id = p_qp_list_header_id;
8995:
8996: --22-FEB-2007 kdass bug 5759350 - changed datatype of p_product_id from NUMBER to VARCHAR2 based on Feng's suggestion
8997: --fix for bug 5979971

Line 9007: FROM ozf_offers

9003:
9004: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
9005: SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code
9006: , beneficiary_account_id, offer_id
9007: FROM ozf_offers
9008: WHERE qp_list_header_id = p_list_header_id;
9009:
9010: CURSOR c_order_line_details (p_line_id IN NUMBER) IS
9011: SELECT invoice_to_org_id, ship_to_org_id