Preissynchronisationsgruppen

Abfrage Zuteilung Preissynchronisationsgruppe
Über SQL-Abfrage (TBase -> Extras) kann eine Liste mit allen Leistungen gezogen werden, welche einer bestimmten Preissynchronisationsgruppe zugeteilt sind.
SELECT lt.s_id AS LT_ID,
lt.describing_name_de AS LT_NAME,
srv.s_id AS LEISTUNG_ID,
srv.describing_name_de AS LEISTUNG_NAME,
lva_value AS PREIS_SYNC_GRUPPE
FROM tbx_service_provider, tbx_to_simple lt, tbx_service, tbx_to_simple srv, wbx_data_lookup, wbx_lookup_values
WHERE tbx_service_provider.s_id = lt.s_id
AND tbx_service.s_id = srv.s_id
AND tbx_service.service_provider_id = tbx_service_provider.s_id
AND tbx_service.s_id = wbx_data_lookup.dlo_dba_id
AND wbx_data_lookup.dlo_dfi_id = "TBX00020010001913775"
AND wbx_data_lookup.dlo_value = wbx_lookup_values.lva_loo_id
AND wbx_lookup_values.lva_lan_code = "de"
AND wbx_data_lookup.dlo_value IN ("TDS00020010903810546")
ORDER BY 2,3


Aktuell verwendete Preissynchronisations-Gruppen