View: JTF_OBJECT_MAPPINGS_V

Product:	JTF - CRM Foundation
Description:	This view is used to map source object name to object id. And it is used to drop down the list of object id that a user can use.
Implementation/DBA Data:	APPS.JTF_OBJECT_MAPPINGS_V

View Text

SELECT NTS.ROWID ROW_ID
, NTS.MAPPING_ID
, NTS.CREATED_BY
, NTS.CREATION_DATE
, NTS.LAST_UPDATED_BY
, NTS.LAST_UPDATE_DATE
, NTS.LAST_UPDATE_LOGIN
, NTS.APPLICATION_ID
, FAL.APPLICATION_NAME
, NTS.SOURCE_OBJECT_CODE
, OBJ.NAME OBJECT_NAME
, NTS.OBJECT_CODE
, NTS.OBJECT_ID
, JTF_OBJECTS_PVT.GET_OBJECT_INSTANCE_NAME(NTS.OBJECT_CODE
, NTS.OBJECT_ID) OBJECT_INSTANCE_NAME
, NTS.END_DATE
, NTS.SEEDED_FLAG
, NTS.OBJECT_VERSION_NUMBER
, NTS.ATTRIBUTE1
, NTS.ATTRIBUTE2
, NTS.ATTRIBUTE3
, NTS.ATTRIBUTE4
, NTS.ATTRIBUTE5
, NTS.ATTRIBUTE6
, NTS.ATTRIBUTE7
, NTS.ATTRIBUTE8
, NTS.ATTRIBUTE9
, NTS.ATTRIBUTE10
, NTS.ATTRIBUTE11
, NTS.ATTRIBUTE12
, NTS.ATTRIBUTE13
, NTS.ATTRIBUTE14
, NTS.ATTRIBUTE15
, NTS.ATTRIBUTE_CATEGORY
FROM JTF_OBJECT_MAPPINGS NTS
, JTF_OBJECTS_VL OBJ
, FND_APPLICATION_VL FAL
WHERE OBJ.OBJECT_CODE = NTS.SOURCE_OBJECT_CODE
AND NTS.APPLICATION_ID = FAL.APPLICATION_ID(+)

Columns