AP Prepayment Remittance Notice - draft

Description
Categories: BI Publisher
Columns: C Vendor Name, C Address Line1, C Address Line2, C Address Line3, C City State Zip, C Country, C Application Date, C Amount Applied, C Currency Code, C Prepay Num ...
Application: Payables
Source: Prepayment Remittance Notice (XML) - Not Supported: Reserved For Future Use
Short Name: APXPPREM_XML
DB package: AP_APXPPREM_XMLP_PKG
select  pv.vendor_name  C_vendor_name,
           pvs.address_line1  C_address_line1,
           pvs.address_line2  C_address_line2,
           pvs.address_line3  C_address_line3,
           decode(pvs.city, '', '', pvs.city || ', ')  ||
           decode(pvs.state, '', '', pvs.state || '  ')  ||
           pvs.zip   C_city_state_zip,
           pvs.country  C_country, 
           aipp.last_update_date  C_application_date,