[Home] [Help] [Dependency Information]
Object Name: | CN_PROCESS_BATCHES_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_PROCESS_BATCHES_ALL |
Subobject Name: | |
Status: | VALID |
CN_PROCESS_BATCHES is an internal table used to manage the
calculation process. The table is automatically populated and
updated during calculation. No attempt must be made to insert or
modify rows in this table.
.
You need one row for each salesperson's period (CN_SRP_PERIODS)
that will be calculated.
.
LOGICAL_BATCH_ID is a unique identifier assigned to all
CN_SRP_PERIODS in a single calculation run.
.
PHYSICAL_BATCH_ID is a non-unique identifier assigned
to each group of CN_SRP_PERIODS within the logical batch
depending upon the number of transactions in each of these
CN_SRP_PERIODS references. Each physical batch is a separate
commit unit.
.
STATUS_CODE indicates whether the batch has been processed:
'IN_USE' indicates that the batch is ready for processing, 'VOID'
indicates that the batch has been processed and can be purged.
.
PROCESS_BATCH_TYPE indicates whether this salesperson
period belongs to the direct or credited salesperson.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_PROCESS_BATCHES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROCESS_BATCH_ID
ORG_ID |
CN_PROCESS_BATCHES_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LOGICAL_BATCH_ID
SALESREP_ID PERIOD_ID |
CN_PROCESS_BATCHES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PHYSICAL_BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Organization identifier | |
PROCESS_BATCH_ID | NUMBER | (15) | Yes | Primary key |
SRP_PERIOD_ID | NUMBER | (15) | Yes | Salesperson's period unique identifier |
PERIOD_ID | NUMBER | (15) | Yes | Sales compensation period unique identifier |
SALESREP_ID | NUMBER | (15) | Yes | Salesperson unique identifier |
LOGICAL_BATCH_ID | NUMBER | (15) | Yes | Logical batch unique identifier |
PHYSICAL_BATCH_ID | NUMBER | (15) | Physical batch unique identifier | |
STATUS_CODE | VARCHAR2 | (30) | Yes | Batch status |
SALES_LINES_TOTAL | NUMBER | Total number of transactions in each salesperson's period | ||
PROCESS_BATCH_NAME | VARCHAR2 | (30) | Not currently used | |
CREATED_BY_USER_ID | NUMBER | (15) | Not currently used | |
CREATED_ON_DATE | DATE | Not currently used | ||
TRX_BATCH_ID | NUMBER | (15) | Not currently used | |
PROCESS_BATCH_TYPE | VARCHAR2 | (30) | Defines whether the period belongs to the direct salesperson or a credited salesperosn | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
START_DATE | DATE | start date | ||
END_DATE | DATE | end date | ||
QUOTA_ID | NUMBER | (15) | plan element id | |
END_PERIOD_ID | NUMBER | (15) | end period id | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
COMMISSION_HEADERS_COUNT | NUMBER | number of records of salesrep has in cn_commission_headers |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, PROCESS_BATCH_ID
, SRP_PERIOD_ID
, PERIOD_ID
, SALESREP_ID
, LOGICAL_BATCH_ID
, PHYSICAL_BATCH_ID
, STATUS_CODE
, SALES_LINES_TOTAL
, PROCESS_BATCH_NAME
, CREATED_BY_USER_ID
, CREATED_ON_DATE
, TRX_BATCH_ID
, PROCESS_BATCH_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, START_DATE
, END_DATE
, QUOTA_ID
, END_PERIOD_ID
, SECURITY_GROUP_ID
, COMMISSION_HEADERS_COUNT
FROM CN.CN_PROCESS_BATCHES_ALL;
CN.CN_PROCESS_BATCHES_ALL does not reference any database object
CN.CN_PROCESS_BATCHES_ALL is referenced by following:
|
|
|