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 1647: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p

1643: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
1644:
1645: BEGIN
1646: SELECT h.version_number INTO l_current_version_number
1647: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p
1648: WHERE h.header_id = p.header_id
1649: AND p.price_adjustment_id = p_price_adjustment_id;
1650: EXCEPTION WHEN NO_DATA_FOUND THEN
1651: SELECT h.version_number INTO l_current_version_number

Line 1652: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p

1648: WHERE h.header_id = p.header_id
1649: AND p.price_adjustment_id = p_price_adjustment_id;
1650: EXCEPTION WHEN NO_DATA_FOUND THEN
1651: SELECT h.version_number INTO l_current_version_number
1652: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p
1653: WHERE h.header_id = p.header_id
1654: AND p.price_adjustment_id = p_price_adjustment_id
1655: AND rownum = 1;
1656: END;

Line 1662: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s

1658: ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1659:
1660: BEGIN
1661: SELECT h.version_number INTO l_current_version_number
1662: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s
1663: WHERE h.header_id = s.header_id
1664: AND s.sales_credit_id = p_sales_credit_id;
1665: EXCEPTION WHEN NO_DATA_FOUND THEN
1666: SELECT h.version_number INTO l_current_version_number

Line 1667: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s

1663: WHERE h.header_id = s.header_id
1664: AND s.sales_credit_id = p_sales_credit_id;
1665: EXCEPTION WHEN NO_DATA_FOUND THEN
1666: SELECT h.version_number INTO l_current_version_number
1667: FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s
1668: WHERE h.header_id = s.header_id
1669: AND s.sales_credit_id = p_sales_credit_id
1670: AND rownum = 1;
1671: END;

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

Line 1681: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY 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
1681: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY l
1682: WHERE h.header_id = l.header_id
1683: AND l.line_id = p_line_id
1684: AND rownum = 1;
1685: END;

Line 1690: FROM OE_ORDER_HEADERS_ALL WHERE header_id = p_header_id;

1686:
1687: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
1688:
1689: SELECT version_number INTO l_current_version_number
1690: FROM OE_ORDER_HEADERS_ALL WHERE header_id = p_header_id;
1691:
1692: END IF;
1693:
1694: RETURN l_current_version_number;