VIEW: APPS.OKX_RESOURCE_ROLES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'