JE Greek Statutory Report Headings
Description
- Categories
- BI Publisher
- Application
- European Localizations
- Source
- Greek Statutory Report Headings
- Short Name
- JEGRRGRH
- DB package
- JG_ZZ_RGRH_PKG
Imported from BI Publisher
Produces Pre-printed Report Headers
Produces Pre-printed Report Headers
SQL 24 lines
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 |
Parameters 7
| Parameter | Type | List of values SQL |
|---|---|---|
| Legal Entity | LOV Oracle | |
| Operating Unit | LOV Oracle | |
| First Page Number | Number | |
| Number of Pages | Number | |
| Report Title | LOV Oracle | |
| Optional Report Title | Char | |
| Year | Number |