VIEW: APPS.IEC_G_EXECUTING_SCHEDULES_V

Source

View Text - Preformatted

SELECT B.SCHEDULE_ID , B.ACTIVITY_ATTRIBUTE1 CALLING_CALENDAR_ID , B.ACTIVITY_ATTRIBUTE2 RECYCLING_ALG_ID , B.ACTIVITY_ATTRIBUTE3 RESET_TIME , B.ACTIVITY_ATTRIBUTE4 DIALING_METHOD , B.ACTIVITY_ATTRIBUTE5 ABANDON_LIMIT , B.ACTIVITY_ATTRIBUTE6 CALL_CENTER_READY_FLAG , B.ACTIVITY_ATTRIBUTE7 PREDICTIVE_PACING_CLASS , B.ACTIVITY_ATTRIBUTE8 PREDICTIVE_TIMEOUT FROM AMS_LIST_HEADERS_ALL A , AMS_CAMPAIGN_SCHEDULES_B B , AMS_ACT_LISTS C WHERE B.ACTIVITY_ID = 460 AND (B.STATUS_CODE = 'ACTIVE' OR B.STATUS_CODE = 'ACTIVE-LOCKED') AND B.ACTIVE_FLAG = 'Y' AND C.LIST_USED_BY_ID = B.SCHEDULE_ID AND C.LIST_USED_BY = 'CSCH' AND C.LIST_ACT_TYPE = 'TARGET' AND C.LIST_HEADER_ID = A.LIST_HEADER_ID AND A.STATUS_CODE = 'EXECUTING'

View Text - HTML Formatted

SELECT B.SCHEDULE_ID
, B.ACTIVITY_ATTRIBUTE1 CALLING_CALENDAR_ID
, B.ACTIVITY_ATTRIBUTE2 RECYCLING_ALG_ID
, B.ACTIVITY_ATTRIBUTE3 RESET_TIME
, B.ACTIVITY_ATTRIBUTE4 DIALING_METHOD
, B.ACTIVITY_ATTRIBUTE5 ABANDON_LIMIT
, B.ACTIVITY_ATTRIBUTE6 CALL_CENTER_READY_FLAG
, B.ACTIVITY_ATTRIBUTE7 PREDICTIVE_PACING_CLASS
, B.ACTIVITY_ATTRIBUTE8 PREDICTIVE_TIMEOUT
FROM AMS_LIST_HEADERS_ALL A
, AMS_CAMPAIGN_SCHEDULES_B B
, AMS_ACT_LISTS C
WHERE B.ACTIVITY_ID = 460
AND (B.STATUS_CODE = 'ACTIVE' OR B.STATUS_CODE = 'ACTIVE-LOCKED')
AND B.ACTIVE_FLAG = 'Y'
AND C.LIST_USED_BY_ID = B.SCHEDULE_ID
AND C.LIST_USED_BY = 'CSCH'
AND C.LIST_ACT_TYPE = 'TARGET'
AND C.LIST_HEADER_ID = A.LIST_HEADER_ID
AND A.STATUS_CODE = 'EXECUTING'