DBA Data[Home] [Help]

APPS.AMS_ADI_CAMP_SCHED_PVT dependencies on AMS_MEDIA_B

Line 96: from ams_adi_campaigns_interface a, ams_media_b b

92: a.activity_attribute1,a.activity_attribute2,a.activity_attribute3,a.activity_attribute4,a.activity_attribute5,
93: a.activity_attribute6,a.activity_attribute7,a.activity_attribute8,a.activity_attribute9,a.activity_attribute10,
94: a.activity_attribute11,a.activity_attribute12,a.activity_attribute13,a.activity_attribute14,a.activity_attribute15,
95: a.activity_attribute_category,a.object_version_number,a.currency_code,a.actual_activity_id,b.media_type_code
96: from ams_adi_campaigns_interface a, ams_media_b b
97: where a.upload_batch_id = l_upload_batch_id
98: and a.actual_activity_id = b.media_id(+)
99: and b.enabled_flag(+) = 'Y';
100:

Line 1870: FROM AMS_MEDIA_B

1866:
1867: CURSOR C_GET_ACTIVITY_TYPE_CODE
1868: IS
1869: SELECT MEDIA_TYPE_CODE
1870: FROM AMS_MEDIA_B
1871: WHERE media_id = p_activity_id;
1872:
1873: l_activity_type_code VARCHAR2(30);
1874: