APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_LINES_ALL

Line 30: FROM oe_order_lines_all

26:
27: IF p_flow_status_code is null THEN
28: SELECT flow_status_code
29: INTO l_flow_status_code
30: FROM oe_order_lines_all
31: WHERE line_id=p_line_id;
32: END IF;
33:
34: IF l_flow_status_code <> 'AWAITING_SHIPPING' AND

Line 1272: FROM OE_ORDER_LINES_ALL a

1268: SERVICE_BILL_OPTION_CODE,
1269: SERVICE_FIRST_PERIOD_AMOUNT,
1270: SUBSCRIPTION_ENABLE_FLAG,
1271: SERVICE_FIRST_PERIOD_ENDDATE
1272: FROM OE_ORDER_LINES_ALL a
1273: WHERE header_id = p_header_id
1274: AND NOT EXISTS (select b.line_id
1275: FROM oe_order_lines_history b
1276: WHERE a.line_id = b.line_id

Line 1676: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l

1672: ELSIF p_line_id <> FND_API.G_MISS_NUM THEN
1673:
1674: BEGIN
1675: SELECT h.version_number INTO l_current_version_number
1676: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l
1677: WHERE h.header_id = l.header_id
1678: AND l.line_id = p_line_id;
1679: EXCEPTION WHEN NO_DATA_FOUND THEN
1680: SELECT h.version_number INTO l_current_version_number