DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on OE_ORDER_LINES

Line 7987: select line_id from oe_order_lines_all

7983: l_apply_automatic_atchmt VARCHAR2(1) :=
7984: NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276
7985:
7986: cursor line_ids(p_header_id IN NUMBER) is
7987: select line_id from oe_order_lines_all
7988: where header_id = p_header_id;
7989: --bug 4190357
7990: -- R12 CC encryption
7991: l_changed_attribute VARCHAR2(200);

Line 9526: OE_ORDER_LINES where header_id = p_header_id;

9522:
9523: BEGIN
9524:
9525: SELECT sum(ordered_quantity) into l_total_quantity from
9526: OE_ORDER_LINES where header_id = p_header_id;
9527:
9528: IF l_total_quantity =0 THEN
9529: OE_Header_Adj_Util.Delete_Header_Charges( p_header_id => p_header_id );
9530: END IF;

Line 9564: FROM OE_ORDER_LINES

9560: ,inventory_item_id
9561: ,unit_selling_price
9562: ,fulfilled_flag
9563: ,line_set_id
9564: FROM OE_ORDER_LINES
9565: WHERE HEADER_ID = p_header_rec.header_id
9566: AND BLANKET_NUMBER IS NOT NULL;
9567:
9568: l_return_status VARCHAR2(1);