Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT IPAC.ROWID ROW_ID
, IPAC.ID ID
, IPAC.OBJECT1_ID1 OBJECT1_ID1
, IPAC.OBJECT1_ID2 OBJECT1_ID2
, IPAC.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, IPAC.USER_GROUP_ID USER_GROUP_ID
, OKR_UTIL_PUB.GET_USER_GROUP_NAME(IPAC.USER_GROUP_ID
, IPAC.USER_GROUP_CODE) USER_GROUP_NAME
, IPAC.USER_GROUP_CODE USER_GROUP_CODE
, FNDA.MEANING USER_GROUP_CODE_MEANING
, IPAC.ACCESS_LEVEL ACCESS_LEVEL
, FNDB.MEANING
, IPAC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IPAC.CREATED_BY CREATED_BY
, IPAC.CREATION_DATE CREATION_DATE
, IPAC.LAST_UPDATED_BY LAST_UPDATED_BY
, IPAC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPAC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM FND_LOOKUPS FNDA
, OKR_IP_ACCESSES IPAC
, FND_LOOKUPS FNDB
WHERE IPAC.USER_GROUP_CODE=FNDA.LOOKUP_CODE
AND FNDA.LOOKUP_TYPE='OKR_ACCESS_LIST'
AND IPAC.ACCESS_LEVEL = FNDB.LOOKUP_CODE
AND FNDB.LOOKUP_TYPE='OKR_ACCESS_LEVEL_LIST'