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_BLKT_RELEASE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1562: FROM OE_ORDER_LINES_ALL

1558:
1559: BEGIN
1560: SELECT HEADER_ID, ORDERED_QUANTITY, UNIT_SELLING_PRICE
1561: INTO l_header_id, l_old_quantity, l_old_unit_sp
1562: FROM OE_ORDER_LINES_ALL
1563: WHERE LINE_ID = p_line_id;
1564: EXCEPTION
1565: -- If QP sourcing API is called while the line is still not
1566: -- saved e.g. when tabbing out of qty field from the UI, no data

Line 1600: FROM OE_ORDER_LINES_ALL

1596: SELECT sum(nvl(ordered_quantity,0)),
1597: sum(nvl(ordered_quantity,0)*nvl(unit_selling_price,0))
1598: INTO l_rem_bl_line_qty
1599: ,l_rem_bl_line_amt
1600: FROM OE_ORDER_LINES_ALL
1601: WHERE HEADER_ID = l_header_id
1602: AND BLANKET_NUMBER = p_blanket_number
1603: AND BLANKET_LINE_NUMBER = p_blanket_line_number
1604: AND LINE_ID <> p_line_id;

Line 1619: FROM OE_ORDER_LINES_ALL

1615: -- Compute the old qty/amt consumed against this blanket header
1616: -- from other lines on this order
1617: SELECT sum(nvl(ordered_quantity,0)*nvl(unit_selling_price,0))
1618: INTO l_rem_bl_hdr_amt
1619: FROM OE_ORDER_LINES_ALL
1620: WHERE HEADER_ID = l_header_id
1621: AND BLANKET_NUMBER = p_blanket_number
1622: AND LINE_ID <> p_line_id;
1623: