Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - CN Tables and Views

TABLE - CN.CN_ATTAIN_SCHEDULES
TABLE - CN.CN_ATTAIN_TIERS
TABLE - CN.CN_ATTRIBUTE_RULES_ALL
TABLE - CN.CN_CALC_EDGES_ALL
TABLE - CN.CN_CALC_EXT_TABLES_ALL
TABLE - CN.CN_CALC_EXT_TBL_DTLS_ALL
TABLE - CN.CN_CALC_FORMULAS_ALL
TABLE - CN.CN_CALC_SQL_EXPS_ALL
TABLE - CN.CN_CALC_SUBMISSION_BATCHES_ALL
TABLE - CN.CN_CALC_SUBMISSION_ENTRIES_ALL
TABLE - CN.CN_CALC_SUB_QUOTAS_ALL
TABLE - CN.CN_CALC_SUB_VALIDATIONS_ALL
TABLE - CN.CN_CAL_PER_INT_TYPES_ALL
TABLE - CN.CN_CLRL_API_ALL
TABLE - CN.CN_COLUMN_IND_MAPS
TABLE - CN.CN_COLUMN_MAPS_ALL
TABLE - CN.CN_COLUMN_TRG_MAPS
TABLE - CN.CN_COMMISSION_HEADERS_ALL
TABLE - CN.CN_COMMISSION_LINES_ALL
TABLE - CN.CN_COMM_LINES_API_ALL
TABLE - CN.CN_COMP_ANCHORS
TABLE - CN.CN_COMP_PLANS_ALL
TABLE - CN.CN_COPY_REQUESTS_ALL
TABLE - CN.CN_CREDIT_CONV_FCTS_ALL
TABLE - CN.CN_CREDIT_TYPES_ALL_B
TABLE - CN.CN_CREDIT_TYPES_ALL_TL
TABLE - CN.CN_CW_SETUP_TASKS_ALL_B
TABLE - CN.CN_CW_SETUP_TASKS_ALL_TL
TABLE - CN.CN_CW_WORKBENCH_ITEMS_ALL_B
TABLE - CN.CN_CW_WORKBENCH_ITEMS_ALL_TL
TABLE - CN.CN_DIMENSIONS_ALL_B
TABLE - CN.CN_DIMENSIONS_ALL_TL
TABLE - CN.CN_DIM_EXPLOSION_ALL
TABLE - CN.CN_DIM_HIERARCHIES_ALL
TABLE - CN.CN_EVENTS_ALL_B
TABLE - CN.CN_EVENTS_ALL_TL
TABLE - CN.CN_EVENT_LOG_ALL
TABLE - CN.CN_FORMULA_INPUTS_ALL
TABLE - CN.CN_HEAD_HIERARCHIES_ALL_B
TABLE - CN.CN_HEAD_HIERARCHIES_ALL_TL
TABLE - CN.CN_HIERARCHIES_API_ALL
TABLE - CN.CN_HIERARCHY_EDGES_ALL
TABLE - CN.CN_HIERARCHY_NODES_ALL
TABLE - CN.CN_IMPORT_TYPES
TABLE - CN.CN_IMP_HEADERS
TABLE - CN.CN_IMP_LINES
TABLE - CN.CN_IMP_MAPS
TABLE - CN.CN_IMP_MAP_FIELDS
TABLE - CN.CN_INTERVAL_TYPES_ALL_B
TABLE - CN.CN_INTERVAL_TYPES_ALL_TL
TABLE - CN.CN_INVOICE_CHANGES_ALL
TABLE - CN.CN_JOB_ROLES
TABLE - CN.CN_LEDGER_BAL_TYPES_ALL_B
TABLE - CN.CN_LEDGER_BAL_TYPES_ALL_TL
TABLE - CN.CN_LEDGER_JE_BATCHES_ALL
TABLE - CN.CN_LEDGER_JOURNAL_ENTRIES_ALL
TABLE - CN.CN_LINE_ROLLUP_PATHS_ALL
TABLE - CN.CN_MODEL_RESOURCES_ALL
TABLE - CN.CN_MODULES_ALL_B
TABLE - CN.CN_MODULES_ALL_TL
TABLE - CN.CN_MOD_OBJ_DEPENDS_ALL
TABLE - CN.CN_NOTIFY_LOG_ALL
TABLE - CN.CN_NOT_TRX_ALL
TABLE - CN.CN_OBJECTS_ALL
TABLE - CN.CN_PAYMENT_API_ALL
TABLE - CN.CN_PAYMENT_TRANSACTIONS_ALL
TABLE - CN.CN_PAYMENT_WORKSHEETS_ALL
TABLE - CN.CN_PAYRUNS_ALL
TABLE - CN.CN_PAY_APPROVAL_FLOW_ALL
TABLE - CN.CN_PAY_ELEMENT_INPUTS_ALL
TABLE - CN.CN_PAY_GROUPS_ALL
TABLE - CN.CN_PERF_MEASURES_ALL
TABLE - CN.CN_PERIOD_QUOTAS_ALL
TABLE - CN.CN_PERIOD_SETS_ALL
TABLE - CN.CN_PERIOD_STATUSES_ALL
TABLE - CN.CN_PERIOD_TYPES_ALL
TABLE - CN.CN_PLAN_TEXTS
TABLE - CN.CN_PMT_PLANS_ALL
TABLE - CN.CN_POSTING_BATCHES_ALL
TABLE - CN.CN_POSTING_DETAILS_ALL
TABLE - CN.CN_POSTING_DETAILS_SUM_ALL
TABLE - CN.CN_PROCESS_AUDITS_ALL
TABLE - CN.CN_PROCESS_AUDIT_LINES_ALL
TABLE - CN.CN_PROCESS_BATCHES_ALL
TABLE - CN.CN_QUARTER_BCK_ALL
TABLE - CN.CN_QUOTAS_ALL
TABLE - CN.CN_QUOTA_ASSIGNS_ALL
TABLE - CN.CN_QUOTA_CATEGORIES
TABLE - CN.CN_QUOTA_PAY_ELEMENTS_ALL
TABLE - CN.CN_QUOTA_RULES_ALL
TABLE - CN.CN_QUOTA_RULE_UPLIFTS_ALL
TABLE - CN.CN_RATE_DIMENSIONS_ALL
TABLE - CN.CN_RATE_DIM_TIERS_ALL
TABLE - CN.CN_RATE_SCHEDULES_ALL
TABLE - CN.CN_RATE_SCH_DIMS_ALL
TABLE - CN.CN_RATE_TIERS_ALL
TABLE - CN.CN_REASONS_ALL
TABLE - CN.CN_REASON_HISTORY_ALL
TABLE - CN.CN_REPORT_TEMPLATES_GTT
TABLE - CN.CN_REPOSITORIES_ALL
TABLE - CN.CN_REVENUE_CLASSES_ALL
TABLE - CN.CN_ROLE_DETAILS
TABLE - CN.CN_ROLE_MODELS_ALL
TABLE - CN.CN_ROLE_PAY_GROUPS_ALL
TABLE - CN.CN_ROLE_PLANS_ALL
TABLE - CN.CN_ROLE_PLAN_MAPS
TABLE - CN.CN_ROLE_PMT_PLANS_ALL
TABLE - CN.CN_ROLE_QUOTA_CATES
TABLE - CN.CN_ROLE_QUOTA_FORMULAS
TABLE - CN.CN_ROLE_QUOTA_RATES
TABLE - CN.CN_ROLLOVER_QUOTAS_ALL
TABLE - CN.CN_RT_FORMULA_ASGNS_ALL
TABLE - CN.CN_RT_QUOTA_ASGNS_ALL
TABLE - CN.CN_RULESETS_ALL_B
TABLE - CN.CN_RULESETS_ALL_TL
TABLE - CN.CN_RULES_ALL_B
TABLE - CN.CN_RULES_ALL_TL
TABLE - CN.CN_RULES_HIERARCHY_ALL
TABLE - CN.CN_RULE_ATTR_EXPRESSION_ALL
TABLE - CN.CN_SALESREPS_API_ALL
TABLE - CN.CN_SCA_ALLOCATIONS_ALL
TABLE - CN.CN_SCA_ALLOC_DETAILS_ALL
TABLE - CN.CN_SCA_COMBINATIONS_ALL
TABLE - CN.CN_SCA_CONDITIONS_ALL
TABLE - CN.CN_SCA_COND_DETAILS_ALL
TABLE - CN.CN_SCA_CREDIT_RULES_ALL
TABLE - CN.CN_SCA_DENORM_RULES_ALL
TABLE - CN.CN_SCA_HEADERS_INTERFACE_ALL
TABLE - CN.CN_SCA_LINES_INTERFACE_ALL
TABLE - CN.CN_SCA_LINES_OUTPUT_ALL
TABLE - CN.CN_SCA_MATCHES_ALL
TABLE - CN.CN_SCA_PROCESS_BATCHES_ALL
TABLE - CN.CN_SCA_RULE_ATTRIBUTES_ALL_B
TABLE - CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL
TABLE - CN.CN_SCA_WINNERS_ALL
TABLE - CN.CN_SCH_DIM_TIERS_ALL
TABLE - CN.CN_SEASONALITIES_ALL
TABLE - CN.CN_SEAS_SCHEDULES_ALL
TABLE - CN.CN_SECURITY_PROFILES_ALL
TABLE - CN.CN_SEC_PROF_ASSIGNS_ALL
TABLE - CN.CN_SF_REPOSITORIES_ALL
TABLE - CN.CN_SOURCE_ALL
TABLE - CN.CN_SRP_CNRT_HISTORY_ALL
TABLE - CN.CN_SRP_COMP_ANCHORS_ALL
TABLE - CN.CN_SRP_DATA_SUMM_F
TABLE - CN.CN_SRP_DENORM_DATA_ALL
TABLE - CN.CN_SRP_DENORM_DATA_BCK_ALL
TABLE - CN.CN_SRP_INTEL_PERIODS_ALL
TABLE - CN.CN_SRP_PAYEE_ASSIGNS_ALL
TABLE - CN.CN_SRP_PAYOUT_DTLS_ALL
TABLE - CN.CN_SRP_PAY_GROUPS_ALL
TABLE - CN.CN_SRP_PERIODS_ALL
TABLE - CN.CN_SRP_PERIOD_PAYEES_ALL
TABLE - CN.CN_SRP_PERIOD_QUOTAS_ALL
TABLE - CN.CN_SRP_PERIOD_QUOTAS_EXT_ALL
TABLE - CN.CN_SRP_PER_QUOTA_RC_ALL
TABLE - CN.CN_SRP_PLAN_ASSIGNS_ALL
TABLE - CN.CN_SRP_PMT_PLANS_ALL
TABLE - CN.CN_SRP_QUOTA_ASSIGNS_ALL
TABLE - CN.CN_SRP_QUOTA_CATES_ALL
TABLE - CN.CN_SRP_QUOTA_RATES_ALL
TABLE - CN.CN_SRP_QUOTA_RULES_ALL
TABLE - CN.CN_SRP_RATE_ASSIGNS_ALL
TABLE - CN.CN_SRP_ROLE_DTLS_ALL
TABLE - CN.CN_SRP_ROLE_HISTORY_ALL
TABLE - CN.CN_SRP_ROLLOVER_QUOTAS_ALL
TABLE - CN.CN_SRP_RULE_UPLIFTS_ALL
TABLE - CN.CN_SRP_TOTAL_COMPS_ALL
TABLE - CN.CN_TABLE_MAPS_ALL
TABLE - CN.CN_TABLE_MAP_OBJECTS_ALL
TABLE - CN.CN_TRX_ALL
TABLE - CN.CN_TRX_BATCHES_ALL
TABLE - CN.CN_TRX_FACTORS_ALL
TABLE - CN.CN_TRX_LINES_ALL
TABLE - CN.CN_TRX_SALES_LINES_ALL
TABLE - CN.CN_USER_ACCESSES_ALL
TABLE - CN.CN_WORKSHEET_BONUSES_ALL
TABLE - CN.CN_WORKSHEET_QG_DTLS_ALL
TABLE - CN.CN_XREF_TBL

Table: CN_ATTAIN_SCHEDULES

Description: This table will store the name of attainment schedule to be used on compensation contracts.
Primary Key: CN_ATTAIN_SCHEDULES_PK
  1. ATTAIN_SCHEDULE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_ATTAIN_TIERS.ATTAIN_SCHEDULE_ID CN_ATTAIN_SCHEDULES
CN_ROLE_DETAILS.ATTAIN_SCHEDULE_ID CN_ATTAIN_SCHEDULES
CN_ROLE_MODELS_ALL.ATTAIN_SCHEDULE_ID CN_ATTAIN_SCHEDULES

[top of page]

CN.CN_ATTAIN_SCHEDULES does not reference any database object

CN.CN_ATTAIN_SCHEDULES is referenced by following:

APPS
SYNONYM - CN_ATTAIN_SCHEDULES

[top of page]

Table: CN_ATTAIN_TIERS

Description: CN_ATTAIN_TIERS contain the % of attainment of each attainment schedule to be shown on compensation contracts.
Primary Key: CN_ATTAIN_TIERS_PK
  1. ATTAIN_TIER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ATTAIN_TIERS.ATTAIN_SCHEDULE_ID CN_ATTAIN_SCHEDULES

[top of page]

CN.CN_ATTAIN_TIERS does not reference any database object

CN.CN_ATTAIN_TIERS is referenced by following:

APPS
SYNONYM - CN_ATTAIN_TIERS

[top of page]

Table: CN_ATTRIBUTE_RULES_ALL

Description: Rule definitions used by the revenue classification generator code.
Primary Key: CN_ATTRIBUTE_RULES_PK
  1. ATTRIBUTE_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ATTRIBUTE_RULES_ALL.RULE_ID
CN_ATTRIBUTE_RULES_ALL.RULESET_ID
CN_ATTRIBUTE_RULES_ALL.ORG_ID 		CN_RULES_ALL_B
CN_ATTRIBUTE_RULES_ALL.COLUMN_ID
CN_ATTRIBUTE_RULES_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_ATTRIBUTE_RULES_ALL.SLICE_MODULE_ID
CN_ATTRIBUTE_RULES_ALL.ORG_ID 		CN_MODULES_ALL_B

[top of page]

CN.CN_ATTRIBUTE_RULES_ALL does not reference any database object

CN.CN_ATTRIBUTE_RULES_ALL is referenced by following:

APPS
SYNONYM - CN_ATTRIBUTE_RULES
SYNONYM - CN_ATTRIBUTE_RULES_ALL

[top of page]

Table: CN_CALC_EDGES_ALL

Description: Contains information about Edges between formulas/performance measures
Primary Key: CN_CALC_EDGES_PK
  1. CALC_EDGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_CALC_EDGES_ALL.PARENT_ID CN_CALC_FORMULAS_ALL
CN_CALC_EDGES_ALL.PARENT_ID CN_FORMULA_INPUTS_ALL
CN_CALC_EDGES_ALL.PARENT_ID CN_PERF_MEASURES_ALL
CN_CALC_EDGES_ALL.CHILD_ID CN_CALC_FORMULAS_ALL
CN_CALC_EDGES_ALL.CHILD_ID CN_PERF_MEASURES_ALL

[top of page]

CN.CN_CALC_EDGES_ALL does not reference any database object

CN.CN_CALC_EDGES_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_EDGES
SYNONYM - CN_CALC_EDGES_ALL

[top of page]

Table: CN_CALC_EXT_TABLES_ALL

Description: Contains information about the relationship between an external table and one of available OSC tables
Primary Key: CN_CALC_EXT_TABLES_PK
  1. CALC_EXT_TABLE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_CALC_EXT_TBL_DTLS_ALL.CALC_EXT_TABLE_ID CN_CALC_EXT_TABLES_ALL

[top of page]

CN.CN_CALC_EXT_TABLES_ALL does not reference any database object

CN.CN_CALC_EXT_TABLES_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_EXT_TABLES
SYNONYM - CN_CALC_EXT_TABLES_ALL

[top of page]

Table: CN_CALC_EXT_TBL_DTLS_ALL

Description: Contains information about the mapping between columns of an external table and columns of an OSC tables for the purpose of SQL Join.
Primary Key: CN_CALC_EXT_TBL_DTLS_PK
  1. CALC_EXT_TBL_DTL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_CALC_EXT_TBL_DTLS_ALL.CALC_EXT_TABLE_ID CN_CALC_EXT_TABLES_ALL

[top of page]

CN.CN_CALC_EXT_TBL_DTLS_ALL does not reference any database object

CN.CN_CALC_EXT_TBL_DTLS_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_EXT_TBL_DTLS
SYNONYM - CN_CALC_EXT_TBL_DTLS_ALL

[top of page]

Table: CN_CALC_FORMULAS_ALL

Description: Contains information about calculation formula. You need one row for each calculation formula defined
Primary Key: CN_CALC_FORMULAS_PK
  1. CALC_FORMULA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_CALC_FORMULAS_ALL.PERF_MEASURE_ID CN_PERF_MEASURES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_CALC_EDGES_ALL.PARENT_ID CN_CALC_FORMULAS_ALL
CN_CALC_EDGES_ALL.CHILD_ID CN_CALC_FORMULAS_ALL
CN_FORMULA_INPUTS_ALL.CALC_FORMULA_ID CN_CALC_FORMULAS_ALL
CN_QUOTAS_ALL.CALC_FORMULA_ID CN_CALC_FORMULAS_ALL
CN_ROLE_QUOTA_CATES.CALC_FORMULA_ID CN_CALC_FORMULAS_ALL
CN_RT_FORMULA_ASGNS_ALL.CALC_FORMULA_ID CN_CALC_FORMULAS_ALL

