APPS.OE_LINE_FULLFILL dependencies on OE_BLANKET_HEADERS

Line 62: FROM OE_BLANKET_HEADERS

58: nvl(p_line_rec.unit_selling_price,0);
59:
60: SELECT transactional_curr_code, conversion_type_code
61: INTO l_blanket_currency, l_conversion_type
62: FROM OE_BLANKET_HEADERS
63: WHERE ORDER_NUMBER = p_line_rec.blanket_number
64: AND SALES_DOCUMENT_TYPE_CODE = 'B';
65:
66: IF l_order_currency <> l_blanket_currency THEN

Line 149: UPDATE oe_blanket_headers_ext bhe

145: WHERE ble.order_number = p_line_rec.blanket_number
146: AND ble.line_number = p_line_rec.blanket_line_number;
147: END IF;
148:
149: UPDATE oe_blanket_headers_ext bhe
150: SET bhe.fulfilled_amount = nvl(bhe.fulfilled_amount,0) +
151: l_amount
152: WHERE bhe.order_number = p_line_rec.blanket_number;
153:

Line 154: UPDATE oe_blanket_headers bh

150: SET bhe.fulfilled_amount = nvl(bhe.fulfilled_amount,0) +
151: l_amount
152: WHERE bhe.order_number = p_line_rec.blanket_number;
153:
154: UPDATE oe_blanket_headers bh
155: SET bh.lock_control = bh.lock_control + 1
156: WHERE bh.order_number = p_line_rec.blanket_number
157: AND bh.sales_document_type_code = 'B';
158:

Line 188: UPDATE oe_blanket_headers_ext bhe

184: WHERE bl.order_number = p_line_rec.blanket_number
185: AND bl.line_number = p_line_rec.blanket_line_number)
186: AND bl.sales_document_type_code = 'B';
187:
188: UPDATE oe_blanket_headers_ext bhe
189: SET bhe.returned_amount = nvl(bhe.returned_amount,0) +
190: l_amount
191: WHERE bhe.order_number = p_line_rec.blanket_number;
192:

Line 193: UPDATE oe_blanket_headers bh

189: SET bhe.returned_amount = nvl(bhe.returned_amount,0) +
190: l_amount
191: WHERE bhe.order_number = p_line_rec.blanket_number;
192:
193: UPDATE oe_blanket_headers bh
194: SET bh.lock_control = bh.lock_control + 1
195: WHERE bh.order_number = p_line_rec.blanket_number
196: AND bh.sales_document_type_code = 'B';
197: