SELECT aa.alert_name, aa.creation_date, aa.last_update_date,
aa.alert_condition_type, aa.enabled_flag, aa.start_date_active,
aa.end_date_active, aa.description, aa.date_last_checked,
aa.maintain_history_days, aa.table_name, aa.sql_statement_text,
fa.application_name
FROM alr_alerts aa, fnd_application_tl fa
WHERE aa.alert_name LIKE 'XX%' AND aa.application_id = fa.application_id
1 comment:
கலக்குறீங்க மாப்பி, ஆகா மாப்பி, ஓகோ மாப்பி.
Post a Comment