[top of page]

CN.CN_CALC_FORMULAS_ALL does not reference any database object

CN.CN_CALC_FORMULAS_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_FORMULAS
SYNONYM - CN_CALC_FORMULAS_ALL

[top of page]

Table: CN_CALC_SQL_EXPS_ALL

Description: This table contains the sql expressions used in calculation process.

[top of page]

CN.CN_CALC_SQL_EXPS_ALL does not reference any database object

CN.CN_CALC_SQL_EXPS_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_SQL_EXPS
SYNONYM - CN_CALC_SQL_EXPS_ALL

[top of page]

Table: CN_CALC_SUBMISSION_BATCHES_ALL

Description: CN_CALC_SUBMISSION_BATCHES contains information about calculation
Primary Key: CN_CALC_SUBMISSION_BATCHES_PK
  1. CALC_SUB_BATCH_ID

[top of page]

CN.CN_CALC_SUBMISSION_BATCHES_ALL does not reference any database object

CN.CN_CALC_SUBMISSION_BATCHES_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_SUBMISSION_BATCHES
SYNONYM - CN_CALC_SUBMISSION_BATCHES_ALL

[top of page]

Table: CN_CALC_SUBMISSION_ENTRIES_ALL

Description: CN_CALC_SUBMISSION_ENTRIES contains information about salesperson to
Primary Key: CN_CALC_SUBMISSION_ENTRIES_PK
  1. CALC_SUB_ENTRY_ID

[top of page]

CN.CN_CALC_SUBMISSION_ENTRIES_ALL does not reference any database object

CN.CN_CALC_SUBMISSION_ENTRIES_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_SUBMISSION_ENTRIES
SYNONYM - CN_CALC_SUBMISSION_ENTRIES_ALL

[top of page]

Table: CN_CALC_SUB_QUOTAS_ALL

Description: Contains information about plan elements to be calculated in a calculation request
Primary Key: CN_CALC_SUB_QUOTAS_PK
  1. CALC_SUB_QUOTA_ID

[top of page]

CN.CN_CALC_SUB_QUOTAS_ALL does not reference any database object

CN.CN_CALC_SUB_QUOTAS_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_SUB_QUOTAS
SYNONYM - CN_CALC_SUB_QUOTAS_ALL

[top of page]

Table: CN_CALC_SUB_VALIDATIONS_ALL

Description:

[top of page]

CN.CN_CALC_SUB_VALIDATIONS_ALL does not reference any database object

CN.CN_CALC_SUB_VALIDATIONS_ALL is referenced by following:

APPS
SYNONYM - CN_CALC_SUB_VALIDATIONS
SYNONYM - CN_CALC_SUB_VALIDATIONS_ALL

[top of page]

Table: CN_CAL_PER_INT_TYPES_ALL

Description: Accumulation Calendar Period Interval Types
Primary Key: CN_CAL_PER_INT_TYPES_PK
  1. CAL_PER_INT_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_CAL_PER_INT_TYPES_ALL.INTERVAL_TYPE_ID CN_INTERVAL_TYPES_ALL_B

[top of page]

CN.CN_CAL_PER_INT_TYPES_ALL does not reference any database object

CN.CN_CAL_PER_INT_TYPES_ALL is referenced by following:

APPS
SYNONYM - CN_CAL_PER_INT_TYPES
SYNONYM - CN_CAL_PER_INT_TYPES_ALL

[top of page]

Table: CN_CLRL_API_ALL

Description: API table to enter rulesets, rules and rule attributes to be loaded into OSC
Primary Key: CN_CLRL_API_PK
  1. CLRL_API_ID

[top of page]

CN.CN_CLRL_API_ALL does not reference any database object

CN.CN_CLRL_API_ALL is referenced by following:

APPS
SYNONYM - CN_CLRL_API
SYNONYM - CN_CLRL_API_ALL

[top of page]

Table: CN_COLUMN_IND_MAPS

Description: Not currently used.
Primary Key: CN_COLUMN_IND_MAPS_PK
  1. COLUMN_ID
  2. INDEX_ID

[top of page]

CN.CN_COLUMN_IND_MAPS does not reference any database object

CN.CN_COLUMN_IND_MAPS is referenced by following:

APPS
SYNONYM - CN_COLUMN_IND_MAPS

[top of page]

Table: CN_COLUMN_MAPS_ALL

Description: Maps source columns to destination columns for AR column mappings.
Primary Key: CN_COLUMN_MAPS_PK
  1. COLUMN_MAP_ID
  2. ORG_ID
Primary Key: CN_COLUMN_MAPS_UK1
  1. SOURCE_COLUMN_ID
  2. DESTINATION_COLUMN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_COLUMN_MAPS_ALL.TABLE_MAP_ID
CN_COLUMN_MAPS_ALL.ORG_ID 		CN_TABLE_MAPS_ALL
CN_COLUMN_MAPS_ALL.SOURCE_COLUMN_ID
CN_COLUMN_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_COLUMN_MAPS_ALL.DESTINATION_COLUMN_ID
CN_COLUMN_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_COLUMN_MAPS_ALL.DRIVING_COLUMN_ID
CN_COLUMN_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL

[top of page]

CN.CN_COLUMN_MAPS_ALL does not reference any database object

CN.CN_COLUMN_MAPS_ALL is referenced by following:

APPS
SYNONYM - CN_COLUMN_MAPS
SYNONYM - CN_COLUMN_MAPS_ALL

[top of page]

Table: CN_COLUMN_TRG_MAPS

Description: Not currently used.
Primary Key: CN_COLUMN_TRG_MAPS_PK
  1. COLUMN_ID
  2. TRIGGER_ID

[top of page]

CN.CN_COLUMN_TRG_MAPS does not reference any database object

CN.CN_COLUMN_TRG_MAPS is referenced by following:

APPS
SYNONYM - CN_COLUMN_TRG_MAPS

[top of page]

Table: CN_COMMISSION_HEADERS_ALL

Description: Stores the Direct credit transactions of a salesperson
Primary Key: CN_COMMISSION_HEADERS_ALL_PK
  1. COMMISSION_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_COMMISSION_HEADERS_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMMISSION_LINES_ALL.COMMISSION_HEADER_ID CN_COMMISSION_HEADERS_ALL
CN_POSTING_DETAILS_ALL.COMMISSION_HEADER_ID CN_COMMISSION_HEADERS_ALL

[top of page]

CN.CN_COMMISSION_HEADERS_ALL does not reference any database object

CN.CN_COMMISSION_HEADERS_ALL is referenced by following:

APPS
SYNONYM - CN_COMMISSION_HEADERS
SYNONYM - CN_COMMISSION_HEADERS_ALL

[top of page]

Table: CN_COMMISSION_LINES_ALL

Description: Stores all transactions created as part of calculation.
Primary Key: CN_COMMISSION_LINES_PK
  1. COMMISSION_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_COMMISSION_LINES_ALL.COMMISSION_HEADER_ID CN_COMMISSION_HEADERS_ALL
CN_COMMISSION_LINES_ALL.CREDITED_SALESREP_ID CN_SALESREPS_API_ALL
CN_COMMISSION_LINES_ALL.PROCESSED_PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_COMMISSION_LINES_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_COMMISSION_LINES_ALL.QUOTA_RULE_ID CN_QUOTA_RULES_ALL
CN_COMMISSION_LINES_ALL.RATE_TIER_ID CN_RATE_TIERS_ALL
CN_COMMISSION_LINES_ALL.PAYEE_LINE_ID CN_COMMISSION_LINES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMMISSION_LINES_ALL.PAYEE_LINE_ID CN_COMMISSION_LINES_ALL

[top of page]

CN.CN_COMMISSION_LINES_ALL does not reference any database object

CN.CN_COMMISSION_LINES_ALL is referenced by following:

APPS
SYNONYM - CN_COMMISSION_LINES
SYNONYM - CN_COMMISSION_LINES_ALL

[top of page]

Table: CN_COMM_LINES_API_ALL

Description: API for importing values into CN_COMMISSION_LINES
Primary Key: CN_COMM_LINES_API_PK
  1. COMM_LINES_API_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_COMM_LINES_API_ALL.SALESREP_ID CN_SALESREPS_API_ALL
CN_COMM_LINES_API_ALL.PROCESSED_PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_COMM_LINES_API_ALL.TRX_ID CN_TRX_ALL
CN_COMM_LINES_API_ALL.TRX_LINE_ID CN_TRX_LINES_ALL
CN_COMM_LINES_API_ALL.TRX_SALES_LINE_ID CN_TRX_SALES_LINES_ALL

[top of page]

CN.CN_COMM_LINES_API_ALL does not reference any database object

CN.CN_COMM_LINES_API_ALL is referenced by following:

APPS
SYNONYM - CN_COMM_LINES_API
SYNONYM - CN_COMM_LINES_API_ALL

[top of page]

Table: CN_COMP_ANCHORS

Description: CN_COMP_ANCHORS contains compensation anchors information. User need to define if certain % of quota is achieved, what is the expected commission.
Primary Key: CN_COMP_ANCHORS_PK
  1. COMP_ANCHOR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_COMP_ANCHORS.QUOTA_CATEGORY_ID CN_QUOTA_CATEGORIES
CN_COMP_ANCHORS.ROLE_QUOTA_CATE_ID CN_ROLE_QUOTA_CATES

[top of page]

CN.CN_COMP_ANCHORS does not reference any database object

CN.CN_COMP_ANCHORS is referenced by following:

APPS
SYNONYM - CN_COMP_ANCHORS

[top of page]

Table: CN_COMP_PLANS_ALL

Description: Compensation Plans
Primary Key: CN_COMP_PLANS_PK
  1. COMP_PLAN_ID
Primary Key: CN_COMP_PLANS_UK1
  1. NAME
  2. VERSION
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_QUOTA_ASSIGNS_ALL.COMP_PLAN_ID CN_COMP_PLANS_ALL
CN_ROLE_PLANS_ALL.COMP_PLAN_ID CN_COMP_PLANS_ALL
CN_SRP_PLAN_ASSIGNS_ALL.COMP_PLAN_ID CN_COMP_PLANS_ALL

[top of page]

CN.CN_COMP_PLANS_ALL does not reference any database object

CN.CN_COMP_PLANS_ALL is referenced by following:

APPS
SYNONYM - CN_COMP_PLANS
SYNONYM - CN_COMP_PLANS_ALL
TRIGGER - CN_COMP_PLANS_T1

[top of page]

Table: CN_COPY_REQUESTS_ALL

Description:

[top of page]

CN.CN_COPY_REQUESTS_ALL references the following:

SYS
PACKAGE - STANDARD
TYPE - XMLTYPE
CN.CN_COPY_REQUESTS_ALL is referenced by following:

APPS
SYNONYM - CN_COPY_REQUESTS_ALL

[top of page]

Table: CN_CREDIT_CONV_FCTS_ALL

Description: Credit type conversion factors.
Primary Key: CN_CREDIT_CONV_FCTS_PK
  1. CREDIT_CONV_FCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_CREDIT_CONV_FCTS_ALL.FROM_CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_CREDIT_CONV_FCTS_ALL.TO_CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_PAYMENT_WORKSHEETS_ALL.CREDIT_CONV_FCT_ID CN_CREDIT_CONV_FCTS_ALL

[top of page]

CN.CN_CREDIT_CONV_FCTS_ALL does not reference any database object

CN.CN_CREDIT_CONV_FCTS_ALL is referenced by following:

APPS
SYNONYM - CN_CREDIT_CONV_FCTS
SYNONYM - CN_CREDIT_CONV_FCTS_ALL

[top of page]

Table: CN_CREDIT_TYPES_ALL_B

Description: Credit Types
Primary Key: CN_CREDIT_TYPES_ALL_B_UK
  1. CREDIT_TYPE_ID
  2. ORG_ID
Primary Key: CN_CREDIT_TYPES_PK
  1. CREDIT_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_CREDIT_CONV_FCTS_ALL.FROM_CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_CREDIT_CONV_FCTS_ALL.TO_CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_PAYMENT_WORKSHEETS_ALL.CONVERT_TO_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_PAYRUNS_ALL.FROM_CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_PAYRUNS_ALL.TO_CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_PMT_PLANS_ALL.CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_POSTING_DETAILS_ALL.CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_QUOTAS_ALL.CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_SRP_PERIODS_ALL.CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B

[top of page]

CN.CN_CREDIT_TYPES_ALL_B does not reference any database object

CN.CN_CREDIT_TYPES_ALL_B is referenced by following:

APPS
SYNONYM - CN_CREDIT_TYPES_ALL_B
SYNONYM - CN_CREDIT_TYPES_B

[top of page]

Table: CN_CREDIT_TYPES_ALL_TL

Description: Credit Types Information
Primary Key: CN_CREDIT_TYPES_ALL_TL_UK
  1. CREDIT_TYPE_ID
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_CREDIT_TYPES_ALL_TL does not reference any database object

CN.CN_CREDIT_TYPES_ALL_TL is referenced by following:

APPS
SYNONYM - CN_CREDIT_TYPES_ALL_TL

[top of page]

Table: CN_CW_SETUP_TASKS_ALL_B

Description: Setup Tasks table

[top of page]

CN.CN_CW_SETUP_TASKS_ALL_B does not reference any database object

CN.CN_CW_SETUP_TASKS_ALL_B is referenced by following:

APPS
SYNONYM - CN_CW_SETUP_TASKS_ALL_B
SYNONYM - CN_CW_SETUP_TASKS_B

[top of page]

Table: CN_CW_SETUP_TASKS_ALL_TL

Description: Setup Tasks TL Table

[top of page]

CN.CN_CW_SETUP_TASKS_ALL_TL does not reference any database object

CN.CN_CW_SETUP_TASKS_ALL_TL is referenced by following:

APPS
SYNONYM - CN_CW_SETUP_TASKS_ALL_TL

[top of page]

Table: CN_CW_WORKBENCH_ITEMS_ALL_B

Description: Workbench Items

[top of page]

CN.CN_CW_WORKBENCH_ITEMS_ALL_B does not reference any database object

CN.CN_CW_WORKBENCH_ITEMS_ALL_B is referenced by following:

APPS
SYNONYM - CN_CW_WORKBENCH_ITEMS_ALL_B
SYNONYM - CN_CW_WORKBENCH_ITEMS_B

[top of page]

Table: CN_CW_WORKBENCH_ITEMS_ALL_TL

Description: Workbench Item

[top of page]

CN.CN_CW_WORKBENCH_ITEMS_ALL_TL does not reference any database object

CN.CN_CW_WORKBENCH_ITEMS_ALL_TL is referenced by following:

APPS
SYNONYM - CN_CW_WORKBENCH_ITEMS_ALL_TL

[top of page]

Table: CN_DIMENSIONS_ALL_B

Description: Stores dimensions of data.
Primary Key: CN_DIMENSIONS_ALL_B_UK
  1. DIMENSION_ID
  2. ORG_ID
Primary Key: CN_DIMENSIONS_PK
  1. DIMENSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_DIMENSIONS_ALL_B.SOURCE_TABLE_ID
CN_DIMENSIONS_ALL_B.ORG_ID 		CN_OBJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_HEAD_HIERARCHIES_ALL_B.DIMENSION_ID CN_DIMENSIONS_ALL_B
CN_OBJECTS_ALL.DIMENSION_ID
CN_OBJECTS_ALL.ORG_ID 		CN_DIMENSIONS_ALL_B

[top of page]

CN.CN_DIMENSIONS_ALL_B does not reference any database object

CN.CN_DIMENSIONS_ALL_B is referenced by following:

APPS
SYNONYM - CN_DIMENSIONS_ALL_B
SYNONYM - CN_DIMENSIONS_B

[top of page]

Table: CN_DIMENSIONS_ALL_TL

Description: Stores dimensions of data (translated attributes)
Primary Key: CN_DIMENSIONS_ALL_TL_UK
  1. DIMENSION_ID
  2. ORG_ID
  3. LANGUAGE
Primary Key: CN_DIMENSIONS_ALL_TL_UK1
  1. NAME
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_DIMENSIONS_ALL_TL does not reference any database object

CN.CN_DIMENSIONS_ALL_TL is referenced by following:

APPS
SYNONYM - CN_DIMENSIONS_ALL_TL

[top of page]

Table: CN_DIM_EXPLOSION_ALL

Description: Denormalizes ancestral relationships
Primary Key: CN_DIM_EXPLOSION_PK
  1. VALUE_ID
  2. ANCESTOR_ID
  3. DIM_HIERARCHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_DIM_EXPLOSION_ALL.VALUE_ID CN_HIERARCHY_NODES_ALL
CN_DIM_EXPLOSION_ALL.ANCESTOR_ID CN_HIERARCHY_NODES_ALL

[top of page]

CN.CN_DIM_EXPLOSION_ALL does not reference any database object

CN.CN_DIM_EXPLOSION_ALL is referenced by following:

APPS
SYNONYM - CN_DIM_EXPLOSION
SYNONYM - CN_DIM_EXPLOSION_ALL

[top of page]

Table: CN_DIM_HIERARCHIES_ALL

Description: Interval level information for dimension hierarchies.
Primary Key: CN_DIM_HIERARCHIES_PK
  1. DIM_HIERARCHY_ID
  2. ORG_ID

[top of page]

CN.CN_DIM_HIERARCHIES_ALL does not reference any database object

CN.CN_DIM_HIERARCHIES_ALL is referenced by following:

