VIEW: APPS.CS_KB_INTEGRATION_V

Source

View Text - Preformatted

SELECT note_b.rowid row_id, note_b.jtf_note_id id, note_b.source_object_id app_obj_id, note_b.source_object_code app_obj_code, note_b.note_type note_type_code, lookup.meaning note_type_meaning, elem_type_b.element_type_id kb_type_id, elem_type_tl.name kb_type_meaning, note_b.note_status status, note_tl.notes note, 'T' true_stmt, note_b.creation_date creation_date, note_b.created_by created_by, note_b.last_update_date last_update_date, note_b.last_updated_by last_updated_by, note_b.last_update_login last_update_login, 'JTF_NOTE' record_source_type from jtf_notes_b note_b, jtf_notes_tl note_tl, cs_kb_ele_type_links elem_type_lnk, cs_kb_element_types_b elem_type_b, cs_kb_element_types_tl elem_type_tl, fnd_lookup_values lookup WHERE note_b.jtf_note_id = note_tl.jtf_note_id and note_tl.language = userenv('LANG') and lookup.lookup_type(+) = 'JTF_NOTE_TYPE' and note_b.note_type = lookup.lookup_code(+) and lookup.language(+) = userenv('LANG') and elem_type_b.element_type_id = elem_type_tl.element_type_id and elem_type_tl.language = userenv('LANG') and note_b.note_type = elem_type_lnk.other_code and elem_type_b.element_type_id = elem_type_lnk.element_type_id union all select kb_elem_b.rowid, kb_elem_b.element_id, kb_elem_link.other_id, objects.object_code, lkup.lookup_code, lkup.meaning, kb_elem_type_b.element_type_id, kb_elem_type_tl.name, null, kb_elem_tl.name, decode(kb_elem_link.link_type, 'T', 'T', 'F', 'F', 'T'), kb_elem_link.creation_date, kb_elem_link.created_by, kb_elem_link.last_update_date, kb_elem_link.last_updated_by, kb_elem_link.last_update_login, 'KB_ELEM' from cs_kb_element_links kb_elem_link, cs_kb_element_types_b kb_elem_type_b, cs_kb_element_types_tl kb_elem_type_tl, cs_kb_elements_b kb_elem_b, cs_kb_elements_tl kb_elem_tl, jtf_objects_b objects, cs_kb_ele_type_links kb_elem_type_lnk, fnd_lookups lkup where kb_elem_b.element_id = kb_elem_tl.element_id and kb_elem_tl.language = userenv('LANG') and kb_elem_type_b.element_type_id = kb_elem_type_tl.element_type_id and kb_elem_type_tl.language = userenv('LANG') and kb_elem_link.element_id = kb_elem_b.element_id and kb_elem_b.element_type_id = kb_elem_type_b.element_type_id and kb_elem_link.object_code = objects.object_code and kb_elem_type_lnk.element_type_id = kb_elem_type_b.element_type_id and kb_elem_type_lnk.other_code = lkup.lookup_code and lkup.lookup_type = 'JTF_NOTE_TYPE' union all select kb_set_b.rowid, kb_set_b.set_id, kb_set_link.other_id, objects.object_code, 'KB_SOLN', kb_set_type_tl.name, kb_set_type_b.set_type_id, kb_set_type_tl.name, null, kb_set_tl.name, decode(kb_set_link.link_type, 'T', 'T', 'F', 'F', 'T'), kb_set_link.creation_date, kb_set_link.created_by, kb_set_link.last_update_date, kb_set_link.last_updated_by, kb_set_link.last_update_login, 'KB_SOLN' from cs_kb_set_links kb_set_link, cs_kb_set_types_b kb_set_type_b, cs_kb_set_types_tl kb_set_type_tl, cs_kb_sets_b kb_set_b, cs_kb_sets_tl kb_set_tl, jtf_objects_b objects where kb_set_b.set_id = kb_set_tl.set_id and kb_set_tl.language = userenv('LANG') and kb_set_type_b.set_type_id = kb_set_type_tl.set_type_id and kb_set_type_tl.language = userenv('LANG') and kb_set_link.set_id = kb_set_b.set_id and kb_set_b.set_type_id = kb_set_type_b.set_type_id and kb_set_link.object_code = objects.object_code

View Text - HTML Formatted

