DBA Data[Home] [Help]

APPS.OE_SALES_CAN_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 1367: oe_price_adj_assocs opaa

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
1371: and opa2.line_id = l_line_old_tbl(j).line_id;

Line 1999: oe_price_adj_assocs opaa,

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
2003: and opa2.price_adjustment_id = opaa.rltd_price_adj_id