APPS
SYNONYM - CN_DIM_HIERARCHIES
SYNONYM - CN_DIM_HIERARCHIES_ALL
TRIGGER - CN_DIM_HIERARCHIES_T2

[top of page]

Table: CN_EVENTS_ALL_B

Description: Contains the various events used in the Collection and Classification processes.
Primary Key: CN_EVENTS_ALL_B_PK
  1. EVENT_ID
  2. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_EVENTS_ALL_B.APPLICATION_REPOSITORY_ID
CN_EVENTS_ALL_B.ORG_ID 		CN_REPOSITORIES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_MODULES_ALL_B.EVENT_ID
CN_MODULES_ALL_B.ORG_ID 		CN_EVENTS_ALL_B
CN_OBJECTS_ALL.EVENT_ID
CN_OBJECTS_ALL.ORG_ID 		CN_EVENTS_ALL_B

[top of page]

CN.CN_EVENTS_ALL_B does not reference any database object

CN.CN_EVENTS_ALL_B is referenced by following:

APPS
SYNONYM - CN_EVENTS_ALL_B
SYNONYM - CN_EVENTS_B

[top of page]

Table: CN_EVENTS_ALL_TL

Description: Contains the multi-lingual event names used in the Collection and Classification processes.
Primary Key: CN_EVENTS_ALL_TL_UK
  1. EVENT_ID
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_EVENTS_ALL_TL does not reference any database object

CN.CN_EVENTS_ALL_TL is referenced by following:

APPS
SYNONYM - CN_EVENTS_ALL_TL

[top of page]

Table: CN_EVENT_LOG_ALL

Description: Log for various system events.
Primary Key: CN_EVENT_LOG_PK
  1. EVENT_LOG_ID

[top of page]

CN.CN_EVENT_LOG_ALL does not reference any database object

CN.CN_EVENT_LOG_ALL is referenced by following:

APPS
SYNONYM - CN_EVENT_LOG
SYNONYM - CN_EVENT_LOG_ALL

[top of page]

Table: CN_FORMULA_INPUTS_ALL

Description: Contains information about input(s) for calculation formulas.
Primary Key: CN_FORMULA_INPUTS_PK
  1. FORMULA_INPUT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_FORMULA_INPUTS_ALL.CALC_FORMULA_ID CN_CALC_FORMULAS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_CALC_EDGES_ALL.PARENT_ID CN_FORMULA_INPUTS_ALL

[top of page]

CN.CN_FORMULA_INPUTS_ALL does not reference any database object

CN.CN_FORMULA_INPUTS_ALL is referenced by following:

APPS
SYNONYM - CN_FORMULA_INPUTS
SYNONYM - CN_FORMULA_INPUTS_ALL

[top of page]

Table: CN_HEAD_HIERARCHIES_ALL_B

Description: Dimension hierarchies
Primary Key: CN_HEAD_HIERARCHIES_ALL_B_PK
  1. HEAD_HIERARCHY_ID
Primary Key: CN_HEAD_HIERARCHIES_ALL_B_UK
  1. HEAD_HIERARCHY_ID
  2. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_HEAD_HIERARCHIES_ALL_B.DIMENSION_ID CN_DIMENSIONS_ALL_B

[top of page]

CN.CN_HEAD_HIERARCHIES_ALL_B does not reference any database object

CN.CN_HEAD_HIERARCHIES_ALL_B is referenced by following:

APPS
SYNONYM - CN_HEAD_HIERARCHIES_ALL_B
SYNONYM - CN_HEAD_HIERARCHIES_B

[top of page]

Table: CN_HEAD_HIERARCHIES_ALL_TL

Description: Dimension hierarchies
Primary Key: CN_HEAD_HIERARCHIES_ALL_TL_UK
  1. HEAD_HIERARCHY_ID
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_HEAD_HIERARCHIES_ALL_TL does not reference any database object

CN.CN_HEAD_HIERARCHIES_ALL_TL is referenced by following:

APPS
SYNONYM - CN_HEAD_HIERARCHIES_ALL_TL

[top of page]

Table: CN_HIERARCHIES_API_ALL

Description: Interface table used for uploading and downing hierarchies
Primary Key: CN_HIERARCHIES_API_PK
  1. HIERARCHY_API_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_HIERARCHY_EDGES_ALL.HIERARCHY_API_ID CN_HIERARCHIES_API_ALL

[top of page]

CN.CN_HIERARCHIES_API_ALL does not reference any database object

CN.CN_HIERARCHIES_API_ALL is referenced by following:

APPS
SYNONYM - CN_HIERARCHIES_API
SYNONYM - CN_HIERARCHIES_API_ALL

[top of page]

Table: CN_HIERARCHY_EDGES_ALL

Description: Parent child relationships in hierarchies.
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_HIERARCHY_EDGES_ALL.HIERARCHY_API_ID CN_HIERARCHIES_API_ALL
CN_HIERARCHY_EDGES_ALL.VALUE_ID CN_HIERARCHY_NODES_ALL
CN_HIERARCHY_EDGES_ALL.PARENT_VALUE_ID CN_HIERARCHY_NODES_ALL

[top of page]

CN.CN_HIERARCHY_EDGES_ALL does not reference any database object

CN.CN_HIERARCHY_EDGES_ALL is referenced by following:

APPS
SYNONYM - CN_HIERARCHY_EDGES
SYNONYM - CN_HIERARCHY_EDGES_ALL
TRIGGER - CN_HIERARCHY_EDGES_T1
TRIGGER - CN_HIERARCHY_EDGES_T2
TRIGGER - CN_HIERARCHY_EDGES_T3
TRIGGER - CN_HIERARCHY_EDGES_T4
TRIGGER - CN_HIERARCHY_EDGES_T5
TRIGGER - CN_HIERARCHY_EDGES_T6

[top of page]

Table: CN_HIERARCHY_NODES_ALL

Description: Nodes in the hierarchy.
Primary Key: CN_HIERARCHY_NODES_PK
  1. VALUE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_DIM_EXPLOSION_ALL.VALUE_ID CN_HIERARCHY_NODES_ALL
CN_DIM_EXPLOSION_ALL.ANCESTOR_ID CN_HIERARCHY_NODES_ALL
CN_HIERARCHY_EDGES_ALL.VALUE_ID CN_HIERARCHY_NODES_ALL
CN_HIERARCHY_EDGES_ALL.PARENT_VALUE_ID CN_HIERARCHY_NODES_ALL

[top of page]

CN.CN_HIERARCHY_NODES_ALL does not reference any database object

CN.CN_HIERARCHY_NODES_ALL is referenced by following:

APPS
SYNONYM - CN_HIERARCHY_NODES
SYNONYM - CN_HIERARCHY_NODES_ALL

[top of page]

Table: CN_IMPORT_TYPES

Description: CN_IMPORT_TYPES store all module types can be imported into the application. You need one row for each module. For each imported module, the view will be used for staging the data and the concurrent program will be used to import data into

[top of page]

CN.CN_IMPORT_TYPES does not reference any database object

CN.CN_IMPORT_TYPES is referenced by following:

APPS
SYNONYM - CN_IMPORT_TYPES

[top of page]

Table: CN_IMP_HEADERS

Description: CN_IMP_HEADERS contains information for user imports.

[top of page]

CN.CN_IMP_HEADERS does not reference any database object

CN.CN_IMP_HEADERS is referenced by following:

APPS
SYNONYM - CN_IMP_HEADERS

[top of page]

Table: CN_IMP_LINES

Description: CN_IMP_LINES is the staging table for import process. It contains all mapped data transfered from user data file.

[top of page]

CN.CN_IMP_LINES does not reference any database object

CN.CN_IMP_LINES is referenced by following:

APPS
SYNONYM - CN_IMP_LINES

[top of page]

Table: CN_IMP_MAPS

Description: CN_IMP_MAPS store the information of mappings between user data file and importing modules.

[top of page]

CN.CN_IMP_MAPS does not reference any database object

CN.CN_IMP_MAPS is referenced by following:

APPS
SYNONYM - CN_IMP_MAPS

[top of page]

Table: CN_IMP_MAP_FIELDS

Description: CN_IMP_MAP_FIELDS store the detailed information of mappings between user data file and importing modules.

[top of page]

CN.CN_IMP_MAP_FIELDS does not reference any database object

CN.CN_IMP_MAP_FIELDS is referenced by following:

APPS
SYNONYM - CN_IMP_MAP_FIELDS

[top of page]

Table: CN_INTERVAL_TYPES_ALL_B

Description: Accumulation Calendar Interval Types. Interval types are assigned to a plan element
Primary Key: CN_INTERVAL_TYPES_ALL_B_PK
  1. INTERVAL_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_CAL_PER_INT_TYPES_ALL.INTERVAL_TYPE_ID CN_INTERVAL_TYPES_ALL_B
CN_QUOTAS_ALL.INTERVAL_TYPE_ID CN_INTERVAL_TYPES_ALL_B

[top of page]

CN.CN_INTERVAL_TYPES_ALL_B does not reference any database object

CN.CN_INTERVAL_TYPES_ALL_B is referenced by following:

APPS
SYNONYM - CN_INTERVAL_TYPES_ALL_B
SYNONYM - CN_INTERVAL_TYPES_B

[top of page]

Table: CN_INTERVAL_TYPES_ALL_TL

Description: Accumulation Calendar Interval Types. Interval types are assigned to a plan element
Primary Key: CN_INTERVAL_TYPES_ALL_TL_UK
  1. INTERVAL_TYPE_ID
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_INTERVAL_TYPES_ALL_TL does not reference any database object

CN.CN_INTERVAL_TYPES_ALL_TL is referenced by following:

APPS
SYNONYM - CN_INTERVAL_TYPES_ALL_TL

[top of page]

Table: CN_INVOICE_CHANGES_ALL

Description: Invoice changes

[top of page]

CN.CN_INVOICE_CHANGES_ALL does not reference any database object

CN.CN_INVOICE_CHANGES_ALL is referenced by following:

APPS
SYNONYM - CN_INVOICE_CHANGES
SYNONYM - CN_INVOICE_CHANGES_ALL

[top of page]

Table: CN_JOB_ROLES

Description: CN_JOB_ROLES contain the information about the job assigned to a sales role.
Primary Key: CN_JOB_ROLES_PK
  1. JOB_ROLE_ID

[top of page]

CN.CN_JOB_ROLES does not reference any database object

CN.CN_JOB_ROLES is referenced by following:

APPS
SYNONYM - CN_JOB_ROLES

[top of page]

Table: CN_LEDGER_BAL_TYPES_ALL_B

Description: Lookup table for account names
Primary Key: CN_LEDGER_BAL_TYPES_ALL_B_PK
  1. BALANCE_ID
  2. ORG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_LEDGER_JOURNAL_ENTRIES_ALL.BALANCE_ID
CN_LEDGER_JOURNAL_ENTRIES_ALL.ORG_ID 		CN_LEDGER_BAL_TYPES_ALL_B

[top of page]

CN.CN_LEDGER_BAL_TYPES_ALL_B does not reference any database object

CN.CN_LEDGER_BAL_TYPES_ALL_B is referenced by following:

APPS
SYNONYM - CN_LEDGER_BAL_TYPES_ALL_B
SYNONYM - CN_LEDGER_BAL_TYPES_B

[top of page]

Table: CN_LEDGER_BAL_TYPES_ALL_TL

Description: Lookup table for account names
Primary Key: CN_LEDGER_BAL_TYPES_ALL_TL_UK
  1. BALANCE_ID
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_LEDGER_BAL_TYPES_ALL_TL does not reference any database object

CN.CN_LEDGER_BAL_TYPES_ALL_TL is referenced by following:

APPS
SYNONYM - CN_LEDGER_BAL_TYPES_ALL_TL

[top of page]

Table: CN_LEDGER_JE_BATCHES_ALL

Description: Batches of journal entries.
Primary Key: CN_LEDGER_JE_BATCHES_PK
  1. BATCH_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_LEDGER_JOURNAL_ENTRIES_ALL.BATCH_ID CN_LEDGER_JE_BATCHES_ALL
CN_PAYRUNS_ALL.BATCH_ID CN_LEDGER_JE_BATCHES_ALL

[top of page]

CN.CN_LEDGER_JE_BATCHES_ALL does not reference any database object

CN.CN_LEDGER_JE_BATCHES_ALL is referenced by following:

APPS
SYNONYM - CN_LEDGER_JE_BATCHES
SYNONYM - CN_LEDGER_JE_BATCHES_ALL

[top of page]

Table: CN_LEDGER_JOURNAL_ENTRIES_ALL

Description: Individual lines of journal entries
Primary Key: CN_LEDGER_JOURNAL_ENTRIES_PK
  1. LEDGER_JE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_LEDGER_JOURNAL_ENTRIES_ALL.SRP_PERIOD_ID CN_SRP_PERIODS_ALL
CN_LEDGER_JOURNAL_ENTRIES_ALL.BATCH_ID CN_LEDGER_JE_BATCHES_ALL
CN_LEDGER_JOURNAL_ENTRIES_ALL.BALANCE_ID
CN_LEDGER_JOURNAL_ENTRIES_ALL.ORG_ID 		CN_LEDGER_BAL_TYPES_ALL_B

[top of page]

CN.CN_LEDGER_JOURNAL_ENTRIES_ALL does not reference any database object

CN.CN_LEDGER_JOURNAL_ENTRIES_ALL is referenced by following:

APPS
SYNONYM - CN_LEDGER_JOURNAL_ENTRIES
SYNONYM - CN_LEDGER_JOURNAL_ENTRIES_ALL

[top of page]

Table: CN_LINE_ROLLUP_PATHS_ALL

Description: Contains information about rollup paths if there are multiple rollup paths found.
Primary Key: CN_LINE_ROLLUP_PATHS_PK
  1. LINE_ROLLUP_PATH_ID

[top of page]

CN.CN_LINE_ROLLUP_PATHS_ALL does not reference any database object

CN.CN_LINE_ROLLUP_PATHS_ALL is referenced by following:

APPS
SYNONYM - CN_LINE_ROLLUP_PATHS
SYNONYM - CN_LINE_ROLLUP_PATHS_ALL

[top of page]

Table: CN_MODEL_RESOURCES_ALL

Description: Stores resources used to simulate an agreement version
Primary Key: CN_MODEL_RESOURCES_PK
  1. MODEL_RESOURCE_ID

[top of page]

CN.CN_MODEL_RESOURCES_ALL does not reference any database object

CN.CN_MODEL_RESOURCES_ALL is referenced by following:

APPS
SYNONYM - CN_MODEL_RESOURCES
SYNONYM - CN_MODEL_RESOURCES_ALL

[top of page]

Table: CN_MODULES_ALL_B

Description: Source modules generated by the Classification and Collection code generators.
Primary Key: CN_MODULES_ALL_B_PK
  1. MODULE_ID
  2. ORG_ID
Primary Key: CN_MODULES_UK1
  1. REPOSITORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_MODULES_ALL_B.REPOSITORY_ID
CN_MODULES_ALL_B.ORG_ID 		CN_REPOSITORIES_ALL
CN_MODULES_ALL_B.PARENT_MODULE_ID
CN_MODULES_ALL_B.ORG_ID 		CN_MODULES_ALL_B
CN_MODULES_ALL_B.SOURCE_REPOSITORY_ID
CN_MODULES_ALL_B.ORG_ID 		CN_REPOSITORIES_ALL
CN_MODULES_ALL_B.EVENT_ID
CN_MODULES_ALL_B.ORG_ID 		CN_EVENTS_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_ATTRIBUTE_RULES_ALL.SLICE_MODULE_ID
CN_ATTRIBUTE_RULES_ALL.ORG_ID 		CN_MODULES_ALL_B
CN_MODULES_ALL_B.PARENT_MODULE_ID
CN_MODULES_ALL_B.ORG_ID 		CN_MODULES_ALL_B
CN_MOD_OBJ_DEPENDS_ALL.MODULE_ID
CN_MOD_OBJ_DEPENDS_ALL.ORG_ID 		CN_MODULES_ALL_B
CN_PROCESS_AUDITS_ALL.MODULE_ID
CN_PROCESS_AUDITS_ALL.ORG_ID 		CN_MODULES_ALL_B
CN_TABLE_MAPS_ALL.MODULE_ID
CN_TABLE_MAPS_ALL.ORG_ID 		CN_MODULES_ALL_B

[top of page]

CN.CN_MODULES_ALL_B does not reference any database object

CN.CN_MODULES_ALL_B is referenced by following:

APPS
SYNONYM - CN_MODULES_ALL_B
SYNONYM - CN_MODULES_B

[top of page]

Table: CN_MODULES_ALL_TL

Description: contain the multi-lingular name for source modules generated by the Classification and Collection code generators.
Primary Key: CN_MODULES_ALL_TL_UK
  1. MODULE_ID
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_MODULES_ALL_TL does not reference any database object

CN.CN_MODULES_ALL_TL is referenced by following:

APPS
SYNONYM - CN_MODULES_ALL_TL

[top of page]

Table: CN_MOD_OBJ_DEPENDS_ALL

Description: Records dependencies between modules and objects.
Primary Key: CN_MOD_OBJ_DEPENDS_PK
  1. MOD_OBJ_DEPENDS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_MOD_OBJ_DEPENDS_ALL.MODULE_ID
CN_MOD_OBJ_DEPENDS_ALL.ORG_ID 		CN_MODULES_ALL_B
CN_MOD_OBJ_DEPENDS_ALL.OBJECT_ID
CN_MOD_OBJ_DEPENDS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_MOD_OBJ_DEPENDS_ALL.PARENT_OBJECT_ID
CN_MOD_OBJ_DEPENDS_ALL.ORG_ID 		CN_OBJECTS_ALL

