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 1961: ozf_offer_adj_rltd_lines rltd

1957: SELECT adj.offer_adjustment_line_id,
1958: to_list_line_id
1959: FROM ozf_offer_adjustment_lines adj,
1960: qp_list_lines lines,
1961: ozf_offer_adj_rltd_lines rltd
1962: WHERE adj.offer_adjustment_id = p_offer_adjustment_id
1963: AND lines.list_line_type_code = 'DIS'
1964: AND lines.list_line_id =nvl(adj.list_line_id, adj.list_line_id_td)
1965: AND rltd.from_list_line_id = adj.list_line_id

Line 2077: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id

2073: AND off.qp_list_header_id = lines.list_header_id
2074: AND adj.list_header_id = lines.list_header_id
2075: AND lines.list_line_id IN
2076: (SELECT from_list_line_id
2077: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id
2078: AND adjr.offer_adjustment_id = adj_line.offer_adjustment_id CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2079: UNION ALL
2080: SELECT list_line_id
2081: FROM ozf_offer_adjustment_lines);

Line 2176: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id

2172: AND off.qp_list_header_id = lines.list_header_id
2173: AND adj.list_header_id = lines.list_header_id
2174: AND lines.list_line_id IN
2175: (SELECT from_list_line_id
2176: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id
2177: AND adjr.offer_adjustment_id = adj_line.offer_adjustment_id CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2178: UNION ALL
2179: SELECT list_line_id
2180: FROM ozf_offer_adjustment_lines);

Line 2282: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id

2278: AND off.qp_list_header_id = lines.list_header_id
2279: AND adj.list_header_id = lines.list_header_id
2280: AND lines.list_line_id IN
2281: (SELECT from_list_line_id
2282: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id
2283: AND adjr.offer_adjustment_id = adj_line.offer_adjustment_id CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2284: UNION ALL
2285: SELECT list_line_id
2286: FROM ozf_offer_adjustment_lines)

Line 2466: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id

2462: AND off.qp_list_header_id = lines.list_header_id
2463: AND adj.list_header_id = lines.list_header_id
2464: AND lines.list_line_id IN
2465: (SELECT from_list_line_id
2466: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id
2467: AND adjr.offer_adjustment_id = adj_line.offer_adjustment_id CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2468: UNION ALL
2469: SELECT list_line_id
2470: FROM ozf_offer_adjustment_lines)

Line 4007: FROM ozf_offer_adj_rltd_lines

4003: FROM oe_price_adjustments
4004: WHERE line_id = p_line_id
4005: AND list_header_id = p_list_header_id
4006: AND list_line_id IN (SELECT from_list_line_id
4007: FROM ozf_offer_adj_rltd_lines
4008: START WITH to_list_line_id = p_list_line_id
4009: CONNECT BY PRIOR from_list_line_id = to_list_line_id
4010: UNION ALL
4011: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id = p_list_line_id ) ;

Line 4011: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id = p_list_line_id ) ;

4007: FROM ozf_offer_adj_rltd_lines
4008: START WITH to_list_line_id = p_list_line_id
4009: CONNECT BY PRIOR from_list_line_id = to_list_line_id
4010: UNION ALL
4011: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id = p_list_line_id ) ;
4012:
4013: --for volume offer, duplicate item cannot be added to the offer.
4014: CURSOR hdr_adjustment_csr IS
4015: SELECT 1

Line 4848: FROM ozf_offer_adj_rltd_lines

4844: FROM ozf_funds_utilized_all_b
4845: WHERE plan_type = 'OFFR'
4846: AND plan_id = p_list_header_id
4847: AND list_line_id IN (SELECT from_list_line_id
4848: FROM ozf_offer_adj_rltd_lines
4849: START WITH to_list_line_id = p_list_line_id
4850: CONNECT BY PRIOR from_list_line_id = to_list_line_id
4851: UNION ALL
4852: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines WHERE to_list_line_id =p_list_line_id)

Line 4852: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines WHERE to_list_line_id =p_list_line_id)

4848: FROM ozf_offer_adj_rltd_lines
4849: START WITH to_list_line_id = p_list_line_id
4850: CONNECT BY PRIOR from_list_line_id = to_list_line_id
4851: UNION ALL
4852: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines WHERE to_list_line_id =p_list_line_id)
4853: AND object_type = 'ORDER'
4854: AND object_id = p_object_id
4855: AND order_line_id = p_order_line_id
4856: AND product_level_type = 'PRODUCT'

Line 5367: FROM ozf_offer_adj_rltd_lines

