VIEW: APPS.MSC_NOTE_CONTENT_UI_V

Source

View Text - Preformatted

SELECT fad.SR_INSTANCE_ID, fad.ENTITY_NAME, decode(fad.ENTITY_NAME, 'MSC_USER_NOTES', 1, 99) ENTITY_NAME_CODE, FAD.PK_VALUE1, FAD.PK_VALUE2, FAD.PK_VALUE3, FAD.PK_VALUE4, FAD.PK_VALUE5, fdst.MEDIA_ID, fdst.SHORT_TEXT, null long_text, DESCRIPTION, fad.seq_num, fad.doc_type, fad.title FROM MSC_DOC_ATTACHMENTS fad, msc_short_text fdst WHERE FAD.ENTITY_NAME = 'MSC_USER_NOTES' AND FAD.DOC_type = 1 AND FDst.MEDIA_ID = FAD.MEDIA_ID AND FDst.sr_instance_id = FAD.sr_instance_id Union all SELECT fad.SR_INSTANCE_ID, fad.ENTITY_NAME, decode(fad.ENTITY_NAME, 'MSC_USER_NOTES', 1, 99) ENTITY_NAME_CODE, FAD.PK_VALUE1, FAD.PK_VALUE2, FAD.PK_VALUE3, FAD.PK_VALUE4, FAD.PK_VALUE5, fdst.MEDIA_ID, null short_text, fdst.long_TEXT, DESCRIPTION, fad.seq_num, fad.doc_type, fad.title FROM MSC_DOC_ATTACHMENTS fad, msc_long_text fdst WHERE FAD.ENTITY_NAME = 'MSC_USER_NOTES' AND FDst.MEDIA_ID = FAD.MEDIA_ID AND FAD.DOC_type = 2 AND FDst.sr_instance_id = FAD.sr_instance_id

View Text - HTML Formatted

SELECT FAD.SR_INSTANCE_ID
, FAD.ENTITY_NAME
, DECODE(FAD.ENTITY_NAME
, 'MSC_USER_NOTES'
, 1
, 99) ENTITY_NAME_CODE
, FAD.PK_VALUE1
, FAD.PK_VALUE2
, FAD.PK_VALUE3
, FAD.PK_VALUE4
, FAD.PK_VALUE5
, FDST.MEDIA_ID
, FDST.SHORT_TEXT
, NULL LONG_TEXT
, DESCRIPTION
, FAD.SEQ_NUM
, FAD.DOC_TYPE
, FAD.TITLE
FROM MSC_DOC_ATTACHMENTS FAD
, MSC_SHORT_TEXT FDST
WHERE FAD.ENTITY_NAME = 'MSC_USER_NOTES'
AND FAD.DOC_TYPE = 1
AND FDST.MEDIA_ID = FAD.MEDIA_ID
AND FDST.SR_INSTANCE_ID = FAD.SR_INSTANCE_ID UNION ALL SELECT FAD.SR_INSTANCE_ID
, FAD.ENTITY_NAME
, DECODE(FAD.ENTITY_NAME
, 'MSC_USER_NOTES'
, 1
, 99) ENTITY_NAME_CODE
, FAD.PK_VALUE1
, FAD.PK_VALUE2
, FAD.PK_VALUE3
, FAD.PK_VALUE4
, FAD.PK_VALUE5
, FDST.MEDIA_ID
, NULL SHORT_TEXT
, FDST.LONG_TEXT
, DESCRIPTION
, FAD.SEQ_NUM
, FAD.DOC_TYPE
, FAD.TITLE
FROM MSC_DOC_ATTACHMENTS FAD
, MSC_LONG_TEXT FDST
WHERE FAD.ENTITY_NAME = 'MSC_USER_NOTES'
AND FDST.MEDIA_ID = FAD.MEDIA_ID
AND FAD.DOC_TYPE = 2
AND FDST.SR_INSTANCE_ID = FAD.SR_INSTANCE_ID