[top of page]

CN.CN_MOD_OBJ_DEPENDS_ALL does not reference any database object

CN.CN_MOD_OBJ_DEPENDS_ALL is referenced by following:

APPS
SYNONYM - CN_MOD_OBJ_DEPENDS
SYNONYM - CN_MOD_OBJ_DEPENDS_ALL

[top of page]

Table: CN_NOTIFY_LOG_ALL

Description: Log for the notification records generated by the events in the event log.
Primary Key: CN_NOTIFY_LOG_PK
  1. NOTIFY_LOG_ID

[top of page]

CN.CN_NOTIFY_LOG_ALL does not reference any database object

CN.CN_NOTIFY_LOG_ALL is referenced by following:

APPS
SYNONYM - CN_NOTIFY_LOG
SYNONYM - CN_NOTIFY_LOG_ALL

[top of page]

Table: CN_NOT_TRX_ALL

Description: Determines which AR records will be used by the Collection process.
Primary Key: CN_NOT_TRX_PK
  1. NOT_TRX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_NOT_TRX_ALL.NOTIFICATION_RUN_ID CN_PROCESS_AUDITS_ALL
CN_NOT_TRX_ALL.SOURCE_TRX_ID RA_CUSTOMER_TRX_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_TRX_ALL.NOT_TRX_ID CN_NOT_TRX_ALL

[top of page]

CN.CN_NOT_TRX_ALL does not reference any database object

CN.CN_NOT_TRX_ALL is referenced by following:

APPS
SYNONYM - CN_NOT_TRX
SYNONYM - CN_NOT_TRX_ALL

[top of page]

Table: CN_OBJECTS_ALL

Description: Collection of objects used by Sales Compensation. Tables, columns, sequences, packages, etc.
Primary Key: CN_OBJECTS_PK
  1. OBJECT_ID
  2. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_OBJECTS_ALL.REPOSITORY_ID
CN_OBJECTS_ALL.ORG_ID 		CN_REPOSITORIES_ALL
CN_OBJECTS_ALL.DIMENSION_ID
CN_OBJECTS_ALL.ORG_ID 		CN_DIMENSIONS_ALL_B
CN_OBJECTS_ALL.TABLE_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.PACKAGE_SPECIFICATION_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.EVENT_ID
CN_OBJECTS_ALL.ORG_ID 		CN_EVENTS_ALL_B
CN_OBJECTS_ALL.SEED_OBJECT_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.PACKAGE_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.PRIMARY_KEY_COLUMN_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.USER_NAME_COLUMN_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_ATTRIBUTE_RULES_ALL.COLUMN_ID
CN_ATTRIBUTE_RULES_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_COLUMN_MAPS_ALL.SOURCE_COLUMN_ID
CN_COLUMN_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_COLUMN_MAPS_ALL.DESTINATION_COLUMN_ID
CN_COLUMN_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_COLUMN_MAPS_ALL.DRIVING_COLUMN_ID
CN_COLUMN_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_DIMENSIONS_ALL_B.SOURCE_TABLE_ID
CN_DIMENSIONS_ALL_B.ORG_ID 		CN_OBJECTS_ALL
CN_MOD_OBJ_DEPENDS_ALL.OBJECT_ID
CN_MOD_OBJ_DEPENDS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_MOD_OBJ_DEPENDS_ALL.PARENT_OBJECT_ID
CN_MOD_OBJ_DEPENDS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.TABLE_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.PACKAGE_SPECIFICATION_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.SEED_OBJECT_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.PACKAGE_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.PRIMARY_KEY_COLUMN_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_OBJECTS_ALL.USER_NAME_COLUMN_ID
CN_OBJECTS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_PROCESS_AUDITS_ALL.OBJECT_ID
CN_PROCESS_AUDITS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_RULESETS_ALL_B.DESTINATION_COLUMN_ID
CN_RULESETS_ALL_B.ORG_ID 		CN_OBJECTS_ALL
CN_SOURCE_ALL.OBJECT_ID
CN_SOURCE_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_TABLE_MAPS_ALL.SOURCE_TABLE_ID
CN_TABLE_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_TABLE_MAPS_ALL.DESTINATION_TABLE_ID
CN_TABLE_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL

[top of page]

CN.CN_OBJECTS_ALL does not reference any database object

CN.CN_OBJECTS_ALL is referenced by following:

APPS
SYNONYM - CN_OBJECTS
SYNONYM - CN_OBJECTS_ALL

[top of page]

Table: CN_PAYMENT_API_ALL

Description: Holds the output of the payment process.
Primary Key: CN_PAYMENT_API_PK
  1. PAYMENT_API_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PAYMENT_API_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PAYMENT_API_ALL.PAYRUN_ID CN_PAYRUNS_ALL
CN_PAYMENT_API_ALL.SALESREP_ID CN_SALESREPS_API_ALL

[top of page]

CN.CN_PAYMENT_API_ALL does not reference any database object

CN.CN_PAYMENT_API_ALL is referenced by following:

APPS
SYNONYM - CN_PAYMENT_API
SYNONYM - CN_PAYMENT_API_ALL

[top of page]

Table: CN_PAYMENT_TRANSACTIONS_ALL

Description: This table is used by the payment module to store the details for each payment worksheet. The records that are created in this table are dependent on the value of the profile Pay by Transaction. When this profile is set to Y(es), the data i

[top of page]

CN.CN_PAYMENT_TRANSACTIONS_ALL does not reference any database object

CN.CN_PAYMENT_TRANSACTIONS_ALL is referenced by following:

APPS
SYNONYM - CN_PAYMENT_TRANSACTIONS
SYNONYM - CN_PAYMENT_TRANSACTIONS_ALL

[top of page]

Table: CN_PAYMENT_WORKSHEETS_ALL

Description: CN_PAYMENT_WORKSHEETS contains information about
Primary Key: CN_PAYMENT_WORKSHEETS_PK
  1. PAYRUN_ID
  2. SALESREP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PAYMENT_WORKSHEETS_ALL.PAYRUN_ID CN_PAYRUNS_ALL
CN_PAYMENT_WORKSHEETS_ALL.CONVERT_TO_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_PAYMENT_WORKSHEETS_ALL.CREDIT_CONV_FCT_ID CN_CREDIT_CONV_FCTS_ALL

[top of page]

CN.CN_PAYMENT_WORKSHEETS_ALL does not reference any database object

CN.CN_PAYMENT_WORKSHEETS_ALL is referenced by following:

APPS
SYNONYM - CN_PAYMENT_WORKSHEETS
SYNONYM - CN_PAYMENT_WORKSHEETS_ALL

[top of page]

Table: CN_PAYRUNS_ALL

Description: Corresponds to runs of checks.
Primary Key: CN_PAYRUNS_PK
  1. PAYRUN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PAYRUNS_ALL.ACCOUNTING_PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PAYRUNS_ALL.BATCH_ID CN_LEDGER_JE_BATCHES_ALL
CN_PAYRUNS_ALL.PAY_PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PAYRUNS_ALL.FROM_CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_PAYRUNS_ALL.TO_CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_PAYRUNS_ALL.PAY_GROUP_ID CN_PAY_GROUPS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_PAYMENT_API_ALL.PAYRUN_ID CN_PAYRUNS_ALL
CN_PAYMENT_WORKSHEETS_ALL.PAYRUN_ID CN_PAYRUNS_ALL
CN_WORKSHEET_BONUSES_ALL.PAYRUN_ID CN_PAYRUNS_ALL

[top of page]

CN.CN_PAYRUNS_ALL does not reference any database object

CN.CN_PAYRUNS_ALL is referenced by following:

APPS
SYNONYM - CN_PAYRUNS
SYNONYM - CN_PAYRUNS_ALL

[top of page]

Table: CN_PAY_APPROVAL_FLOW_ALL

Description: CN_PAY_APPROVAL_FLOW contains informatiom of an analyst submits the payment worksheet to his/her reporting managers to approve.

[top of page]

CN.CN_PAY_APPROVAL_FLOW_ALL does not reference any database object

CN.CN_PAY_APPROVAL_FLOW_ALL is referenced by following:

APPS
SYNONYM - CN_PAY_APPROVAL_FLOW
SYNONYM - CN_PAY_APPROVAL_FLOW_ALL

[top of page]

Table: CN_PAY_ELEMENT_INPUTS_ALL

Description: This table stores the mapping information about the Pay Element Input and and OIC Table Columns.
Primary Key: CN_PAY_ELEMENT_INPUTS_PK
  1. PAY_ELEMENT_INPUT_ID

[top of page]

CN.CN_PAY_ELEMENT_INPUTS_ALL does not reference any database object

CN.CN_PAY_ELEMENT_INPUTS_ALL is referenced by following:

APPS
SYNONYM - CN_PAY_ELEMENT_INPUTS
SYNONYM - CN_PAY_ELEMENT_INPUTS_ALL

[top of page]

Table: CN_PAY_GROUPS_ALL

Description: CN_PAY_GROUPS_ALL is used to store pay groups. Pay groups are defined as a set of pay periods in a pay calendar. Pay groups are used to determine the frequency of payment for a sales person.
Primary Key: CN_PAY_GROUPS_PK
  1. PAY_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_PAYRUNS_ALL.PAY_GROUP_ID CN_PAY_GROUPS_ALL
CN_SRP_PAY_GROUPS_ALL.PAY_GROUP_ID CN_PAY_GROUPS_ALL

[top of page]

CN.CN_PAY_GROUPS_ALL does not reference any database object

CN.CN_PAY_GROUPS_ALL is referenced by following:

APPS
SYNONYM - CN_PAY_GROUPS
SYNONYM - CN_PAY_GROUPS_ALL

[top of page]

Table: CN_PERF_MEASURES_ALL

Description: Contains information about performance measure. You need one row for each performance measure defined.
Primary Key: CN_PERF_MEASURES_PK
  1. PERF_MEASURE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_CALC_EDGES_ALL.PARENT_ID CN_PERF_MEASURES_ALL
CN_CALC_EDGES_ALL.CHILD_ID CN_PERF_MEASURES_ALL
CN_CALC_FORMULAS_ALL.PERF_MEASURE_ID CN_PERF_MEASURES_ALL

[top of page]

CN.CN_PERF_MEASURES_ALL does not reference any database object

CN.CN_PERF_MEASURES_ALL is referenced by following:

APPS
SYNONYM - CN_PERF_MEASURES_ALL

[top of page]

Table: CN_PERIOD_QUOTAS_ALL

Description: This table stores period target and payment amounts associated with a plan element
Primary Key: CN_PERIOD_QUOTAS_PK
  1. PERIOD_QUOTA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PERIOD_QUOTAS_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PERIOD_QUOTAS_ALL.QUOTA_ID CN_QUOTAS_ALL

[top of page]

CN.CN_PERIOD_QUOTAS_ALL does not reference any database object

CN.CN_PERIOD_QUOTAS_ALL is referenced by following:

APPS
SYNONYM - CN_PERIOD_QUOTAS
SYNONYM - CN_PERIOD_QUOTAS_ALL

[top of page]

Table: CN_PERIOD_SETS_ALL

Description: This table is used by OSC to store the period_set_id which is system generated by OSC.
Primary Key: CN_PERIOD_SETS_PK
  1. PERIOD_SET_ID

[top of page]

CN.CN_PERIOD_SETS_ALL does not reference any database object

CN.CN_PERIOD_SETS_ALL is referenced by following:

APPS
SYNONYM - CN_PERIOD_SETS
SYNONYM - CN_PERIOD_SETS_ALL

[top of page]

Table: CN_PERIOD_STATUSES_ALL

Description: Status of the Sales Compensation accounting periods. In addition to the GL status.
Primary Key: CN_PERIOD_STATUSES_PK
  1. PERIOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PERIOD_STATUSES_ALL.PERIOD_SET_NAME
CN_PERIOD_STATUSES_ALL.PERIOD_NAME 		GL_PERIODS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMMISSION_LINES_ALL.PROCESSED_PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_COMM_LINES_API_ALL.PROCESSED_PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PAYMENT_API_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PAYRUNS_ALL.ACCOUNTING_PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PAYRUNS_ALL.PAY_PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PERIOD_QUOTAS_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_PROCESS_BATCHES_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_SRP_PERIODS_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_SRP_PERIOD_QUOTAS_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL

[top of page]

CN.CN_PERIOD_STATUSES_ALL does not reference any database object

CN.CN_PERIOD_STATUSES_ALL is referenced by following:

APPS
SYNONYM - CN_PERIOD_STATUSES
SYNONYM - CN_PERIOD_STATUSES_ALL

[top of page]

Table: CN_PERIOD_TYPES_ALL

Description: Period Type is defined in GL. This table is used to store period_type_id generated in OSC which is not in GL.
Primary Key: CN_PERIOD_TYPES_PK
  1. PERIOD_TYPE_ID
Primary Key: CN_PERIOD_TYPES_UK1
  1. PERIOD_TYPE
  2. ORG_ID
Primary Key: CN_PERIOD_TYPE_UK2
  1. PERIOD_TYPE_ID
  2. ORG_ID

[top of page]

CN.CN_PERIOD_TYPES_ALL does not reference any database object

CN.CN_PERIOD_TYPES_ALL is referenced by following:

APPS
SYNONYM - CN_PERIOD_TYPES
SYNONYM - CN_PERIOD_TYPES_ALL

[top of page]

Table: CN_PLAN_TEXTS

Description: CN_PLAN_TEXTS contains the custimized information on compensation contract for each sales role. User can customize contract title, club qualification, terms and conditions, approver's information.
Primary Key: CN_PLAN_TEXTS_PK
  1. PLAN_TEXT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PLAN_TEXTS.ROLE_ID CN_ROLE_DETAILS
CN_PLAN_TEXTS.QUOTA_CATEGORY_ID CN_QUOTA_CATEGORIES

[top of page]

CN.CN_PLAN_TEXTS does not reference any database object

CN.CN_PLAN_TEXTS is referenced by following:

APPS
SYNONYM - CN_PLAN_TEXTS

[top of page]

Table: CN_PMT_PLANS_ALL

Description: This table stores information regarding the payment plans used to affect the compensation paid to sales people
Primary Key: CN_PMT_PLANS_PK
  1. PMT_PLAN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PMT_PLANS_ALL.CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_PMT_PLANS_ALL.PMT_PLAN_ID CN_PMT_PLANS_ALL

[top of page]

CN.CN_PMT_PLANS_ALL does not reference any database object

CN.CN_PMT_PLANS_ALL is referenced by following:

APPS
SYNONYM - CN_PMT_PLANS
SYNONYM - CN_PMT_PLANS_ALL

[top of page]

Table: CN_POSTING_BATCHES_ALL

Description: Batch for posting processing
Primary Key: CN_POSTING_BATCHES_PK
  1. POSTING_BATCH_ID
Primary Key: CN_POSTING_BATCHES_UK1
  1. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_POSTING_DETAILS_ALL.POSTING_BATCH_ID CN_POSTING_BATCHES_ALL

[top of page]

CN.CN_POSTING_BATCHES_ALL does not reference any database object

CN.CN_POSTING_BATCHES_ALL is referenced by following:

APPS
SYNONYM - CN_POSTING_BATCHES
SYNONYM - CN_POSTING_BATCHES_ALL

[top of page]

Table: CN_POSTING_DETAILS_ALL

Description: This table contains detail posting information, including payee salesrep, posting type, processing date.
Primary Key: CN_POSTING_DETAILS_PK
  1. POSTING_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_POSTING_DETAILS_ALL.COMMISSION_HEADER_ID CN_COMMISSION_HEADERS_ALL
CN_POSTING_DETAILS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_POSTING_DETAILS_ALL.CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_POSTING_DETAILS_ALL.POSTING_BATCH_ID CN_POSTING_BATCHES_ALL
CN_POSTING_DETAILS_ALL.QUOTA_ID CN_QUOTAS_ALL

[top of page]

CN.CN_POSTING_DETAILS_ALL does not reference any database object

CN.CN_POSTING_DETAILS_ALL is referenced by following:

APPS
SYNONYM - CN_POSTING_DETAILS
SYNONYM - CN_POSTING_DETAILS_ALL

[top of page]

Table: CN_POSTING_DETAILS_SUM_ALL

Description: This table contains the summarized information from cn_posting_details
Primary Key: CN_POSTING_DETAILS_SUM_PK
  1. POSTING_DETAIL_SUM_ID

[top of page]

CN.CN_POSTING_DETAILS_SUM_ALL does not reference any database object

CN.CN_POSTING_DETAILS_SUM_ALL is referenced by following:

APPS
SYNONYM - CN_POSTING_DETAILS_SUM
SYNONYM - CN_POSTING_DETAILS_SUM_ALL

[top of page]

Table: CN_PROCESS_AUDITS_ALL

Description: Process execution log details
Primary Key: CN_PROCESS_AUDITS_PK
  1. PROCESS_AUDIT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PROCESS_AUDITS_ALL.PARENT_PROCESS_AUDIT_ID CN_PROCESS_AUDITS_ALL
CN_PROCESS_AUDITS_ALL.OBJECT_ID
CN_PROCESS_AUDITS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_PROCESS_AUDITS_ALL.MODULE_ID
CN_PROCESS_AUDITS_ALL.ORG_ID 		CN_MODULES_ALL_B
CN_PROCESS_AUDITS_ALL.PARENT_PROCESS_AUDIT_ID CN_PROCESS_AUDITS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_NOT_TRX_ALL.NOTIFICATION_RUN_ID CN_PROCESS_AUDITS_ALL
CN_PROCESS_AUDITS_ALL.PARENT_PROCESS_AUDIT_ID CN_PROCESS_AUDITS_ALL
CN_PROCESS_AUDITS_ALL.PARENT_PROCESS_AUDIT_ID CN_PROCESS_AUDITS_ALL
CN_PROCESS_AUDIT_LINES_ALL.PROCESS_AUDIT_ID CN_PROCESS_AUDITS_ALL
CN_TRX_BATCHES_ALL.PROCESS_AUDIT_ID CN_PROCESS_AUDITS_ALL

