VIEW: CN.CN_REPOSITORIES_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, REPOSITORY_ID REPOSITORY_ID, VERSION VERSION, SCHEMA SCHEMA, STATUS STATUS, APPLICATION_TYPE APPLICATION_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DESCRIPTION DESCRIPTION, DATABASE_LINK DATABASE_LINK, USAGE_FLAG USAGE_FLAG, EMAIL_OWNER EMAIL_OWNER, EMAIL_DBA EMAIL_DBA, CURRENT_PERIOD_ID CURRENT_PERIOD_ID, SYSTEM_START_DATE SYSTEM_START_DATE, SYSTEM_START_PERIOD_ID SYSTEM_START_PERIOD_ID, SYSTEM_END_DATE SYSTEM_END_DATE, SYSTEM_END_PERIOD_ID SYSTEM_END_PERIOD_ID, REV_CLASS_HIERARCHY_ID REV_CLASS_HIERARCHY_ID, SRP_ROLLUP_HIERARCHY_ID SRP_ROLLUP_HIERARCHY_ID, SYSTEM_BATCH_SIZE SYSTEM_BATCH_SIZE, TRANSFER_BATCH_SIZE TRANSFER_BATCH_SIZE, SRP_ROLLUP_FLAG SRP_ROLLUP_FLAG, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CURRENT_PERIOD CURRENT_PERIOD, SYSTEM_START_PERIOD SYSTEM_START_PERIOD, SYSTEM_END_PERIOD SYSTEM_END_PERIOD, CLAWBACK_GRACE_DAYS CLAWBACK_GRACE_DAYS, TRX_ROLLUP_METHOD TRX_ROLLUP_METHOD, SRP_BATCH_SIZE SRP_BATCH_SIZE, SALESREP_BATCH_SIZE SALESREP_BATCH_SIZE, CLS_PACKAGE_SIZE CLS_PACKAGE_SIZE, NAME NAME, APPLICATION_ID APPLICATION_ID, REPOSITORY_TYPE REPOSITORY_TYPE, LATEST_PROCESSED_DATE LATEST_PROCESSED_DATE, PERIOD_SET_ID PERIOD_SET_ID, PERIOD_TYPE_ID PERIOD_TYPE_ID, PAYABLES_FLAG PAYABLES_FLAG, PAYROLL_FLAG PAYROLL_FLAG, PAYABLES_CCID_LEVEL PAYABLES_CCID_LEVEL, INCOME_PLANNER_DISCLAIMER INCOME_PLANNER_DISCLAIMER, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, SCA_MAPPING_STATUS SCA_MAPPING_STATUS, CN_ROLL_SUM_TRX CN_ROLL_SUM_TRX, CN_CUSTOM_AGGR_TRX CN_CUSTOM_AGGR_TRX, CN_PRIOR_ADJUSTMENT CN_PRIOR_ADJUSTMENT, CN_COMM_RATE_PRECISION CN_COMM_RATE_PRECISION, CN_CONVERSION_TYPE CN_CONVERSION_TYPE, CN_CUSTOM_FLAG CN_CUSTOM_FLAG, CN_COLLECT_ON_ACCT_CREDITS CN_COLLECT_ON_ACCT_CREDITS, CN_RAM_NEGATE CN_RAM_NEGATE, CN_REPORTING_HIERARCHY CN_REPORTING_HIERARCHY, CN_NON_REVENUE_SPLIT CN_NON_REVENUE_SPLIT, CN_RESET_ERROR_TRX CN_RESET_ERROR_TRX, CN_CUST_DISCLAIMER CN_CUST_DISCLAIMER, CN_DISPLAY_DRAW CN_DISPLAY_DRAW, CN_COMM_REPORT_TEMPLATE CN_COMM_REPORT_TEMPLATE, CN_YTD_REPORT_TEMPLATE CN_YTD_REPORT_TEMPLATE, CN_EARNING_REPORT_TEMPLATE CN_EARNING_REPORT_TEMPLATE, CN_ATTA_REPORT_TEMPLATE CN_ATTA_REPORT_TEMPLATE, CN_PROF_REPORT_TEMPLATE CN_PROF_REPORT_TEMPLATE, CN_COMPPLAN_REPORT_TEMPLATE CN_COMPPLAN_REPORT_TEMPLATE, ZD_EDITION_NAME ZD_EDITION_NAME from "CN"."CN_REPOSITORIES_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, REPOSITORY_ID REPOSITORY_ID
, VERSION VERSION
, SCHEMA SCHEMA
, STATUS STATUS
, APPLICATION_TYPE APPLICATION_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, DATABASE_LINK DATABASE_LINK
, USAGE_FLAG USAGE_FLAG
, EMAIL_OWNER EMAIL_OWNER
, EMAIL_DBA EMAIL_DBA
, CURRENT_PERIOD_ID CURRENT_PERIOD_ID
, SYSTEM_START_DATE SYSTEM_START_DATE
, SYSTEM_START_PERIOD_ID SYSTEM_START_PERIOD_ID
, SYSTEM_END_DATE SYSTEM_END_DATE
, SYSTEM_END_PERIOD_ID SYSTEM_END_PERIOD_ID
, REV_CLASS_HIERARCHY_ID REV_CLASS_HIERARCHY_ID
, SRP_ROLLUP_HIERARCHY_ID SRP_ROLLUP_HIERARCHY_ID
, SYSTEM_BATCH_SIZE SYSTEM_BATCH_SIZE
, TRANSFER_BATCH_SIZE TRANSFER_BATCH_SIZE
, SRP_ROLLUP_FLAG SRP_ROLLUP_FLAG
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CURRENT_PERIOD CURRENT_PERIOD
, SYSTEM_START_PERIOD SYSTEM_START_PERIOD
, SYSTEM_END_PERIOD SYSTEM_END_PERIOD
, CLAWBACK_GRACE_DAYS CLAWBACK_GRACE_DAYS
, TRX_ROLLUP_METHOD TRX_ROLLUP_METHOD
, SRP_BATCH_SIZE SRP_BATCH_SIZE
, SALESREP_BATCH_SIZE SALESREP_BATCH_SIZE
, CLS_PACKAGE_SIZE CLS_PACKAGE_SIZE
, NAME NAME
, APPLICATION_ID APPLICATION_ID
, REPOSITORY_TYPE REPOSITORY_TYPE
, LATEST_PROCESSED_DATE LATEST_PROCESSED_DATE
, PERIOD_SET_ID PERIOD_SET_ID
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, PAYABLES_FLAG PAYABLES_FLAG
, PAYROLL_FLAG PAYROLL_FLAG
, PAYABLES_CCID_LEVEL PAYABLES_CCID_LEVEL
, INCOME_PLANNER_DISCLAIMER INCOME_PLANNER_DISCLAIMER
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, SCA_MAPPING_STATUS SCA_MAPPING_STATUS
, CN_ROLL_SUM_TRX CN_ROLL_SUM_TRX
, CN_CUSTOM_AGGR_TRX CN_CUSTOM_AGGR_TRX
, CN_PRIOR_ADJUSTMENT CN_PRIOR_ADJUSTMENT
, CN_COMM_RATE_PRECISION CN_COMM_RATE_PRECISION
, CN_CONVERSION_TYPE CN_CONVERSION_TYPE
, CN_CUSTOM_FLAG CN_CUSTOM_FLAG
, CN_COLLECT_ON_ACCT_CREDITS CN_COLLECT_ON_ACCT_CREDITS
, CN_RAM_NEGATE CN_RAM_NEGATE
, CN_REPORTING_HIERARCHY CN_REPORTING_HIERARCHY
, CN_NON_REVENUE_SPLIT CN_NON_REVENUE_SPLIT
, CN_RESET_ERROR_TRX CN_RESET_ERROR_TRX
, CN_CUST_DISCLAIMER CN_CUST_DISCLAIMER
, CN_DISPLAY_DRAW CN_DISPLAY_DRAW
, CN_COMM_REPORT_TEMPLATE CN_COMM_REPORT_TEMPLATE
, CN_YTD_REPORT_TEMPLATE CN_YTD_REPORT_TEMPLATE
, CN_EARNING_REPORT_TEMPLATE CN_EARNING_REPORT_TEMPLATE
, CN_ATTA_REPORT_TEMPLATE CN_ATTA_REPORT_TEMPLATE
, CN_PROF_REPORT_TEMPLATE CN_PROF_REPORT_TEMPLATE
, CN_COMPPLAN_REPORT_TEMPLATE CN_COMPPLAN_REPORT_TEMPLATE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CN"."CN_REPOSITORIES_ALL"