[Home] [Help] [Dependency Information]
Object Name: | CN_REPOSITORIES_ALL# |
---|---|
Object Type: | VIEW |
Owner: | CN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|