APPS.OE_HEADER_ADJ_UTIL dependencies on OE_ORDER_LINES_ALL

Line 4381: FROM oe_order_lines_all

4377: IF p_header_id IS NOT NULL THEN
4378: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
4379: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
4380: INTO l_adj_total
4381: FROM oe_order_lines_all
4382: WHERE HEADER_ID = p_header_id
4383: AND charge_periodicity_code IS NULL -- addded for recurring charges
4384: AND nvl(cancelled_flag,'N') ='N';
4385: ELSE

Line 4389: FROM oe_order_lines_all

4385: ELSE
4386: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
4387: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
4388: INTO l_adj_total
4389: FROM oe_order_lines_all
4390: WHERE line_id = p_line_id
4391: AND nvl(cancelled_flag,'N') ='N';
4392: END IF;
4393:

Line 4462: , oe_order_lines_all ool

4458: 'NEWPRICE',ool.unit_list_price-opa.operand))
4459: unit_discount_amount
4460: --Bug 3340636 Ends
4461: FROM oe_price_adjustments_v opa
4462: , oe_order_lines_all ool
4463: WHERE opa.HEADER_ID = p_header_id
4464: and opa.line_id is null
4465: and ool.line_id = p_line_id
4466: and ool.header_id = p_header_id

Line 4481: , oe_order_lines_all ool

4477: ,opa.operand
4478: ,opa.arithmetic_operator
4479: ,Nvl(opa.adjusted_amount,0)*(-1) unit_discount_amount --added nvl for bug 13605684
4480: FROM oe_price_adjustments_v opa
4481: , oe_order_lines_all ool
4482: WHERE opa.line_id =p_line_id
4483: and ool.line_id = p_line_id
4484: and ool.header_id = p_header_id
4485: and nvl(opa.applied_flag,'N') = 'Y'

Line 5188: FROM oe_order_lines_all

5184: IF p_header_id IS NOT NULL THEN
5185: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
5186: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
5187: INTO l_adj_total
5188: FROM oe_order_lines_all
5189: WHERE HEADER_ID = p_header_id
5190: AND nvl(charge_periodicity_code,'ONE') = p_charge_periodicity_code
5191: AND nvl(cancelled_flag,'N') ='N';
5192: END IF;

Line 5282: FROM oe_order_lines_all

5278:
5279:
5280: SELECT nvl(sum(unit_list_price * ordered_quantity), 0) --bug5354658
5281: INTO l_rec_list_price_total
5282: FROM oe_order_lines_all
5283: WHERE HEADER_ID = l_header_id
5284: AND charge_periodicity_code = p_charge_periodicity_code
5285: AND nvl(cancelled_flag,'N') ='N';
5286: