[Home] [Help] [Dependency Information]
Object Name: | CNSBPS_BONUSES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALESREP_ID | NUMBER | (15) | Yes | Salesrep unique identifier |
PAYRUN_ID | NUMBER | (15) | Yes | Payrun unique identifier for the payrun in which the bonus is given |
PERIOD_ID | NUMBER | (15) | Yes | Period unique identifier denormalizing the period of the payrun |
BONUS_TYPE | VARCHAR2 | (80) | Yes | Name of the bonus quota (in CN_QUOTAS) being given a bonus |
AMOUNT | NUMBER | Amount of bonus given: Either zero (if no value is entered in CN_PAYRUNS_BONUSES) or the value entered |
Cut, paste (and edit) the following text to query this object:
SELECT SALESREP_ID
, PAYRUN_ID
, PERIOD_ID
, BONUS_TYPE
, AMOUNT
FROM APPS.CNSBPS_BONUSES_V;
APPS.CNSBPS_BONUSES_V is not referenced by any database object
|
|
|