-- Check Folder option columns
SELECT *
FROM apps.fnd_folder_columns
WHERE folder_id IN (
SELECT folder_id
FROM apps.fnd_folders
WHERE NAME = 'OM' AND OBJECT = 'OE_ORDERS'
AND public_flag = 'Y')
AND item_prompt = 'Pricing Contract'
-- AOL Messages
SELECT *
FROM fnd_new_messages
WHERE message_name IN
('XXZP_INVALID_TEMPLATE_CHANGE',
'XXZP_ITEM_COST_DEFINED',
'XXZP_BATCH_SELECTION',
'XXZP_NEW_BATCH',
'XXZP_RECORD_ERROR')
ORDER BY message_name
-- Lookups
SELECT *
FROM apps.fnd_lookup_values
WHERE lookup_type IN ('XYZ_EC_ORDERTYPE_LKP')
