SELECT aa.alert_name, aa.creation_date, aa.last_update_date, aa.alert_condition_type, fl.meaning alert_type, aa.enabled_flag, aa.start_date_active, aa.end_date_active, aa.description alert_desc, aa.date_last_checked, aa.maintain_history_days, aa.table_name, aa.sql_statement_text, fat.application_name FROM alr_alerts aa ,fnd_lookups fl ,fnd_application_tl fat WHERE aa.alert_name LIKE 'XX%' AND aa.alert_condition_type = fl.lookup_code AND fl.lookup_type = 'ALERT_CONDITION_TYPE' AND aa.application_id = fat.application_id AND fat.language = USERENV('LANG')
Subscribe to:
Post Comments (Atom)
Query to get the Concurrent Program along with Value Set details
SELECT fcpl1.user_concurrent_program_name ,fdfcuv.end_user_column_name ,ffvs.flex_value_set_name value_set_name ,ffvt.appl...
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
SELECT HAOU.NAME "Operating Unit", OTTT_H.NAME "Transaction Type", OTTT_H.DESCRIPTION "Descripti...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...
No comments:
Post a Comment