VIEW: APPS.ISC_PLAN_SNAPSHOT_V

Source

View Text - Preformatted

SELECT -1 ID, fnm.message_text VALUE, null PLAN_NAME, null LAST_RUN_DATE FROM fnd_new_messages fnm, fnd_application fna where fnm.message_name = 'ISC_DBI_PLAN_SNAPSHOT_NONE' and fnm.language_code = userenv('LANG') and fna.application_short_name = 'ISC' and fnm.application_id = fna.application_id UNION ALL SELECT snapshot_id ID, Compile_designator||'-'|| to_char(data_start_date, FND_PROFILE.value_specific('ICX_DATE_FORMAT_MASK')) VALUE, Compile_designator PLAN_NAME, Data_start_date LAST_RUN_DATE FROM ISC_DBI_PLAN_SNAPSHOTS ORDER BY plan_name NULLS FIRST,last_run_date DESC

View Text - HTML Formatted

SELECT -1 ID
, FNM.MESSAGE_TEXT VALUE
, NULL PLAN_NAME
, NULL LAST_RUN_DATE
FROM FND_NEW_MESSAGES FNM
, FND_APPLICATION FNA
WHERE FNM.MESSAGE_NAME = 'ISC_DBI_PLAN_SNAPSHOT_NONE'
AND FNM.LANGUAGE_CODE = USERENV('LANG')
AND FNA.APPLICATION_SHORT_NAME = 'ISC'
AND FNM.APPLICATION_ID = FNA.APPLICATION_ID UNION ALL SELECT SNAPSHOT_ID ID
, COMPILE_DESIGNATOR||'-'|| TO_CHAR(DATA_START_DATE
, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK')) VALUE
, COMPILE_DESIGNATOR PLAN_NAME
, DATA_START_DATE LAST_RUN_DATE
FROM ISC_DBI_PLAN_SNAPSHOTS ORDER BY PLAN_NAME NULLS FIRST
, LAST_RUN_DATE DESC