500 Error
ORA-00942: table or view does not exist
Datasource: hrvic
SQL: SELECT
decode(c.body_type_id,201,c.org_name,(c.preferred_name||' '||c.surname)) TRAINER
, c.client_id CLIENT_ID
, SUM(cs.aus_total_starts) STARTS
, SUM(cs.aus_total_wins) WINS
, SUM(cs.aus_total_place) PLACES
, SUM(cs.aus_total_seconds) SECONDS
, SUM(cs.aus_total_thirds) THIRDS
, SUM(cs.aus_total_stakes) STAKES
, cs1.aus_total_starts TS_STARTS
, cs1.aus_total_wins TS_WINS
, cs1.aus_total_place TS_PLACES
, cs1.aus_total_seconds TS_SECONDS
, cs1.aus_total_thirds TS_THIRDS
, cs1.aus_total_stakes TS_STAKES
, a.city CITY
, a.state STATE
, a2.city STABLE_CITY
, a2.state STABLE_STATE
, decode(lc1.licence_code, 'TRA', 'Grade A Trainer', 'TRB', 'Grade B Trainer', 'TRC', 'Grade C Trainer', '') LICENCE
, decode(phphone.effective_value, 0, '', 1, a.telephone) telephone_priv_all
, decode(pmobile.effective_value, 0, '', 1, c.mobile_phone) mobile_phone_priv_display
, decode(p.effective_value, 0, '', 1, decode(phphone.effective_value, 0, '', 1, a.telephone)) a_priv_display_directory
, decode(p.effective_value, 0, '', 1, decode(pmobile.effective_value, 0, '', 1, c.mobile_phone)) c_priv_display_directory
, decode(phweb.effective_value, 0, '', 1, decode(p.effective_value, 0, '', 1, decode(phphone.effective_value, 0, '', 1, a.telephone))) a_hweb_priv_display_web_dir
, decode(phweb.effective_value, 0, '', 1, decode(p.effective_value, 0, '', 1, decode(pmobile.effective_value, 0, '', 1, c.mobile_phone))) c_hweb_priv_display_web_dir
FROM
client c
, client_summary cs
, client_summary cs1
, season s
, address a
, address a2
, property p
, licence l1
, licence_category lc1
, VW_PRIV_EFFECTIVE_COMM_VALUES p
, VW_PRIV_EFFECTIVE_COMM_VALUES phweb
, VW_PRIV_EFFECTIVE_COMM_VALUES phphone
, VW_PRIV_EFFECTIVE_COMM_VALUES pmobile
WHERE
c.client_id = '10003307'
and c.client_id = cs.client_id (+)
and cs.client_type = 'TRAINER'
and c.client_id = l1.client_id
and l1.state = 'VIC'
and sysdate between l1.start_date and l1.end_date
and nvl(l1.status, 'CURRENT') not in ('DISQUALIFIED','CANCELLED')
and l1.licence_category_id between 1 and 4
and l1.licence_category_id = lc1.licence_category_id
and nvl(c.postal_address_id, c.street_address_id) = a.address_id
and a.valid_to_date >= sysdate
and c.stables_property_id = p.property_id(+)
and nvl(p.street_address_id, p.postal_address_id) = a2.address_id(+)
and nvl(a2.valid_to_date, sysdate+1) > sysdate
and c.client_id = cs1.client_id (+)
and cs1.client_type(+) = 'TRAINER'
and s.season_type_id = 101
and sysdate between s.from_date and s.to_date
and s.season_id = cs1.season_id (+)
and c.client_id = p.client_id
and c.client_id = phweb.client_id
and c.client_id = phphone.client_id
and c.client_id = pmobile.client_id
and p.communication_id = pkg_constants.fGetConstNumber('PRIV_OPTION_LicenseeDir')
and phweb.communication_id = pkg_constants.fGetConstNumber('PRIV_OPTION_DisplayHarness')
and phphone.communication_id = pkg_constants.fGetConstNumber('PRIV_OPTION_PublishHPhone')
and pmobile.communication_id = pkg_constants.fGetConstNumber('PRIV_OPTION_PublishMPhone')
GROUP BY c.body_type_id, c.org_name, c.preferred_name, c.surname, c.client_id, a.city, a.state, a2.city, a2.state, lc1.licence_code
, cs1.aus_total_starts, cs1.aus_total_wins, cs1.aus_total_place, cs1.aus_total_seconds, cs1.aus_total_thirds, cs1.aus_total_stakes
, a.telephone, c.mobile_phone
, p.effective_value, phweb.effective_value, phphone.effective_value, pmobile.effective_value
Code: 0
Type: 0
Column: 0
ID: ??
Line: 289
Raw Trace: hrv.includes.model.licenceesdao_cfc$cf.udfCall(/muraWRM/hrv/includes/model/licenceesdao.cfc:289)
Template: /srv/rise/www/thetrots/wwwroot/hrv/includes/model/licenceesdao.cfc
Type: cfml
Column: 0
ID: ??
Line: 19
Raw Trace: hrv.includes.display_objects.custom.directory.victrainersdetails_cfm$cf.call(/muraWRM/hrv/includes/display_objects/custom/directory/vicTrainersDetails.cfm:19)
Template: /srv/rise/www/thetrots/wwwroot/hrv/includes/display_objects/custom/directory/vicTrainersDetails.cfm
Type: cfml
Column: 0
ID: ??
Line: 2468
Raw Trace: content.contentrenderer_cfc$cf.udfCallb(/mura/content/contentRenderer.cfc:2468)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 228
Raw Trace: cfobject_cfc$cf.udfCall3(/mura/cfobject.cfc:228)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/cfobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 106
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:106)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/MuraScope.cfc
Type: cfml
Column: 0
ID: ??
Line: 2420
Raw Trace: content.contentrenderer_cfc$cf.udfCallb(/mura/content/contentRenderer.cfc:2420)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 88
Raw Trace: content.contentrendererutility_cfc$cf.udfCall1(/mura/content/contentRendererUtility.cfc:88)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentRendererUtility.cfc
Type: cfml
Column: 0
ID: ??
Line: 3053
Raw Trace: content.contentrenderer_cfc$cf.udfCalld(/mura/content/contentRenderer.cfc:3053)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 228
Raw Trace: cfobject_cfc$cf.udfCall3(/mura/cfobject.cfc:228)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/cfobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 106
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:106)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/MuraScope.cfc
Type: cfml
Column: 0
ID: ??
Line: 88
Raw Trace: hrv.includes.themes.murabootstrap3.content_types.page.index_cfm$cf.call(/muraWRM/hrv/includes/themes/MuraBootstrap3/content_types/page/index.cfm:88)
Template: /srv/rise/www/thetrots/wwwroot/hrv/includes/themes/MuraBootstrap3/content_types/page/index.cfm
Type: cfml
Column: 0
ID: ??
Line: 1607
Raw Trace: content.contentrenderer_cfc$cf.udfCall6(/mura/content/contentRenderer.cfc:1607)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 228
Raw Trace: cfobject_cfc$cf.udfCall3(/mura/cfobject.cfc:228)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/cfobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 106
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:106)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/MuraScope.cfc
Type: cfml
Column: 0
ID: ??
Line: 32
Raw Trace: hrv.includes.themes.murabootstrap3.templates.one_column_cfm$cf.call(/muraWRM/hrv/includes/themes/MuraBootstrap3/templates/one_column.cfm:32)
Template: /srv/rise/www/thetrots/wwwroot/hrv/includes/themes/MuraBootstrap3/templates/one_column.cfm
Type: cfml
Column: 0
ID: ??
Line: 94
Raw Trace: translator.standardhtmltranslator_cfc$cf.udfCall(/mura/Translator/standardHTMLTranslator.cfc:94)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/Translator/standardHTMLTranslator.cfc
Type: cfml
Column: 0
ID: ??
Line: 140
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:140)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/plugin/pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 87
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall1(/mura/Handler/standardEventsHandler.cfc:87)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/Handler/standardEventsHandler.cfc
Type: cfml
Column: 0
ID: ??
Line: 1328
Raw Trace: utility_cfc$cf.udfCall7(/mura/utility.cfc:1328)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/utility.cfc
Type: cfml
Column: 0
ID: ??
Line: 90
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:90)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/plugin/pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 420
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall3(/mura/Handler/standardEventsHandler.cfc:420)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/Handler/standardEventsHandler.cfc
Type: cfml
Column: 0
ID: ??
Line: 1328
Raw Trace: utility_cfc$cf.udfCall7(/mura/utility.cfc:1328)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/utility.cfc
Type: cfml
Column: 0
ID: ??
Line: 90
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:90)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/plugin/pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 805
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:805)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 259
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:259)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 313
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:313)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 676
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:676)
Template: /srv/rise/www/thetrots/wwwroot/requirements/mura/content/contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 46
Raw Trace: index_cfm$cf.call(/index.cfm:46)
Template: /srv/rise/www/thetrots/wwwroot/index.cfm
Type: cfml