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_ADJ_RLTD_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 2128: FROM ozf_offer_adj_rltd_lines adjr

2124: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
2125: -- yzhao 01/13/2006 fix bug 4939453 offer adjustment creates new list_line_id
2126: -- AND adjl.list_line_id = oe.list_line_id
2127: AND oe.list_line_id IN (SELECT from_list_line_id
2128: FROM ozf_offer_adj_rltd_lines adjr
2129: START WITH adjr.from_list_line_id = adjl.list_line_id
2130: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
2131: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2132: )

Line 2254: FROM ozf_offer_adj_rltd_lines adjr

2250: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
2251: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
2252: -- AND adjl.list_line_id = oe.list_line_id
2253: AND oe.list_line_id IN (SELECT from_list_line_id
2254: FROM ozf_offer_adj_rltd_lines adjr
2255: START WITH adjr.from_list_line_id = adjl.list_line_id
2256: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
2257: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2258: )

Line 2343: FROM ozf_offer_adj_rltd_lines adjr

2339: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
2340: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
2341: -- AND adjl.list_line_id = oe.list_line_id
2342: AND oe.list_line_id IN (SELECT from_list_line_id
2343: FROM ozf_offer_adj_rltd_lines adjr
2344: START WITH adjr.from_list_line_id = adjl.list_line_id
2345: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
2346: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2347: )

Line 2422: FROM ozf_offer_adj_rltd_lines adjr

2418: AND util.plan_id = p_qp_list_header_id
2419: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
2420: -- AND adjl.list_line_id = oe.list_line_id
2421: AND oe.list_line_id IN (SELECT from_list_line_id
2422: FROM ozf_offer_adj_rltd_lines adjr
2423: START WITH adjr.from_list_line_id = adjl.list_line_id
2424: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
2425: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2426: )

Line 2473: FROM ozf_offer_adj_rltd_lines adjr

2469: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
2470: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
2471: -- AND adjl.list_line_id = oe.list_line_id
2472: AND oe.list_line_id IN (SELECT from_list_line_id
2473: FROM ozf_offer_adj_rltd_lines adjr
2474: START WITH adjr.from_list_line_id = adjl.list_line_id
2475: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
2476: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2477: )