VIEW: APPS.CSM_STATE_RULES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.RULE_ID , B.STATE_TYPE , B.APPLICATION_ID , TL.RULE_NAME FROM JTF_STATE_RULES_B B , JTF_STATE_RULES_TL TL , CSM_STATE_RULES_ACC ACC WHERE B.RULE_ID = TL.RULE_ID AND ACC.RULE_ID = B.RULE_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.RULE_ID
, B.STATE_TYPE
, B.APPLICATION_ID
, TL.RULE_NAME
FROM JTF_STATE_RULES_B B
, JTF_STATE_RULES_TL TL
, CSM_STATE_RULES_ACC ACC
WHERE B.RULE_ID = TL.RULE_ID
AND ACC.RULE_ID = B.RULE_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE