APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1647: FROM OE_ORDER_LINES_ALL

1643:
1644: BEGIN
1645: SELECT HEADER_ID, ORDERED_QUANTITY, UNIT_SELLING_PRICE
1646: INTO l_header_id, l_old_quantity, l_old_unit_sp
1647: FROM OE_ORDER_LINES_ALL
1648: WHERE LINE_ID = p_line_id;
1649: EXCEPTION
1650: -- If QP sourcing API is called while the line is still not
1651: -- saved e.g. when tabbing out of qty field from the UI, no data

Line 1685: FROM OE_ORDER_LINES_ALL

1681: SELECT sum(nvl(ordered_quantity,0)),
1682: sum(nvl(ordered_quantity,0)*nvl(unit_selling_price,0))
1683: INTO l_rem_bl_line_qty
1684: ,l_rem_bl_line_amt
1685: FROM OE_ORDER_LINES_ALL
1686: WHERE HEADER_ID = l_header_id
1687: AND BLANKET_NUMBER = p_blanket_number
1688: AND BLANKET_LINE_NUMBER = p_blanket_line_number
1689: AND LINE_ID <> p_line_id;

Line 1704: FROM OE_ORDER_LINES_ALL

1700: -- Compute the old qty/amt consumed against this blanket header
1701: -- from other lines on this order
1702: SELECT sum(nvl(ordered_quantity,0)*nvl(unit_selling_price,0))
1703: INTO l_rem_bl_hdr_amt
1704: FROM OE_ORDER_LINES_ALL
1705: WHERE HEADER_ID = l_header_id
1706: AND BLANKET_NUMBER = p_blanket_number
1707: AND LINE_ID <> p_line_id;
1708: