APPS.OE_ORDER_BOOK_UTIL dependencies on OE_ORDER_LINES

Line 170: FROM OE_ORDER_LINES

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

Line 509: UPDATE oe_order_lines_all

505: -- Clear cached results for constraints as order being booked
506: -- may change results of some validation packages
507: OE_PC_Constraints_Admin_PVT.Clear_Cached_Results;
508:
509: UPDATE oe_order_lines_all
510: SET booked_flag = 'Y'
511: , flow_status_code = 'BOOKED'
512: , last_updated_by = FND_GLOBAL.USER_ID
513: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 905: FROM oe_order_lines_all

901: --
902: --FP bug 3872166
903: CURSOR line_ids(p_header_id IN NUMBER) IS
904: SELECT line_id
905: FROM oe_order_lines_all
906: WHERE header_id = p_header_id;
907: BEGIN
908: IF l_debug_level > 0 THEN
909: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;

Line 1066: FROM oe_order_lines_all

1062:
1063: BEGIN
1064: SELECT
1065: 'EXISTS' INTO l_dummy
1066: FROM oe_order_lines_all
1067: WHERE header_id = p_header_id and
1068: ROWNUM = 1;
1069:
1070: IF sql%found THEN