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_OFFER_ADJUSTMENTS_B

Line 1937: FROM ozf_offer_adjustments_b

1933: SELECT offer_adjustment_id,
1934: list_header_id,
1935: effective_date,
1936: approved_date
1937: FROM ozf_offer_adjustments_b
1938: WHERE status_code = 'ACTIVE'
1939: AND nvl(budget_adjusted_flag, 'N') = 'N'
1940: AND effective_date < approved_date; --query only backdated adjustments
1941:

Line 2045: ozf_offer_adjustments_b adj,

2041: line.shipping_quantity2, -- Catch Weight ER
2042: line.fulfillment_base -- Catch Weight ER
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,

Line 2144: ozf_offer_adjustments_b adj,

2140: line.shipping_quantity2, -- Catch Weight ER
2141: line.fulfillment_base -- Catch Weight ER
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,

Line 2250: ozf_offer_adjustments_b adj,

2246: line.shipping_quantity2, -- Catch Weight ER
2247: line.fulfillment_base -- Catch Weight ER
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,

Line 2348: ozf_offer_adjustments_b adj,

2344: line.shipping_quantity2, -- Catch Weight ER
2345: line.fulfillment_base -- Catch Weight ER
2346: FROM oe_order_lines_all line,
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,

Line 2434: ozf_offer_adjustments_b adj,

2430: line.shipping_quantity2, -- Catch Weight ER
2431: line.fulfillment_base -- Catch Weight ER
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,

Line 2532: ozf_offer_adjustments_b adj,

2528: line.shipping_quantity2, -- Catch Weight ER
2529: line.fulfillment_base -- Catch Weight ER
2530: FROM oe_order_lines_all line,
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,

Line 2787: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;

2783:
2784: l_end_date DATE;
2785: l_type VARCHAR2(7) := NULL;
2786:
2787: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;
2788: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;
2789: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;
2790: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;
2791:

Line 2788: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;

2784: l_end_date DATE;
2785: l_type VARCHAR2(7) := NULL;
2786:
2787: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;
2788: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;
2789: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;
2790: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;
2791:
2792: l_offerAdjustmentIdTbl offerAdjustmentIdTbl;

Line 2789: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;

2785: l_type VARCHAR2(7) := NULL;
2786:
2787: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;
2788: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;
2789: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;
2790: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;
2791:
2792: l_offerAdjustmentIdTbl offerAdjustmentIdTbl;
2793: l_listHeaderIdTbl listHeaderIdTbl;

Line 2790: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;

2786:
2787: TYPE offerAdjustmentIdTbl IS TABLE OF ozf_offer_adjustments_b.offer_adjustment_id%TYPE;
2788: TYPE listHeaderIdTbl IS TABLE OF ozf_offer_adjustments_b.list_header_id%TYPE;
2789: TYPE effectiveDateTbl IS TABLE OF ozf_offer_adjustments_b.effective_date%TYPE;
2790: TYPE approvedDateTbl IS TABLE OF ozf_offer_adjustments_b.approved_date%TYPE;
2791:
2792: l_offerAdjustmentIdTbl offerAdjustmentIdTbl;
2793: l_listHeaderIdTbl listHeaderIdTbl;
2794: l_effectiveDateTbl effectiveDateTbl;

Line 3918: UPDATE ozf_offer_adjustments_b b

3914: write_conc_log ('Closing adjustments ' );
3915: END IF;
3916:
3917: FORALL t_i IN INDICES OF l_adjIdByListHdrId
3918: UPDATE ozf_offer_adjustments_b b
3919: SET budget_adjusted_flag = 'Y',
3920: object_version_number = object_version_number + 1,
3921: status_code = 'CLOSED'
3922: WHERE offer_adjustment_id = l_adjidbylisthdrid(t_i)