1. Tables and Views for Financials
  2. AR_XML_INVOICE_CHARGE_V

AR_XML_INVOICE_CHARGE_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CUSTOMER_TRX_ID

CUSTOMER_TRX_LINE_ID

LINK_TO_CUSTOMER_TRX_LINE_ID

CHARGE_AMOUNT

CURRENCY_CODE

DESCRIPTION

LINE_NUMBER

LINE_TYPE

CHARGE_USER_ONE

CHARGE_USER_TWO

CHARGE_USER_THREE

CHARGE_USER_FOUR

CHARGE_USER_FIVE

CHARGE_USER_SIX

CHARGE_USER_SEVEN

CHARGE_USER_EIGHT

CHARGE_USER_NINE

CHARGE_USER_TEN

CHARGE_USER_ELEVEN

CHARGE_USER_TWELVE

CHARGE_USER_THIRTEEN

CHARGE_USER_FOURTEEN

CHARGE_USER_FIFTEEN

CHARGE_USER_SIXTEEN

CHARGE_USER_SEVENTEEN

CHARGE_USER_EIGHTEEN

CHARGE_USER_NINETEEN

CHARGE_USER_TWENTY

CHARGE_USER_TWENTY_ONE

CHARGE_USER_TWENTY_TWO

CHARGE_USER_TWENTY_THREE

CHARGE_USER_TWENTY_FOUR

CHARGE_USER_TWENTY_FIVE

CHARGE_USER_TWENTY_SIX

CHARGE_USER_TWENTY_SEVEN

CHARGE_USER_TWENTY_EIGHT

CHARGE_USER_TWENTY_NINE

CHARGE_USER_THIRTY

Query

SQL_Statement

SELECT

l.customer_trx_id CUSTOMER_TRX_ID,

l.customer_trx_line_id CUSTOMER_TRX_LINE_ID,

l.link_to_cust_trx_line_id LINK_TO_CUSTOMER_TRX_LINE_ID,

l.extended_amount charge_amount,

header.INVOICE_CURRENCY_CODE CURRENCY_CODE,

l.description description,

l.line_number line_number,

l.line_type line_type,

ar_xml_view_functions.charge_function1 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_One,

ar_xml_view_functions.charge_function2 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Two,

ar_xml_view_functions.charge_function3 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Three,

ar_xml_view_functions.charge_function4 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Four,

ar_xml_view_functions.charge_function5 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Five,

ar_xml_view_functions.charge_function6 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Six,

ar_xml_view_functions.charge_function7 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Seven,

ar_xml_view_functions.charge_function8 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Eight,

ar_xml_view_functions.charge_function9 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Nine ,

ar_xml_view_functions.charge_function10 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Ten,

ar_xml_view_functions.charge_function11 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Eleven,

ar_xml_view_functions.charge_function12 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twelve,

ar_xml_view_functions.charge_function13 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Thirteen,

ar_xml_view_functions.charge_function14 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Fourteen,

ar_xml_view_functions.charge_function15 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Fifteen,

ar_xml_view_functions.charge_function16 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Sixteen,

ar_xml_view_functions.charge_function17 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Seventeen,

ar_xml_view_functions.charge_function18 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Eighteen,

ar_xml_view_functions.charge_function19 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Nineteen,

ar_xml_view_functions.charge_function20 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty,

ar_xml_view_functions.charge_function21 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_One,

ar_xml_view_functions.charge_function22 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_Two,

ar_xml_view_functions.charge_function23 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_Three,

ar_xml_view_functions.charge_function24 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_Four,

ar_xml_view_functions.charge_function25 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_Five,

ar_xml_view_functions.charge_function26 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_Six,

ar_xml_view_functions.charge_function27 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_Seven,

ar_xml_view_functions.charge_function28 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_Eight,

ar_xml_view_functions.charge_function29 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Twenty_Nine,

ar_xml_view_functions.charge_function30 (l.customer_trx_id, l.customer_trx_line_id) Charge_User_Thirty

from

ra_customer_trx_all header,

ra_customer_trx_lines_all l

WHERE

header.CUSTOMER_TRX_ID = l.CUSTOMER_TRX_ID

and l.line_type not in ('LINE','TAX')

order by l.line_number