DBA Data[Home] [Help]

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 1367: FROM OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL

1363: END IF;
1364: --End of bug12616480
1365: SELECT /*MOAC_SQL_CHANGES*/ OH.TRANSACTIONAL_CURR_CODE
1366: INTO l_currency_code
1367: FROM OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL
1368: WHERE OH.HEADER_ID=OL.HEADER_ID
1369: AND OL.LINE_ID=p_line_id;
1370: ELSIF p_currency_code IS NOT NULL THEN
1371: l_currency_code:=p_currency_code;