DWC Problem with Input Parameter in a SQL-Script View

[D039507]

Hello,

I have a problem to use an input parameter in a SQL-Script-View in more then one Joins.

For example, this one is working fine:

SELECT aa."RealEstateExternalID",
	aa."CompanyCode",
	aa."ValidityEndDate",
	aa."REIntegObjectUsageType",
	bb."REIntegObjectUsageTypeName",
	aa."REIntegObjectUsageClfn"
FROM SAP_RE_CLM_OccupancyCubeAggr AS aa
left join "SAP_RE_CLM_IntObjUsageType"(LANGUAGE: :LANGUAGE) as bb on aa."REIntegObjectUsageType" = bb."REIntegObjectUsageType"

Now I want to use a second join with the same logic for for another text field:

SELECT aa."RealEstateExternalID",
	aa."CompanyCode",
	aa."ValidityEndDate",
	aa."REIntegObjectUsageType",
	bb."REIntegObjectUsageTypeName",
	aa."REIntegObjectUsageClfn"
FROM SAP_RE_CLM_OccupancyCubeAggr AS aa
left join "SAP_RE_CLM_IntObjUsageType"(LANGUAGE: :LANGUAGE) as bb on aa."REIntegObjectUsageType" = bb."REIntegObjectUsageType"
left join "SAP_RE_CLM_IntObjUsageClfn"(LANGUAGE: :LANGUAGE) as cc on aa."REIntegObjectUsageClfn" = cc."REIntegObjectUsageClfn"

Then I get this error message:

wrong number of arguments: LANGUAGE is not bound, Code: 292, SQL State: 07001

Has anyone an idea how to solve this?

Thanks in advance

Thorsten