SELECT RG.ID RULE_GROUP_ID, RG.DNZ_CHR_ID DNZ_CHR_ID, RG.CHR_ID CHR_ID, RG.CLE_ID CLE_ID, SLH.ID SLH_ID, SLH.OBJECT1_ID1 PAYMENT_ID FROM OKC_RULE_GROUPS_B RG,OKC_RULES_B SLH WHERE SLH.DNZ_CHR_ID = RG.DNZ_CHR_ID AND SLH.RGP_ID = RG.ID AND SLH.RULE_INFORMATION_CATEGORY = 'LASLH'
SELECT RG.ID RULE_GROUP_ID
, RG.DNZ_CHR_ID DNZ_CHR_ID
, RG.CHR_ID CHR_ID
, RG.CLE_ID CLE_ID
, SLH.ID SLH_ID
, SLH.OBJECT1_ID1 PAYMENT_ID
FROM OKC_RULE_GROUPS_B RG
, OKC_RULES_B SLH
WHERE SLH.DNZ_CHR_ID = RG.DNZ_CHR_ID
AND SLH.RGP_ID = RG.ID
AND SLH.RULE_INFORMATION_CATEGORY = 'LASLH'
|
|
|