APPS.OE_ORDER_PRICE_PVT dependencies on OE_ORDER_LINES

Line 397: FROM OE_ORDER_LINES /* MOAC SQL NO CHANGE */

393: , CALCULATE_PRICE_FLAG
394: , upgraded_flag
395: , CHARGE_PERIODICITY_CODE --rc
396: , LOCK_CONTROL
397: FROM OE_ORDER_LINES /* MOAC SQL NO CHANGE */
398: WHERE l_entity = 'L'
399: -- AND ORDERED_QUANTITY <> 0 (--bug 3018537) commented for the FP bug 3335024
400: AND LINE_ID = p_line_id
401: UNION

Line 455: FROM OE_ORDER_LINES /* MOAC SQL NO CHANGE */

451: , CALCULATE_PRICE_FLAG
452: , CHARGE_PERIODICITY_CODE --rc
453: , upgraded_flag
454: , LOCK_CONTROL
455: FROM OE_ORDER_LINES /* MOAC SQL NO CHANGE */
456: WHERE l_entity = 'H'
457: --AND ORDERED_QUANTITY <> 0 (--bug 3018537) commented for the FP bug 3335024
458: AND HEADER_ID = p_header_id;
459:

Line 2034: select line_id from oe_order_lines_all

2030: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
2031: line_Tbl_Index pls_integer;
2032:
2033: CURSOR service_lines is
2034: select line_id from oe_order_lines_all
2035: where
2036: service_reference_line_id=p_line_Id and
2037: service_reference_type_code='ORDER'and
2038: header_id=p_header_id and

Line 2621: , OE_ORDER_LINES l

2617: --bug 2028480 end
2618: CURSOR gsa_violators IS
2619: SELECT ql.LINE_ID, l.ordered_item, l.inventory_item_id, ql.pricing_status_text
2620: FROM QP_PREQ_LINES_TMP ql
2621: , OE_ORDER_LINES l
2622: WHERE ql.line_id=l.line_id
2623: AND ql.LINE_TYPE_CODE='LINE'
2624: AND ql.PROCESS_STATUS <> 'NOT_VALID'
2625: AND ql.PRICING_STATUS_CODE =

Line 2918: , OE_ORDER_LINES l

2914: , l.sold_to_org_id
2915: , l.transaction_phase_code--for bug 3108881
2916: , l.order_source_id
2917: FROM QP_PREQ_LINES_TMP lines
2918: , OE_ORDER_LINES l
2919: WHERE lines.pricing_status_code IN
2920: ( QP_PREQ_GRP.G_STATUS_UPDATED
2921: , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
2922: AND lines.process_status <> 'NOT_VALID'

Line 3365: UPDATE OE_ORDER_LINES_all l

3361:
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( ' BEFORE UPDATING ORDER LINES' , 3 ) ;
3364: END IF;
3365: UPDATE OE_ORDER_LINES_all l
3366: SET (UNIT_SELLING_PRICE
3367: , UNIT_LIST_PRICE
3368: ,UNIT_SELLING_PRICE_PER_PQTY
3369: ,UNIT_LIST_PRICE_PER_PQTY

Line 5800: Select count(header_id) into l_total_lines from oe_order_lines

5796: END IF;
5797:
5798: -- find out the total number of lines in the order
5799: BEGIN
5800: Select count(header_id) into l_total_lines from oe_order_lines
5801: where header_id = p_header_id;
5802: EXCEPTION
5803: WHEN OTHERS THEN
5804: IF l_debug_level > 0 THEN

Line 6544: exists(select 'x' from oe_order_lines

6540: BEGIN
6541:
6542: Select 'x' into l_dummy
6543: from dual where
6544: exists(select 'x' from oe_order_lines
6545: Where header_id = l_header_id
6546: and calculate_price_flag in ('Y','P')
6547: and item_type_code not in ('CONFIG', 'INCLUDED'));
6548: l_completely_frozen := FALSE;

Line 6561: exists (select 'x' from oe_order_lines

6557: IF l_completely_frozen = FALSE THEN
6558:
6559: Select 'p' into l_dummy
6560: from dual where
6561: exists (select 'x' from oe_order_lines
6562: where header_id = l_header_id
6563: and calculate_price_flag in ('N', 'P')
6564: and cancelled_flag = 'N'
6565: and item_type_code not in ('CONFIG', 'INCLUDED') );

Line 6913: from oe_order_lines l

6909: , lines.line_quantity
6910: , l.shipped_quantity
6911: , l.header_id
6912: , lines.line_index
6913: from oe_order_lines l
6914: , qp_preq_lines_tmp lines
6915: where lines.line_id = l.line_id
6916: and lines.line_type_code='LINE'
6917: and l.booked_flag = 'Y'