APPS.OE_LINEINFO_GRP dependencies on OE_ORDER_LINES_ALL

Line 37: FROM oe_order_lines_all

33: Begin
34: x_return_status:=FND_API.G_RET_STS_SUCCESS;
35: SELECT SUM(tax_value)
36: INTO l_order_tax_total
37: FROM oe_order_lines_all
38: WHERE header_id=p_header_id
39: AND charge_periodicity_code is NULL
40: AND NVL(cancelled_flag,'N') ='N'
41: AND line_category_code<>'RETURN';

Line 46: FROM oe_order_lines_all

42:
43:
44: SELECT SUM(tax_value)
45: INTO l_return_tax_total
46: FROM oe_order_lines_all
47: WHERE header_id=p_header_id
48: AND charge_periodicity_code is NULL
49: AND NVL(cancelled_flag,'N') ='N'
50: AND line_category_code='RETURN';

Line 78: FROM oe_order_lines_all

74: x_tax_rec.tax_date,
75: x_tax_rec.tax_exempt_flag,
76: x_tax_rec.tax_exempt_number,
77: x_tax_rec.tax_exempt_reason_code
78: FROM oe_order_lines_all
79: Where header_id = p_header_id
80: and line_id = p_line_id;
81:
82: Exception When others THEN