APPS.OE_ORDER_UTIL dependencies on OE_ORDER_LINES

Line 65: FROM OE_ORDER_LINES

61: WHERE HEADER_ID = p_header_id
62: FOR UPDATE NOWAIT;
63: CURSOR lines IS
64: SELECT line_id
65: FROM OE_ORDER_LINES
66: WHERE HEADER_ID = p_header_id
67: FOR UPDATE NOWAIT;
68: CURSOR price_adjustments IS
69: SELECT price_adjustment_id

Line 1355: FROM OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL

1351: WHERE HEADER_ID=p_header_id;
1352: ELSIF p_header_id IS NULL AND p_currency_code IS NULL AND p_line_id IS NOT NULL THEN
1353: SELECT /*MOAC_SQL_CHANGES*/ OH.TRANSACTIONAL_CURR_CODE
1354: INTO l_currency_code
1355: FROM OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL
1356: WHERE OH.HEADER_ID=OL.HEADER_ID
1357: AND OL.LINE_ID=p_line_id;
1358: ELSIF p_currency_code IS NOT NULL THEN
1359: l_currency_code:=p_currency_code;