eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 1584: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p

1580: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
1581:
1582: BEGIN
1583: SELECT h.version_number INTO l_current_version_number
1584: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p
1585: WHERE h.header_id = p.header_id
1586: AND p.price_adjustment_id = p_price_adjustment_id;
1587: EXCEPTION WHEN NO_DATA_FOUND THEN
1588: SELECT h.version_number INTO l_current_version_number

Line 1589: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p

1585: WHERE h.header_id = p.header_id
1586: AND p.price_adjustment_id = p_price_adjustment_id;
1587: EXCEPTION WHEN NO_DATA_FOUND THEN
1588: SELECT h.version_number INTO l_current_version_number
1589: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p
1590: WHERE h.header_id = p.header_id
1591: AND p.price_adjustment_id = p_price_adjustment_id
1592: AND rownum = 1;
1593: END;

Line 1599: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s

1595: ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1596:
1597: BEGIN
1598: SELECT h.version_number INTO l_current_version_number
1599: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s
1600: WHERE h.header_id = s.header_id
1601: AND s.sales_credit_id = p_sales_credit_id;
1602: EXCEPTION WHEN NO_DATA_FOUND THEN
1603: SELECT h.version_number INTO l_current_version_number

Line 1604: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s

1600: WHERE h.header_id = s.header_id
1601: AND s.sales_credit_id = p_sales_credit_id;
1602: EXCEPTION WHEN NO_DATA_FOUND THEN
1603: SELECT h.version_number INTO l_current_version_number
1604: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s
1605: WHERE h.header_id = s.header_id
1606: AND s.sales_credit_id = p_sales_credit_id
1607: AND rownum = 1;
1608: END;

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

Line 1618: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY 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
1618: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY l
1619: WHERE h.header_id = l.header_id
1620: AND l.line_id = p_line_id
1621: AND rownum = 1;
1622: END;

Line 1627: FROM OE_ORDER_HEADERS_ALL WHERE header_id = p_header_id;

1623:
1624: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
1625:
1626: SELECT version_number INTO l_current_version_number
1627: FROM OE_ORDER_HEADERS_ALL WHERE header_id = p_header_id;
1628:
1629: END IF;
1630:
1631: RETURN l_current_version_number;