SQLDepot

1 query found for "Calculation Rule Language"

Retrieve Calculation Rules for Calculation Group group

SELECT 
  R.CALC_RULE_CD, 
  R.CR_EXEC_SEQ, 
  R.REF_CALC_GRP_CD,
  L.DESCR100
FROM 
  C1_CALC_RULE R, 
  C1_CALC_RULE_L L
WHERE 
  R.CALC_GRP_CD = 'INSERT_CALCULATION_GROUP'
  AND R.CALC_GRP_CD = L.CALC_GRP_CD
  AND R.CALC_RULE_CD = L.CALC_RULE_CD
  AND L.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
ORDER BY R.CR_EXEC_SEQ
uploaded by Nuno Rodrigues