DBA Data[Home] [Help]

APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_BLANKET_HEADERS_EXT

Line 240: FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH

236: ,BH.BLANKET_MAX_AMOUNT
237: ,H.TRANSACTIONAL_CURR_CODE
238: ,H.CONVERSION_TYPE_CODE
239: ,'N' -- locked_flag
240: FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH
241: WHERE H.HEADER_ID = p_blanket_header_id
242: AND H.ORDER_NUMBER = BH.ORDER_NUMBER
243: AND H.SALES_DOCUMENT_TYPE_CODE = 'B';
244:

Line 945: UPDATE OE_BLANKET_HEADERS_EXT

941:
942: l_index := g_blkt_hdr_tbl.FIRST;
943: WHILE l_index IS NOT NULL LOOP
944:
945: UPDATE OE_BLANKET_HEADERS_EXT
946: SET RELEASED_AMOUNT = g_blkt_hdr_tbl(l_index).released_amount
947: ,FULFILLED_AMOUNT = g_blkt_hdr_tbl(l_index).fulfilled_amount
948: WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
949: FROM OE_BLANKET_HEADERS H