SELECT csom_acc.access_id, jom.mapping_id, jom.source_object_code, jom.object_id, jom.OBJECT_code, jom.application_id, jom.end_date from jtf_object_mappings jom, csm_object_mappings_acc csom_acc WHERE jom.mapping_id = csom_acc.mapping_id
SELECT CSOM_ACC.ACCESS_ID
, JOM.MAPPING_ID
, JOM.SOURCE_OBJECT_CODE
, JOM.OBJECT_ID
, JOM.OBJECT_CODE
, JOM.APPLICATION_ID
, JOM.END_DATE
FROM JTF_OBJECT_MAPPINGS JOM
, CSM_OBJECT_MAPPINGS_ACC CSOM_ACC
WHERE JOM.MAPPING_ID = CSOM_ACC.MAPPING_ID
|
|
|