View: AMS_CTD_ASSOC_V

Product:	AMS - Marketing
Description:	This view is on top of ams_clik_thru_actions_vl and
Implementation/DBA Data:	APPS.AMS_CTD_ASSOC_V

View Text

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

Columns