VIEW: APPS.GCS_FINANCIAL_ITEMS_V

Source

View Text - Preformatted

SELECT ghb.hierarchy_id, 1, msg.message_text, msg.language_code, msg.language_code from gcs_hierarchies_b ghb, fnd_new_messages msg WHERE msg.application_id = 266 and msg.message_name = 'FCH_ICM_TOTAL_FIN_ITEM' and ghb.certification_flag = 'Y'

View Text - HTML Formatted

SELECT GHB.HIERARCHY_ID
, 1
, MSG.MESSAGE_TEXT
, MSG.LANGUAGE_CODE
, MSG.LANGUAGE_CODE
FROM GCS_HIERARCHIES_B GHB
, FND_NEW_MESSAGES MSG
WHERE MSG.APPLICATION_ID = 266
AND MSG.MESSAGE_NAME = 'FCH_ICM_TOTAL_FIN_ITEM'
AND GHB.CERTIFICATION_FLAG = 'Y'