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

TABLE: CN.CN_REPOSITORIES_ALL

Object Details
Object Name: CN_REPOSITORIES_ALL
Object Type: TABLE
Owner: CN
FND Design Data: TableCN.CN_REPOSITORIES_ALL
Subobject Name:
Status: VALID


CN_REPOSITORIES stores default, control, and option information you
provide to customize Oracle Sales Comepnsation to your company's
needs. CN_REPOSITORIES corresponds to the System Parameters form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CN_REPOSITORIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Organization identifier
REPOSITORY_ID NUMBER (15) Yes Primary key
VERSION VARCHAR2 (30) Yes Version of the application
SCHEMA VARCHAR2 (30)
Schema in which repository lives
STATUS VARCHAR2 (1) Yes System status
APPLICATION_TYPE VARCHAR2 (10)
Not currently used
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DESCRIPTION VARCHAR2 (1900)
Not currently used
DATABASE_LINK VARCHAR2 (128)
For non local databases, the database link to connect
USAGE_FLAG VARCHAR2 (1)
Not currently used
EMAIL_OWNER VARCHAR2 (30)
Not currently used
EMAIL_DBA VARCHAR2 (30)
Not currently used
CURRENT_PERIOD_ID NUMBER (15)
Not currently used
SYSTEM_START_DATE DATE

Not currently used
SYSTEM_START_PERIOD_ID NUMBER (15)
Not currently used
SYSTEM_END_DATE DATE

Not currently used
SYSTEM_END_PERIOD_ID NUMBER (15)
Not currently used
REV_CLASS_HIERARCHY_ID NUMBER (15)
Revenue class hierarchy unique identifier
SRP_ROLLUP_HIERARCHY_ID NUMBER (15)
Salesperson hierarchy unique identifier
SYSTEM_BATCH_SIZE NUMBER (15)
Number of transactions processed between commits during collection and calculation.
TRANSFER_BATCH_SIZE NUMBER (15)
For distributed systems the number of records to transfer across a database link between commits
SRP_ROLLUP_FLAG VARCHAR2 (1)
Flag to indicate whether transactions should rollup the management hierarchy during calculation
SET_OF_BOOKS_ID NUMBER (15)
Set of books unique identifier
CURRENT_PERIOD VARCHAR2 (30)
Not currently used
SYSTEM_START_PERIOD VARCHAR2 (30)
Not currently used
SYSTEM_END_PERIOD VARCHAR2 (30)
Not currently used
CLAWBACK_GRACE_DAYS NUMBER (5)
Number of days before clawback is made
TRX_ROLLUP_METHOD VARCHAR2 (30)
Transaction rollup method.
SRP_BATCH_SIZE NUMBER (15)
Salesrep processing batch size.
SALESREP_BATCH_SIZE NUMBER (15)
Number of rules in a package
CLS_PACKAGE_SIZE NUMBER (15)
Number of rules in a package
NAME VARCHAR2 (30)
User defined name for the instance of Sales Compensation
APPLICATION_ID NUMBER (15) Yes Application unique identifier
REPOSITORY_TYPE VARCHAR2 (15) Yes Not currently used.
LATEST_PROCESSED_DATE DATE

Latest Processed Date
PERIOD_SET_ID NUMBER (15)
Period set id
PERIOD_TYPE_ID NUMBER (15)
Period type id.
PAYABLES_FLAG VARCHAR2 (1)
Flag to indicate if oracle payables integration is enabled
PAYROLL_FLAG VARCHAR2 (1)
Flag to indicate if oracle payroll integration is enabled.
PAYABLES_CCID_LEVEL VARCHAR2 (30)
Flag to indicate the source of gl account mapping in OIC
INCOME_PLANNER_DISCLAIMER VARCHAR2 (2000)
Free Format Text for Customized Income Planner Disclaimer
OBJECT_VERSION_NUMBER NUMBER
Yes This column is used for locking purposes
SECURITY_GROUP_ID NUMBER

Used in hosted environments
SCA_MAPPING_STATUS VARCHAR2 (20) Yes Interface mapping status for Sales Credit Allocation
CN_ROLL_SUM_TRX VARCHAR2 (20)
cn_roll_sum_trx
CN_CUSTOM_AGGR_TRX VARCHAR2 (20)
cn_custom_aggr_trx
CN_PRIOR_ADJUSTMENT VARCHAR2 (20)
Prior Adjustments
CN_COMM_RATE_PRECISION NUMBER

Commission Rate Preference
CN_CONVERSION_TYPE VARCHAR2 (240)
Conversion Type
CN_CUSTOM_FLAG VARCHAR2 (240)
Custom Flag
CN_COLLECT_ON_ACCT_CREDITS VARCHAR2 (240)
cn_collect_on_acct_credits
CN_RAM_NEGATE VARCHAR2 (240)
cn_ram_negate
CN_REPORTING_HIERARCHY VARCHAR2 (240)
CN_REPORTING_HIERARCHY
CN_NON_REVENUE_SPLIT VARCHAR2 (240)
CN_NON_REVENUE_SPLIT
CN_RESET_ERROR_TRX VARCHAR2 (240)
CN_RESET_ERROR_TRX
CN_CUST_DISCLAIMER VARCHAR2 (240)
CN_CUST_DISCLAIMER
CN_DISPLAY_DRAW VARCHAR2 (240)
CN_DISPLAY_DRAW
CN_COMM_REPORT_TEMPLATE VARCHAR2 (240)
CN_COMM_REPORT_TEMPLATE
CN_YTD_REPORT_TEMPLATE VARCHAR2 (240)
CN_YTD_REPORT_TEMPLATE
CN_EARNING_REPORT_TEMPLATE VARCHAR2 (240)
CN_EARNING_REPORT_TEMPLATE
CN_ATTA_REPORT_TEMPLATE VARCHAR2 (240)
CN_ATTA_REPORT_TEMPLATE
CN_PROF_REPORT_TEMPLATE VARCHAR2 (240)
CN_PROF_REPORT_TEMPLATE
CN_COMPPLAN_REPORT_TEMPLATE VARCHAR2 (240)
CN_COMPPLAN_REPORT_TEMPLATE
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
FROM CN.CN_REPOSITORIES_ALL;

Dependencies

[top of page]

CN.CN_REPOSITORIES_ALL does not reference any database object

CN.CN_REPOSITORIES_ALL is referenced by following:

SchemaAPPS
SynonymCN_REPOSITORIES
SynonymCN_REPOSITORIES_ALL
TriggerCN_REPOSITORIES_T1