[top of page]

CN.CN_PROCESS_AUDITS_ALL does not reference any database object

CN.CN_PROCESS_AUDITS_ALL is referenced by following:

APPS
SYNONYM - CN_PROCESS_AUDITS
SYNONYM - CN_PROCESS_AUDITS_ALL

[top of page]

Table: CN_PROCESS_AUDIT_LINES_ALL

Description: Process execution log messages
Primary Key: CN_PROCESS_AUDIT_LINES_PK
  1. PROCESS_AUDIT_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PROCESS_AUDIT_LINES_ALL.PROCESS_AUDIT_ID CN_PROCESS_AUDITS_ALL

[top of page]

CN.CN_PROCESS_AUDIT_LINES_ALL does not reference any database object

CN.CN_PROCESS_AUDIT_LINES_ALL is referenced by following:

APPS
SYNONYM - CN_PROCESS_AUDIT_LINES
SYNONYM - CN_PROCESS_AUDIT_LINES_ALL

[top of page]

Table: CN_PROCESS_BATCHES_ALL

Description: Process Batches used in Calculation process.
Primary Key: CN_PROCESS_BATCHES_PK
  1. PROCESS_BATCH_ID
Primary Key: CN_PROCESS_BATCHES_UK1
  1. LOGICAL_BATCH_ID
  2. SRP_PERIOD_ID
Primary Key: CN_PROCESS_BATCHES_UK2
  1. LOGICAL_BATCH_ID
  2. SALESREP_ID
  3. PERIOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_PROCESS_BATCHES_ALL.SRP_PERIOD_ID CN_SRP_PERIODS_ALL
CN_PROCESS_BATCHES_ALL.SALESREP_ID CN_SALESREPS_API_ALL
CN_PROCESS_BATCHES_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL

[top of page]

CN.CN_PROCESS_BATCHES_ALL does not reference any database object

CN.CN_PROCESS_BATCHES_ALL is referenced by following:

APPS
SYNONYM - CN_PROCESS_BATCHES
SYNONYM - CN_PROCESS_BATCHES_ALL

[top of page]

Table: CN_QUARTER_BCK_ALL

Description: This table stores quarters used in organization paid homepage bin.

[top of page]

CN.CN_QUARTER_BCK_ALL does not reference any database object

CN.CN_QUARTER_BCK_ALL is referenced by following:

APPS
SYNONYM - CN_QUARTER_BCK
SYNONYM - CN_QUARTER_BCK_ALL

[top of page]

Table: CN_QUOTAS_ALL

Description: Plan Elements
Primary Key: CN_QUOTAS_PK
  1. QUOTA_ID
Primary Key: CN_QUOTAS_UK1
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_QUOTAS_ALL.CALC_FORMULA_ID CN_CALC_FORMULAS_ALL
CN_QUOTAS_ALL.CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_QUOTAS_ALL.INTERVAL_TYPE_ID CN_INTERVAL_TYPES_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
AS_PE_INT_CATEGORIES.QUOTA_ID CN_QUOTAS_ALL
CN_COMMISSION_LINES_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_PERIOD_QUOTAS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_POSTING_DETAILS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_QUOTA_ASSIGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_QUOTA_RULES_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_RT_QUOTA_ASGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_SRP_PAYEE_ASSIGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_SRP_PERIOD_QUOTAS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_SRP_PER_QUOTA_RC_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_SRP_QUOTA_ASSIGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_SRP_RATE_ASSIGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_TRX_FACTORS_ALL.QUOTA_ID CN_QUOTAS_ALL

[top of page]

CN.CN_QUOTAS_ALL does not reference any database object

CN.CN_QUOTAS_ALL is referenced by following:

APPS
SYNONYM - CN_QUOTAS
SYNONYM - CN_QUOTAS_ALL

[top of page]

Table: CN_QUOTA_ASSIGNS_ALL

Description: Elements assigned to a compensation plan
Primary Key: CN_QUOTA_ASSIGNS_PK
  1. QUOTA_ASSIGN_ID
Primary Key: CN_QUOTA_ASSIGNS_UK1
  1. COMP_PLAN_ID
  2. QUOTA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_QUOTA_ASSIGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_QUOTA_ASSIGNS_ALL.COMP_PLAN_ID CN_COMP_PLANS_ALL

[top of page]

CN.CN_QUOTA_ASSIGNS_ALL does not reference any database object

CN.CN_QUOTA_ASSIGNS_ALL is referenced by following:

APPS
SYNONYM - CN_QUOTA_ASSIGNS
SYNONYM - CN_QUOTA_ASSIGNS_ALL

[top of page]

Table: CN_QUOTA_CATEGORIES

Description: CN_QUOTA_CATEGORIES contains informations about your quota components. You need one row for each component you create.
Primary Key: CN_QUOTA_CATEGORIES_PK
  1. QUOTA_CATEGORY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMP_ANCHORS.QUOTA_CATEGORY_ID CN_QUOTA_CATEGORIES
CN_PLAN_TEXTS.QUOTA_CATEGORY_ID CN_QUOTA_CATEGORIES
CN_ROLE_QUOTA_CATES.QUOTA_CATEGORY_ID CN_QUOTA_CATEGORIES

[top of page]

CN.CN_QUOTA_CATEGORIES does not reference any database object

CN.CN_QUOTA_CATEGORIES is referenced by following:

APPS
SYNONYM - CN_QUOTA_CATEGORIES

[top of page]

Table: CN_QUOTA_PAY_ELEMENTS_ALL

Description: This table contains the infomation about the quota pay element mapping.

[top of page]

CN.CN_QUOTA_PAY_ELEMENTS_ALL does not reference any database object

CN.CN_QUOTA_PAY_ELEMENTS_ALL is referenced by following:

APPS
SYNONYM - CN_QUOTA_PAY_ELEMENTS
SYNONYM - CN_QUOTA_PAY_ELEMENTS_ALL

[top of page]

Table: CN_QUOTA_RULES_ALL

Description: Revenue classes assigned to a plan element
Primary Key: CN_QUOTA_RULES_PK
  1. QUOTA_RULE_ID
Primary Key: CN_QUOTA_RULES_UK1
  1. REVENUE_CLASS_ID
  2. QUOTA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_QUOTA_RULES_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
CN_QUOTA_RULES_ALL.QUOTA_ID CN_QUOTAS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMMISSION_LINES_ALL.QUOTA_RULE_ID CN_QUOTA_RULES_ALL
CN_QUOTA_RULE_UPLIFTS_ALL.QUOTA_RULE_ID CN_QUOTA_RULES_ALL
CN_SRP_QUOTA_RULES_ALL.QUOTA_RULE_ID CN_QUOTA_RULES_ALL
CN_TRX_FACTORS_ALL.QUOTA_RULE_ID CN_QUOTA_RULES_ALL

[top of page]

CN.CN_QUOTA_RULES_ALL does not reference any database object

CN.CN_QUOTA_RULES_ALL is referenced by following:

APPS
SYNONYM - CN_QUOTA_RULES
SYNONYM - CN_QUOTA_RULES_ALL
TRIGGER - CN_QUOTA_RULES_T1

[top of page]

Table: CN_QUOTA_RULE_UPLIFTS_ALL

Description: Contains information about the payment and target uplift percentage for revenue classes assigned to a plan element for specific date ranges.
Primary Key: CN_QUOTA_RULE_UPLIFTS_PK
  1. QUOTA_RULE_UPLIFT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_QUOTA_RULE_UPLIFTS_ALL.QUOTA_RULE_ID CN_QUOTA_RULES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_RULE_UPLIFTS_ALL.QUOTA_RULE_UPLIFT_ID CN_QUOTA_RULE_UPLIFTS_ALL

[top of page]

CN.CN_QUOTA_RULE_UPLIFTS_ALL does not reference any database object

CN.CN_QUOTA_RULE_UPLIFTS_ALL is referenced by following:

APPS
SYNONYM - CN_QUOTA_RULE_UPLIFTS
SYNONYM - CN_QUOTA_RULE_UPLIFTS_ALL
TRIGGER - CN_QUOTA_RULE_UPLIFTS_T1

[top of page]

Table: CN_RATE_DIMENSIONS_ALL

Description: Contains information about rate dimensions.
Primary Key: CN_RATE_DIMENSIONS_PK
  1. RATE_DIMENSION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_RATE_DIM_TIERS_ALL.RATE_DIMENSION_ID CN_RATE_DIMENSIONS_ALL
CN_RATE_SCH_DIMS_ALL.RATE_DIMENSION_ID CN_RATE_DIMENSIONS_ALL

[top of page]

CN.CN_RATE_DIMENSIONS_ALL does not reference any database object

CN.CN_RATE_DIMENSIONS_ALL is referenced by following:

APPS
SYNONYM - CN_RATE_DIMENSIONS
SYNONYM - CN_RATE_DIMENSIONS_ALL

[top of page]

Table: CN_RATE_DIM_TIERS_ALL

Description: Contains information about tiers for each rate dimension.
Primary Key: CN_RATE_DIM_TIERS_PK
  1. RATE_DIM_TIER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RATE_DIM_TIERS_ALL.RATE_DIMENSION_ID CN_RATE_DIMENSIONS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SCH_DIM_TIERS_ALL.RATE_DIM_TIER_ID CN_RATE_DIM_TIERS_ALL

[top of page]

CN.CN_RATE_DIM_TIERS_ALL does not reference any database object

CN.CN_RATE_DIM_TIERS_ALL is referenced by following:

APPS
SYNONYM - CN_RATE_DIM_TIERS
SYNONYM - CN_RATE_DIM_TIERS_ALL
TRIGGER - CN_RATE_DIM_TIERS_T1

[top of page]

Table: CN_RATE_SCHEDULES_ALL

Description: Compensation rate table
Primary Key: CN_RATE_SCHEDULES_PK
  1. RATE_SCHEDULE_ID
Primary Key: CN_RATE_SCHEDULES_UK1
  1. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_RATE_SCH_DIMS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_RATE_TIERS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_ROLE_QUOTA_RATES.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_RT_FORMULA_ASGNS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_RT_QUOTA_ASGNS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_SCH_DIM_TIERS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_SRP_QUOTA_ASSIGNS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_SRP_RATE_ASSIGNS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL

[top of page]

CN.CN_RATE_SCHEDULES_ALL does not reference any database object

CN.CN_RATE_SCHEDULES_ALL is referenced by following:

APPS
SYNONYM - CN_RATE_SCHEDULES
SYNONYM - CN_RATE_SCHEDULES_ALL

[top of page]

Table: CN_RATE_SCH_DIMS_ALL

Description: Contains information about rate dimensions assigned to each rate table
Primary Key: CN_RATE_SCH_DIMS_PK
  1. RATE_SCH_DIM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RATE_SCH_DIMS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_RATE_SCH_DIMS_ALL.RATE_DIMENSION_ID CN_RATE_DIMENSIONS_ALL

[top of page]

CN.CN_RATE_SCH_DIMS_ALL does not reference any database object

CN.CN_RATE_SCH_DIMS_ALL is referenced by following:

APPS
SYNONYM - CN_RATE_SCH_DIMS
SYNONYM - CN_RATE_SCH_DIMS_ALL

[top of page]

Table: CN_RATE_TIERS_ALL

Description: Compensation Rate Table
Primary Key: CN_RATE_TIERS_PK
  1. RATE_TIER_ID
Primary Key: CN_RATE_TIERS_UK1
  1. RATE_SCHEDULE_ID
Primary Key: CN_RATE_TIERS_UK2
  1. RATE_SCHEDULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RATE_TIERS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMMISSION_LINES_ALL.RATE_TIER_ID CN_RATE_TIERS_ALL
CN_ROLE_QUOTA_RATES.RATE_TIER_ID CN_RATE_TIERS_ALL
CN_SCH_DIM_TIERS_ALL.RATE_TIER_ID CN_RATE_TIERS_ALL
CN_SRP_RATE_ASSIGNS_ALL.RATE_TIER_ID CN_RATE_TIERS_ALL

[top of page]

CN.CN_RATE_TIERS_ALL does not reference any database object

CN.CN_RATE_TIERS_ALL is referenced by following:

APPS
SYNONYM - CN_RATE_TIERS
SYNONYM - CN_RATE_TIERS_ALL
TRIGGER - CN_RATE_TIERS_T1

[top of page]

Table: CN_REASONS_ALL

Description: This table contains user entered and system generated descriptions regarding changes made to the payment worksheet
Primary Key: CN_REASONS_PK
  1. REASON_ID

[top of page]

CN.CN_REASONS_ALL does not reference any database object

CN.CN_REASONS_ALL is referenced by following:

APPS
SYNONYM - CN_REASONS
SYNONYM - CN_REASONS_ALL

[top of page]

Table: CN_REASON_HISTORY_ALL

Description: This table is an audit table for CN_REASONS_ALL table. Whenever an update or a delete happens to the CN_REASONS_ALL table, this table records the change.

[top of page]

CN.CN_REASON_HISTORY_ALL does not reference any database object

CN.CN_REASON_HISTORY_ALL is referenced by following:

APPS
SYNONYM - CN_REASON_HISTORY
SYNONYM - CN_REASON_HISTORY_ALL

[top of page]

Table: CN_REPORT_TEMPLATES_GTT

Description:

[top of page]

CN.CN_REPORT_TEMPLATES_GTT does not reference any database object

CN.CN_REPORT_TEMPLATES_GTT is referenced by following:

APPS
SYNONYM - CN_REPORT_TEMPLATES_GTT

[top of page]

Table: CN_REPOSITORIES_ALL

Description: System parameters table
Primary Key: CN_REPOSITORIES_PK
  1. REPOSITORY_ID
  2. ORG_ID
Primary Key: CN_REPOSITORIES_UK1
  1. SCHEMA
  2. DATABASE_LINK
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_REPOSITORIES_ALL.SET_OF_BOOKS_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_EVENTS_ALL_B.APPLICATION_REPOSITORY_ID
CN_EVENTS_ALL_B.ORG_ID 		CN_REPOSITORIES_ALL
CN_MODULES_ALL_B.REPOSITORY_ID
CN_MODULES_ALL_B.ORG_ID 		CN_REPOSITORIES_ALL
CN_MODULES_ALL_B.SOURCE_REPOSITORY_ID
CN_MODULES_ALL_B.ORG_ID 		CN_REPOSITORIES_ALL
CN_OBJECTS_ALL.REPOSITORY_ID
CN_OBJECTS_ALL.ORG_ID 		CN_REPOSITORIES_ALL
CN_RULESETS_ALL_B.REPOSITORY_ID
CN_RULESETS_ALL_B.ORG_ID 		CN_REPOSITORIES_ALL

[top of page]

CN.CN_REPOSITORIES_ALL does not reference any database object

CN.CN_REPOSITORIES_ALL is referenced by following:

APPS
SYNONYM - CN_REPOSITORIES
SYNONYM - CN_REPOSITORIES_ALL
TRIGGER - CN_REPOSITORIES_T1

[top of page]

Table: CN_REVENUE_CLASSES_ALL

Description: Revenue classes.
Primary Key: CN_REVENUE_CLASSES_PK
  1. REVENUE_CLASS_ID
Primary Key: CN_REVENUE_CLASSES_UK1
  1. REPOSITORY_ID
  2. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMMISSION_HEADERS_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
CN_QUOTA_RULES_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
CN_RULES_ALL_B.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
CN_SRP_PER_QUOTA_RC_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
CN_SRP_QUOTA_RULES_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
CN_TRX_FACTORS_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL

[top of page]

CN.CN_REVENUE_CLASSES_ALL does not reference any database object

CN.CN_REVENUE_CLASSES_ALL is referenced by following:

APPS
SYNONYM - CN_REVENUE_CLASSES
SYNONYM - CN_REVENUE_CLASSES_ALL

[top of page]

Table: CN_ROLE_DETAILS

Description: CN_ROLE_DETAILS contain detail information of a sales role. These detail information are only used in salesforce planning.
Primary Key: CN_ROLE_DETAILS_PK
  1. ROLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ROLE_DETAILS.ATTAIN_SCHEDULE_ID CN_ATTAIN_SCHEDULES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_PLAN_TEXTS.ROLE_ID CN_ROLE_DETAILS
CN_ROLE_PLAN_MAPS.ROLE_ID CN_ROLE_DETAILS
CN_ROLE_QUOTA_CATES.ROLE_ID CN_ROLE_DETAILS

[top of page]

CN.CN_ROLE_DETAILS does not reference any database object

CN.CN_ROLE_DETAILS is referenced by following:

APPS
SYNONYM - CN_ROLE_DETAILS

[top of page]

Table: CN_ROLE_MODELS_ALL

Description: Stores the different agreement versions (models) for an agreement (corresponding to a role)
Primary Key: CN_ROLE_MODELS_PK
  1. ROLE_MODEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ROLE_MODELS_ALL.ATTAIN_SCHEDULE_ID CN_ATTAIN_SCHEDULES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_ROLE_QUOTA_CATES.ROLE_MODEL_ID CN_ROLE_MODELS_ALL
