Tuesday, October 24, 2017

Alert Tables in Oracle Apps

ALR_ALERTS
ALR_ACTIONS
ALR_ACTION_SETS
ALR_RESPONSE_SETS
ALR_DISTRIBUTION_LISTS
ALR_MESSAGE_SYSTEMS
ALR_ORACLE_MAIL_ACCOUNTS
ALR_LOOKUPS
ALR_ALERT_CHECKS
ALR_ALERT_INPUTS
ALR_ALERT_INSTALLATIONS
ALR_ALERT_OUTPUTS

No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...