DBA Data[Home] [Help]

APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_BLANKET_HEADERS_EXT

Line 237: FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH

233: ,BH.BLANKET_MAX_AMOUNT
234: ,H.TRANSACTIONAL_CURR_CODE
235: ,H.CONVERSION_TYPE_CODE
236: ,'N' -- locked_flag
237: FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH
238: WHERE H.HEADER_ID = x_blanket_header_id
239: AND H.ORDER_NUMBER = BH.ORDER_NUMBER
240: AND H.SALES_DOCUMENT_TYPE_CODE = 'B';
241: --

Line 926: UPDATE OE_BLANKET_HEADERS_EXT

922:
923: l_index := g_blkt_hdr_tbl.FIRST;
924: WHILE l_index IS NOT NULL LOOP
925:
926: UPDATE OE_BLANKET_HEADERS_EXT
927: SET RELEASED_AMOUNT = g_blkt_hdr_tbl(l_index).released_amount
928: ,FULFILLED_AMOUNT = g_blkt_hdr_tbl(l_index).fulfilled_amount
929: WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
930: FROM OE_BLANKET_HEADERS H