APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_BLANKET_LINES_EXT

Line 223: FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL

219: ,L.ORDER_QUANTITY_UOM
220: ,nvl(BL.RETURNED_QUANTITY,0)
221: ,nvl(BL.RETURNED_AMOUNT,0)
222: ,'N' -- locked_flag
223: FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL
224: WHERE L.LINE_ID = x_blanket_line_id
225: AND L.LINE_ID = BL.LINE_ID
226: AND L.SALES_DOCUMENT_TYPE_CODE = 'B';
227:

Line 255: FROM OE_BLANKET_LINES_EXT BL

251: end if;
252:
253: SELECT line_id
254: INTO x_blanket_line_id
255: FROM OE_BLANKET_LINES_EXT BL
256: WHERE BL.ORDER_NUMBER = p_blanket_number
257: AND BL.LINE_NUMBER = p_blanket_line_number;
258:
259: if l_debug_level > 0 then

Line 944: UPDATE OE_BLANKET_LINES_EXT

940:
941: l_index := g_blkt_line_tbl.FIRST;
942: WHILE l_index IS NOT NULL LOOP
943:
944: UPDATE OE_BLANKET_LINES_EXT
945: SET RELEASED_AMOUNT = g_blkt_line_tbl(l_index).released_amount
946: ,RELEASED_QUANTITY = g_blkt_line_tbl(l_index).released_quantity
947: ,FULFILLED_AMOUNT = g_blkt_line_tbl(l_index).fulfilled_amount
948: ,FULFILLED_QUANTITY = g_blkt_line_tbl(l_index).fulfilled_quantity