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
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 |