SELECT ACC.ACCESS_ID , B.RESOURCE_ID , B.RESOURCE_NUMBER , B.SOURCE_ID , B.USER_ID , B.USER_NAME , B.SOURCE_NAME , B.SOURCE_FIRST_NAME , B.SOURCE_MIDDLE_NAME , B.SOURCE_LAST_NAME , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE FROM JTF_RS_RESOURCE_EXTNS B , CSM_JTF_RESOURCE_EXTNS_ACC ACC WHERE B.RESOURCE_ID = ACC.RESOURCE_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID
SELECT ACC.ACCESS_ID
, B.RESOURCE_ID
, B.RESOURCE_NUMBER
, B.SOURCE_ID
, B.USER_ID
, B.USER_NAME
, B.SOURCE_NAME
, B.SOURCE_FIRST_NAME
, B.SOURCE_MIDDLE_NAME
, B.SOURCE_LAST_NAME
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
FROM JTF_RS_RESOURCE_EXTNS B
, CSM_JTF_RESOURCE_EXTNS_ACC ACC
WHERE B.RESOURCE_ID = ACC.RESOURCE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
|
|
|