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_SRP_PERIODS_ALL#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORG_ID	NUMBER	(15)
SRP_PERIOD_ID	NUMBER	(15)	Yes
SALESREP_ID	NUMBER	(15)	Yes
PERIOD_ID	NUMBER	(15)	Yes
SRP_PLAN_ASSIGN_ID	NUMBER	(15)
STATUS	VARCHAR2	(10)
CALC_BATCH_ID	NUMBER	(15)
PERIOD_TYPE_ID	NUMBER	(15)
CASH_DTD	NUMBER
CASH_CTD	NUMBER
CASH_BBD	NUMBER
CASH_BBC	NUMBER
DUE_DTD	NUMBER
DUE_CTD	NUMBER
DUE_BBD	NUMBER
DUE_BBC	NUMBER
COMMISSION_EARNED_DTD	NUMBER
COMMISSION_EARNED_CTD	NUMBER
COMMISSION_EARNED_BBD	NUMBER
COMMISSION_EARNED_BBC	NUMBER
BONUS_EARNED_DTD	NUMBER
BONUS_EARNED_CTD	NUMBER
BONUS_EARNED_BBD	NUMBER
BONUS_EARNED_BBC	NUMBER
DRAW_NONREC_DTD	NUMBER
DRAW_NONREC_CTD	NUMBER
DRAW_NONREC_BBD	NUMBER
DRAW_NONREC_BBC	NUMBER
PAYROLL_DUE_DTD	NUMBER
PAYROLL_DUE_CTD	NUMBER
PAYROLL_DUE_BBD	NUMBER
PAYROLL_DUE_BBC	NUMBER
PAYROLL_TRANSFER_DTD	NUMBER
PAYROLL_TRANSFER_CTD	NUMBER
PAYROLL_TRANSFER_BBD	NUMBER
PAYROLL_TRANSFER_BBC	NUMBER
DRAW_PAYABLE_DTD	NUMBER
DRAW_PAYABLE_CTD	NUMBER
DRAW_PAYABLE_BBD	NUMBER
DRAW_PAYABLE_BBC	NUMBER
MISC_EARNED_DTD	NUMBER
MISC_EARNED_CTD	NUMBER
MISC_EARNED_BBD	NUMBER
MISC_EARNED_BBC	NUMBER
TRANSFERRED	NUMBER
CLASSIFIED	NUMBER
UNCLASSIFIED	NUMBER
DIRECT_PAYED	NUMBER
DIRECT_UNPAYED	NUMBER
INDIRECT_PAYED	NUMBER
CALCULATED	NUMBER
UNCALCULATED	NUMBER
SUB_CALCULATED	NUMBER
SUB_UNCALCULATED	NUMBER
BALANCE10_DTD	NUMBER
BALANCE10_CTD	NUMBER
BALANCE10_BBD	NUMBER
BALANCE10_BBC	NUMBER
BALANCE11_DTD	NUMBER
BALANCE11_CTD	NUMBER
BALANCE11_BBD	NUMBER
BALANCE11_BBC	NUMBER
BALANCE12_DTD	NUMBER
BALANCE12_CTD	NUMBER
BALANCE12_BBD	NUMBER
BALANCE12_BBC	NUMBER
BALANCE13_DTD	NUMBER
BALANCE13_CTD	NUMBER
BALANCE13_BBD	NUMBER
BALANCE13_BBC	NUMBER
BALANCE14_DTD	NUMBER
BALANCE14_CTD	NUMBER
BALANCE14_BBD	NUMBER
BALANCE14_BBC	NUMBER
BALANCE15_DTD	NUMBER
BALANCE15_CTD	NUMBER
BALANCE15_BBD	NUMBER
BALANCE15_BBC	NUMBER
BALANCE16_DTD	NUMBER
BALANCE16_CTD	NUMBER
BALANCE16_BBD	NUMBER
BALANCE16_BBC	NUMBER
BALANCE17_DTD	NUMBER
BALANCE17_CTD	NUMBER
BALANCE17_BBD	NUMBER
BALANCE17_BBC	NUMBER
BALANCE18_DTD	NUMBER
BALANCE18_CTD	NUMBER
BALANCE18_BBD	NUMBER
BALANCE18_BBC	NUMBER
BALANCE19_DTD	NUMBER
BALANCE19_CTD	NUMBER
BALANCE19_BBD	NUMBER
BALANCE19_BBC	NUMBER
BALANCE20_DTD	NUMBER
BALANCE20_CTD	NUMBER
BALANCE20_BBD	NUMBER
BALANCE20_BBC	NUMBER
BALANCE21_DTD	NUMBER
BALANCE21_CTD	NUMBER
BALANCE21_BBD	NUMBER
BALANCE21_BBC	NUMBER
BALANCE22_DTD	NUMBER
BALANCE22_CTD	NUMBER
BALANCE22_BBD	NUMBER
BALANCE22_BBC	NUMBER
BALANCE23_DTD	NUMBER
BALANCE23_CTD	NUMBER
BALANCE23_BBD	NUMBER
BALANCE23_BBC	NUMBER
BALANCE24_DTD	NUMBER
BALANCE24_CTD	NUMBER
BALANCE24_BBD	NUMBER
BALANCE24_BBC	NUMBER
BALANCE25_DTD	NUMBER
BALANCE25_CTD	NUMBER
BALANCE25_BBD	NUMBER
BALANCE25_BBC	NUMBER
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
PROCESSING_STATUS_CODE	VARCHAR2	(30)
PROCESS_ALL_FLAG	VARCHAR2	(1)
REQUEST_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
CONSISTENCY_FLAG	VARCHAR2	(1)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
START_DATE	DATE
END_DATE	DATE
CREDIT_TYPE_ID	NUMBER	(15)	Yes
ROLE_ID	NUMBER	(15)
PAY_GROUP_ID	NUMBER	(15)
PAID_FLAG	VARCHAR2	(1)
BALANCE1_DTD	NUMBER
BALANCE1_CTD	NUMBER
BALANCE1_BBD	NUMBER
BALANCE1_BBC	NUMBER
BALANCE2_DTD	NUMBER
BALANCE2_CTD	NUMBER
BALANCE2_BBD	NUMBER
BALANCE2_BBC	NUMBER
BALANCE3_DTD	NUMBER
BALANCE3_CTD	NUMBER
BALANCE3_BBD	NUMBER
BALANCE3_BBC	NUMBER
BALANCE4_DTD	NUMBER
BALANCE4_CTD	NUMBER
BALANCE4_BBD	NUMBER
BALANCE4_BBC	NUMBER
BALANCE5_DTD	NUMBER
BALANCE5_CTD	NUMBER
BALANCE5_BBD	NUMBER
BALANCE5_BBC	NUMBER
BALANCE6_DTD	NUMBER
BALANCE6_CTD	NUMBER
BALANCE6_BBD	NUMBER
BALANCE6_BBC	NUMBER
BALANCE7_DTD	NUMBER
BALANCE7_CTD	NUMBER
BALANCE7_BBD	NUMBER
BALANCE7_BBC	NUMBER
BALANCE8_DTD	NUMBER
BALANCE8_CTD	NUMBER
BALANCE8_BBD	NUMBER
BALANCE8_BBC	NUMBER
BALANCE9_DTD	NUMBER
BALANCE9_CTD	NUMBER
BALANCE9_BBD	NUMBER
BALANCE9_BBC	NUMBER
BALANCE26_DTD	NUMBER
BALANCE26_CTD	NUMBER
BALANCE26_BBD	NUMBER
BALANCE26_BBC	NUMBER
BALANCE27_DTD	NUMBER
BALANCE27_CTD	NUMBER
BALANCE27_BBD	NUMBER
BALANCE27_BBC	NUMBER
BALANCE28_DTD	NUMBER
BALANCE28_CTD	NUMBER
BALANCE28_BBD	NUMBER
BALANCE28_BBC	NUMBER
BALANCE29_DTD	NUMBER
BALANCE29_CTD	NUMBER
BALANCE29_BBD	NUMBER
BALANCE29_BBC	NUMBER
BALANCE30_DTD	NUMBER
BALANCE30_CTD	NUMBER
BALANCE30_BBD	NUMBER
BALANCE30_BBC	NUMBER
BALANCE31_DTD	NUMBER
BALANCE31_CTD	NUMBER
BALANCE31_BBD	NUMBER
BALANCE31_BBC	NUMBER
BALANCE32_DTD	NUMBER
BALANCE32_CTD	NUMBER
BALANCE32_BBD	NUMBER
BALANCE32_BBC	NUMBER
BALANCE33_DTD	NUMBER
BALANCE33_CTD	NUMBER
BALANCE33_BBD	NUMBER
BALANCE33_BBC	NUMBER
SECURITY_GROUP_ID	NUMBER
QUOTA_ID	NUMBER

