Product: | JTF - CRM Foundation |
---|---|
Description: | Internal View for JTF_STATE_RESPONSIBILITIES and FND_RESPONSIBILITY |
Implementation/DBA Data: | APPS.JTF_STATE_RESPONSIBILITIES_V |
SELECT SRE.STATE_RESPONSIBILITY_ID STATE_RESPONSIBILITY_ID
, SRE.CREATED_BY
, SRE.CREATION_DATE
, SRE.LAST_UPDATED_BY
, SRE.LAST_UPDATE_DATE
, SRE.LAST_UPDATE_LOGIN
, SRE.RESPONSIBILITY_ID RESPONSIBILITY_ID
, FRE.APPLICATION_ID APPLICATION_ID
, FRL.RESPONSIBILITY_NAME RESPONSIBILITY_NAME
, SRE.RULE_ID RULE_ID
, SRU.RULE_NAME RULE_NAME
, SRU.STATE_TYPE
, SRE.ATTRIBUTE1 ATTRIBUTE1
, SRE.ATTRIBUTE2 ATTRIBUTE2
, SRE.ATTRIBUTE3 ATTRIBUTE3
, SRE.ATTRIBUTE4 ATTRIBUTE4
, SRE.ATTRIBUTE5 ATTRIBUTE5
, SRE.ATTRIBUTE6 ATTRIBUTE6
, SRE.ATTRIBUTE7 ATTRIBUTE7
, SRE.ATTRIBUTE8 ATTRIBUTE8
, SRE.ATTRIBUTE9 ATTRIBUTE9
, SRE.ATTRIBUTE10 ATTRIBUTE10
, SRE.ATTRIBUTE11 ATTRIBUTE11
, SRE.ATTRIBUTE12 ATTRIBUTE12
, SRE.ATTRIBUTE13 ATTRIBUTE13
, SRE.ATTRIBUTE14 ATTRIBUTE14
, SRE.ATTRIBUTE15 ATTRIBUTE15
, SRE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SRE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM JTF_STATE_RESPONSIBILITIES SRE
, FND_RESPONSIBILITY_TL FRL
, FND_RESPONSIBILITY FRE
, JTF_STATE_RULES_VL SRU
WHERE SRE.RESPONSIBILITY_ID = FRE.RESPONSIBILITY_ID AND SRE.RULE_ID = SRU.RULE_ID AND FRE.RESPONSIBILITY_ID = FRL.RESPONSIBILITY_ID AND FRE.APPLICATION_ID = FRL.APPLICATION_ID AND FRL.LANGUAGE = USERENV ('LANG')