CN_SRP_QUOTA_CATES_ALL.ROLE_MODEL_ID CN_ROLE_MODELS_ALL
CN_SRP_ROLE_DTLS_ALL.ROLE_MODEL_ID CN_ROLE_MODELS_ALL

[top of page]

CN.CN_ROLE_MODELS_ALL does not reference any database object

CN.CN_ROLE_MODELS_ALL is referenced by following:

APPS
SYNONYM - CN_ROLE_MODELS
SYNONYM - CN_ROLE_MODELS_ALL

[top of page]

Table: CN_ROLE_PAY_GROUPS_ALL

Description: CN_ROLE_PAY_GROUPS_ALL contains information of pay groups assigned to sales role. You need one row for each pay group assignment to a sales role which is date effective.
Primary Key: SYS_C00135283
  1. ROLE_PAY_GROUP_ID

[top of page]

CN.CN_ROLE_PAY_GROUPS_ALL does not reference any database object

CN.CN_ROLE_PAY_GROUPS_ALL is referenced by following:

APPS
SYNONYM - CN_ROLE_PAY_GROUPS
SYNONYM - CN_ROLE_PAY_GROUPS_ALL

[top of page]

Table: CN_ROLE_PLANS_ALL

Description: Comp Plan Assignment to a Comp Role
Primary Key: CN_ROLE_PLANS_PK
  1. ROLE_PLAN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ROLE_PLANS_ALL.COMP_PLAN_ID CN_COMP_PLANS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_PLAN_ASSIGNS_ALL.ROLE_PLAN_ID CN_ROLE_PLANS_ALL

[top of page]

CN.CN_ROLE_PLANS_ALL does not reference any database object

CN.CN_ROLE_PLANS_ALL is referenced by following:

APPS
SYNONYM - CN_ROLE_PLANS
SYNONYM - CN_ROLE_PLANS_ALL
TRIGGER - CN_ROLE_PLANS_T

[top of page]

Table: CN_ROLE_PLAN_MAPS

Description: CN_ROLE_PLAN_MAPS contains the mapping between a sales role and compensation plan.
Primary Key: CN_ROLE_PLAN_MAPS_PK
  1. ROLE_PLAN_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ROLE_PLAN_MAPS.ROLE_ID CN_ROLE_DETAILS

[top of page]

CN.CN_ROLE_PLAN_MAPS does not reference any database object

CN.CN_ROLE_PLAN_MAPS is referenced by following:

APPS
SYNONYM - CN_ROLE_PLAN_MAPS

[top of page]

Table: CN_ROLE_PMT_PLANS_ALL

Description: CN_ROLE_PMT_PLANS_ALL contains information of payment plans assigned to sales role. You need one row for each payment plan assignment to a sales role which is date effective.

[top of page]

CN.CN_ROLE_PMT_PLANS_ALL does not reference any database object

CN.CN_ROLE_PMT_PLANS_ALL is referenced by following:

APPS
SYNONYM - CN_ROLE_PMT_PLANS
SYNONYM - CN_ROLE_PMT_PLANS_ALL

[top of page]

Table: CN_ROLE_QUOTA_CATES

Description: CN_ROLE_QUOTA_CATES contains information of assigning quota components to sales role.
Primary Key: CN_ROLE_QUOTA_CATES_PK
  1. ROLE_QUOTA_CATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ROLE_QUOTA_CATES.ROLE_ID CN_ROLE_DETAILS
CN_ROLE_QUOTA_CATES.QUOTA_CATEGORY_ID CN_QUOTA_CATEGORIES
CN_ROLE_QUOTA_CATES.ROLE_MODEL_ID CN_ROLE_MODELS_ALL
CN_ROLE_QUOTA_CATES.CALC_FORMULA_ID CN_CALC_FORMULAS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMP_ANCHORS.ROLE_QUOTA_CATE_ID CN_ROLE_QUOTA_CATES
CN_ROLE_QUOTA_FORMULAS.ROLE_QUOTA_CATE_ID CN_ROLE_QUOTA_CATES
CN_ROLE_QUOTA_RATES.ROLE_QUOTA_RATE_ID CN_ROLE_QUOTA_CATES
CN_SRP_QUOTA_CATES_ALL.ROLE_QUOTA_CATE_ID CN_ROLE_QUOTA_CATES

[top of page]

CN.CN_ROLE_QUOTA_CATES does not reference any database object

CN.CN_ROLE_QUOTA_CATES is referenced by following:

APPS
SYNONYM - CN_ROLE_QUOTA_CATES

[top of page]

Table: CN_ROLE_QUOTA_FORMULAS

Description: CN_ROLE_QUOTA_FORMULAS contains the calculation formulas of each computed quota components.
Primary Key: CN_ROLE_QUOTA_FORMULAS_PK
  1. ROLE_QUOTA_FORMULA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ROLE_QUOTA_FORMULAS.ROLE_QUOTA_CATE_ID CN_ROLE_QUOTA_CATES

[top of page]

CN.CN_ROLE_QUOTA_FORMULAS does not reference any database object

CN.CN_ROLE_QUOTA_FORMULAS is referenced by following:

APPS
SYNONYM - CN_ROLE_QUOTA_FORMULAS

[top of page]

Table: CN_ROLE_QUOTA_RATES

Description: CN_ROLE_QUOTA_RATES contains information of assigning rate table to a quota component of a sales role.
Primary Key: CN_ROLE_QUOTA_RATES_PK
  1. ROLE_QUOTA_RATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_ROLE_QUOTA_RATES.ROLE_QUOTA_RATE_ID CN_ROLE_QUOTA_CATES
CN_ROLE_QUOTA_RATES.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_ROLE_QUOTA_RATES.RATE_TIER_ID CN_RATE_TIERS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_QUOTA_RATES_ALL.ROLE_QUOTA_RATE_ID CN_ROLE_QUOTA_RATES

[top of page]

CN.CN_ROLE_QUOTA_RATES does not reference any database object

CN.CN_ROLE_QUOTA_RATES is referenced by following:

APPS
SYNONYM - CN_ROLE_QUOTA_RATES

[top of page]

Table: CN_ROLLOVER_QUOTAS_ALL

Description: Table defining rollover quota mapping information at plan element level

[top of page]

CN.CN_ROLLOVER_QUOTAS_ALL does not reference any database object

CN.CN_ROLLOVER_QUOTAS_ALL is referenced by following:

APPS
SYNONYM - CN_ROLLOVER_QUOTAS
SYNONYM - CN_ROLLOVER_QUOTAS_ALL

[top of page]

Table: CN_RT_FORMULA_ASGNS_ALL

Description: Contains information about assignment of rate tables to a calculation formula for specific date ranges
Primary Key: CN_RT_FORMULA_ASGNS_PK
  1. RT_FORMULA_ASGN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RT_FORMULA_ASGNS_ALL.CALC_FORMULA_ID CN_CALC_FORMULAS_ALL
CN_RT_FORMULA_ASGNS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL

[top of page]

CN.CN_RT_FORMULA_ASGNS_ALL does not reference any database object

CN.CN_RT_FORMULA_ASGNS_ALL is referenced by following:

APPS
SYNONYM - CN_RT_FORMULA_ASGNS
SYNONYM - CN_RT_FORMULA_ASGNS_ALL

[top of page]

Table: CN_RT_QUOTA_ASGNS_ALL

Description: Contains information about assignment of rate tables to a plan element for specific date ranges
Primary Key: CN_RT_QUOTA_ASGNS_PK
  1. RT_QUOTA_ASGN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RT_QUOTA_ASGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_RT_QUOTA_ASGNS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_RATE_ASSIGNS_ALL.RT_QUOTA_ASGN_ID CN_RT_QUOTA_ASGNS_ALL

[top of page]

CN.CN_RT_QUOTA_ASGNS_ALL does not reference any database object

CN.CN_RT_QUOTA_ASGNS_ALL is referenced by following:

APPS
SYNONYM - CN_RT_QUOTA_ASGNS
SYNONYM - CN_RT_QUOTA_ASGNS_ALL
TRIGGER - CN_RT_QUOTA_ASGNS_T1

[top of page]

Table: CN_RULESETS_ALL_B

Description: Rulesets for revenue classification rules.
Primary Key: CN_RULESETS_ALL_B_UK
  1. RULESET_ID
  2. ORG_ID
Primary Key: CN_RULESETS_PK
  1. RULESET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RULESETS_ALL_B.REPOSITORY_ID
CN_RULESETS_ALL_B.ORG_ID 		CN_REPOSITORIES_ALL
CN_RULESETS_ALL_B.DESTINATION_COLUMN_ID
CN_RULESETS_ALL_B.ORG_ID 		CN_OBJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_RULES_ALL_B.RULESET_ID CN_RULESETS_ALL_B

[top of page]

CN.CN_RULESETS_ALL_B does not reference any database object

CN.CN_RULESETS_ALL_B is referenced by following:

APPS
SYNONYM - CN_RULESETS_ALL_B
SYNONYM - CN_RULESETS_B
TRIGGER - CN_RULESETS_T1

[top of page]

Table: CN_RULESETS_ALL_TL

Description: Multi-Lingual Rulesets name for revenue classification rules.
Primary Key: CN_RULESETS_ALL_TL_UK
  1. RULESET_ID
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_RULESETS_ALL_TL does not reference any database object

CN.CN_RULESETS_ALL_TL is referenced by following:

APPS
SYNONYM - CN_RULESETS_ALL_TL

[top of page]

Table: CN_RULES_ALL_B

Description: Rules for revenue classification. Input to the revenue classification generator.
Primary Key: CN_RULES_ALL_B_UK
  1. RULE_ID
  2. RULESET_ID
  3. ORG_ID
Primary Key: CN_RULES_ALL_B_UK2
  1. RULE_LEVEL
Primary Key: CN_RULES_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RULES_ALL_B.RULESET_ID CN_RULESETS_ALL_B
CN_RULES_ALL_B.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_ATTRIBUTE_RULES_ALL.RULE_ID
CN_ATTRIBUTE_RULES_ALL.RULESET_ID
CN_ATTRIBUTE_RULES_ALL.ORG_ID 		CN_RULES_ALL_B
CN_RULES_HIERARCHY_ALL.RULE_ID
CN_RULES_HIERARCHY_ALL.RULESET_ID
CN_RULES_HIERARCHY_ALL.ORG_ID 		CN_RULES_ALL_B
CN_RULES_HIERARCHY_ALL.PARENT_RULE_ID
CN_RULES_HIERARCHY_ALL.RULESET_ID
CN_RULES_HIERARCHY_ALL.ORG_ID 		CN_RULES_ALL_B
CN_RULE_ATTR_EXPRESSION_ALL.RULE_ID CN_RULES_ALL_B

[top of page]

CN.CN_RULES_ALL_B does not reference any database object

CN.CN_RULES_ALL_B is referenced by following:

APPS
SYNONYM - CN_RULES_ALL_B
SYNONYM - CN_RULES_B

[top of page]

Table: CN_RULES_ALL_TL

Description: Multi-Lingual rules name for revenue classification. Input to the revenue classification generator.
Primary Key: CN_RULES_ALL_TL_UK
  1. RULE_ID
  2. RULESET_ID
  3. ORG_ID
  4. LANGUAGE

[top of page]

CN.CN_RULES_ALL_TL does not reference any database object

CN.CN_RULES_ALL_TL is referenced by following:

APPS
SYNONYM - CN_RULES_ALL_TL

[top of page]

Table: CN_RULES_HIERARCHY_ALL

Description: Hierarchy showing parent/child relationships for rules in CN_RULES.
Primary Key: CN_RULES_HIERARCHY_PK
  1. RULE_ID
Primary Key: CN_RULES_HIERARCHY_UK1
  1. PARENT_RULE_ID
  2. SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RULES_HIERARCHY_ALL.RULE_ID
CN_RULES_HIERARCHY_ALL.RULESET_ID
CN_RULES_HIERARCHY_ALL.ORG_ID 		CN_RULES_ALL_B
CN_RULES_HIERARCHY_ALL.PARENT_RULE_ID
CN_RULES_HIERARCHY_ALL.RULESET_ID
CN_RULES_HIERARCHY_ALL.ORG_ID 		CN_RULES_ALL_B

[top of page]

CN.CN_RULES_HIERARCHY_ALL does not reference any database object

CN.CN_RULES_HIERARCHY_ALL is referenced by following:

APPS
SYNONYM - CN_RULES_HIERARCHY
SYNONYM - CN_RULES_HIERARCHY_ALL

[top of page]

Table: CN_RULE_ATTR_EXPRESSION_ALL

Description: This table is used to store the expressions built using the rule attribute for a rule
Primary Key: CN_RULE_ATTR_EXPRESSION_ALL_PK
  1. RULE_ATTR_EXPRESSION_ID
Primary Key: CN_RULE_ATTR_EXPRESSION_ALL_UK
  1. RULE_ATTR_EXPRESSION_ID
  2. OPERAND_EXPRESSION_ID
  3. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_RULE_ATTR_EXPRESSION_ALL.RULE_ID CN_RULES_ALL_B

[top of page]

CN.CN_RULE_ATTR_EXPRESSION_ALL does not reference any database object

CN.CN_RULE_ATTR_EXPRESSION_ALL is referenced by following:

APPS
SYNONYM - CN_RULE_ATTR_EXPRESSION
SYNONYM - CN_RULE_ATTR_EXPRESSION_ALL

[top of page]

Table: CN_SALESREPS_API_ALL

Description: Not currently used
Primary Key: CN_SALESREPS_API_PK
  1. SALESREP_API_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMMISSION_LINES_ALL.CREDITED_SALESREP_ID CN_SALESREPS_API_ALL
CN_COMM_LINES_API_ALL.SALESREP_ID CN_SALESREPS_API_ALL
CN_PAYMENT_API_ALL.SALESREP_ID CN_SALESREPS_API_ALL
CN_PROCESS_BATCHES_ALL.SALESREP_ID CN_SALESREPS_API_ALL
CN_WORKSHEET_BONUSES_ALL.SALESREP_ID CN_SALESREPS_API_ALL

[top of page]

CN.CN_SALESREPS_API_ALL does not reference any database object

CN.CN_SALESREPS_API_ALL is referenced by following:

APPS
SYNONYM - CN_SALESREPS_API_ALL

[top of page]

Table: CN_SCA_ALLOCATIONS_ALL

Description: This table will keep the date ranges of each allocation percentages assigned to a credit rule.

[top of page]

CN.CN_SCA_ALLOCATIONS_ALL does not reference any database object

CN.CN_SCA_ALLOCATIONS_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_ALLOCATIONS
SYNONYM - CN_SCA_ALLOCATIONS_ALL

[top of page]

Table: CN_SCA_ALLOC_DETAILS_ALL

Description: Table with revenue and non-revenue percentage information for each allocation role

[top of page]

CN.CN_SCA_ALLOC_DETAILS_ALL does not reference any database object

CN.CN_SCA_ALLOC_DETAILS_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_ALLOC_DETAILS
SYNONYM - CN_SCA_ALLOC_DETAILS_ALL

[top of page]

Table: CN_SCA_COMBINATIONS_ALL

Description: This table holds unique Rule Attribute combinations used to build credit rules.

[top of page]

CN.CN_SCA_COMBINATIONS_ALL does not reference any database object

CN.CN_SCA_COMBINATIONS_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_COMBINATIONS
SYNONYM - CN_SCA_COMBINATIONS_ALL

[top of page]

Table: CN_SCA_CONDITIONS_ALL

Description: This table keeps list of Credit Rule Attributes associated with each Credit Rule.

[top of page]

CN.CN_SCA_CONDITIONS_ALL does not reference any database object

CN.CN_SCA_CONDITIONS_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_CONDITIONS
SYNONYM - CN_SCA_CONDITIONS_ALL
MATERIALIZED VIEW - CN_SCA_RULE_COND_VALS_MV

[top of page]

Table: CN_SCA_COND_DETAILS_ALL

Description: This table keeps condition operators and associated values

[top of page]

CN.CN_SCA_COND_DETAILS_ALL does not reference any database object

CN.CN_SCA_COND_DETAILS_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_COND_DETAILS
SYNONYM - CN_SCA_COND_DETAILS_ALL
MATERIALIZED VIEW - CN_SCA_RULE_COND_VALS_MV

[top of page]

Table: CN_SCA_CREDIT_RULES_ALL

Description: This table holds the Sales Credit Rule definition.

[top of page]

CN.CN_SCA_CREDIT_RULES_ALL does not reference any database object

CN.CN_SCA_CREDIT_RULES_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_CREDIT_RULES
SYNONYM - CN_SCA_CREDIT_RULES_ALL

[top of page]

Table: CN_SCA_DENORM_RULES_ALL

Description: This table holds the denormalized version of the Sales Credit Rules

[top of page]

CN.CN_SCA_DENORM_RULES_ALL does not reference any database object

CN.CN_SCA_DENORM_RULES_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_DENORM_RULES
SYNONYM - CN_SCA_DENORM_RULES_ALL
MATERIALIZED VIEW - CN_SCA_RULE_COND_VALS_MV

[top of page]

Table: CN_SCA_HEADERS_INTERFACE_ALL

Description: This table holds the transactions those needs to be processed by Sales Credit Engine.

[top of page]

CN.CN_SCA_HEADERS_INTERFACE_ALL does not reference any database object

CN.CN_SCA_HEADERS_INTERFACE_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_HEADERS_INTERFACE
SYNONYM - CN_SCA_HEADERS_INTERFACE_ALL

[top of page]

Table: CN_SCA_LINES_INTERFACE_ALL

Description: This table holds corresponding resources and their roles for each transaction of CN_SCA_HEADERS_INTERFACE_ALL

