1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
Server exception: Error preparing statement for executing the report query :
SELECT distinct
nms_contracts_R.cnt_id,
nms_contracts_R.name,
nms_contracts_R.external_contract_no,
nms_contracts_R.contract_no,
nms_contracts_R.business_category,
nms_contracts_R.wordings,
nms.cg_ref_codes.RV_MEANING,
nms_contract_relationships.relationship relOI,
nms_counterparts.name nameOI,
rel2.relationship as relRR,
ctp2.name as nameRR,
nms_captive_entities.name as captive_entities_name,
nms_management_entities.name as management_entities_name
FROM nms_contracts_R,
nms_contract_relationships,
nms_counterparts,
nms_counterparts ctp2,
nms_contract_relationships rel2,
nms.cg_ref_codes,
nms_captive_entities,
nms_management_entities
WHERE ((nms_contract_relationships.cnt_id = nms_contracts_R.cnt_id)
AND (nms_contracts_R.cnt_id = rel2.cnt_id)
AND (ctp2.ctp_id = rel2.ctp_id)
AND (nms_counterparts.ctp_id(+) = nms_contract_relationships.ctp_id)
AND (nms_contracts_R.business_category = cg_ref_codes.rv_low_value)
AND (nms_contracts_R.cnt_id IN ($V{allcnt}))
AND (nms_contracts_R.cic_id = nms_captive_entities.cic_id)
AND (nms_captive_entities.mgety_code = nms_management_entities.code)
AND (nms_contracts_R.CNT_TYPE = 'ITR')
AND (cg_ref_codes.rv_domain = 'BUSINESS CATEGORY')
AND (nms_contract_relationships.relationship = 'OI')
AND (rel2.relationship = 'CE' )
)
order by contract_no |
Partager