JE Portuguese Payables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Portuguese Payables Taxpayer ID Exception Report
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
Description: Portuguese Payables Taxpayer ID Exception Report
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
Run
JE Portuguese Payables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Legal Entity |
|
LOV Oracle | |
Ledger |
|
LOV Oracle | |
Balancing Segment |
|
LOV Oracle |