1. Tables and Views for Financials
  2. AR_XML_INVOICE_REMIT_TO_V

AR_XML_INVOICE_REMIT_TO_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CUSTOMER_TRX_ID

CUSTOMER_ACCOUNT_ID

CUSTOMER_ACCOUNT_SITE_ID

ADDRESS_LINE_ONE

ADDRESS_LINE_TWO

ADDRESS_LINE_THREE

ADDRESS_LINE_FOUR

ADDRESS

CITY

COUNTY

STATE

PROVINCE

POSTAL_CODE

TERRITORY_SHORT_NAME

COMPLETE_ADDRESS

REMIT_USER_ONE

REMIT_USER_TWO

REMIT_USER_THREE

REMIT_USER_FOUR

REMIT_USER_FIVE

REMIT_USER_SIX

REMIT_USER_SEVEN

REMIT_USER_EIGHT

REMIT_USER_NINE

REMIT_USER_TEN

REMIT_USER_ELEVEN

REMIT_USER_TWELVE

REMIT_USER_THIRTEEN

REMIT_USER_FOURTEEN

REMIT_USER_FIFTEEN

REMIT_USER_SIXTEEN

REMIT_USER_SEVENTEEN

REMIT_USER_EIGHTEEN

REMIT_USER_NINETEEN

REMIT_USER_TWENTY

REMIT_USER_TWENTY_ONE

REMIT_USER_TWENTY_TWO

REMIT_USER_TWENTY_THREE

REMIT_USER_TWENTY_FOUR

REMIT_USER_TWENTY_FIVE

REMIT_USER_TWENTY_SIX

REMIT_USER_TWENTY_SEVEN

REMIT_USER_TWENTY_EIGHT

REMIT_USER_TWENTY_NINE

REMIT_USER_THIRTY

REMIT_TO_LOCATION_ID

REMIT_TO_COUNTRY

Query

SQL_Statement

SELECT

trx.customer_trx_id,

trx.bill_to_customer_id customer_account_id,

site_uses.cust_acct_site_id customer_account_site_id,

loc.address1 Address_Line_One,

loc.address2 Address_Line_Two,

loc.address3 Address_Line_Three,

loc.address4 Address_Line_Four,

DECODE( trx.remit_to_address_seq_id,NULL,NULL,

hz_format_pub.format_address(loc.ADDRESS1, loc.ADDRESS2, loc.ADDRESS3, loc.ADDRESS4, NULL, NULL, NULL, NULL, NULL, NULL, NULL)) ADDRESS,

loc.city,

loc.county,

loc.state,

loc.province,

loc.postal_code,

ft.territory_short_name,

DECODE( trx.remit_to_address_seq_id,NULL,NULL,

hz_format_pub.format_address(loc.ADDRESS1, loc.ADDRESS2, loc.ADDRESS3, loc.ADDRESS4, loc.CITY, loc.POSTAL_CODE, loc.STATE, loc.PROVINCE, loc.COUNTY, FT.TERRITORY_SHORT_NAME, NULL)) COMPLETE_ADDRESS,

ar_xml_view_functions.rt_function1 (RAA_REMIT.PARTY_SITE_ID) Remit_User_One,

ar_xml_view_functions.rt_function2 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Two,

ar_xml_view_functions.rt_function3 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Three,

ar_xml_view_functions.rt_function4 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Four,

ar_xml_view_functions.rt_function5 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Five,

ar_xml_view_functions.rt_function6 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Six,

ar_xml_view_functions.rt_function7 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Seven,

ar_xml_view_functions.rt_function8 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Eight,

ar_xml_view_functions.rt_function9 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Nine ,

ar_xml_view_functions.rt_function10 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Ten,

ar_xml_view_functions.rt_function11 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Eleven,

ar_xml_view_functions.rt_function12 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twelve,

ar_xml_view_functions.rt_function13 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Thirteen,

ar_xml_view_functions.rt_function14 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Fourteen,

ar_xml_view_functions.rt_function15 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Fifteen,

ar_xml_view_functions.rt_function16 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Sixteen,

ar_xml_view_functions.rt_function17 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Seventeen,

ar_xml_view_functions.rt_function18 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Eighteen,

ar_xml_view_functions.rt_function19 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Nineteen,

ar_xml_view_functions.rt_function20 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty,

ar_xml_view_functions.rt_function21 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_One,

ar_xml_view_functions.rt_function22 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_Two,

ar_xml_view_functions.rt_function23 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_Three,

ar_xml_view_functions.rt_function24 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_Four,

ar_xml_view_functions.rt_function25 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_Five,

ar_xml_view_functions.rt_function26 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_Six,

ar_xml_view_functions.rt_function27 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_Seven,

ar_xml_view_functions.rt_function28 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_Eight,

ar_xml_view_functions.rt_function29 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Twenty_Nine,

ar_xml_view_functions.rt_function30 (RAA_REMIT.PARTY_SITE_ID) Remit_User_Thirty,

ral.LOCATION_ID REMIT_TO_LOCATION_ID,

loc.COUNTRY REMIT_TO_COUNTRY

FROM ar_remit_to_locs_all ral,

hz_locations loc,

fnd_territories_vl ft,

ra_customer_trx_all trx,

hz_cust_site_uses_all site_uses,

HZ_CUST_ACCT_SITES_ALL RAA_REMIT

WHERE RAA_REMIT.CUST_ACCT_SITE_ID = site_uses.CUST_ACCT_SITE_ID

AND ral.address_loc_seq_id(+) = trx.remit_to_address_seq_id

AND loc.location_id(+) = ral.location_id

AND loc.country = ft.territory_code(+)

AND site_uses.site_use_id = trx.bill_to_site_use_id