View: JTF_NOTES_SOURCE_TYPE_MAP_V

Product:	JTF - CRM Foundation
Description:	View over JTF_OBJECT_MAPPINGS_V
Implementation/DBA Data:	APPS.JTF_NOTES_SOURCE_TYPE_MAP_V

View Text

SELECT OBM.ROW_ID
, OBM.MAPPING_ID
, OBM.SOURCE_OBJECT_CODE
, OBJ.NAME SOURCE_MEANING
, OBM.OBJECT_ID
, LKUP.MEANING TYPE_MEANING
, OBM.END_DATE
, OBM.LAST_UPDATE_DATE
, OBM.LAST_UPDATED_BY
, OBM.CREATION_DATE
, OBM.CREATED_BY
, OBM.LAST_UPDATE_LOGIN
, OBM.APPLICATION_ID
, OBM.SEEDED_FLAG
, 'JTF_NOTE_TYPE'
FROM JTF_OBJECT_MAPPINGS_V OBM
, JTF_OBJECTS_VL OBJ
, FND_LOOKUPS LKUP
WHERE OBM.SOURCE_OBJECT_CODE=OBJ.OBJECT_CODE
AND LKUP.LOOKUP_CODE = OBM.OBJECT_ID
AND LKUP.LOOKUP_TYPE='JTF_NOTE_TYPE'
AND OBM.OBJECT_CODE='JTF_NOTE_TYPE'

Columns