DBA Data[Home] [Help]

APPS.OE_LINE_FULLFILL dependencies on OE_BLANKET_HEADERS_EXT

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 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: