[Home] [Help] [Dependency Information]
Object Name: | CN_REPOSITORIES_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_REPOSITORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ORG_ID |
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 |
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;
CN.CN_REPOSITORIES_ALL does not reference any database object
CN.CN_REPOSITORIES_ALL is referenced by following:
|
|
|