API to get order line number, line amount and order amount

---------------------------------------------------------------------------------

oe_order_misc_pub.get_concat_line_number(oola.line_id) 

oe_totals_grp.get_order_total(ooha.header_id, oola.line_id, 'ALL')

oe_totals_grp.get_order_total(ooha.header_id, NULL, 'ALL')

---------------------------------------------------------------------------------

SELECT
    ooha.org_id,
    ooha.header_id,
    ooha.order_number,
    oola.line_id,
    oe_order_misc_pub.get_concat_line_number(oola.line_id) line_number,
    nvl(oe_totals_grp.get_order_total(ooha.header_id, oola.line_id, 'ALL'), 0)                 line_amount,
    nvl(oe_totals_grp.get_order_total(ooha.header_id, NULL, 'ALL'), 0)                         order_amount  
FROM
    oe_order_headers_all  ooha,
    oe_order_lines_all    oola
WHERE
        ooha.header_id = oola.header_id
    AND ooha.org_id = oola.org_id
    AND ooha.order_number = '71000004'
    order by oola.line_id;