VIEW: APPS.CN_COLLECTIONS_V

Source

View Text - Preformatted

SELECT cm.module_id, cm.repository_id, crr.set_of_books_id, cm.source_repository_id, cm.event_id, cm.module_type, crr.version, crr.schema, cm.collect_flag, crr.application_type, crr.description FROM cn_modules_vl cm, cn_repositories crr WHERE cm.repository_id = crr.repository_id AND cm.parent_module_id = (SELECT module_id FROM cn_modules WHERE module_type = 'COL')

View Text - HTML Formatted

SELECT CM.MODULE_ID
, CM.REPOSITORY_ID
, CRR.SET_OF_BOOKS_ID
, CM.SOURCE_REPOSITORY_ID
, CM.EVENT_ID
, CM.MODULE_TYPE
, CRR.VERSION
, CRR.SCHEMA
, CM.COLLECT_FLAG
, CRR.APPLICATION_TYPE
, CRR.DESCRIPTION
FROM CN_MODULES_VL CM
, CN_REPOSITORIES CRR
WHERE CM.REPOSITORY_ID = CRR.REPOSITORY_ID
AND CM.PARENT_MODULE_ID = (SELECT MODULE_ID
FROM CN_MODULES
WHERE MODULE_TYPE = 'COL')