VIEW: APPS.AMS_ACT_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT OBJ.object_association_id, OBJ.usage_type, LKUP1.meaning, OBJ.master_object_id, OBJ.master_object_type, LKUP2.meaning, OBJ.using_object_id, OBJ.using_object_type, LKUP3.meaning, CAM.CAMPAIGN_ID, CAM.CAMPAIGN_NAME, CAM.Campaign_purpose_code, CAM.Campaign_purpose, CAM.owner_user_id, CAM.ACTUAL_PLAN_START_DATE, CAM.ACTUAL_PLAN_END_DATE, OBJ.object_version_number from AMS_OBJECT_ASSOCIATIONS OBJ, AMS_CAMPAIGNS_V CAM, AMS_LOOKUPS LKUP1, AMS_LOOKUPS LKUP2, AMS_LOOKUPS LKUP3 WHERE OBJ.USING_OBJECT_TYPE='CAMP' AND OBJ.USING_OBJECT_ID=CAM.CAMPAIGN_ID AND LKUP1.LOOKUP_TYPE(+)='AMS_OBJECT_USAGE_TYPE' AND LKUP1.LOOKUP_CODE(+)= OBJ.USAGE_TYPE AND LKUP2.LOOKUP_TYPE(+)='AMS_MASTER_OBJECT_TYPE' AND LKUP2.LOOKUP_CODE(+)= OBJ.MASTER_OBJECT_TYPE AND LKUP3.LOOKUP_TYPE(+)='AMS_USING_OBJECT_TYPE' AND LKUP3.LOOKUP_CODE(+)= OBJ.USING_OBJECT_TYPE

View Text - HTML Formatted

SELECT OBJ.OBJECT_ASSOCIATION_ID
, OBJ.USAGE_TYPE
, LKUP1.MEANING
, OBJ.MASTER_OBJECT_ID
, OBJ.MASTER_OBJECT_TYPE
, LKUP2.MEANING
, OBJ.USING_OBJECT_ID
, OBJ.USING_OBJECT_TYPE
, LKUP3.MEANING
, CAM.CAMPAIGN_ID
, CAM.CAMPAIGN_NAME
, CAM.CAMPAIGN_PURPOSE_CODE
, CAM.CAMPAIGN_PURPOSE
, CAM.OWNER_USER_ID
, CAM.ACTUAL_PLAN_START_DATE
, CAM.ACTUAL_PLAN_END_DATE
, OBJ.OBJECT_VERSION_NUMBER
FROM AMS_OBJECT_ASSOCIATIONS OBJ
, AMS_CAMPAIGNS_V CAM
, AMS_LOOKUPS LKUP1
, AMS_LOOKUPS LKUP2
, AMS_LOOKUPS LKUP3
WHERE OBJ.USING_OBJECT_TYPE='CAMP'
AND OBJ.USING_OBJECT_ID=CAM.CAMPAIGN_ID
AND LKUP1.LOOKUP_TYPE(+)='AMS_OBJECT_USAGE_TYPE'
AND LKUP1.LOOKUP_CODE(+)= OBJ.USAGE_TYPE
AND LKUP2.LOOKUP_TYPE(+)='AMS_MASTER_OBJECT_TYPE'
AND LKUP2.LOOKUP_CODE(+)= OBJ.MASTER_OBJECT_TYPE
AND LKUP3.LOOKUP_TYPE(+)='AMS_USING_OBJECT_TYPE'
AND LKUP3.LOOKUP_CODE(+)= OBJ.USING_OBJECT_TYPE