VIEW: APPS.CN_TABLE_MAPS_V

Source

View Text - Preformatted

SELECT tm.table_map_id ,tm.org_id , tm.mapping_type , tm.module_id , tm.destination_table_id , tm.source_tbl_hdr_fkcol_id , tm.source_tbl_pkcol_id , tm.source_hdr_tbl_pkcol_id , tm.notify_where , tm.collect_where , tm.delete_flag , tm.last_update_date , tm.last_updated_by , tm.last_update_login , tm.creation_date , tm.created_by ,linetab.object_id ,hdrtab.object_id , linetab.name , linetab.alias , hdrtab.name , hdrtab.alias , linefk.name , linepk.name , hdrpk.name , desttab.name , desttab.alias , module.module_status , event.event_id , event.name , tm.object_version_number FROM cn_table_maps tm, cn_objects linetab, cn_objects linefk, cn_objects linepk, cn_objects hdrpk, cn_objects hdrtab, cn_objects desttab, cn_modules module, cn_events event WHERE desttab.object_id = tm.destination_table_id AND module.module_id = tm.module_id AND event.event_id = module.event_id AND linepk.object_id = tm.source_tbl_pkcol_id AND linetab.object_id = linepk.table_id AND linefk.object_id(+) = tm.source_tbl_hdr_fkcol_id AND hdrpk.object_id(+) = tm.source_hdr_tbl_pkcol_id AND hdrtab.object_id(+) = hdrpk.table_id AND linetab.org_id = tm.org_id AND linefk.org_id(+) = tm.org_id AND linepk.org_id = linetab.org_id AND hdrpk.org_id(+) = tm.org_id AND hdrtab.org_id(+) = hdrpk.org_id AND desttab.org_id = linepk.org_id AND module.org_id = desttab.org_id AND event.org_id = module.org_id

View Text - HTML Formatted

SELECT TM.TABLE_MAP_ID
, TM.ORG_ID
, TM.MAPPING_TYPE
, TM.MODULE_ID
, TM.DESTINATION_TABLE_ID
, TM.SOURCE_TBL_HDR_FKCOL_ID
, TM.SOURCE_TBL_PKCOL_ID
, TM.SOURCE_HDR_TBL_PKCOL_ID
, TM.NOTIFY_WHERE
, TM.COLLECT_WHERE
, TM.DELETE_FLAG
, TM.LAST_UPDATE_DATE
, TM.LAST_UPDATED_BY
, TM.LAST_UPDATE_LOGIN
, TM.CREATION_DATE
, TM.CREATED_BY
, LINETAB.OBJECT_ID
, HDRTAB.OBJECT_ID
, LINETAB.NAME
, LINETAB.ALIAS
, HDRTAB.NAME
, HDRTAB.ALIAS
, LINEFK.NAME
, LINEPK.NAME
, HDRPK.NAME
, DESTTAB.NAME
, DESTTAB.ALIAS
, MODULE.MODULE_STATUS
, EVENT.EVENT_ID
, EVENT.NAME
, TM.OBJECT_VERSION_NUMBER
FROM CN_TABLE_MAPS TM
, CN_OBJECTS LINETAB
, CN_OBJECTS LINEFK
, CN_OBJECTS LINEPK
, CN_OBJECTS HDRPK
, CN_OBJECTS HDRTAB
, CN_OBJECTS DESTTAB
, CN_MODULES MODULE
, CN_EVENTS EVENT
WHERE DESTTAB.OBJECT_ID = TM.DESTINATION_TABLE_ID
AND MODULE.MODULE_ID = TM.MODULE_ID
AND EVENT.EVENT_ID = MODULE.EVENT_ID
AND LINEPK.OBJECT_ID = TM.SOURCE_TBL_PKCOL_ID
AND LINETAB.OBJECT_ID = LINEPK.TABLE_ID
AND LINEFK.OBJECT_ID(+) = TM.SOURCE_TBL_HDR_FKCOL_ID
AND HDRPK.OBJECT_ID(+) = TM.SOURCE_HDR_TBL_PKCOL_ID
AND HDRTAB.OBJECT_ID(+) = HDRPK.TABLE_ID
AND LINETAB.ORG_ID = TM.ORG_ID
AND LINEFK.ORG_ID(+) = TM.ORG_ID
AND LINEPK.ORG_ID = LINETAB.ORG_ID
AND HDRPK.ORG_ID(+) = TM.ORG_ID
AND HDRTAB.ORG_ID(+) = HDRPK.ORG_ID
AND DESTTAB.ORG_ID = LINEPK.ORG_ID
AND MODULE.ORG_ID = DESTTAB.ORG_ID
AND EVENT.ORG_ID = MODULE.ORG_ID