DBA Data[Home] [Help]

APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_BLANKET_LINES_EXT

Line 225: FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL

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

Line 262: FROM OE_BLANKET_LINES_EXT BL

258: end if;
259:
260: SELECT line_id
261: INTO x_blanket_line_id
262: FROM OE_BLANKET_LINES_EXT BL
263: WHERE BL.ORDER_NUMBER = p_blanket_number
264: AND BL.LINE_NUMBER = p_blanket_line_number;
265:
266: l_blanket_line_id := x_blanket_line_id;

Line 965: UPDATE OE_BLANKET_LINES_EXT

961:
962: l_index := g_blkt_line_tbl.FIRST;
963: WHILE l_index IS NOT NULL LOOP
964:
965: UPDATE OE_BLANKET_LINES_EXT
966: SET RELEASED_AMOUNT = g_blkt_line_tbl(l_index).released_amount
967: ,RELEASED_QUANTITY = g_blkt_line_tbl(l_index).released_quantity
968: ,FULFILLED_AMOUNT = g_blkt_line_tbl(l_index).fulfilled_amount
969: ,FULFILLED_QUANTITY = g_blkt_line_tbl(l_index).fulfilled_quantity