[top of page]

CN.CN_SCA_LINES_INTERFACE_ALL does not reference any database object

CN.CN_SCA_LINES_INTERFACE_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_LINES_INTERFACE
SYNONYM - CN_SCA_LINES_INTERFACE_ALL

[top of page]

Table: CN_SCA_LINES_OUTPUT_ALL

Description: Table for storing allocation results

[top of page]

CN.CN_SCA_LINES_OUTPUT_ALL does not reference any database object

CN.CN_SCA_LINES_OUTPUT_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_LINES_OUTPUT
SYNONYM - CN_SCA_LINES_OUTPUT_ALL

[top of page]

Table: CN_SCA_MATCHES_ALL

Description: This table to store the matching information between transactions and credit rules

[top of page]

CN.CN_SCA_MATCHES_ALL does not reference any database object

CN.CN_SCA_MATCHES_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_MATCHES
SYNONYM - CN_SCA_MATCHES_ALL

[top of page]

Table: CN_SCA_PROCESS_BATCHES_ALL

Description: Table for batch submission information for sales credit allocation

[top of page]

CN.CN_SCA_PROCESS_BATCHES_ALL does not reference any database object

CN.CN_SCA_PROCESS_BATCHES_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_PROCESS_BATCHES
SYNONYM - CN_SCA_PROCESS_BATCHES_ALL

[top of page]

Table: CN_SCA_RULE_ATTRIBUTES_ALL_B

Description: This base table keeps Credit Rule Attributes definition
Primary Key: CN_SCA_RULE_ATT_ALL_B_UK
  1. SCA_RULE_ATTRIBUTE_ID
  2. ORG_ID

[top of page]

CN.CN_SCA_RULE_ATTRIBUTES_ALL_B does not reference any database object

CN.CN_SCA_RULE_ATTRIBUTES_ALL_B is referenced by following:

APPS
SYNONYM - CN_SCA_RULE_ATTRIBUTES_ALL_B
SYNONYM - CN_SCA_RULE_ATTRIBUTES_B

[top of page]

Table: CN_SCA_RULE_ATTRIBUTES_ALL_TL

Description: This table keeps the translatable information of Credit Rule Attribute definition.
Primary Key: CN_SCA_RULE_ATT_ALL_TL_UK
  1. SCA_RULE_ATTRIBUTE_ID
  2. ORG_ID
  3. LANGUAGE

[top of page]

CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL does not reference any database object

CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL is referenced by following:

APPS
SYNONYM - CN_SCA_RULE_ATTRIBUTES_ALL_TL

[top of page]

Table: CN_SCA_WINNERS_ALL

Description: Tthis table to keep the winning rule information sales credit allocation

[top of page]

CN.CN_SCA_WINNERS_ALL does not reference any database object

CN.CN_SCA_WINNERS_ALL is referenced by following:

APPS
SYNONYM - CN_SCA_WINNERS
SYNONYM - CN_SCA_WINNERS_ALL

[top of page]

Table: CN_SCH_DIM_TIERS_ALL

Description: Contains information about the rate cube defined by the combination of rate tiers of each rate dimension assigned to the rate table
Primary Key: CN_SCH_DIM_TIERS_PK
  1. SCH_DIM_TIER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SCH_DIM_TIERS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_SCH_DIM_TIERS_ALL.RATE_DIM_TIER_ID CN_RATE_DIM_TIERS_ALL
CN_SCH_DIM_TIERS_ALL.RATE_TIER_ID CN_RATE_TIERS_ALL

[top of page]

CN.CN_SCH_DIM_TIERS_ALL does not reference any database object

CN.CN_SCH_DIM_TIERS_ALL is referenced by following:

APPS
SYNONYM - CN_SCH_DIM_TIERS
SYNONYM - CN_SCH_DIM_TIERS_ALL

[top of page]

Table: CN_SEASONALITIES_ALL

Description: Table storing seasonalities associated with seasonality schedules by interval type

[top of page]

CN.CN_SEASONALITIES_ALL does not reference any database object

CN.CN_SEASONALITIES_ALL is referenced by following:

APPS
SYNONYM - CN_SEASONALITIES
SYNONYM - CN_SEASONALITIES_ALL

[top of page]

Table: CN_SEAS_SCHEDULES_ALL

Description: Table storing seasonality schedules

[top of page]

CN.CN_SEAS_SCHEDULES_ALL does not reference any database object

CN.CN_SEAS_SCHEDULES_ALL is referenced by following:

APPS
SYNONYM - CN_SEAS_SCHEDULES
SYNONYM - CN_SEAS_SCHEDULES_ALL

[top of page]

Table: CN_SECURITY_PROFILES_ALL

Description: Contains information of salesperson who can be associated with other salespersons to access their information but not for transaction rollup during calculation.
Primary Key: CN_SECURITY_PROFILES_PK
  1. SECURITY_PROFILE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SEC_PROF_ASSIGNS_ALL.SECURITY_PROFILE_ID CN_SECURITY_PROFILES_ALL

[top of page]

CN.CN_SECURITY_PROFILES_ALL does not reference any database object

CN.CN_SECURITY_PROFILES_ALL is referenced by following:

APPS
SYNONYM - CN_SECURITY_PROFILES
SYNONYM - CN_SECURITY_PROFILES_ALL

[top of page]

Table: CN_SEC_PROF_ASSIGNS_ALL

Description: Contains information all the salespeople assigned to a salesperson who can access their information but not for transaction rollup during calculation.
Primary Key: CN_SEC_PROF_ASSIGNS_PK
  1. SEC_PROF_ASSIGN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SEC_PROF_ASSIGNS_ALL.SECURITY_PROFILE_ID CN_SECURITY_PROFILES_ALL

[top of page]

CN.CN_SEC_PROF_ASSIGNS_ALL does not reference any database object

CN.CN_SEC_PROF_ASSIGNS_ALL is referenced by following:

APPS
SYNONYM - CN_SEC_PROF_ASSIGNS
SYNONYM - CN_SEC_PROF_ASSIGNS_ALL

[top of page]

Table: CN_SF_REPOSITORIES_ALL

Description: CN_SF_REPOSITORIES stores default contract title, terms and conditions information .
Primary Key: CN_SF_REPOSITORIES_PK
  1. REPOSITORY_ID

[top of page]

CN.CN_SF_REPOSITORIES_ALL does not reference any database object

CN.CN_SF_REPOSITORIES_ALL is referenced by following:

APPS
SYNONYM - CN_SF_REPOSITORIES
SYNONYM - CN_SF_REPOSITORIES_ALL

[top of page]

Table: CN_SOURCE_ALL

Description: Stores the dynamically generated code from the Classification and Collection code generators.
Primary Key: CN_SOURCE_PK
  1. SOURCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SOURCE_ALL.OBJECT_ID
CN_SOURCE_ALL.ORG_ID 		CN_OBJECTS_ALL

[top of page]

CN.CN_SOURCE_ALL does not reference any database object

CN.CN_SOURCE_ALL is referenced by following:

APPS
SYNONYM - CN_SOURCE
SYNONYM - CN_SOURCE_ALL

[top of page]

Table: CN_SRP_CNRT_HISTORY_ALL

Description: CN_SRP_CNRT_HISTORY contains the history information of salespeople's compensation contract .
Primary Key: CN_SRP_CNRT_HISTORY_PK
  1. SRP_CNRT_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_CNRT_HISTORY_ALL.SRP_ROLE_ID CN_SRP_ROLE_DTLS_ALL

[top of page]

CN.CN_SRP_CNRT_HISTORY_ALL does not reference any database object

CN.CN_SRP_CNRT_HISTORY_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_CNRT_HISTORY
SYNONYM - CN_SRP_CNRT_HISTORY_ALL

[top of page]

Table: CN_SRP_COMP_ANCHORS_ALL

Description: Table storing anchor information at the salesperson (resource) level

[top of page]

CN.CN_SRP_COMP_ANCHORS_ALL does not reference any database object

CN.CN_SRP_COMP_ANCHORS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_COMP_ANCHORS
SYNONYM - CN_SRP_COMP_ANCHORS_ALL

[top of page]

Table: CN_SRP_DATA_SUMM_F

Description: CN_SRP_DATA_SUMM_F is a summary table on top of CN_SRP_PERIOD_QUOTAS_ALL table. This table keeps the total commission amount and quota amount for each salesperson per period.

[top of page]

CN.CN_SRP_DATA_SUMM_F does not reference any database object

CN.CN_SRP_DATA_SUMM_F is referenced by following:

APPS
SYNONYM - CN_SRP_DATA_SUMM_F

[top of page]

Table: CN_SRP_DENORM_DATA_ALL

Description: The denormalized table to store the salesperson's data.

[top of page]

CN.CN_SRP_DENORM_DATA_ALL does not reference any database object

CN.CN_SRP_DENORM_DATA_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_DENORM_DATA
SYNONYM - CN_SRP_DENORM_DATA_ALL

[top of page]

Table: CN_SRP_DENORM_DATA_BCK_ALL

Description: This is a backup table to CN_SRP_DENORM_DATA_ALL

[top of page]

CN.CN_SRP_DENORM_DATA_BCK_ALL does not reference any database object

CN.CN_SRP_DENORM_DATA_BCK_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_DENORM_DATA_BCK
SYNONYM - CN_SRP_DENORM_DATA_BCK_ALL

[top of page]

Table: CN_SRP_INTEL_PERIODS_ALL

Description: Contains information on processing status and transaction processing flag for the salesperson in a particular period
Primary Key: CN_SRP_INTEL_PERIODS_PK
  1. SRP_INTEL_PERIOD_ID

[top of page]

CN.CN_SRP_INTEL_PERIODS_ALL does not reference any database object

CN.CN_SRP_INTEL_PERIODS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_INTEL_PERIODS
SYNONYM - CN_SRP_INTEL_PERIODS_ALL

[top of page]

Table: CN_SRP_PAYEE_ASSIGNS_ALL

Description: CN_SRP_PAYEE_ASSIGNS_ALL contains information of payees assigned to salesperson plan element. You need one row for each payee assignment to a saleperson plan element which is date effective.
Primary Key: CN_SRP_PAYEE_ASSIGNS_PK
  1. SRP_PAYEE_ASSIGN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_PAYEE_ASSIGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_SRP_PAYEE_ASSIGNS_ALL.SRP_QUOTA_ASSIGN_ID CN_SRP_QUOTA_ASSIGNS_ALL

[top of page]

CN.CN_SRP_PAYEE_ASSIGNS_ALL does not reference any database object

CN.CN_SRP_PAYEE_ASSIGNS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PAYEE_ASSIGNS
SYNONYM - CN_SRP_PAYEE_ASSIGNS_ALL

[top of page]

Table: CN_SRP_PAYOUT_DTLS_ALL

Description: This table stores the models payout details for each quota component at different attainment tier levels

[top of page]

CN.CN_SRP_PAYOUT_DTLS_ALL does not reference any database object

CN.CN_SRP_PAYOUT_DTLS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PAYOUT_DTLS
SYNONYM - CN_SRP_PAYOUT_DTLS_ALL

[top of page]

Table: CN_SRP_PAY_GROUPS_ALL

Description: CN_SRP_PAY_GROUPS contains information about the payment group each salesperson is assigned to. At any time a salesperson can have only one assigned payment group. Date effective range can be specified for each pay group assignment to a sa
Primary Key: CN_SRP_PAY_GROUPS_PK
  1. SRP_PAY_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_PAY_GROUPS_ALL.PAY_GROUP_ID CN_PAY_GROUPS_ALL

[top of page]

CN.CN_SRP_PAY_GROUPS_ALL does not reference any database object

CN.CN_SRP_PAY_GROUPS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PAY_GROUPS
SYNONYM - CN_SRP_PAY_GROUPS_ALL

[top of page]

Table: CN_SRP_PERIODS_ALL

Description: Salesperson compensation by period
Primary Key: CN_SRP_PERIODS_PK
  1. SRP_PERIOD_ID
Primary Key: CN_SRP_PERIODS_UK1
  1. SALESREP_ID
  2. PERIOD_ID
  3. CREDIT_TYPE_ID
  4. ROLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_PERIODS_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_SRP_PERIODS_ALL.CREDIT_TYPE_ID CN_CREDIT_TYPES_ALL_B
CN_SRP_PERIODS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_LEDGER_JOURNAL_ENTRIES_ALL.SRP_PERIOD_ID CN_SRP_PERIODS_ALL
CN_PROCESS_BATCHES_ALL.SRP_PERIOD_ID CN_SRP_PERIODS_ALL

[top of page]

CN.CN_SRP_PERIODS_ALL does not reference any database object

CN.CN_SRP_PERIODS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PERIODS
SYNONYM - CN_SRP_PERIODS_ALL

[top of page]

Table: CN_SRP_PERIOD_PAYEES_ALL

Description: Internal process tables which maintains information for a payee as part of calculation
Primary Key: CN_SRP_PERIOD_PAYEES_PK
  1. SRP_PERIOD_PAYEE_ID

[top of page]

CN.CN_SRP_PERIOD_PAYEES_ALL does not reference any database object

CN.CN_SRP_PERIOD_PAYEES_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PERIOD_PAYEES
SYNONYM - CN_SRP_PERIOD_PAYEES_ALL

[top of page]

Table: CN_SRP_PERIOD_QUOTAS_ALL

Description: Salesperson Plan Elements by Period
Primary Key: CN_SRP_PERIOD_QUOTAS_PK
  1. SRP_PERIOD_QUOTA_ID
Primary Key: CN_SRP_PERIOD_QUOTAS_UK1
  1. SRP_QUOTA_ASSIGN_ID
  2. PERIOD_ID
Primary Key: CN_SRP_PERIOD_QUOTAS_UK2
  1. SALESREP_ID
  2. PERIOD_ID
  3. QUOTA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_PERIOD_QUOTAS_ALL.PERIOD_ID CN_PERIOD_STATUSES_ALL
CN_SRP_PERIOD_QUOTAS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_PERIOD_QUOTAS_ALL.SRP_QUOTA_ASSIGN_ID CN_SRP_QUOTA_ASSIGNS_ALL
CN_SRP_PERIOD_QUOTAS_ALL.QUOTA_ID CN_QUOTAS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_PER_QUOTA_RC_ALL.SRP_PERIOD_QUOTA_ID CN_SRP_PERIOD_QUOTAS_ALL

[top of page]

CN.CN_SRP_PERIOD_QUOTAS_ALL does not reference any database object

CN.CN_SRP_PERIOD_QUOTAS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PERIOD_QUOTAS
SYNONYM - CN_SRP_PERIOD_QUOTAS_ALL
TRIGGER - CN_SRP_PERIOD_QUOTAS_T1

[top of page]

Table: CN_SRP_PERIOD_QUOTAS_EXT_ALL

Description: An extension of CN_SRP_PERIOD_QUOTAS_ALL to handle accumulation of multiple inputs

[top of page]

CN.CN_SRP_PERIOD_QUOTAS_EXT_ALL does not reference any database object

CN.CN_SRP_PERIOD_QUOTAS_EXT_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PERIOD_QUOTAS_EXT
SYNONYM - CN_SRP_PERIOD_QUOTAS_EXT_ALL

[top of page]

Table: CN_SRP_PER_QUOTA_RC_ALL

Description: Salesperson Revenue Classes by Period
Primary Key: CN_SRP_PER_QUOTA_RC_PK
  1. SRP_PER_QUOTA_RC_ID
Primary Key: CN_SRP_PER_QUOTA_RC_UK1
  1. SRP_PERIOD_QUOTA_ID
  2. REVENUE_CLASS_ID
Primary Key: CN_SRP_PER_QUOTA_RC_UK2
  1. SALESREP_ID
  2. PERIOD_ID
  3. QUOTA_ID
  4. REVENUE_CLASS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_PER_QUOTA_RC_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_PER_QUOTA_RC_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_SRP_PER_QUOTA_RC_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
CN_SRP_PER_QUOTA_RC_ALL.SRP_PERIOD_QUOTA_ID CN_SRP_PERIOD_QUOTAS_ALL

[top of page]

CN.CN_SRP_PER_QUOTA_RC_ALL does not reference any database object

CN.CN_SRP_PER_QUOTA_RC_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PER_QUOTA_RC
SYNONYM - CN_SRP_PER_QUOTA_RC_ALL

[top of page]

Table: CN_SRP_PLAN_ASSIGNS_ALL

Description: Salesperson Plan Assignments
Primary Key: CN_SRP_PLAN_ASSIGNS_PK
  1. SRP_PLAN_ASSIGN_ID
Primary Key: CN_SRP_PLAN_ASSIGNS_UK1
  1. SALESREP_ID
  2. COMP_PLAN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_PLAN_ASSIGNS_ALL.COMP_PLAN_ID CN_COMP_PLANS_ALL
CN_SRP_PLAN_ASSIGNS_ALL.ROLE_PLAN_ID CN_ROLE_PLANS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_POSTING_DETAILS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_PERIODS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_PERIOD_QUOTAS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_PER_QUOTA_RC_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_QUOTA_ASSIGNS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_QUOTA_RULES_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_RATE_ASSIGNS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL

[top of page]

CN.CN_SRP_PLAN_ASSIGNS_ALL does not reference any database object

CN.CN_SRP_PLAN_ASSIGNS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PLAN_ASSIGNS
SYNONYM - CN_SRP_PLAN_ASSIGNS_ALL

[top of page]

Table: CN_SRP_PMT_PLANS_ALL

