APPS.OE_ORDER_BOOK_UTIL dependencies on OE_ORDER_LINES

Line 167: FROM OE_ORDER_LINES

163: , org_id
164: , return_context
165: , reference_customer_trx_line_id /* end renga */
166: , order_firmed_date /* Key Transaction Dates */
167: FROM OE_ORDER_LINES
168: WHERE HEADER_ID = p_header_id;
169:
170: --
171: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 472: UPDATE oe_order_lines_all

468: -- Clear cached results for constraints as order being booked
469: -- may change results of some validation packages
470: OE_PC_Constraints_Admin_PVT.Clear_Cached_Results;
471:
472: UPDATE oe_order_lines_all
473: SET booked_flag = 'Y'
474: , flow_status_code = 'BOOKED'
475: , last_updated_by = FND_GLOBAL.USER_ID
476: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 839: FROM oe_order_lines_all

835: --
836: --FP bug 3872166
837: CURSOR line_ids(p_header_id IN NUMBER) IS
838: SELECT line_id
839: FROM oe_order_lines_all
840: WHERE header_id = p_header_id;
841: BEGIN
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;

Line 1000: FROM oe_order_lines_all

996:
997: BEGIN
998: SELECT
999: 'EXISTS' INTO l_dummy
1000: FROM oe_order_lines_all
1001: WHERE header_id = p_header_id and
1002: ROWNUM = 1;
1003:
1004: IF sql%found THEN