[Home] [Help] [Dependency Information]
Object Name: | CN_SRP_DENORM_DATA_BCK_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_SRP_DENORM_DATA_BCK_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: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALESREP_ID | NUMBER | (15) | See the column description in CN_SRP_DENORM_DATA_ALL | |
RESOURCE_ID | NUMBER | (15) | See the column description in CN_SRP_DENORM_DATA_ALL | |
NAME | VARCHAR2 | (80) | See the column description in CN_SRP_DENORM_DATA_ALL | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | See the column description in CN_SRP_DENORM_DATA_ALL | |
MGR_SALESREP_ID | NUMBER | (15) | See the column description in CN_SRP_DENORM_DATA_ALL | |
MGR_RESOURCE_ID | NUMBER | (15) | See the column description in CN_SRP_DENORM_DATA_ALL | |
START_DATE | DATE | See the column description in CN_SRP_DENORM_DATA_ALL | ||
END_DATE | DATE | See the column description in CN_SRP_DENORM_DATA_ALL | ||
DIRECT_MGR | VARCHAR2 | (1) | See the column description in CN_SRP_DENORM_DATA_ALL | |
QUARTER | NUMBER | See the column description in CN_SRP_DENORM_DATA_ALL | ||
YEAR | NUMBER | See the column description in CN_SRP_DENORM_DATA_ALL | ||
PAYMENT | NUMBER | See the column description in CN_SRP_DENORM_DATA_ALL | ||
EARNINGS | NUMBER | See the column description in CN_SRP_DENORM_DATA_ALL | ||
INTERVAL | VARCHAR2 | (30) | See the column description in CN_SRP_DENORM_DATA_ALL | |
STREET_LEVEL | VARCHAR2 | (1) | See the column description in CN_SRP_DENORM_DATA_ALL | |
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_BCK_ALL;
CN.CN_SRP_DENORM_DATA_BCK_ALL does not reference any database object
CN.CN_SRP_DENORM_DATA_BCK_ALL is referenced by following:
|
|
|