Query Text

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


SELECT ORG_ID
,      SRP_PERIOD_ID
,      SALESREP_ID
,      PERIOD_ID
,      SRP_PLAN_ASSIGN_ID
,      STATUS
,      CALC_BATCH_ID
,      PERIOD_TYPE_ID
,      CASH_DTD
,      CASH_CTD
,      CASH_BBD
,      CASH_BBC
,      DUE_DTD
,      DUE_CTD
,      DUE_BBD
,      DUE_BBC
,      COMMISSION_EARNED_DTD
,      COMMISSION_EARNED_CTD
,      COMMISSION_EARNED_BBD
,      COMMISSION_EARNED_BBC
,      BONUS_EARNED_DTD
,      BONUS_EARNED_CTD
,      BONUS_EARNED_BBD
,      BONUS_EARNED_BBC
,      DRAW_NONREC_DTD
,      DRAW_NONREC_CTD
,      DRAW_NONREC_BBD
,      DRAW_NONREC_BBC
,      PAYROLL_DUE_DTD
,      PAYROLL_DUE_CTD
,      PAYROLL_DUE_BBD
,      PAYROLL_DUE_BBC
,      PAYROLL_TRANSFER_DTD
,      PAYROLL_TRANSFER_CTD
,      PAYROLL_TRANSFER_BBD
,      PAYROLL_TRANSFER_BBC
,      DRAW_PAYABLE_DTD
,      DRAW_PAYABLE_CTD
,      DRAW_PAYABLE_BBD
,      DRAW_PAYABLE_BBC
,      MISC_EARNED_DTD
,      MISC_EARNED_CTD
,      MISC_EARNED_BBD
,      MISC_EARNED_BBC
,      TRANSFERRED
,      CLASSIFIED
,      UNCLASSIFIED
,      DIRECT_PAYED
,      DIRECT_UNPAYED
,      INDIRECT_PAYED
,      CALCULATED
,      UNCALCULATED
,      SUB_CALCULATED
,      SUB_UNCALCULATED
,      BALANCE10_DTD
,      BALANCE10_CTD
,      BALANCE10_BBD
,      BALANCE10_BBC
,      BALANCE11_DTD
,      BALANCE11_CTD
,      BALANCE11_BBD
,      BALANCE11_BBC
,      BALANCE12_DTD
,      BALANCE12_CTD
,      BALANCE12_BBD
,      BALANCE12_BBC
,      BALANCE13_DTD
,      BALANCE13_CTD
,      BALANCE13_BBD
,      BALANCE13_BBC
,      BALANCE14_DTD
,      BALANCE14_CTD
,      BALANCE14_BBD
,      BALANCE14_BBC
,      BALANCE15_DTD
,      BALANCE15_CTD
,      BALANCE15_BBD
,      BALANCE15_BBC
,      BALANCE16_DTD
,      BALANCE16_CTD
,      BALANCE16_BBD
,      BALANCE16_BBC
,      BALANCE17_DTD
,      BALANCE17_CTD
,      BALANCE17_BBD
,      BALANCE17_BBC
,      BALANCE18_DTD
,      BALANCE18_CTD
,      BALANCE18_BBD
,      BALANCE18_BBC
,      BALANCE19_DTD
,      BALANCE19_CTD
,      BALANCE19_BBD
,      BALANCE19_BBC
,      BALANCE20_DTD
,      BALANCE20_CTD
,      BALANCE20_BBD
,      BALANCE20_BBC
,      BALANCE21_DTD
,      BALANCE21_CTD
,      BALANCE21_BBD
,      BALANCE21_BBC
,      BALANCE22_DTD
,      BALANCE22_CTD
,      BALANCE22_BBD
,      BALANCE22_BBC
,      BALANCE23_DTD
,      BALANCE23_CTD
,      BALANCE23_BBD
,      BALANCE23_BBC
,      BALANCE24_DTD
,      BALANCE24_CTD
,      BALANCE24_BBD
,      BALANCE24_BBC
,      BALANCE25_DTD
,      BALANCE25_CTD
,      BALANCE25_BBD
,      BALANCE25_BBC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROCESSING_STATUS_CODE
,      PROCESS_ALL_FLAG
,      REQUEST_ID
,      PROGRAM_ID
,      CONSISTENCY_FLAG
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      START_DATE
,      END_DATE
,      CREDIT_TYPE_ID
,      ROLE_ID
,      PAY_GROUP_ID
,      PAID_FLAG
,      BALANCE1_DTD
,      BALANCE1_CTD
,      BALANCE1_BBD
,      BALANCE1_BBC
,      BALANCE2_DTD
,      BALANCE2_CTD
,      BALANCE2_BBD
,      BALANCE2_BBC
,      BALANCE3_DTD
,      BALANCE3_CTD
,      BALANCE3_BBD
,      BALANCE3_BBC
,      BALANCE4_DTD
,      BALANCE4_CTD
,      BALANCE4_BBD
,      BALANCE4_BBC
,      BALANCE5_DTD
,      BALANCE5_CTD
,      BALANCE5_BBD
,      BALANCE5_BBC
,      BALANCE6_DTD
,      BALANCE6_CTD
,      BALANCE6_BBD
,      BALANCE6_BBC
,      BALANCE7_DTD
,      BALANCE7_CTD
,      BALANCE7_BBD
,      BALANCE7_BBC
,      BALANCE8_DTD
,      BALANCE8_CTD
,      BALANCE8_BBD
,      BALANCE8_BBC
,      BALANCE9_DTD
,      BALANCE9_CTD
,      BALANCE9_BBD
,      BALANCE9_BBC
,      BALANCE26_DTD
,      BALANCE26_CTD
,      BALANCE26_BBD
,      BALANCE26_BBC
,      BALANCE27_DTD
,      BALANCE27_CTD
,      BALANCE27_BBD
,      BALANCE27_BBC
,      BALANCE28_DTD
,      BALANCE28_CTD
,      BALANCE28_BBD
,      BALANCE28_BBC
,      BALANCE29_DTD
,      BALANCE29_CTD
,      BALANCE29_BBD
,      BALANCE29_BBC
,      BALANCE30_DTD
,      BALANCE30_CTD
,      BALANCE30_BBD
,      BALANCE30_BBC
,      BALANCE31_DTD
,      BALANCE31_CTD
,      BALANCE31_BBD
,      BALANCE31_BBC
,      BALANCE32_DTD
,      BALANCE32_CTD
,      BALANCE32_BBD
,      BALANCE32_BBC
,      BALANCE33_DTD
,      BALANCE33_CTD
,      BALANCE33_BBD
,      BALANCE33_BBC
,      SECURITY_GROUP_ID
,      QUOTA_ID
FROM CN.CN_SRP_PERIODS_ALL#;

Dependencies

[top of page]

CN.CN_SRP_PERIODS_ALL# references the following:

CN: CN_SRP_PERIODS_ALL

CN.CN_SRP_PERIODS_ALL# is referenced by following:

APPS: CN_SRP_PERIODS; CN_SRP_PERIODS_ALL