Description: CN_SRP_PMT_PLANS contains information of payment plans assigned to salespeople. You need one row for each payment plan assignment to a saleperson which is date effective.
Primary Key: CN_SRP_PMT_PLANS_ALL_PK
  1. SRP_PMT_PLAN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_PMT_PLANS_ALL.PMT_PLAN_ID CN_PMT_PLANS_ALL

[top of page]

CN.CN_SRP_PMT_PLANS_ALL does not reference any database object

CN.CN_SRP_PMT_PLANS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_PMT_PLANS
SYNONYM - CN_SRP_PMT_PLANS_ALL

[top of page]

Table: CN_SRP_QUOTA_ASSIGNS_ALL

Description: Salesperson Plan Element Assignments
Primary Key: CN_SRP_QUOTA_ASSIGNS_PK
  1. SRP_QUOTA_ASSIGN_ID
Primary Key: CN_SRP_QUOTA_ASSIGNS_UK1
  1. SRP_PLAN_ASSIGN_ID
  2. QUOTA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_QUOTA_ASSIGNS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_QUOTA_ASSIGNS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_SRP_QUOTA_ASSIGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_PAYEE_ASSIGNS_ALL.SRP_QUOTA_ASSIGN_ID CN_SRP_QUOTA_ASSIGNS_ALL
CN_SRP_PERIOD_QUOTAS_ALL.SRP_QUOTA_ASSIGN_ID CN_SRP_QUOTA_ASSIGNS_ALL
CN_SRP_QUOTA_RULES_ALL.SRP_QUOTA_ASSIGN_ID CN_SRP_QUOTA_ASSIGNS_ALL
CN_SRP_RATE_ASSIGNS_ALL.SRP_QUOTA_ASSIGN_ID CN_SRP_QUOTA_ASSIGNS_ALL

[top of page]

CN.CN_SRP_QUOTA_ASSIGNS_ALL does not reference any database object

CN.CN_SRP_QUOTA_ASSIGNS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_QUOTA_ASSIGNS
SYNONYM - CN_SRP_QUOTA_ASSIGNS_ALL
TRIGGER - CN_SRP_QUOTA_ASSIGNS_T1

[top of page]

Table: CN_SRP_QUOTA_CATES_ALL

Description: CN_SRP_QUOTA_CATES contains information of quota components assigned to salesperson.
Primary Key: CN_SRP_QUOTA_CATES_PK
  1. SRP_QUOTA_CATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_QUOTA_CATES_ALL.SRP_ROLE_ID CN_SRP_ROLE_DTLS_ALL
CN_SRP_QUOTA_CATES_ALL.ROLE_QUOTA_CATE_ID CN_ROLE_QUOTA_CATES
CN_SRP_QUOTA_CATES_ALL.ROLE_MODEL_ID CN_ROLE_MODELS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_QUOTA_RATES_ALL.SRP_QUOTA_CATE_ID CN_SRP_QUOTA_CATES_ALL

[top of page]

CN.CN_SRP_QUOTA_CATES_ALL does not reference any database object

CN.CN_SRP_QUOTA_CATES_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_QUOTA_CATES
SYNONYM - CN_SRP_QUOTA_CATES_ALL

[top of page]

Table: CN_SRP_QUOTA_RATES_ALL

Description: CN_SRP_QUOTA_RATES contains information of quota component's rate table assigned to salesperson.
Primary Key: CN_SRP_QUOTA_RATES_PK
  1. SRP_QUOTA_RATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_QUOTA_RATES_ALL.SRP_QUOTA_CATE_ID CN_SRP_QUOTA_CATES_ALL
CN_SRP_QUOTA_RATES_ALL.ROLE_QUOTA_RATE_ID CN_ROLE_QUOTA_RATES

[top of page]

CN.CN_SRP_QUOTA_RATES_ALL does not reference any database object

CN.CN_SRP_QUOTA_RATES_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_QUOTA_RATES
SYNONYM - CN_SRP_QUOTA_RATES_ALL

[top of page]

Table: CN_SRP_QUOTA_RULES_ALL

Description: Salesperson Revenue Classes
Primary Key: CN_SRP_QUOTA_RULES_PK
  1. SRP_QUOTA_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_QUOTA_RULES_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_QUOTA_RULES_ALL.SRP_QUOTA_ASSIGN_ID CN_SRP_QUOTA_ASSIGNS_ALL
CN_SRP_QUOTA_RULES_ALL.QUOTA_RULE_ID CN_QUOTA_RULES_ALL
CN_SRP_QUOTA_RULES_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_RULE_UPLIFTS_ALL.SRP_QUOTA_RULE_ID CN_SRP_QUOTA_RULES_ALL

[top of page]

CN.CN_SRP_QUOTA_RULES_ALL does not reference any database object

CN.CN_SRP_QUOTA_RULES_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_QUOTA_RULES
SYNONYM - CN_SRP_QUOTA_RULES_ALL

[top of page]

Table: CN_SRP_RATE_ASSIGNS_ALL

Description: Salesperson Rate Tiers
Primary Key: CN_SRP_RATE_ASSIGNS_PK
  1. SRP_QUOTA_ASSIGN_ID
  2. RATE_TIER_ID
Primary Key: CN_SRP_RATE_ASSIGNS_UK1
  1. RATE_TIER_ID
  2. SRP_QUOTA_ASSIGN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_RATE_ASSIGNS_ALL.SRP_PLAN_ASSIGN_ID CN_SRP_PLAN_ASSIGNS_ALL
CN_SRP_RATE_ASSIGNS_ALL.SRP_QUOTA_ASSIGN_ID CN_SRP_QUOTA_ASSIGNS_ALL
CN_SRP_RATE_ASSIGNS_ALL.RATE_SCHEDULE_ID CN_RATE_SCHEDULES_ALL
CN_SRP_RATE_ASSIGNS_ALL.QUOTA_ID CN_QUOTAS_ALL
CN_SRP_RATE_ASSIGNS_ALL.RT_QUOTA_ASGN_ID CN_RT_QUOTA_ASGNS_ALL
CN_SRP_RATE_ASSIGNS_ALL.RATE_TIER_ID CN_RATE_TIERS_ALL

[top of page]

CN.CN_SRP_RATE_ASSIGNS_ALL does not reference any database object

CN.CN_SRP_RATE_ASSIGNS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_RATE_ASSIGNS
SYNONYM - CN_SRP_RATE_ASSIGNS_ALL
TRIGGER - CN_SRP_RATE_ASSIGNS_T1

[top of page]

Table: CN_SRP_ROLE_DTLS_ALL

Description: CN_SRP_ROLE_DTLS contains the detail information of sales role assigned to salesperson.
Primary Key: CN_SRP_ROLE_DTLS_PK
  1. SRP_ROLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_ROLE_DTLS_ALL.ROLE_MODEL_ID CN_ROLE_MODELS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_SRP_CNRT_HISTORY_ALL.SRP_ROLE_ID CN_SRP_ROLE_DTLS_ALL
CN_SRP_QUOTA_CATES_ALL.SRP_ROLE_ID CN_SRP_ROLE_DTLS_ALL
CN_SRP_ROLE_HISTORY_ALL.SRP_ROLE_ID CN_SRP_ROLE_DTLS_ALL

[top of page]

CN.CN_SRP_ROLE_DTLS_ALL does not reference any database object

CN.CN_SRP_ROLE_DTLS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_ROLE_DTLS
SYNONYM - CN_SRP_ROLE_DTLS_ALL

[top of page]

Table: CN_SRP_ROLE_HISTORY_ALL

Description: CN_SRP_ROLE_HISTORY contains the history information of each sales role and salesperson assignments.
Primary Key: CN_SRP_HISTORY_PK
  1. SRP_ROLE_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_ROLE_HISTORY_ALL.SRP_ROLE_ID CN_SRP_ROLE_DTLS_ALL

[top of page]

CN.CN_SRP_ROLE_HISTORY_ALL does not reference any database object

CN.CN_SRP_ROLE_HISTORY_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_ROLE_HISTORY
SYNONYM - CN_SRP_ROLE_HISTORY_ALL

[top of page]

Table: CN_SRP_ROLLOVER_QUOTAS_ALL

Description: Table defining rollover quota mapping information at salesperson level

[top of page]

CN.CN_SRP_ROLLOVER_QUOTAS_ALL does not reference any database object

CN.CN_SRP_ROLLOVER_QUOTAS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_ROLLOVER_QUOTAS
SYNONYM - CN_SRP_ROLLOVER_QUOTAS_ALL

[top of page]

Table: CN_SRP_RULE_UPLIFTS_ALL

Description: CN_SRP_RULE_UPLIFTS_ALL contains information of revenue class uplift factors assigned to a salesperson's plan element. You need one row for each revenue class uplift factors (Payment factor and Quota factor) assigned to a plan element with
Primary Key: CN_SRP_RULE_UPLIFTS_ALL_PK
  1. SRP_RULE_UPLIFT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_SRP_RULE_UPLIFTS_ALL.SRP_QUOTA_RULE_ID CN_SRP_QUOTA_RULES_ALL
CN_SRP_RULE_UPLIFTS_ALL.QUOTA_RULE_UPLIFT_ID CN_QUOTA_RULE_UPLIFTS_ALL

[top of page]

CN.CN_SRP_RULE_UPLIFTS_ALL does not reference any database object

CN.CN_SRP_RULE_UPLIFTS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_RULE_UPLIFTS
SYNONYM - CN_SRP_RULE_UPLIFTS_ALL
TRIGGER - CN_SRP_RULE_UPLIFTS_T1

[top of page]

Table: CN_SRP_TOTAL_COMPS_ALL

Description: Total compensation for fixed and quota based components of a given model for a given attainment tier.
Primary Key: CN_SRP_TOTAL_COMPS_PK
  1. SRP_TOTAL_COMP_ID

[top of page]

CN.CN_SRP_TOTAL_COMPS_ALL does not reference any database object

CN.CN_SRP_TOTAL_COMPS_ALL is referenced by following:

APPS
SYNONYM - CN_SRP_TOTAL_COMPS
SYNONYM - CN_SRP_TOTAL_COMPS_ALL

[top of page]

Table: CN_TABLE_MAPS_ALL

Description: Maps source tables to destination tables for AR column mappings.
Primary Key: CN_TABLE_MAPS_PK
  1. TABLE_MAP_ID
  2. ORG_ID
Primary Key: CN_TABLE_MAPS_UK1
  1. DESTINATION_TABLE_ID
  2. SOURCE_TABLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_TABLE_MAPS_ALL.SOURCE_TABLE_ID
CN_TABLE_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL
CN_TABLE_MAPS_ALL.MODULE_ID
CN_TABLE_MAPS_ALL.ORG_ID 		CN_MODULES_ALL_B
CN_TABLE_MAPS_ALL.DESTINATION_TABLE_ID
CN_TABLE_MAPS_ALL.ORG_ID 		CN_OBJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COLUMN_MAPS_ALL.TABLE_MAP_ID
CN_COLUMN_MAPS_ALL.ORG_ID 		CN_TABLE_MAPS_ALL

[top of page]

CN.CN_TABLE_MAPS_ALL does not reference any database object

CN.CN_TABLE_MAPS_ALL is referenced by following:

APPS
SYNONYM - CN_TABLE_MAPS
SYNONYM - CN_TABLE_MAPS_ALL

[top of page]

Table: CN_TABLE_MAP_OBJECTS_ALL

Description: List of objects (in CN_OBJECTS) associated with Collections transaction sources.
Primary Key: CN_TABLE_MAP_OBJECTS_PK
  1. TABLE_MAP_OBJECT_ID
Primary Key: CN_TABLE_MAP_OBJECT_UK1
  1. TABLE_MAP_OBJECT_ID
  2. ORG_ID

[top of page]

CN.CN_TABLE_MAP_OBJECTS_ALL does not reference any database object

CN.CN_TABLE_MAP_OBJECTS_ALL is referenced by following:

APPS
SYNONYM - CN_TABLE_MAP_OBJECTS
SYNONYM - CN_TABLE_MAP_OBJECTS_ALL

[top of page]

Table: CN_TRX_ALL

Description: Contains CN transactions picked up in the AR data collection process.
Primary Key: CN_TRX_PK
  1. TRX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_TRX_ALL.NOT_TRX_ID CN_NOT_TRX_ALL
CN_TRX_ALL.SOURCE_TRX_ID RA_CUSTOMER_TRX_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMM_LINES_API_ALL.TRX_ID CN_TRX_ALL
CN_TRX_LINES_ALL.TRX_ID CN_TRX_ALL
CN_TRX_SALES_LINES_ALL.TRX_ID CN_TRX_ALL

[top of page]

CN.CN_TRX_ALL does not reference any database object

CN.CN_TRX_ALL is referenced by following:

APPS
SYNONYM - CN_TRX
SYNONYM - CN_TRX_ALL

[top of page]

Table: CN_TRX_BATCHES_ALL

Description: Group for cn_commission_lines
Primary Key: CN_TRX_BATCHES_PK
  1. TRX_BATCH_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_TRX_BATCHES_ALL.PROCESS_AUDIT_ID CN_PROCESS_AUDITS_ALL

[top of page]

CN.CN_TRX_BATCHES_ALL does not reference any database object

CN.CN_TRX_BATCHES_ALL is referenced by following:

APPS
SYNONYM - CN_TRX_BATCHES
SYNONYM - CN_TRX_BATCHES_ALL

[top of page]

Table: CN_TRX_FACTORS_ALL

Description: Revenue class transaction factors
Primary Key: CN_TRX_FACTORS_PK
  1. TRX_FACTOR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_TRX_FACTORS_ALL.REVENUE_CLASS_ID CN_REVENUE_CLASSES_ALL
CN_TRX_FACTORS_ALL.QUOTA_RULE_ID CN_QUOTA_RULES_ALL
CN_TRX_FACTORS_ALL.QUOTA_ID CN_QUOTAS_ALL

[top of page]

CN.CN_TRX_FACTORS_ALL does not reference any database object

CN.CN_TRX_FACTORS_ALL is referenced by following:

APPS
SYNONYM - CN_TRX_FACTORS
SYNONYM - CN_TRX_FACTORS_ALL
TRIGGER - CN_TRX_FACTORS_T1

[top of page]

Table: CN_TRX_LINES_ALL

Description: Contains CN transactions picked up in the AR data collection process.
Primary Key: CN_TRX_LINES_PK
  1. TRX_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_TRX_LINES_ALL.TRX_ID CN_TRX_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMM_LINES_API_ALL.TRX_LINE_ID CN_TRX_LINES_ALL
CN_TRX_SALES_LINES_ALL.TRX_LINE_ID CN_TRX_LINES_ALL

[top of page]

CN.CN_TRX_LINES_ALL does not reference any database object

CN.CN_TRX_LINES_ALL is referenced by following:

APPS
SYNONYM - CN_TRX_LINES
SYNONYM - CN_TRX_LINES_ALL

[top of page]

Table: CN_TRX_SALES_LINES_ALL

Description: Contains CN transactions picked up in the AR data collection process.
Primary Key: CN_TRX_SALES_LINES_PK
  1. TRX_SALES_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_TRX_SALES_LINES_ALL.TRX_ID CN_TRX_ALL
CN_TRX_SALES_LINES_ALL.TRX_LINE_ID CN_TRX_LINES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
CN_COMM_LINES_API_ALL.TRX_SALES_LINE_ID CN_TRX_SALES_LINES_ALL

[top of page]

CN.CN_TRX_SALES_LINES_ALL does not reference any database object

CN.CN_TRX_SALES_LINES_ALL is referenced by following:

APPS
SYNONYM - CN_TRX_SALES_LINES
SYNONYM - CN_TRX_SALES_LINES_ALL

[top of page]

Table: CN_USER_ACCESSES_ALL

Description: CN_USER_ACCESS contains the information of which compensation groups a user has access to.
Primary Key: CN_USER_ACCESSES_PK
  1. USER_ACCESS_ID

[top of page]

CN.CN_USER_ACCESSES_ALL does not reference any database object

CN.CN_USER_ACCESSES_ALL is referenced by following:

APPS
SYNONYM - CN_USER_ACCESSES
SYNONYM - CN_USER_ACCESSES_ALL

[top of page]

Table: CN_WORKSHEET_BONUSES_ALL

Description: Bonuses given in payment process.
Primary Key: CN_WORKSHEET_BONUSES_PK
  1. SALESREP_ID
  2. PAYRUN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CN_WORKSHEET_BONUSES_ALL.PAYRUN_ID CN_PAYRUNS_ALL
CN_WORKSHEET_BONUSES_ALL.SALESREP_ID CN_SALESREPS_API_ALL

[top of page]

CN.CN_WORKSHEET_BONUSES_ALL does not reference any database object

CN.CN_WORKSHEET_BONUSES_ALL is referenced by following:

APPS
SYNONYM - CN_WORKSHEET_BONUSES
SYNONYM - CN_WORKSHEET_BONUSES_ALL

[top of page]

Table: CN_WORKSHEET_QG_DTLS_ALL

Description: CN_WORKSHEET_QG_DTLS contains information for a payment worksheet at quota group level.

[top of page]

CN.CN_WORKSHEET_QG_DTLS_ALL does not reference any database object

CN.CN_WORKSHEET_QG_DTLS_ALL is referenced by following:

APPS
SYNONYM - CN_WORKSHEET_QG_DTLS
SYNONYM - CN_WORKSHEET_QG_DTLS_ALL

[top of page]

Table: CN_XREF_TBL

Description:

[top of page]

CN.CN_XREF_TBL does not reference any database object

CN.CN_XREF_TBL is referenced by following:

APPS
SYNONYM - CN_XREF_TBL

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract