VIEW: APPS.CN_COLUMN_MAPS_V

Source

View Text - Preformatted

SELECT cm.rowid, cm.column_map_id, cm.table_map_id, cm.destination_column_id, cm.calc_ext_table_id, cm.expression, cm.editable, cm.modified, cm.update_clause, cm.last_update_date, cm.last_updated_by, cm.last_update_login, cm.creation_date, cm.created_by, destcol.name, destcol.column_type, desttab.object_id, desttab.name, DECODE(template.destination_column_id,NULL,'N','Y'), seed.column_map_id, seed.expression, seed.calc_ext_table_id, seed.update_clause, seed.group_by_flag, seed.unique_flag, cm.object_version_number, cm.org_id ORG_ID FROM cn_column_maps cm, cn_objects destcol, cn_objects desttab, cn_column_maps template, cn_column_maps_all seed WHERE cm.destination_column_id = destcol.object_id AND desttab.object_id = destcol.table_id AND template.destination_column_id(+) = cm.destination_column_id AND template.table_map_id(+) = -999 AND seed.destination_column_id = destcol.object_id AND seed.table_map_id = cm.table_map_id AND seed.org_id = -3113 AND cm.org_id = destcol.org_id AND destcol.org_id = desttab.org_id AND template.org_id(+) = cm.org_id UNION ALL SELECT cm.rowid, cm.column_map_id, cm.table_map_id, cm.destination_column_id, cm.calc_ext_table_id, cm.expression, cm.editable, cm.modified, cm.update_clause, cm.last_update_date, cm.last_updated_by, cm.last_update_login, cm.creation_date, cm.created_by, destcol.name, destcol.column_type, desttab.object_id, desttab.name, DECODE(template.destination_column_id,NULL,'N','Y'), TO_NUMBER(NULL), NULL, TO_NUMBER(NULL), NULL, cm.group_by_flag, cm.unique_flag, cm.object_version_number, cm.org_id ORG_ID FROM cn_column_maps cm, cn_objects destcol, cn_objects desttab, cn_column_maps template WHERE cm.destination_column_id = destcol.object_id AND desttab.object_id = destcol.table_id AND template.destination_column_id(+) = cm.destination_column_id AND template.table_map_id(+) = -999 AND cm.org_id = destcol.org_id AND destcol.org_id = desttab.org_id AND template.org_id(+) = cm.org_id AND NOT EXISTS (SELECT 1 FROM cn_column_maps_all seed WHERE seed.destination_column_id = destcol.object_id AND seed.table_map_id = cm.table_map_id AND seed.org_id = -3113)

View Text - HTML Formatted

SELECT CM.ROWID
, CM.COLUMN_MAP_ID
, CM.TABLE_MAP_ID
, CM.DESTINATION_COLUMN_ID
, CM.CALC_EXT_TABLE_ID
, CM.EXPRESSION
, CM.EDITABLE
, CM.MODIFIED
, CM.UPDATE_CLAUSE
, CM.LAST_UPDATE_DATE
, CM.LAST_UPDATED_BY
, CM.LAST_UPDATE_LOGIN
, CM.CREATION_DATE
, CM.CREATED_BY
, DESTCOL.NAME
, DESTCOL.COLUMN_TYPE
, DESTTAB.OBJECT_ID
, DESTTAB.NAME
, DECODE(TEMPLATE.DESTINATION_COLUMN_ID
, NULL
, 'N'
, 'Y')
, SEED.COLUMN_MAP_ID
, SEED.EXPRESSION
, SEED.CALC_EXT_TABLE_ID
, SEED.UPDATE_CLAUSE
, SEED.GROUP_BY_FLAG
, SEED.UNIQUE_FLAG
, CM.OBJECT_VERSION_NUMBER
, CM.ORG_ID ORG_ID
FROM CN_COLUMN_MAPS CM
, CN_OBJECTS DESTCOL
, CN_OBJECTS DESTTAB
, CN_COLUMN_MAPS TEMPLATE
, CN_COLUMN_MAPS_ALL SEED
WHERE CM.DESTINATION_COLUMN_ID = DESTCOL.OBJECT_ID
AND DESTTAB.OBJECT_ID = DESTCOL.TABLE_ID
AND TEMPLATE.DESTINATION_COLUMN_ID(+) = CM.DESTINATION_COLUMN_ID
AND TEMPLATE.TABLE_MAP_ID(+) = -999
AND SEED.DESTINATION_COLUMN_ID = DESTCOL.OBJECT_ID
AND SEED.TABLE_MAP_ID = CM.TABLE_MAP_ID
AND SEED.ORG_ID = -3113
AND CM.ORG_ID = DESTCOL.ORG_ID
AND DESTCOL.ORG_ID = DESTTAB.ORG_ID
AND TEMPLATE.ORG_ID(+) = CM.ORG_ID UNION ALL SELECT CM.ROWID
, CM.COLUMN_MAP_ID
, CM.TABLE_MAP_ID
, CM.DESTINATION_COLUMN_ID
, CM.CALC_EXT_TABLE_ID
, CM.EXPRESSION
, CM.EDITABLE
, CM.MODIFIED
, CM.UPDATE_CLAUSE
, CM.LAST_UPDATE_DATE
, CM.LAST_UPDATED_BY
, CM.LAST_UPDATE_LOGIN
, CM.CREATION_DATE
, CM.CREATED_BY
, DESTCOL.NAME
, DESTCOL.COLUMN_TYPE
, DESTTAB.OBJECT_ID
, DESTTAB.NAME
, DECODE(TEMPLATE.DESTINATION_COLUMN_ID
, NULL
, 'N'
, 'Y')
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, CM.GROUP_BY_FLAG
, CM.UNIQUE_FLAG
, CM.OBJECT_VERSION_NUMBER
, CM.ORG_ID ORG_ID
FROM CN_COLUMN_MAPS CM
, CN_OBJECTS DESTCOL
, CN_OBJECTS DESTTAB
, CN_COLUMN_MAPS TEMPLATE
WHERE CM.DESTINATION_COLUMN_ID = DESTCOL.OBJECT_ID
AND DESTTAB.OBJECT_ID = DESTCOL.TABLE_ID
AND TEMPLATE.DESTINATION_COLUMN_ID(+) = CM.DESTINATION_COLUMN_ID
AND TEMPLATE.TABLE_MAP_ID(+) = -999
AND CM.ORG_ID = DESTCOL.ORG_ID
AND DESTCOL.ORG_ID = DESTTAB.ORG_ID
AND TEMPLATE.ORG_ID(+) = CM.ORG_ID
AND NOT EXISTS (SELECT 1
FROM CN_COLUMN_MAPS_ALL SEED
WHERE SEED.DESTINATION_COLUMN_ID = DESTCOL.OBJECT_ID
AND SEED.TABLE_MAP_ID = CM.TABLE_MAP_ID
AND SEED.ORG_ID = -3113)