DBA Data[Home] [Help]

APPS.OE_ORDER_CACHE dependencies on OE_ORDER_LINES

Line 1342: oe_order_lines oeorln

1338: g_line_discount_rec.price_adjustment_id
1339: FROM oe_discounts sodsc,
1340: oe_discount_lines sodls,
1341: oe_price_break_lines sopbl,
1342: oe_order_lines oeorln
1343: WHERE sodls.discount_line_id = l_discount_line_id
1344: AND sodls.discount_id = sodsc.discount_id
1345: AND sopbl.discount_line_id(+) = sodls.discount_line_id
1346: AND oeorln.line_id = l_line_id;

Line 1363: oe_order_lines oeorln

1359: g_line_discount_rec.discount_line_id,
1360: g_line_discount_rec.adjustment_name,
1361: g_line_discount_rec.price_adjustment_id
1362: FROM oe_discounts sodsc,
1363: oe_order_lines oeorln
1364: WHERE sodsc.discount_id = l_discount_id
1365: AND oeorln.line_id = l_line_id;
1366:
1367: END IF;