View: JTF_RS_JOB_ROLES_VL

Product:	JTF - CRM Foundation
Description:	This view is used in define role setup form jobs block.
Implementation/DBA Data:	APPS.JTF_RS_JOB_ROLES_VL

View Text

SELECT R.ROWID ROW_ID
, R.JOB_ROLE_ID JOB_ROLE_ID
, R.JOB_ID JOB_ID
, R.ROLE_ID ROLE_ID
, R.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, R.ATTRIBUTE1 ATTRIBUTE1
, R.ATTRIBUTE2 ATTRIBUTE2
, R.ATTRIBUTE3 ATTRIBUTE3
, R.ATTRIBUTE4 ATTRIBUTE4
, R.ATTRIBUTE5 ATTRIBUTE5
, R.ATTRIBUTE6 ATTRIBUTE6
, R.ATTRIBUTE7 ATTRIBUTE7
, R.ATTRIBUTE8 ATTRIBUTE8
, R.ATTRIBUTE9 ATTRIBUTE9
, R.ATTRIBUTE10 ATTRIBUTE10
, R.ATTRIBUTE11 ATTRIBUTE11
, R.ATTRIBUTE12 ATTRIBUTE12
, R.ATTRIBUTE13 ATTRIBUTE13
, R.ATTRIBUTE14 ATTRIBUTE14
, R.ATTRIBUTE15 ATTRIBUTE15
, R.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, R.CREATED_BY CREATED_BY
, R.CREATION_DATE CREATION_DATE
, R.LAST_UPDATED_BY LAST_UPDATED_BY
, R.LAST_UPDATE_DATE LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.NAME JOB_NAME
FROM JTF_RS_JOB_ROLES R
, PER_JOBS P
WHERE R.JOB_ID = P.JOB_ID

Columns