1. Tables and Views for Financials
  2. AR_XML_SO_INFO_V

AR_XML_SO_INFO_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CUSTOMER_TRX_LINE_ID

SALES_ORDER

SALES_ORDER_REVISION

SALES_ORDER_DATE

SALES_ORDER_LINE

SALES_USER_ONE

SALES_USER_TWO

SALES_USER_THREE

SALES_USER_FOUR

SALES_USER_FIVE

SALES_USER_SIX

SALES_USER_SEVEN

SALES_USER_EIGHT

SALES_USER_NINE

SALES_USER_TEN

SALES_USER_ELEVEN

SALES_USER_TWELVE

SALES_USER_THIRTEEN

SALES_USER_FOURTEEN

SALES_USER_FIFTEEN

SALES_USER_SIXTEEN

SALES_USER_SEVENTEEN

SALES_USER_EIGHTEEN

SALES_USER_NINETEEN

SALES_USER_TWENTY

SALES_USER_TWENTY_ONE

SALES_USER_TWENTY_TWO

SALES_USER_TWENTY_THREE

SALES_USER_TWENTY_FOUR

SALES_USER_TWENTY_FIVE

SALES_USER_TWENTY_SIX

SALES_USER_TWENTY_SEVEN

SALES_USER_TWENTY_EIGHT

SALES_USER_TWENTY_NINE

SALES_USER_THIRTY

SALES_ORDER_SOURCE

Query

SQL_Statement

SELECT

CUSTOMER_TRX_LINE_ID,

SALES_ORDER,

SALES_ORDER_REVISION,

SALES_ORDER_DATE,

SALES_ORDER_LINE,

ar_xml_view_functions.so_function1 (customer_trx_id, customer_trx_line_id) Sales_User_One,

ar_xml_view_functions.so_function2 (customer_trx_id, customer_trx_line_id) Sales_User_Two,

ar_xml_view_functions.so_function3 (customer_trx_id, customer_trx_line_id) Sales_User_Three,

ar_xml_view_functions.so_function4 (customer_trx_id, customer_trx_line_id) Sales_User_Four,

ar_xml_view_functions.so_function5 (customer_trx_id, customer_trx_line_id) Sales_User_Five,

ar_xml_view_functions.so_function6 (customer_trx_id, customer_trx_line_id) Sales_User_Six,

ar_xml_view_functions.so_function7 (customer_trx_id, customer_trx_line_id) Sales_User_Seven,

ar_xml_view_functions.so_function8 (customer_trx_id, customer_trx_line_id) Sales_User_Eight,

ar_xml_view_functions.so_function9 (customer_trx_id, customer_trx_line_id) Sales_User_Nine ,

ar_xml_view_functions.so_function10 (customer_trx_id, customer_trx_line_id) Sales_User_Ten,

ar_xml_view_functions.so_function11 (customer_trx_id, customer_trx_line_id) Sales_User_Eleven,

ar_xml_view_functions.so_function12 (customer_trx_id, customer_trx_line_id) Sales_User_Twelve,

ar_xml_view_functions.so_function13 (customer_trx_id, customer_trx_line_id) Sales_User_Thirteen,

ar_xml_view_functions.so_function14 (customer_trx_id, customer_trx_line_id) Sales_User_Fourteen,

ar_xml_view_functions.so_function15 (customer_trx_id, customer_trx_line_id) Sales_User_Fifteen,

ar_xml_view_functions.so_function16 (customer_trx_id, customer_trx_line_id) Sales_User_Sixteen,

ar_xml_view_functions.so_function17 (customer_trx_id, customer_trx_line_id) Sales_User_Seventeen,

ar_xml_view_functions.so_function18 (customer_trx_id, customer_trx_line_id) Sales_User_Eighteen,

ar_xml_view_functions.so_function19 (customer_trx_id, customer_trx_line_id) Sales_User_Nineteen,

ar_xml_view_functions.so_function20 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty,

ar_xml_view_functions.so_function21 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_One,

ar_xml_view_functions.so_function22 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_Two,

ar_xml_view_functions.so_function23 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_Three,

ar_xml_view_functions.so_function24 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_Four,

ar_xml_view_functions.so_function25 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_Five,

ar_xml_view_functions.so_function26 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_Six,

ar_xml_view_functions.so_function27 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_Seven,

ar_xml_view_functions.so_function28 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_Eight,

ar_xml_view_functions.so_function29 (customer_trx_id, customer_trx_line_id) Sales_User_Twenty_Nine,

ar_xml_view_functions.so_function30 (customer_trx_id, customer_trx_line_id) Sales_User_Thirty,

SALES_ORDER_SOURCE

FROM

RA_CUSTOMER_TRX_LINES_ALL

WHERE SALES_ORDER is NOT NULL