JE Italian Statutory Report Heading
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Produces Pre-printed Report Headers
Application: European Localizations
Source: Italian Statutory Report Heading
Short Name: JEITRGRH
DB package: JG_ZZ_RGRH_PKG
Description: Produces Pre-printed Report Headers
Application: European Localizations
Source: Italian Statutory Report Heading
Short Name: JEITRGRH
DB package: JG_ZZ_RGRH_PKG
Run
JE Italian Statutory Report Heading and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT &P_ADDRESS1 Address1, &P_ADDRESS2 Address2, &P_ADDRESS3 Address3, &P_ADDRESS4 Address4, &P_FISCAL_CODE fiscal_code, &P_FISCAL_COMPANY_NAME name, &P_GR_FISCAL_COMPANY_VALUE GR_Fiscal_Company_Value, &P_GR_VAT_NUMBER GR_VAT_Number, &P_GR_TAX_OFFICE GR_Tax_Office, &P_GR_TAX_AREA GR_Tax_Area, &P_GR_ADDRESS GR_Address, &P_GR_CITY GR_City, &P_GR_POSTAL_CODE GR_Postal_Code, &P_GR_CITY ||', '||&P_GR_POSTAL_CODE GR_CITY_POSTAL, JG_ZZ_RGRH_PKG.C_GR_COMPANY_ACTIVITY_formula C_GR_COMPANY_ACTIVITY, JG_ZZ_RGRH_PKG.C_GR_TAX_OFFICE_formula C_GR_TAX_OFFICE, JG_ZZ_RGRH_PKG.C_GR_TAX_AREA_formula C_GR_TAX_AREA, JG_ZZ_RGRH_PKG.C_TOTAL_PAGES_formula C_TOTAL_PAGES, :P_YEAR YEAR, :P_VAT_REG VAT_REG, :P_REPORT_NAME REPORT_NAME FROM xle_firstparty_information_v WHERE legal_entity_id = :P_LEGAL_ENTITY_ID |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Legal Entity |
|
LOV Oracle | |
| Operating Unit |
|
LOV Oracle | |
| First Page Number |
|
Number | |
| Number of Pages |
|
Number | |
| Total Pages Required |
|
LOV Oracle | |
| Report Title |
|
LOV Oracle | |
| System |
|
LOV Oracle | |
| Year |
|
Number |
