JE Portuguese Payables Taxpayer ID Exception - draft

Description
Categories: BI Publisher
Application: European Localizations
Source: Portuguese Payables Taxpayer ID Exception Report (XML) - Not Supported: Reserved For Future Use
Short Name: JEPTAPER_XML
DB package: JE_JEPTAPER_XMLP_PKG
select substr(p.VENDOR_NAME,1,80)  VENDOR_NAME,  
          p.SEGMENT1  VENDOR_NUMBER
from   po_vendor_sites              ps,
          po_vendors                      p,
          ap_invoice_distributions  id,
          ap_invoices                       i,
          zx_rates_b                       tc,
          zx_party_tax_profile      ptp
where  upper(tc.tax_rate_code) != 'EXEMPT'
and     upper(tc.tax_rate_code) not like 'ND%'
and     id.posted_flag = 'Y'
and     upper(id.line_type_lookup_code) != 'AWT'
and     ( upper(p.vendor_type_lookup_code) != 'EMPLOYEE'  or  p.vendor_type_lookup_code  is NULL )
and     p.num_1099 is NULL  
and     p.vendor_id = i.vendor_id
and     id.invoice_id = i.invoice_id
and     ps.vendor_id = p.vendor_id
and     id.tax_code_id = tc.tax_rate_id (+)
and     ptp.party_id = i.org_id
and     ptp.PARTY_TAX_PROFILE_ID = tc.content_owner_id
and     ptp.party_type_code = 'OU'
and     i.legal_entity_id = :P_LEGAL_ENTITY_ID
and     i.set_of_books_id = nvl(:P_SET_OF_BOOKS_ID,i.set_of_books_id)
and    (:P_BALANCING_SEGMENT IS NULL
           OR
          (:P_BALANCING_SEGMENT IS NOT NULL
            AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS 
                                 WHERE code_combination_id = id.dist_code_combination_id
                                  AND chart_of_accounts_id = :P_CHART_OF_ACCT
                                  AND &P_BAL_SEG_NAME)))
group by p.SEGMENT1, p.VENDOR_NAME
order by p.VENDOR_NAME, p.SEGMENT1
Parameter Name SQL text Validation
FND_NUMBER
 
Number
Chart of Account
 
LOV Oracle
Balancing Segment
 
LOV Oracle
Ledger
 
LOV Oracle
Legal Entity
 
LOV Oracle