SELECT ASSOC.ASSOCIATION_ID,CTD.CTD_ID,ACTION.ACTION_ID,ACTION.ACTION_CODE,ACTION.ACTION_NAME,ASSOC.USED_BY_TYPE,ASSOC.USED_BY_VAL1,ASSOC.USED_BY_VAL2,ASSOC.USED_BY_VAL2 FROM AMS_CTD_ASSOCIATIONS ASSOC,AMS_CTDS CTD,AMS_CLIK_THRU_ACTIONS_VL ACTION WHERE assoc.CTD_ID = ctd.CTD_ID and ctd.action_id = action.action_id
SELECT ASSOC.ASSOCIATION_ID
, CTD.CTD_ID
, ACTION.ACTION_ID
, ACTION.ACTION_CODE
, ACTION.ACTION_NAME
, ASSOC.USED_BY_TYPE
, ASSOC.USED_BY_VAL1
, ASSOC.USED_BY_VAL2
, ASSOC.USED_BY_VAL2
FROM AMS_CTD_ASSOCIATIONS ASSOC
, AMS_CTDS CTD
, AMS_CLIK_THRU_ACTIONS_VL ACTION
WHERE ASSOC.CTD_ID = CTD.CTD_ID
AND CTD.ACTION_ID = ACTION.ACTION_ID
|
|
|