DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1209: FROM OE_ORDER_LINES_ALL a

1205: --key Transaction Dates
1206: order_firmed_date,
1207: CHARGE_PERIODICITY_CODE,
1208: actual_fulfillment_date
1209: FROM OE_ORDER_LINES_ALL a
1210: WHERE header_id = p_header_id
1211: AND NOT EXISTS (select b.line_id
1212: FROM oe_order_lines_history b
1213: WHERE a.line_id = b.line_id

Line 1613: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l

1609: ELSIF p_line_id <> FND_API.G_MISS_NUM THEN
1610:
1611: BEGIN
1612: SELECT h.version_number INTO l_current_version_number
1613: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l
1614: WHERE h.header_id = l.header_id
1615: AND l.line_id = p_line_id;
1616: EXCEPTION WHEN NO_DATA_FOUND THEN
1617: SELECT h.version_number INTO l_current_version_number