APPS.OE_LINE_FULLFILL dependencies on OE_BLANKET_LINES_EXT

Line 89: FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL

85: -- New Data Model Changes for Blanket Orders
86:
87: SELECT L.Order_Quantity_UOM
88: INTO l_blanket_uom
89: FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL
90: WHERE BL.ORDER_NUMBER = p_line_rec.blanket_number
91: AND BL.LINE_NUMBER = p_line_rec.blanket_line_number
92: AND L.LINE_ID = BL.LINE_ID
93: AND L.SALES_DOCUMENT_TYPE_CODE = 'B';

Line 124: WHERE L.Line_Id IN (SELECT Line_Id FROM oe_blanket_lines_ext bl

120: IF p_line_rec.line_category_code = 'ORDER' THEN
121:
122: UPDATE oe_blanket_lines l
123: SET l.lock_control = l.lock_control + 1
124: WHERE L.Line_Id IN (SELECT Line_Id FROM oe_blanket_lines_ext bl
125: WHERE bl.order_number = p_line_rec.blanket_number
126: AND bl.line_number = p_line_rec.blanket_line_number)
127: AND l.sales_document_type_code = 'B';
128:

Line 133: UPDATE oe_blanket_lines_ext ble

129: -- Bug 2734877
130: -- Update fulfilled qty only if uom is not null
131: -- If blanket uom is null, fulfilled qty should also be null
132: IF l_blanket_uom IS NULL THEN
133: UPDATE oe_blanket_lines_ext ble
134: SET ble.fulfilled_amount = nvl(ble.fulfilled_amount,0) +
135: l_amount
136: WHERE ble.order_number = p_line_rec.blanket_number
137: AND ble.line_number = p_line_rec.blanket_line_number;

Line 140: UPDATE oe_blanket_lines_ext ble

136: WHERE ble.order_number = p_line_rec.blanket_number
137: AND ble.line_number = p_line_rec.blanket_line_number;
138:
139: ELSE
140: UPDATE oe_blanket_lines_ext ble
141: SET ble.fulfilled_quantity = nvl(ble.fulfilled_quantity,0) +
142: l_fulfilled_quantity
143: ,ble.fulfilled_amount = nvl(ble.fulfilled_amount,0) +
144: l_amount

Line 165: UPDATE oe_blanket_lines_ext ble

161: -- Bug 2734877
162: -- Update returned qty only if uom is not null
163: -- If blanket uom is null, returned qty should also be null
164: IF l_blanket_uom IS NULL THEN
165: UPDATE oe_blanket_lines_ext ble
166: SET ble.returned_amount = nvl(ble.returned_amount,0) +
167: l_amount
168: WHERE ble.order_number = p_line_rec.blanket_number
169: AND ble.line_number = p_line_rec.blanket_line_number;

Line 172: UPDATE oe_blanket_lines_ext ble

168: WHERE ble.order_number = p_line_rec.blanket_number
169: AND ble.line_number = p_line_rec.blanket_line_number;
170:
171: ELSE
172: UPDATE oe_blanket_lines_ext ble
173: SET ble.returned_quantity = nvl(ble.returned_quantity,0) +
174: l_fulfilled_quantity
175: ,ble.returned_amount = nvl(ble.returned_amount,0) +
176: l_amount

Line 183: WHERE bl.line_Id IN (SELECT Line_Id FROM oe_blanket_lines_ext bl

179: END IF;
180:
181: UPDATE oe_blanket_lines bl
182: SET bl.lock_control = bl.lock_control + 1
183: WHERE bl.line_Id IN (SELECT Line_Id FROM oe_blanket_lines_ext bl
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: