Über SQL-Abfrage (TBase -> Extras) kann eine Liste mit allen Leistungen gezogen werden, welche einer bestimmten Preissynchronisationsgruppe zugeteilt sind.
| Info | ||||
|---|---|---|---|---|
| ||||
| 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 |
| Anchor | ||||
|---|---|---|---|---|
|