VIEW: APPS.MSC_NOTE_UI_V

Source

View Text - Preformatted

SELECT distinct fad.SR_INSTANCE_ID, fad.ENTITY_NAME, decode(fad.ENTITY_NAME, 'MSC_USER_NOTES', 1, 99) ENTITY_NAME_CODE, FAD.PK_VALUE1, mi1.item_name PK_VALUE1_TEXT, FAD.PK_VALUE2, mi2.item_name PK_VALUE2_TEXT, FAD.PK_VALUE3, null PK_VALUE3_TEXT, FAD.PK_VALUE4, null PK_VALUE4_TEXT, FAD.PK_VALUE5, null PK_VALUE5_TEXT FROM MSC_DOC_ATTACHMENTS fad, msc_items mi1, msc_items mi2 WHERE FAD.ENTITY_NAME = 'MSC_USER_NOTES' and fad.PK_VALUE1 = mi1.inventory_item_id and fad.PK_VALUE2 = mi2.inventory_item_id

View Text - HTML Formatted

SELECT DISTINCT FAD.SR_INSTANCE_ID
, FAD.ENTITY_NAME
, DECODE(FAD.ENTITY_NAME
, 'MSC_USER_NOTES'
, 1
, 99) ENTITY_NAME_CODE
, FAD.PK_VALUE1
, MI1.ITEM_NAME PK_VALUE1_TEXT
, FAD.PK_VALUE2
, MI2.ITEM_NAME PK_VALUE2_TEXT
, FAD.PK_VALUE3
, NULL PK_VALUE3_TEXT
, FAD.PK_VALUE4
, NULL PK_VALUE4_TEXT
, FAD.PK_VALUE5
, NULL PK_VALUE5_TEXT
FROM MSC_DOC_ATTACHMENTS FAD
, MSC_ITEMS MI1
, MSC_ITEMS MI2
WHERE FAD.ENTITY_NAME = 'MSC_USER_NOTES'
AND FAD.PK_VALUE1 = MI1.INVENTORY_ITEM_ID
AND FAD.PK_VALUE2 = MI2.INVENTORY_ITEM_ID