SELECT ACC.ACCESS_ID , B.MAPPING_ID , B.APPLICATION_ID , B.SOURCE_OBJECT_CODE , B.OBJECT_CODE , B.OBJECT_ID , B.END_DATE , B.OBJECT_VERSION_NUMBER FROM JTF_OBJECT_MAPPINGS B , JTM_JTF_OBJECT_MAPPINGS_ACC ACC WHERE B.MAPPING_ID = ACC.MAPPING_ID
SELECT ACC.ACCESS_ID
, B.MAPPING_ID
, B.APPLICATION_ID
, B.SOURCE_OBJECT_CODE
, B.OBJECT_CODE
, B.OBJECT_ID
, B.END_DATE
, B.OBJECT_VERSION_NUMBER
FROM JTF_OBJECT_MAPPINGS B
, JTM_JTF_OBJECT_MAPPINGS_ACC ACC
WHERE B.MAPPING_ID = ACC.MAPPING_ID
|
|
|