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]

VIEW: CN.CN_PAYMENT_WORKSHEETS_ALL#

Object Details

Object Name:	CN_PAYMENT_WORKSHEETS_ALL#
Object Type:	VIEW
Owner:	CN
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORG_ID	NUMBER	(15)
SALESREP_ID	NUMBER	(15)	Yes
PAYRUN_ID	NUMBER	(15)	Yes
PAY_CAP	NUMBER
COMM_DUE_BB	NUMBER
BONUS_DUE_BB	NUMBER
DRAW_RECOVERABLE_BEGIN	NUMBER
COMM_PTD	NUMBER
BONUS_PTD	NUMBER
COMM_DRAW	NUMBER
BONUS_DRAW	NUMBER
COMM_PAID	NUMBER
BONUS_PAID	NUMBER
DRAW_PAID	NUMBER
ADJUST_PAID	NUMBER
COST_CENTER_ID	NUMBER	(15)
REASON	VARCHAR2	(80)
BONUS_REASON	VARCHAR2	(80)
RECOVERY_METHOD	VARCHAR2	(80)
DRAW_PTD	NUMBER
BONUS_GIVEN	NUMBER
GUARANTEE	NUMBER
PAYMENT_WORKSHEET_ID	NUMBER	(15)	Yes
ROLE_ID	NUMBER	(15)
CREDIT_TYPE_ID	NUMBER	(15)
RETURNED_FUNDS_FLAG	VARCHAR2	(1)
POST_SUBLEDGER_FLAG	VARCHAR2	(1)
MINIMUM_AMOUNT	NUMBER
COMM_NREC	NUMBER
REG_BONUS_DUE_BB	NUMBER
REG_BONUS_PTD	NUMBER
REG_BONUS_REC	NUMBER
REG_BONUS_TO_REC	NUMBER
REG_BONUS_PAID	NUMBER
PAYEE_COMM_DUE_BB	NUMBER
PAYEE_COMM_PTD	NUMBER
PAYEE_COMM_PAID	NUMBER
PAYEE_BONUS_DUE_BB	NUMBER
PAYEE_BONUS_PTD	NUMBER
PAYEE_BONUS_PAID	NUMBER
CONVERT_TO_TYPE_ID	NUMBER	(15)
CREDIT_CONV_FCT_ID	NUMBER	(15)
CONVERT_TO_PAID	NUMBER
POSTING_STATUS	VARCHAR2	(30)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
PMT_AMOUNT_CALC	NUMBER
PMT_AMOUNT_ADJ_REC	NUMBER
PMT_AMOUNT_ADJ_NREC	NUMBER
REVIEWED_BY_ANALYST	VARCHAR2	(1)
ANALYST_NOTES	VARCHAR2	(4000)
SECURITY_GROUP_ID	NUMBER
CURRENT_EARNINGS_DUE	NUMBER
PMT_AMOUNT_ADJ	NUMBER
PMT_AMOUNT_RECOVERY	NUMBER
QUOTA_ID	NUMBER
WORKSHEET_STATUS	VARCHAR2	(30)	Yes
OBJECT_VERSION_NUMBER	NUMBER
CURRENT_EARNINGS	NUMBER
BB_PMT_RECOVERY_PLANS	NUMBER
BB_PRIOR_PERIOD_ADJ	NUMBER
HELD_AMOUNT	NUMBER
REQUEST_ID	NUMBER

Query Text

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


SELECT ORG_ID
,      SALESREP_ID
,      PAYRUN_ID
,      PAY_CAP
,      COMM_DUE_BB
,      BONUS_DUE_BB
,      DRAW_RECOVERABLE_BEGIN
,      COMM_PTD
,      BONUS_PTD
,      COMM_DRAW
,      BONUS_DRAW
,      COMM_PAID
,      BONUS_PAID
,      DRAW_PAID
,      ADJUST_PAID
,      COST_CENTER_ID
,      REASON
,      BONUS_REASON
,      RECOVERY_METHOD
,      DRAW_PTD
,      BONUS_GIVEN
,      GUARANTEE
,      PAYMENT_WORKSHEET_ID
,      ROLE_ID
,      CREDIT_TYPE_ID
,      RETURNED_FUNDS_FLAG
,      POST_SUBLEDGER_FLAG
,      MINIMUM_AMOUNT
,      COMM_NREC
,      REG_BONUS_DUE_BB
,      REG_BONUS_PTD
,      REG_BONUS_REC
,      REG_BONUS_TO_REC
,      REG_BONUS_PAID
,      PAYEE_COMM_DUE_BB
,      PAYEE_COMM_PTD
,      PAYEE_COMM_PAID
,      PAYEE_BONUS_DUE_BB
,      PAYEE_BONUS_PTD
,      PAYEE_BONUS_PAID
,      CONVERT_TO_TYPE_ID
,      CREDIT_CONV_FCT_ID
,      CONVERT_TO_PAID
,      POSTING_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PMT_AMOUNT_CALC
,      PMT_AMOUNT_ADJ_REC
,      PMT_AMOUNT_ADJ_NREC
,      REVIEWED_BY_ANALYST
,      ANALYST_NOTES
,      SECURITY_GROUP_ID
,      CURRENT_EARNINGS_DUE
,      PMT_AMOUNT_ADJ
,      PMT_AMOUNT_RECOVERY
,      QUOTA_ID
,      WORKSHEET_STATUS
,      OBJECT_VERSION_NUMBER
,      CURRENT_EARNINGS
,      BB_PMT_RECOVERY_PLANS
,      BB_PRIOR_PERIOD_ADJ
,      HELD_AMOUNT
,      REQUEST_ID
FROM CN.CN_PAYMENT_WORKSHEETS_ALL#;

Dependencies

[top of page]

CN.CN_PAYMENT_WORKSHEETS_ALL# references the following:

CN: CN_PAYMENT_WORKSHEETS_ALL

CN.CN_PAYMENT_WORKSHEETS_ALL# is referenced by following:

APPS: CN_PAYMENT_WORKSHEETS; CN_PAYMENT_WORKSHEETS_ALL