eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CN.CN_SRP_PERIOD_QUOTAS_ALL

Object Details

Object Name:	CN_SRP_PERIOD_QUOTAS_ALL
Object Type:	TABLE
Owner:	CN
FND Design Data:	CN.CN_SRP_PERIOD_QUOTAS_ALL
Subobject Name:
Status:	VALID

CN_SRP_PERIOD_QUOTAS stores period target and draw amounts
assigned to a salesperson's plan element. You need one row for each
period in which the salesperson's compensation plan is active.
.
The user cannot directly insert into or delete from this table. Rows
are automatically created for each period that the salesperson's compe
nsation
plan is active. Rows are deleted when you delete the compensation plan
assignment or reduce the active period range.
.
SRP_PERIOD_QUOTA_ID is the unique system generated primary key
invisible to the user.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_SRP_PERIOD_QUOTAS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SRP_PERIOD_QUOTA_ID ORG_ID
CN_SRP_PERIOD_QUOTAS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	SRP_PLAN_ASSIGN_ID QUOTA_ID PERIOD_ID
CN_SRP_PERIOD_QUOTAS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SRP_QUOTA_ASSIGN_ID
CN_SRP_PERIOD_QUOTAS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALESREP_ID PERIOD_ID QUOTA_ID
CN_SRP_PERIOD_QUOTAS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTA_ID
CN_SRP_PERIOD_QUOTAS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_ID QUOTA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)		Organization identifier
SRP_PERIOD_QUOTA_ID	NUMBER	(15)	Yes	Unique identifier
SRP_PLAN_ASSIGN_ID	NUMBER	(15)	Yes	Salesperson plan assignment unique identifier
SRP_QUOTA_ASSIGN_ID	NUMBER	(15)	Yes	Salesperson plan element assignment unique identifier
SALESREP_ID	NUMBER	(15)	Yes	Salesperson unique identifier
PERIOD_ID	NUMBER	(15)	Yes	Unique identifier of period to which the target applies
QUOTA_ID	NUMBER	(15)	Yes	Plan element unique identifier
TARGET_AMOUNT	NUMBER		Yes	Target
QUOTA_ACHIEVED_PTD	NUMBER
COMMISSION_PAYED_PTD	NUMBER		Yes	Commission paid period-to-date
COMMISSION_PAYED_YTD	NUMBER
QUOTA_ACHIEVED_YTD	NUMBER
ITD_TARGET	NUMBER			Interval to date target
PERIOD_PAYMENT	NUMBER			Payment amount for this period
ITD_PAYMENT	NUMBER			Interval to date payment
TRX_AMOUNT_PTD	NUMBER
TRX_AMOUNT_YTD	NUMBER
QUANTITY_PTD	NUMBER
QUANTITY_YTD	NUMBER
COMMISSION_PAYED_ITD	NUMBER			Interval to date commission payed
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_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
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).
QUOTA_ACHIEVED_PTD_F	NUMBER
QUOTA_AMOUNT_PTD_F	NUMBER
QUOTA_AMOUNT_YTD_F	NUMBER
QUOTA_ACHIEVED_YTD_F	NUMBER
COMMISSION_PAYED_ITD_F	NUMBER			forecast commissioninterval-to-date
COMMISSION_PAYED_PTD_F	NUMBER			Forecast commission period-to-date
COMMISSION_PAYED_YTD_F	NUMBER
TRX_AMOUNT_PTD_F	NUMBER
TRX_AMOUNT_YTD_F	NUMBER
QUANTITY_PTD_F	NUMBER
QUANTITY_YTD_F	NUMBER
INPUT_ACHIEVED_PTD	NUMBER			Input Achieved Period to date
INPUT_ACHIEVED_ITD	NUMBER			Input Achieved Interval to date
OUTPUT_ACHIEVED_PTD	NUMBER			Output Achieved Period to date
OUTPUT_ACHIEVED_ITD	NUMBER			Output Achieved Interval to date
PERF_ACHIEVED_PTD	NUMBER			Performance Achieved Period to Date
PERF_ACHIEVED_ITD	NUMBER			Performance Achieved Interval to date
ADVANCE_RECOVERED_PTD	NUMBER			Advance recovered PTD
ADVANCE_RECOVERED_ITD	NUMBER			Advance recovered ITD
ADVANCE_TO_REC_PTD	NUMBER			Advance to recover PTD
ADVANCE_TO_REC_ITD	NUMBER			Advance to recover ITD
COMM_PEND_PTD	NUMBER			Commission pending PTD
COMM_PEND_ITD	NUMBER			Commission pending ITD
RECOVERY_AMOUNT_PTD	NUMBER			Recovery Amount Period to date
RECOVERY_AMOUNT_ITD	NUMBER			Recovery Amount Interval to date
PERFORMANCE_GOAL_PTD	NUMBER			Period to date Performance Goal
PERFORMANCE_GOAL_ITD	NUMBER			Interval To Date performance goal
LAST_RATE_TIER_ID	NUMBER	(15)		Last rate tier
LAST_RATES	NUMBER			Last commission rate
INPUT_ACHIEVED_PTD_F	NUMBER			Forecast Input Achieved Period to date
INPUT_ACHIEVED_ITD_F	NUMBER			Forecast Input Achieved Interval to date
OUTPUT_ACHIEVED_PTD_F	NUMBER			Forecast Output Achieved Period to date
OUTPUT_ACHIEVED_ITD_F	NUMBER			Forecast Output Achieved Interval to date
PERF_ACHIEVED_PTD_F	NUMBER			Forecast Performance Achieved Period to date
PERF_ACHIEVED_ITD_F	NUMBER			Forecast Performance Achieved Interval to date
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ROLLOVER	NUMBER			Rollover of current period
TOTAL_ROLLOVER	NUMBER			Total rollover from previous periods from all sources
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	This column is used for locking purpose
TRANSACTION_AMOUNT_PTD	NUMBER			Transaction Amount Period to Date
TRANSACTION_AMOUNT_ITD	NUMBER			Transaction Amount Interval to Date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_ID
,      SRP_PERIOD_QUOTA_ID
,      SRP_PLAN_ASSIGN_ID
,      SRP_QUOTA_ASSIGN_ID
,      SALESREP_ID
,      PERIOD_ID
,      QUOTA_ID
,      TARGET_AMOUNT
,      QUOTA_ACHIEVED_PTD
,      COMMISSION_PAYED_PTD
,      COMMISSION_PAYED_YTD
,      QUOTA_ACHIEVED_YTD
,      ITD_TARGET
,      PERIOD_PAYMENT
,      ITD_PAYMENT
,      TRX_AMOUNT_PTD
,      TRX_AMOUNT_YTD
,      QUANTITY_PTD
,      QUANTITY_YTD
,      COMMISSION_PAYED_ITD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      QUOTA_ACHIEVED_PTD_F
,      QUOTA_AMOUNT_PTD_F
,      QUOTA_AMOUNT_YTD_F
,      QUOTA_ACHIEVED_YTD_F
,      COMMISSION_PAYED_ITD_F
,      COMMISSION_PAYED_PTD_F
,      COMMISSION_PAYED_YTD_F
,      TRX_AMOUNT_PTD_F
,      TRX_AMOUNT_YTD_F
,      QUANTITY_PTD_F
,      QUANTITY_YTD_F
,      INPUT_ACHIEVED_PTD
,      INPUT_ACHIEVED_ITD
,      OUTPUT_ACHIEVED_PTD
,      OUTPUT_ACHIEVED_ITD
,      PERF_ACHIEVED_PTD
,      PERF_ACHIEVED_ITD
,      ADVANCE_RECOVERED_PTD
,      ADVANCE_RECOVERED_ITD
,      ADVANCE_TO_REC_PTD
,      ADVANCE_TO_REC_ITD
,      COMM_PEND_PTD
,      COMM_PEND_ITD
,      RECOVERY_AMOUNT_PTD
,      RECOVERY_AMOUNT_ITD
,      PERFORMANCE_GOAL_PTD
,      PERFORMANCE_GOAL_ITD
,      LAST_RATE_TIER_ID
,      LAST_RATES
,      INPUT_ACHIEVED_PTD_F
,      INPUT_ACHIEVED_ITD_F
,      OUTPUT_ACHIEVED_PTD_F
,      OUTPUT_ACHIEVED_ITD_F
,      PERF_ACHIEVED_PTD_F
,      PERF_ACHIEVED_ITD_F
,      SECURITY_GROUP_ID
,      ROLLOVER
,      TOTAL_ROLLOVER
,      OBJECT_VERSION_NUMBER
,      TRANSACTION_AMOUNT_PTD
,      TRANSACTION_AMOUNT_ITD
FROM CN.CN_SRP_PERIOD_QUOTAS_ALL;

Dependencies

[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: CN_SRP_PERIOD_QUOTAS; CN_SRP_PERIOD_QUOTAS_ALL; CN_SRP_PERIOD_QUOTAS_T1