SELECT NOTE_B.ROWID ROW_ID
, NOTE_B.JTF_NOTE_ID ID
, NOTE_B.SOURCE_OBJECT_ID APP_OBJ_ID
, NOTE_B.SOURCE_OBJECT_CODE APP_OBJ_CODE
, NOTE_B.NOTE_TYPE NOTE_TYPE_CODE
, LOOKUP.MEANING NOTE_TYPE_MEANING
, ELEM_TYPE_B.ELEMENT_TYPE_ID KB_TYPE_ID
, ELEM_TYPE_TL.NAME KB_TYPE_MEANING
, NOTE_B.NOTE_STATUS STATUS
, NOTE_TL.NOTES NOTE
, 'T' TRUE_STMT
, NOTE_B.CREATION_DATE CREATION_DATE
, NOTE_B.CREATED_BY CREATED_BY
, NOTE_B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NOTE_B.LAST_UPDATED_BY LAST_UPDATED_BY
, NOTE_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'JTF_NOTE' RECORD_SOURCE_TYPE
FROM JTF_NOTES_B NOTE_B
, JTF_NOTES_TL NOTE_TL
, CS_KB_ELE_TYPE_LINKS ELEM_TYPE_LNK
, CS_KB_ELEMENT_TYPES_B ELEM_TYPE_B
, CS_KB_ELEMENT_TYPES_TL ELEM_TYPE_TL
, FND_LOOKUP_VALUES LOOKUP
WHERE NOTE_B.JTF_NOTE_ID = NOTE_TL.JTF_NOTE_ID
AND NOTE_TL.LANGUAGE = USERENV('LANG')
AND LOOKUP.LOOKUP_TYPE(+) = 'JTF_NOTE_TYPE'
AND NOTE_B.NOTE_TYPE = LOOKUP.LOOKUP_CODE(+)
AND LOOKUP.LANGUAGE(+) = USERENV('LANG')
AND ELEM_TYPE_B.ELEMENT_TYPE_ID = ELEM_TYPE_TL.ELEMENT_TYPE_ID
AND ELEM_TYPE_TL.LANGUAGE = USERENV('LANG')
AND NOTE_B.NOTE_TYPE = ELEM_TYPE_LNK.OTHER_CODE
AND ELEM_TYPE_B.ELEMENT_TYPE_ID = ELEM_TYPE_LNK.ELEMENT_TYPE_ID UNION ALL SELECT KB_ELEM_B.ROWID
, KB_ELEM_B.ELEMENT_ID
, KB_ELEM_LINK.OTHER_ID
, OBJECTS.OBJECT_CODE
, LKUP.LOOKUP_CODE
, LKUP.MEANING
, KB_ELEM_TYPE_B.ELEMENT_TYPE_ID
, KB_ELEM_TYPE_TL.NAME
, NULL
, KB_ELEM_TL.NAME
, DECODE(KB_ELEM_LINK.LINK_TYPE
, 'T'
, 'T'
, 'F'
, 'F'
, 'T')
, KB_ELEM_LINK.CREATION_DATE
, KB_ELEM_LINK.CREATED_BY
, KB_ELEM_LINK.LAST_UPDATE_DATE
, KB_ELEM_LINK.LAST_UPDATED_BY
, KB_ELEM_LINK.LAST_UPDATE_LOGIN
, 'KB_ELEM'
FROM CS_KB_ELEMENT_LINKS KB_ELEM_LINK
, CS_KB_ELEMENT_TYPES_B KB_ELEM_TYPE_B
, CS_KB_ELEMENT_TYPES_TL KB_ELEM_TYPE_TL
, CS_KB_ELEMENTS_B KB_ELEM_B
, CS_KB_ELEMENTS_TL KB_ELEM_TL
, JTF_OBJECTS_B OBJECTS
, CS_KB_ELE_TYPE_LINKS KB_ELEM_TYPE_LNK
, FND_LOOKUPS LKUP
WHERE KB_ELEM_B.ELEMENT_ID = KB_ELEM_TL.ELEMENT_ID
AND KB_ELEM_TL.LANGUAGE = USERENV('LANG')
AND KB_ELEM_TYPE_B.ELEMENT_TYPE_ID = KB_ELEM_TYPE_TL.ELEMENT_TYPE_ID
AND KB_ELEM_TYPE_TL.LANGUAGE = USERENV('LANG')
AND KB_ELEM_LINK.ELEMENT_ID = KB_ELEM_B.ELEMENT_ID
AND KB_ELEM_B.ELEMENT_TYPE_ID = KB_ELEM_TYPE_B.ELEMENT_TYPE_ID
AND KB_ELEM_LINK.OBJECT_CODE = OBJECTS.OBJECT_CODE
AND KB_ELEM_TYPE_LNK.ELEMENT_TYPE_ID = KB_ELEM_TYPE_B.ELEMENT_TYPE_ID
AND KB_ELEM_TYPE_LNK.OTHER_CODE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'JTF_NOTE_TYPE' UNION ALL SELECT KB_SET_B.ROWID
, KB_SET_B.SET_ID
, KB_SET_LINK.OTHER_ID
, OBJECTS.OBJECT_CODE
, 'KB_SOLN'
, KB_SET_TYPE_TL.NAME
, KB_SET_TYPE_B.SET_TYPE_ID
, KB_SET_TYPE_TL.NAME
, NULL
, KB_SET_TL.NAME
, DECODE(KB_SET_LINK.LINK_TYPE
, 'T'
, 'T'
, 'F'
, 'F'
, 'T')
, KB_SET_LINK.CREATION_DATE
, KB_SET_LINK.CREATED_BY
, KB_SET_LINK.LAST_UPDATE_DATE
, KB_SET_LINK.LAST_UPDATED_BY
, KB_SET_LINK.LAST_UPDATE_LOGIN
, 'KB_SOLN'
FROM CS_KB_SET_LINKS KB_SET_LINK
, CS_KB_SET_TYPES_B KB_SET_TYPE_B
, CS_KB_SET_TYPES_TL KB_SET_TYPE_TL
, CS_KB_SETS_B KB_SET_B
, CS_KB_SETS_TL KB_SET_TL
, JTF_OBJECTS_B OBJECTS
WHERE KB_SET_B.SET_ID = KB_SET_TL.SET_ID
AND KB_SET_TL.LANGUAGE = USERENV('LANG')
AND KB_SET_TYPE_B.SET_TYPE_ID = KB_SET_TYPE_TL.SET_TYPE_ID
AND KB_SET_TYPE_TL.LANGUAGE = USERENV('LANG')
AND KB_SET_LINK.SET_ID = KB_SET_B.SET_ID
AND KB_SET_B.SET_TYPE_ID = KB_SET_TYPE_B.SET_TYPE_ID
AND KB_SET_LINK.OBJECT_CODE = OBJECTS.OBJECT_CODE