DBA Data[Home] [Help]

APPS.OTA_TFL_API_BUSINESS_RULES2 dependencies on OTA_VENDOR_SUPPLIES

Line 353: from ota_vendor_supplies tvs

349: tpe.start_date and nvl(tpe.end_date,evt.course_start_date)
350: and (( evt.activity_version_id = tpe.activity_version_id
351: and not exists
352: (select null
353: from ota_vendor_supplies tvs
354: , ota_price_list_entries tpe2
355: where tvs.vendor_id = evt.vendor_id
356: and tvs.activity_version_id = evt.activity_version_id
357: and tpe2.vendor_supply_id = tvs.vendor_supply_id

Line 366: from ota_vendor_supplies tvs

362: )
363: or
364: ( exists
365: (select null
366: from ota_vendor_supplies tvs
367: where tvs.vendor_id = evt.vendor_id
368: and tvs.activity_version_id = evt.activity_version_id
369: and tpe.vendor_supply_id = tvs.vendor_supply_id)
370: ));