DBA Data[Home] [Help]

APPS.OTA_TFL_API_BUSINESS_RULES2 dependencies on OTA_PRICE_LIST_ENTRIES

Line 336: , ota_price_list_entries tpe

332: select decode(p_price_list_type,'T',tpe.price
333: ,tpe.price)
334: , evt.standard_price
335: from ota_events evt
336: , ota_price_list_entries tpe
337: , ota_price_lists tpl
338: where evt.event_id = p_event_id
339: and evt.currency_code = p_currency_code
340: and tpe.price_basis = p_price_basis

Line 354: , ota_price_list_entries tpe2

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
358: and tpe2.price_list_id = p_price_list_id