5363: FROM ozf_funds_utilized_all_b
5364: WHERE plan_type = 'OFFR'
5365: AND plan_id = p_list_header_id
5366: AND list_line_id IN (SELECT from_list_line_id
5367: FROM ozf_offer_adj_rltd_lines
5368: START WITH to_list_line_id = p_list_line_id
5369: CONNECT BY PRIOR from_list_line_id = to_list_line_id
5370: UNION ALL
5371: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id =p_list_line_id)

Line 5371: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id =p_list_line_id)

5367: FROM ozf_offer_adj_rltd_lines
5368: START WITH to_list_line_id = p_list_line_id
5369: CONNECT BY PRIOR from_list_line_id = to_list_line_id
5370: UNION ALL
5371: SELECT to_list_line_id FROM ozf_offer_adj_rltd_lines where to_list_line_id =p_list_line_id)
5372: AND object_type = 'ORDER'
5373: AND object_id = p_object_id
5374: AND order_line_id = p_order_line_id
5375: AND product_level_type = 'PRODUCT'

Line 6041: FROM ozf_offer_adj_rltd_lines adjr

6037: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
6038: -- yzhao 01/13/2006 fix bug 4939453 offer adjustment creates new list_line_id
6039: -- AND adjl.list_line_id = oe.list_line_id
6040: AND oe.list_line_id IN (SELECT from_list_line_id
6041: FROM ozf_offer_adj_rltd_lines adjr
6042: START WITH adjr.from_list_line_id = adjl.list_line_id
6043: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
6044: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
6045: )

Line 6095: FROM ozf_offer_adj_rltd_lines adjr

6091: AND util.plan_id = p_qp_list_header_id
6092: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)
6093: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
6094: AND oe.list_line_id IN (SELECT from_list_line_id -- = oe.list_line_id : Fix for bug 12660466
6095: FROM ozf_offer_adj_rltd_lines adjr
6096: START WITH adjr.from_list_line_id = adjl.list_line_id
6097: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
6098: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
6099: )

Line 6183: FROM ozf_offer_adj_rltd_lines adjr

6179: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
6180: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
6181: -- AND adjl.list_line_id = oe.list_line_id
6182: AND oe.list_line_id IN (SELECT from_list_line_id
6183: FROM ozf_offer_adj_rltd_lines adjr
6184: START WITH adjr.from_list_line_id = adjl.list_line_id
6185: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
6186: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
6187: )

Line 6234: FROM ozf_offer_adj_rltd_lines adjr

6230: AND util.plan_id = p_qp_list_header_id
6231: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)
6232: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
6233: AND oe.list_line_id IN (SELECT from_list_line_id -- = oe.list_line_id : Fix for bug 12660466
6234: FROM ozf_offer_adj_rltd_lines adjr
6235: START WITH adjr.from_list_line_id = adjl.list_line_id_td
6236: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
6237: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
6238: )

Line 6287: FROM ozf_offer_adj_rltd_lines adjr

6283: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
6284: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
6285: -- AND adjl.list_line_id = oe.list_line_id
6286: AND oe.list_line_id IN (SELECT from_list_line_id
6287: FROM ozf_offer_adj_rltd_lines adjr
6288: START WITH adjr.from_list_line_id = adjl.list_line_id
6289: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
6290: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
6291: )

Line 6339: FROM ozf_offer_adj_rltd_lines adjr

6335: AND util.plan_id = p_qp_list_header_id
6336: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)
6337: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
6338: AND oe.list_line_id IN (SELECT from_list_line_id -- = oe.list_line_id : Fix for bug 12660466
6339: FROM ozf_offer_adj_rltd_lines adjr
6340: START WITH adjr.from_list_line_id = adjl.list_line_id
6341: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
6342: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
6343: )

Line 6381: FROM ozf_offer_adj_rltd_lines adjr

6377: AND util.plan_id = p_qp_list_header_id
6378: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
6379: -- AND adjl.list_line_id = oe.list_line_id
6380: AND oe.list_line_id IN (SELECT from_list_line_id
6381: FROM ozf_offer_adj_rltd_lines adjr
6382: START WITH adjr.from_list_line_id = adjl.list_line_id
6383: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
6384: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
6385: )

Line 6434: FROM ozf_offer_adj_rltd_lines adjr

6430: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id
6431: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
6432: -- AND adjl.list_line_id = oe.list_line_id
6433: AND oe.list_line_id IN (SELECT from_list_line_id
6434: FROM ozf_offer_adj_rltd_lines adjr
6435: START WITH adjr.from_list_line_id = adjl.list_line_id
6436: AND adjr.offer_adjustment_id = adjl.offer_adjustment_id
6437: CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
6438: )