JE Italian Payables Exemption Letter Register- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Italian Payables Exemption Letter Register
Application: European Localizations
Source: Italian Payables Exemption Letter Register (XML) - Not Supported: Reserved For Future Use
Short Name: JEITXLRG_XML
DB package: JE_JEITXLRG_XMLP_PKG
Description: Italian Payables Exemption Letter Register
Application: European Localizations
Source: Italian Payables Exemption Letter Register (XML) - Not Supported: Reserved For Future Use
Short Name: JEITXLRG_XML
DB package: JE_JEITXLRG_XMLP_PKG
Run
JE Italian Payables Exemption Letter Register- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT substr(xl.year,3,4) year, xl.exemption_letter_id, xl.issue_date, xl.issue_date, substr(pv.vendor_name,1,80) vendor_name, substr(pvs.address_line1,1,35) address_line1, pvs.city, pv.vat_registration_num FROM je_it_exempt_letters xl, po_vendors pv, po_vendor_sites_all pvs WHERE xl.vendor_id = pv.vendor_id AND pv.vendor_id = pvs.vendor_id AND pvs.tax_reporting_site_flag = 'Y' AND pvs.org_id=MO_GLOBAL.get_current_org_id AND xl.legal_entity_id = :LP_LEGAL_ENTITY_ID AND trunc(to_date(xl.issue_date,'DD-MON-YYYY')) between trunc(:p_first_day) and trunc(:p_last_day) ORDER BY xl.year, xl.exemption_letter_id |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Reporting Identifier |
|
LOV Oracle | |
Period From |
|
LOV Oracle | |
Period To |
|
LOV Oracle | |
First Page Number |
|
Number |