Messages
SELECT fm.message_name Message_Name,
fatl.application_name Application,
fatv.user_module_name Module,
fm.message_number,
fm.context Translation_Notes,
msg_type.meaning Message_Type,
msg_cat.meaning Category,
msg_sev.meaning Severity,
HR_GENERAL.DECODE_LOOKUP('YES_NO',fm.loggable_alertable) Logging_Enabled,
fm.message_text Short_Text,
fm.message_user_Details User_Details,
fm.message_Admin_details Administrator_Details,
fm.message_Cause Cause,
fm.message_user_action User_Action,
fm.message_Admin_Action Administrator_Action,
fmt.token_name,
fmt.data_type,
fmt.description
FROM FND_MESSAGES fm,
FND_APPLICATION_TL fatl,
FND_MESSAGE_TOKENS fmt,
fnd_lookups msg_type,
fnd_lookups msg_cat,
fnd_lookups msg_sev,
fnd_appl_taxonomy_vl fatv
WHERE msg_type.lookup_type(+) = 'MESSAGE_TYPE'
AND msg_type.lookup_code(+) = fm.type
AND msg_cat.lookup_type(+) = 'MESSAGE_CATEGORY'
AND msg_cat.lookup_code(+) = fm.message_category
AND msg_sev.lookup_type(+) = 'MESSAGE_SEVERITY'
AND msg_sev.lookup_code(+) = fm.message_Severity
AND fatv.module_id = fm.module_id
AND fatl.application_id = fm.application_id
AND fmt.message_name(+) = fm.message_name
AND fatl.language = USERENV('LANG')
AND fatl.application_name = 'Absence Management'
AND (
(:P_CREATION_TYPE= 'Custom' and fm.created_by <> 'SEED_DATA_FROM_APPLICATION' )
OR (:P_CREATION_TYPE = 'Seeded' and fm.created_by = 'SEED_DATA_FROM_APPLICATION' )
OR (:P_CREATION_TYPE = 'Seeded Modified' and fm.created_by = 'SEED_DATA_FROM_APPLICATION' and fm.last_updated_by <> 'SEED_DATA_FROM_APPLICATION')
OR (:P_CREATION_TYPE = 'ALL')
)
ORDER BY fm.message_name