APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_ORDER_LINES

Line 21: FROM OE_ORDER_LINES

17: BEGIN
18:
19: SELECT LINE_NUMBER
20: INTO l_line_number
21: FROM OE_ORDER_LINES
22: WHERE LINE_ID = p_line_id;
23:
24: RETURN l_line_number;
25:

Line 51: FROM OE_ORDER_LINES

47: BEGIN
48:
49: SELECT SHIPMENT_NUMBER
50: INTO l_shipment_number
51: FROM OE_ORDER_LINES
52: WHERE LINE_ID = p_line_id;
53:
54: RETURN l_shipment_number;
55:

Line 1004: FROM OE_ORDER_LINES

1000: BEGIN
1001:
1002: SELECT line_number
1003: INTO l_set_line_number
1004: FROM OE_ORDER_LINES
1005: WHERE LINE_SET_ID = p_line_set_id
1006: AND ROWNUM = 1;
1007:
1008: RETURN l_set_line_number;

Line 1041: FROM OE_ORDER_LINES

1037: SELECT SUM(nvl(ordered_quantity,0))
1038: ,SUM(nvl(ordered_quantity,0) * nvl(unit_selling_price,0))
1039: INTO l_set_quantity
1040: ,l_set_amount
1041: FROM OE_ORDER_LINES
1042: WHERE line_set_id = p_line_set_id
1043: AND blanket_number = p_blanket_number
1044: AND blanket_line_number = p_blanket_line_number;
1045:

Line 1298: from oe_order_lines

1294:
1295: begin
1296: select header_id
1297: into l_hdr_id
1298: from oe_order_lines
1299: where line_id = p_request_tbl(I).entity_id;
1300:
1301:
1302: --ER6795052

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: