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_ADJUSTMENT_LINES

Line 1737: FROM ozf_offer_adjustment_lines adj, qp_list_lines lines, ozf_offer_adj_rltd_lines rltd

1733: --get the products for an adjustment
1734: CURSOR c_adjusted_line_cur (p_offer_adjustment_id IN NUMBER) IS
1735: SELECT adj.original_discount, adj.modified_discount, lines.arithmetic_operator,
1736: adj.created_from_adjustments, lines.list_line_id, rltd.to_list_line_id
1737: FROM ozf_offer_adjustment_lines adj, qp_list_lines lines, ozf_offer_adj_rltd_lines rltd
1738: WHERE adj.offer_adjustment_id = p_offer_adjustment_id
1739: AND lines.list_line_type_code = 'DIS'
1740: AND lines.list_line_id = adj.list_line_id
1741: AND rltd.from_list_line_id = adj.list_line_id

Line 2117: ozf_offer_adjustment_lines adjl,

2113: ,util.reference_type
2114: ,util.reference_id
2115: FROM ozf_funds_utilized_all_b util,
2116: ozf_temp_eligibility temp,
2117: ozf_offer_adjustment_lines adjl,
2118: oe_order_lines_all ol,
2119: oe_price_adjustments oe
2120: WHERE util.plan_type = 'OFFR'
2121: AND product_id IS NOT NULL

Line 2165: ozf_offer_adjustment_lines adjl,

2161: ,util.reference_type
2162: ,util.reference_id
2163: FROM ozf_funds_utilized_all_b util,
2164: ozf_temp_eligibility temp,
2165: ozf_offer_adjustment_lines adjl,
2166: OZF_RESALE_ADJUSTMENTS_ALL oe
2167: WHERE util.plan_type = 'OFFR'
2168: AND product_id IS NOT NULL
2169: AND util.plan_id = p_qp_list_header_id

Line 2200: ozf_offer_adjustment_lines adjl,

2196: ) amount
2197: FROM ozf_funds_utilized_all_b util,
2198: oe_price_adj_assocs assocs,
2199: oe_price_adjustments oe,
2200: ozf_offer_adjustment_lines adjl,
2201: ozf_temp_eligibility temp
2202: WHERE util.plan_id = p_qp_list_header_id
2203: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)
2204: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id

Line 2243: ozf_offer_adjustment_lines adjl,

2239: ,util.reference_type
2240: ,util.reference_id
2241: FROM ozf_funds_utilized_all_b util,
2242: ozf_temp_eligibility temp,
2243: ozf_offer_adjustment_lines adjl,
2244: oe_order_lines_all ol,
2245: oe_price_adjustments oe
2246: WHERE util.plan_type = 'OFFR'
2247: AND product_id IS NOT NULL

Line 2289: ozf_offer_adjustment_lines adjl,

2285: ,util.reference_type
2286: ,util.reference_id
2287: FROM ozf_funds_utilized_all_b util,
2288: ozf_temp_eligibility temp,
2289: ozf_offer_adjustment_lines adjl,
2290: OZF_RESALE_ADJUSTMENTS_ALL oe
2291: WHERE util.plan_type = 'OFFR'
2292: AND product_id IS NOT NULL
2293: AND util.plan_id = p_qp_list_header_id

Line 2332: ozf_offer_adjustment_lines adjl,

2328: ,util.reference_type
2329: ,util.reference_id
2330: FROM ozf_funds_utilized_all_b util,
2331: ozf_temp_eligibility temp,
2332: ozf_offer_adjustment_lines adjl,
2333: oe_order_lines_all ol,
2334: oe_price_adjustments oe
2335: WHERE util.plan_type = 'OFFR'
2336: AND product_id IS NOT NULL

Line 2379: ozf_offer_adjustment_lines adjl,

2375: ,util.reference_type
2376: ,util.reference_id
2377: FROM ozf_funds_utilized_all_b util,
2378: ozf_temp_eligibility temp,
2379: ozf_offer_adjustment_lines adjl,
2380: OZF_RESALE_ADJUSTMENTS_ALL oe
2381: WHERE util.plan_type = 'OFFR'
2382: AND product_id IS NOT NULL
2383: AND util.plan_id = p_qp_list_header_id

Line 2414: ozf_offer_adjustment_lines adjl,

2410: ,util.bill_to_site_use_id
2411: ,util.reference_type
2412: ,util.reference_id
2413: FROM ozf_funds_utilized_all_b util,
2414: ozf_offer_adjustment_lines adjl,
2415: oe_order_lines_all ol,
2416: oe_price_adjustments oe
2417: WHERE util.plan_type = 'OFFR'
2418: AND util.plan_id = p_qp_list_header_id

Line 2462: ozf_offer_adjustment_lines adjl,

2458: ,util.reference_type
2459: ,util.reference_id
2460: FROM ozf_funds_utilized_all_b util,
2461: ozf_temp_eligibility temp,
2462: ozf_offer_adjustment_lines adjl,
2463: oe_order_lines_all ol,
2464: oe_price_adjustments oe
2465: WHERE util.plan_type = 'OFFR'
2466: AND product_id IS NOT NULL

Line 2810: FROM ozf_offer_adjustment_lines adjl, qp_pricing_attributes qppa

2806: CURSOR c_off_adj_lines IS
2807: SELECT offer_adjustment_line_id,
2808: qppa.product_attribute,
2809: qppa.product_attr_value
2810: FROM ozf_offer_adjustment_lines adjl, qp_pricing_attributes qppa
2811: WHERE adjl.offer_adjustment_id = p_offer_adjustment_id AND adjl.list_line_id = qppa.list_line_id;
2812: BEGIN
2813: -- ozf_utility_pvt.debug_message('enter validate_product_budget obj_id=' || p_object_id || ' budget_id=' || p_budget_id);
2814:

Line 3389: ozf_offer_adjustment_lines adjl

3385: ) /*
3386: select product_id , cust_account_id , fund_id , sum(DECODE(adjl.arithmetic_operator,'AMOUNT', (adjl.modified_discount - adjl.original_discount),
3387: (( adjl.modified_discount - adjl.original_discount)* amount/adjl.original_discount))) AMount
3388: from ozf_funds_utilized_all_vl util , ozf_temp_eligibility temp,
3389: ozf_offer_adjustment_lines adjl
3390: where util.plan_type = 'OFFR'
3391: and product_id IS NOT NULL and util.plan_id = 7909
3392: and util.product_id = temp.eligibility_id
3393: and temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id