Product: | OKX - Contracts Integration |
---|---|
Description: | Information about role and resource associations |
Implementation/DBA Data: | APPS.OKX_RESOURCE_ROLES_V |
SELECT RR.ROLE_RELATE_ID ID1
, '#' ID2
, RR.ROLE_RESOURCE_ID RESOURCE_ID
, RR.ROLE_RESOURCE_TYPE RESOURCE_TYPE
, RR.ROLE_RELATE_ID ROLE_RELATE_ID
, RR.ROLE_ID ROLE_ID
, T.ROLE_NAME NAME
, T.ROLE_DESC DESCRIPTION
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(RR.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(RR.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, RR.START_DATE_ACTIVE START_DATE_ACTIVE
, RR.END_DATE_ACTIVE END_DATE_ACTIVE
, B.ROLE_TYPE_CODE ROLE_TYPE_CODE
, B.ROLE_CODE ROLE_CODE
, RR.DELETE_FLAG DELETE_FLAG
, B.SEEDED_FLAG SEEDED_FLAG
, B.MEMBER_FLAG MEMBER_FLAG
, B.ADMIN_FLAG ADMIN_FLAG
, B.LEAD_FLAG LEAD_FLAG
, B.MANAGER_FLAG MANAGER_FLAG
FROM JTF_RS_ROLE_RELATIONS RR
, JTF_RS_ROLES_B B
, JTF_RS_ROLES_TL T
WHERE B.ROLE_ID = RR.ROLE_ID
AND B.ROLE_ID = T.ROLE_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.ROLE_TYPE_CODE = 'CONTRACTS'