APPS.OE_HEADER_ADJ_UTIL dependencies on OE_ORDER_LINES_ALL

Line 4322: FROM oe_order_lines_all

4318: IF p_header_id IS NOT NULL THEN
4319: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
4320: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
4321: INTO l_adj_total
4322: FROM oe_order_lines_all
4323: WHERE HEADER_ID = p_header_id
4324: AND charge_periodicity_code IS NULL -- addded for recurring charges
4325: AND nvl(cancelled_flag,'N') ='N';
4326: ELSE

Line 4330: FROM oe_order_lines_all

4326: ELSE
4327: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
4328: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
4329: INTO l_adj_total
4330: FROM oe_order_lines_all
4331: WHERE line_id = p_line_id
4332: AND nvl(cancelled_flag,'N') ='N';
4333: END IF;
4334:

Line 4403: , oe_order_lines_all ool

4399: 'NEWPRICE',ool.unit_list_price-opa.operand))
4400: unit_discount_amount
4401: --Bug 3340636 Ends
4402: FROM oe_price_adjustments_v opa
4403: , oe_order_lines_all ool
4404: WHERE opa.HEADER_ID = p_header_id
4405: and opa.line_id is null
4406: and ool.line_id = p_line_id
4407: and ool.header_id = p_header_id

Line 4422: , oe_order_lines_all ool

4418: ,opa.operand
4419: ,opa.arithmetic_operator
4420: ,opa.adjusted_amount*(-1) unit_discount_amount
4421: FROM oe_price_adjustments_v opa
4422: , oe_order_lines_all ool
4423: WHERE opa.line_id =p_line_id
4424: and ool.line_id = p_line_id
4425: and ool.header_id = p_header_id
4426: and nvl(opa.applied_flag,'N') = 'Y'

Line 5032: FROM oe_order_lines_all

5028: IF p_header_id IS NOT NULL THEN
5029: SELECT sum(ROUND(((unit_selling_price - unit_list_price)*
5030: ordered_quantity) ,OE_ORDER_UTIL.G_Precision))
5031: INTO l_adj_total
5032: FROM oe_order_lines_all
5033: WHERE HEADER_ID = p_header_id
5034: AND nvl(charge_periodicity_code,'ONE') = p_charge_periodicity_code
5035: AND nvl(cancelled_flag,'N') ='N';
5036: END IF;

Line 5126: FROM oe_order_lines_all

5122:
5123:
5124: SELECT nvl(sum(unit_list_price * ordered_quantity), 0) --bug5354658
5125: INTO l_rec_list_price_total
5126: FROM oe_order_lines_all
5127: WHERE HEADER_ID = l_header_id
5128: AND charge_periodicity_code = p_charge_periodicity_code
5129: AND nvl(cancelled_flag,'N') ='N';
5130: