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.OE_SALES_CAN_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 1365: from oe_price_adjustments opa1,

1361: /* Fix for bug # 2387919 */
1362: begin
1363: select count(*)
1364: into l_prg_line_count
1365: from oe_price_adjustments opa1,
1366: oe_price_adjustments opa2,
1367: oe_price_adj_assocs opaa
1368: where opa1.list_line_type_code = 'PRG'
1369: and opa1.price_adjustment_id = opaa.price_adjustment_id

Line 1366: oe_price_adjustments opa2,

1362: begin
1363: select count(*)
1364: into l_prg_line_count
1365: from oe_price_adjustments opa1,
1366: oe_price_adjustments opa2,
1367: oe_price_adj_assocs opaa
1368: where opa1.list_line_type_code = 'PRG'
1369: and opa1.price_adjustment_id = opaa.price_adjustment_id
1370: and opa2.price_adjustment_id = opaa.rltd_price_adj_id

Line 1997: from oe_price_adjustments opa1,

1993: /* Fix for bug # 2387919 */
1994: begin
1995: select count(*)
1996: into l_prg_line_count
1997: from oe_price_adjustments opa1,
1998: oe_price_adjustments opa2,
1999: oe_price_adj_assocs opaa,
2000: oe_order_lines_all ol --bug 4156493
2001: where opa1.list_line_type_code = 'PRG'

Line 1998: oe_price_adjustments opa2,

1994: begin
1995: select count(*)
1996: into l_prg_line_count
1997: from oe_price_adjustments opa1,
1998: oe_price_adjustments opa2,
1999: oe_price_adj_assocs opaa,
2000: oe_order_lines_all ol --bug 4156493
2001: where opa1.list_line_type_code = 'PRG'
2002: and opa1.price_adjustment_id = opaa.price_adjustment_id