[Home] [Help] [Dependency Information]
Object Name: | CN_SRP_DENORM_DATA_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_SRP_DENORM_DATA_ALL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_SRP_DENORM_DATA_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
MGR_SALESREP_ID
QUARTER YEAR INTERVAL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALESREP_ID | NUMBER | (15) | salesrep ID corresponding to the resource | |
RESOURCE_ID | NUMBER | (15) | resource ID of a particular manager assignment | |
NAME | VARCHAR2 | (80) | name of the resource | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | employee number of the resource | |
MGR_SALESREP_ID | NUMBER | (15) | Stores the manager's id of this salesperson. | |
MGR_RESOURCE_ID | NUMBER | (15) | resource of the salesrep's manager | |
START_DATE | DATE | start of the manager assignment | ||
END_DATE | DATE | end of the manager assignment | ||
DIRECT_MGR | VARCHAR2 | (1) | Flag to show whether this manager is the direct manager of this salesperson. | |
QUARTER | NUMBER | fiscal quarter | ||
YEAR | NUMBER | fiscal year | ||
PAYMENT | NUMBER | amount the salesrep was paid in the interval | ||
EARNINGS | NUMBER | The revenues made by this salesperson for this interval. | ||
INTERVAL | VARCHAR2 | (30) | The interval types, Quarter or Year. | |
STREET_LEVEL | VARCHAR2 | (1) | street-level representative flag Y for street-level representative N for others | |
ORG_ID | NUMBER | Organization identifier | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT SALESREP_ID
, RESOURCE_ID
, NAME
, EMPLOYEE_NUMBER
, MGR_SALESREP_ID
, MGR_RESOURCE_ID
, START_DATE
, END_DATE
, DIRECT_MGR
, QUARTER
, YEAR
, PAYMENT
, EARNINGS
, INTERVAL
, STREET_LEVEL
, ORG_ID
, SECURITY_GROUP_ID
FROM CN.CN_SRP_DENORM_DATA_ALL;
CN.CN_SRP_DENORM_DATA_ALL does not reference any database object
CN.CN_SRP_DENORM_DATA_ALL is referenced by following:
|
|
|