DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_LOOKUPS

Line 6144: ams_lookups lookup

6140: campaign_id
6141: FROM ams_campaign_schedules_b csch,
6142: ams_scheduler scheduler,
6143: AMS_MEDIA_VL Med,
6144: ams_lookups lookup
6145: WHERE csch.schedule_id = p_schedule_id
6146: AND scheduler.OBJECT_ID(+) = nvl(csch.orig_csch_id, csch.schedule_id)
6147: AND scheduler.OBJECT_TYPE(+) = 'CSCH'
6148: AND Med.media_id = csch.activity_id