Reports2017-11-18T12:27:27+00:00

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
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
Ledger Id
 
LOV Oracle
Country
 
LOV Oracle
Year
 
Number
Optional Report Title
 
Report Title
 
LOV Oracle
Number of Pages
 
Number
First Page Number
 
Number
Operating Unit
 
LOV Oracle
Legal Entity
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept