VIEW: APPS.IEC_G_SCHEDULES_V

Source

View Text - Preformatted

SELECT A.SCHEDULE_ID , B.SCHEDULE_NAME , B.DESCRIPTION , A.USER_STATUS_ID , A.STATUS_CODE , A.ACTIVITY_ID , A.ACTIVITY_ATTRIBUTE1 , A.ACTIVITY_ATTRIBUTE2 , A.ACTIVITY_ATTRIBUTE3 , A.ACTIVITY_ATTRIBUTE4 , A.ACTIVITY_ATTRIBUTE5 , A.ACTIVITY_ATTRIBUTE6 , A.ACTIVITY_ATTRIBUTE7 , A.ACTIVITY_ATTRIBUTE8 , A.ACTIVE_FLAG , A.SOURCE_CODE , A.START_DATE_TIME , A.END_DATE_TIME , A.CAMPAIGN_ID , C.CAMPAIGN_NAME , A.MARKETING_MEDIUM_ID , A.LAST_UPDATE_DATE , A.LAST_UPDATED_BY , A.CREATION_DATE , A.CREATED_BY , A.LAST_UPDATE_LOGIN , A.OBJECT_VERSION_NUMBER , A.OWNER_USER_ID , B.LANGUAGE , D.NAME FROM AMS_CAMPAIGN_SCHEDULES_B A , AMS_CAMPAIGN_SCHEDULES_TL B , AMS_CAMPAIGNS_ALL_TL C , AMS_USER_STATUSES_TL D WHERE A.ACTIVITY_ID = 460 AND A.SCHEDULE_ID = B.SCHEDULE_ID AND C.CAMPAIGN_ID =A.CAMPAIGN_ID AND B.LANGUAGE = C.LANGUAGE AND A.USER_STATUS_ID = D.USER_STATUS_ID AND D.LANGUAGE = B.LANGUAGE

View Text - HTML Formatted

SELECT A.SCHEDULE_ID
, B.SCHEDULE_NAME
, B.DESCRIPTION
, A.USER_STATUS_ID
, A.STATUS_CODE
, A.ACTIVITY_ID
, A.ACTIVITY_ATTRIBUTE1
, A.ACTIVITY_ATTRIBUTE2
, A.ACTIVITY_ATTRIBUTE3
, A.ACTIVITY_ATTRIBUTE4
, A.ACTIVITY_ATTRIBUTE5
, A.ACTIVITY_ATTRIBUTE6
, A.ACTIVITY_ATTRIBUTE7
, A.ACTIVITY_ATTRIBUTE8
, A.ACTIVE_FLAG
, A.SOURCE_CODE
, A.START_DATE_TIME
, A.END_DATE_TIME
, A.CAMPAIGN_ID
, C.CAMPAIGN_NAME
, A.MARKETING_MEDIUM_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, A.OWNER_USER_ID
, B.LANGUAGE
, D.NAME
FROM AMS_CAMPAIGN_SCHEDULES_B A
, AMS_CAMPAIGN_SCHEDULES_TL B
, AMS_CAMPAIGNS_ALL_TL C
, AMS_USER_STATUSES_TL D
WHERE A.ACTIVITY_ID = 460
AND A.SCHEDULE_ID = B.SCHEDULE_ID
AND C.CAMPAIGN_ID =A.CAMPAIGN_ID
AND B.LANGUAGE = C.LANGUAGE
AND A.USER_STATUS_ID = D.USER_STATUS_ID
AND D.LANGUAGE = B.LANGUAGE