APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_ORDER_LINES

Line 22: FROM OE_ORDER_LINES

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

Line 52: FROM OE_ORDER_LINES

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

Line 1030: FROM OE_ORDER_LINES

1026: BEGIN
1027:
1028: SELECT line_number
1029: INTO l_set_line_number
1030: FROM OE_ORDER_LINES
1031: WHERE LINE_SET_ID = p_line_set_id
1032: AND ROWNUM = 1;
1033:
1034: RETURN l_set_line_number;

Line 1069: FROM OE_ORDER_LINES

1065: SELECT SUM(nvl(ordered_quantity,0))
1066: ,SUM(nvl(ordered_quantity,0) * nvl(unit_selling_price,0))
1067: INTO l_set_quantity
1068: ,l_set_amount
1069: FROM OE_ORDER_LINES
1070: WHERE line_set_id = p_line_set_id
1071: AND blanket_number = p_blanket_number
1072: AND blanket_line_number = p_blanket_line_number;
1073:

Line 1353: from oe_order_lines

1349:
1350: begin
1351: select header_id
1352: into l_hdr_id
1353: from oe_order_lines
1354: where line_id = p_request_tbl_temp(I).entity_id;
1355:
1356:
1357: --ER6795052

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: