eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: CN.CN_REPOSITORIES_ALL#

Object Details

Object Name:	CN_REPOSITORIES_ALL#
Object Type:	VIEW
Owner:	CN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORG_ID	NUMBER	(15)	Yes
REPOSITORY_ID	NUMBER	(15)	Yes
VERSION	VARCHAR2	(30)	Yes
SCHEMA	VARCHAR2	(30)
STATUS	VARCHAR2	(1)	Yes
APPLICATION_TYPE	VARCHAR2	(10)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
DESCRIPTION	VARCHAR2	(1900)
DATABASE_LINK	VARCHAR2	(128)
USAGE_FLAG	VARCHAR2	(1)
EMAIL_OWNER	VARCHAR2	(30)
EMAIL_DBA	VARCHAR2	(30)
CURRENT_PERIOD_ID	NUMBER	(15)
SYSTEM_START_DATE	DATE
SYSTEM_START_PERIOD_ID	NUMBER	(15)
SYSTEM_END_DATE	DATE
SYSTEM_END_PERIOD_ID	NUMBER	(15)
REV_CLASS_HIERARCHY_ID	NUMBER	(15)
SRP_ROLLUP_HIERARCHY_ID	NUMBER	(15)
SYSTEM_BATCH_SIZE	NUMBER	(15)
TRANSFER_BATCH_SIZE	NUMBER	(15)
SRP_ROLLUP_FLAG	VARCHAR2	(1)
SET_OF_BOOKS_ID	NUMBER	(15)
CURRENT_PERIOD	VARCHAR2	(30)
SYSTEM_START_PERIOD	VARCHAR2	(30)
SYSTEM_END_PERIOD	VARCHAR2	(30)
CLAWBACK_GRACE_DAYS	NUMBER	(5)
TRX_ROLLUP_METHOD	VARCHAR2	(30)
SRP_BATCH_SIZE	NUMBER	(15)
SALESREP_BATCH_SIZE	NUMBER	(15)
CLS_PACKAGE_SIZE	NUMBER	(15)
NAME	VARCHAR2	(30)
APPLICATION_ID	NUMBER	(15)	Yes
REPOSITORY_TYPE	VARCHAR2	(15)	Yes
LATEST_PROCESSED_DATE	DATE
PERIOD_SET_ID	NUMBER	(15)
PERIOD_TYPE_ID	NUMBER	(15)
PAYABLES_FLAG	VARCHAR2	(1)
PAYROLL_FLAG	VARCHAR2	(1)
PAYABLES_CCID_LEVEL	VARCHAR2	(30)
INCOME_PLANNER_DISCLAIMER	VARCHAR2	(2000)
OBJECT_VERSION_NUMBER	NUMBER		Yes
SECURITY_GROUP_ID	NUMBER
SCA_MAPPING_STATUS	VARCHAR2	(20)	Yes
CN_ROLL_SUM_TRX	VARCHAR2	(20)
CN_CUSTOM_AGGR_TRX	VARCHAR2	(20)
CN_PRIOR_ADJUSTMENT	VARCHAR2	(20)
CN_COMM_RATE_PRECISION	NUMBER
CN_CONVERSION_TYPE	VARCHAR2	(240)
CN_CUSTOM_FLAG	VARCHAR2	(240)
CN_COLLECT_ON_ACCT_CREDITS	VARCHAR2	(240)
CN_RAM_NEGATE	VARCHAR2	(240)
CN_REPORTING_HIERARCHY	VARCHAR2	(240)
CN_NON_REVENUE_SPLIT	VARCHAR2	(240)
CN_RESET_ERROR_TRX	VARCHAR2	(240)
CN_CUST_DISCLAIMER	VARCHAR2	(240)
CN_DISPLAY_DRAW	VARCHAR2	(240)
CN_COMM_REPORT_TEMPLATE	VARCHAR2	(240)
CN_YTD_REPORT_TEMPLATE	VARCHAR2	(240)
CN_EARNING_REPORT_TEMPLATE	VARCHAR2	(240)
CN_ATTA_REPORT_TEMPLATE	VARCHAR2	(240)
CN_PROF_REPORT_TEMPLATE	VARCHAR2	(240)
CN_COMPPLAN_REPORT_TEMPLATE	VARCHAR2	(240)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

CN.CN_REPOSITORIES_ALL# references the following:

CN: CN_REPOSITORIES_ALL

CN.CN_REPOSITORIES_ALL# is referenced by following:

APPS: CN_REPOSITORIES; CN_REPOSITORIES_ALL; CN_REPOSITORIES_ALL+; CN_REPOSITORIES_T1