1. Tables and Views for Financials
  2. AR_XML_PO_INFO_V

AR_XML_PO_INFO_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CUSTOMER_TRX_ID

PURCHASE_ORDER

PURCHASE_ORDER_REVISION

PURCHASE_ORDER_DATE

PURCHASE_USER_ONE

PURCHASE_USER_TWO

PURCHASE_USER_THREE

PURCHASE_USER_FOUR

PURCHASE_USER_FIVE

PURCHASE_USER_SIX

PURCHASE_USER_SEVEN

PURCHASE_USER_EIGHT

PURCHASE_USER_NINE

PURCHASE_USER_TEN

PURCHASE_USER_ELEVEN

PURCHASE_USER_TWELVE

PURCHASE_USER_THIRTEEN

PURCHASE_USER_FOURTEEN

PURCHASE_USER_FIFTEEN

PURCHASE_USER_SIXTEEN

PURCHASE_USER_SEVENTEEN

PURCHASE_USER_EIGHTEEN

PURCHASE_USER_NINETEEN

PURCHASE_USER_TWENTY

PURCHASE_USER_TWENTY_ONE

PURCHASE_USER_TWENTY_TWO

PURCHASE_USER_TWENTY_THREE

PURCHASE_USER_TWENTY_FOUR

PURCHASE_USER_TWENTY_FIVE

PURCHASE_USER_TWENTY_SIX

PURCHASE_USER_TWENTY_SEVEN

PURCHASE_USER_TWENTY_EIGHT

PURCHASE_USER_TWENTY_NINE

PURCHASE_USER_THIRTY

Query

SQL_Statement

SELECT

CUSTOMER_TRX_ID,

PURCHASE_ORDER,

PURCHASE_ORDER_REVISION,

PURCHASE_ORDER_DATE,

ar_xml_view_functions.po_function1 (customer_trx_id) Purchase_User_One,

ar_xml_view_functions.po_function2 (customer_trx_id) Purchase_User_Two,

ar_xml_view_functions.po_function3 (customer_trx_id) Purchase_User_Three,

ar_xml_view_functions.po_function4 (customer_trx_id) Purchase_User_Four,

ar_xml_view_functions.po_function5 (customer_trx_id) Purchase_User_Five,

ar_xml_view_functions.po_function6 (customer_trx_id) Purchase_User_Six,

ar_xml_view_functions.po_function7 (customer_trx_id) Purchase_User_Seven,

ar_xml_view_functions.po_function8 (customer_trx_id) Purchase_User_Eight,

ar_xml_view_functions.po_function9 (customer_trx_id) Purchase_User_Nine ,

ar_xml_view_functions.po_function10 (customer_trx_id) Purchase_User_Ten,

ar_xml_view_functions.po_function11 (customer_trx_id) Purchase_User_Eleven,

ar_xml_view_functions.po_function12 (customer_trx_id) Purchase_User_Twelve,

ar_xml_view_functions.po_function13 (customer_trx_id) Purchase_User_Thirteen,

ar_xml_view_functions.po_function14 (customer_trx_id) Purchase_User_Fourteen,

ar_xml_view_functions.po_function15 (customer_trx_id) Purchase_User_Fifteen,

ar_xml_view_functions.po_function16 (customer_trx_id) Purchase_User_Sixteen,

ar_xml_view_functions.po_function17 (customer_trx_id) Purchase_User_Seventeen,

ar_xml_view_functions.po_function18 (customer_trx_id) Purchase_User_Eighteen,

ar_xml_view_functions.po_function19 (customer_trx_id) Purchase_User_Nineteen,

ar_xml_view_functions.po_function20 (customer_trx_id) Purchase_User_Twenty,

ar_xml_view_functions.po_function21 (customer_trx_id) Purchase_User_Twenty_One,

ar_xml_view_functions.po_function22 (customer_trx_id) Purchase_User_Twenty_Two,

ar_xml_view_functions.po_function23 (customer_trx_id) Purchase_User_Twenty_Three,

ar_xml_view_functions.po_function24 (customer_trx_id) Purchase_User_Twenty_Four,

ar_xml_view_functions.po_function25 (customer_trx_id) Purchase_User_Twenty_Five,

ar_xml_view_functions.po_function26 (customer_trx_id) Purchase_User_Twenty_Six,

ar_xml_view_functions.po_function27 (customer_trx_id) Purchase_User_Twenty_Seven,

ar_xml_view_functions.po_function28 (customer_trx_id) Purchase_User_Twenty_Eight,

ar_xml_view_functions.po_function29 (customer_trx_id) Purchase_User_Twenty_Nine,

ar_xml_view_functions.po_function30 (customer_trx_id) Purchase_User_Thirty

FROM

RA_CUSTOMER_TRX_ALL

WHERE PURCHASE_ORDER is NOT NULL