DBA Data[Home] [Help]

VIEW: APPS.CSF_M_OBJECT_MAPPINGS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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