APPS.OE_TOTALS_GRP dependencies on OE_ORDER_LINES_ALL

Line 111: FROM oe_order_lines_all

107: DECODE(line_category_code,'RETURN',-1,1)*
108: NVL(tax_value,0)
109: INTO l_line_amount,
110: l_tax_amount
111: FROM oe_order_lines_all
112: WHERE line_id = p_line_id
113: AND NVL(cancelled_flag,'N')='N';
114: END IF;
115: EXCEPTION

Line 240: FROM oe_order_lines_all

236: DECODE(line_category_code,'RETURN',-1,1)*
237: NVL(tax_value,0)
238: INTO l_line_amount,
239: l_tax_amount
240: FROM oe_order_lines_all
241: WHERE line_id = p_line_id
242: AND NVL(cancelled_flag,'N')='N';
243: END IF;
244: EXCEPTION

Line 320: FROM oe_order_lines_all

316: IS
317: CURSOR lines_cur(p_header_id IN NUMBER) IS
318: SELECT line_id
319: , payment_term_id
320: FROM oe_order_lines_all
321: WHERE header_id = p_header_id;
322:
323: l_api_name CONSTANT VARCHAR2(30):= 'Get_PayNow_Total';
324: l_pay_now_total_detail_tbl AR_VIEW_TERM_GRP.amounts_table;

Line 361: FROM oe_order_lines_all

357: ELSE
358: BEGIN
359: SELECT org_id
360: INTO l_org_id
361: FROM oe_order_lines_all
362: WHERE line_id = p_line_id;
363: EXCEPTION WHEN NO_DATA_FOUND THEN
364: null;
365: END;

Line 386: FROM oe_order_lines_all

382: ,payment_term_id
383: INTO l_line_tbl(1).line_id
384: ,l_line_tbl(1).header_id
385: ,l_line_tbl(1).payment_term_id
386: FROM oe_order_lines_all
387: WHERE line_id=p_line_id;
388: ELSE
389: -- this is for header payment
390: i := 1;