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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
COMMISSION_HEADER_ID	NUMBER	(15)	Yes
DIRECT_SALESREP_ID	NUMBER	(15)	Yes
PROCESSED_DATE	DATE		Yes
PROCESSED_PERIOD_ID	NUMBER	(15)
ROLLUP_DATE	DATE
TRANSACTION_AMOUNT	NUMBER
QUANTITY	NUMBER
DISCOUNT_PERCENTAGE	NUMBER
MARGIN_PERCENTAGE	NUMBER
ORIG_CURRENCY_CODE	VARCHAR2	(15)
TRANSACTION_AMOUNT_ORIG	NUMBER
TRX_TYPE	VARCHAR2	(30)
STATUS	VARCHAR2	(30)
PRE_PROCESSED_CODE	VARCHAR2	(30)
COMM_LINES_API_ID	NUMBER	(15)
SOURCE_DOC_TYPE	VARCHAR2	(80)
SOURCE_TRX_NUMBER	VARCHAR2	(80)
QUOTA_ID	NUMBER	(15)
SRP_PLAN_ASSIGN_ID	NUMBER	(15)
REVENUE_CLASS_ID	NUMBER	(15)
ROLE_ID	NUMBER	(15)
COMP_GROUP_ID	NUMBER	(15)
COMMISSION_AMOUNT	NUMBER
TRX_BATCH_ID	NUMBER	(15)
REVERSAL_FLAG	VARCHAR2	(1)
REVERSAL_HEADER_ID	NUMBER	(15)
REASON_CODE	VARCHAR2	(30)
COMMENTS	VARCHAR2	(1800)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)
ATTRIBUTE6	VARCHAR2	(240)
ATTRIBUTE7	VARCHAR2	(240)
ATTRIBUTE8	VARCHAR2	(240)
ATTRIBUTE9	VARCHAR2	(240)
ATTRIBUTE10	VARCHAR2	(240)
ATTRIBUTE11	VARCHAR2	(240)
ATTRIBUTE12	VARCHAR2	(240)
ATTRIBUTE13	VARCHAR2	(240)
ATTRIBUTE14	VARCHAR2	(240)
ATTRIBUTE15	VARCHAR2	(240)
ATTRIBUTE16	VARCHAR2	(240)
ATTRIBUTE17	VARCHAR2	(240)
ATTRIBUTE18	VARCHAR2	(240)
ATTRIBUTE19	VARCHAR2	(240)
ATTRIBUTE20	VARCHAR2	(240)
ATTRIBUTE21	VARCHAR2	(240)
ATTRIBUTE22	VARCHAR2	(240)
ATTRIBUTE23	VARCHAR2	(240)
ATTRIBUTE24	VARCHAR2	(240)
ATTRIBUTE25	VARCHAR2	(240)
ATTRIBUTE26	VARCHAR2	(240)
ATTRIBUTE27	VARCHAR2	(240)
ATTRIBUTE28	VARCHAR2	(240)
ATTRIBUTE29	VARCHAR2	(240)
ATTRIBUTE30	VARCHAR2	(240)
ATTRIBUTE31	VARCHAR2	(240)
ATTRIBUTE32	VARCHAR2	(240)
ATTRIBUTE33	VARCHAR2	(240)
ATTRIBUTE34	VARCHAR2	(240)
ATTRIBUTE35	VARCHAR2	(240)
ATTRIBUTE36	VARCHAR2	(240)
ATTRIBUTE37	VARCHAR2	(240)
ATTRIBUTE38	VARCHAR2	(240)
ATTRIBUTE39	VARCHAR2	(240)
ATTRIBUTE40	VARCHAR2	(240)
ATTRIBUTE41	VARCHAR2	(240)
ATTRIBUTE42	VARCHAR2	(240)
ATTRIBUTE43	VARCHAR2	(240)
ATTRIBUTE44	VARCHAR2	(240)
ATTRIBUTE45	VARCHAR2	(240)
ATTRIBUTE46	VARCHAR2	(240)
ATTRIBUTE47	VARCHAR2	(240)
ATTRIBUTE48	VARCHAR2	(240)
ATTRIBUTE49	VARCHAR2	(240)
ATTRIBUTE50	VARCHAR2	(240)
ATTRIBUTE51	VARCHAR2	(240)
ATTRIBUTE52	VARCHAR2	(240)
ATTRIBUTE53	VARCHAR2	(240)
ATTRIBUTE54	VARCHAR2	(240)
ATTRIBUTE55	VARCHAR2	(240)
ATTRIBUTE56	VARCHAR2	(240)
ATTRIBUTE57	VARCHAR2	(240)
ATTRIBUTE58	VARCHAR2	(240)
ATTRIBUTE59	VARCHAR2	(240)
ATTRIBUTE60	VARCHAR2	(240)
ATTRIBUTE61	VARCHAR2	(240)
ATTRIBUTE62	VARCHAR2	(240)
ATTRIBUTE63	VARCHAR2	(240)
ATTRIBUTE64	VARCHAR2	(240)
ATTRIBUTE65	VARCHAR2	(240)
ATTRIBUTE66	VARCHAR2	(240)
ATTRIBUTE67	VARCHAR2	(240)
ATTRIBUTE68	VARCHAR2	(240)
ATTRIBUTE69	VARCHAR2	(240)
ATTRIBUTE70	VARCHAR2	(240)
ATTRIBUTE71	VARCHAR2	(240)
ATTRIBUTE72	VARCHAR2	(240)
ATTRIBUTE73	VARCHAR2	(240)
ATTRIBUTE74	VARCHAR2	(240)
ATTRIBUTE75	VARCHAR2	(240)
ATTRIBUTE76	VARCHAR2	(240)
ATTRIBUTE77	VARCHAR2	(240)
ATTRIBUTE78	VARCHAR2	(240)
ATTRIBUTE79	VARCHAR2	(240)
ATTRIBUTE80	VARCHAR2	(240)
ATTRIBUTE81	VARCHAR2	(240)
ATTRIBUTE82	VARCHAR2	(240)
ATTRIBUTE83	VARCHAR2	(240)
ATTRIBUTE84	VARCHAR2	(240)
ATTRIBUTE85	VARCHAR2	(240)
ATTRIBUTE86	VARCHAR2	(240)
ATTRIBUTE87	VARCHAR2	(240)
ATTRIBUTE88	VARCHAR2	(240)
ATTRIBUTE89	VARCHAR2	(240)
ATTRIBUTE90	VARCHAR2	(240)
ATTRIBUTE91	VARCHAR2	(240)
ATTRIBUTE92	VARCHAR2	(240)
ATTRIBUTE93	VARCHAR2	(240)
ATTRIBUTE94	VARCHAR2	(240)
ATTRIBUTE95	VARCHAR2	(240)
ATTRIBUTE96	VARCHAR2	(240)
ATTRIBUTE97	VARCHAR2	(240)
ATTRIBUTE98	VARCHAR2	(240)
ATTRIBUTE99	VARCHAR2	(240)
ATTRIBUTE100	VARCHAR2	(240)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
ORG_ID	NUMBER	(15)
EXCHANGE_RATE	NUMBER
FORECAST_ID	NUMBER	(15)
UPSIDE_QUANTITY	NUMBER
UPSIDE_AMOUNT	NUMBER
UOM_CODE	VARCHAR2	(3)
SOURCE_TRX_ID	NUMBER
SOURCE_TRX_LINE_ID	NUMBER
SOURCE_TRX_SALES_LINE_ID	NUMBER
NEGATED_FLAG	VARCHAR2	(1)
CUSTOMER_ID	NUMBER	(15)
INVENTORY_ITEM_ID	NUMBER	(15)
ORDER_NUMBER	NUMBER
BOOKED_DATE	DATE
INVOICE_NUMBER	VARCHAR2	(20)
INVOICE_DATE	DATE
BILL_TO_ADDRESS_ID	NUMBER
SHIP_TO_ADDRESS_ID	NUMBER
BILL_TO_CONTACT_ID	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
ADJ_COMM_LINES_API_ID	NUMBER	(15)
ADJUST_DATE	DATE
ADJUSTED_BY	VARCHAR2	(100)
REVENUE_TYPE	VARCHAR2	(15)
ADJUST_ROLLUP_FLAG	VARCHAR2	(1)
ADJUST_COMMENTS	VARCHAR2	(2000)
ADJUST_STATUS	VARCHAR2	(20)
LINE_NUMBER	NUMBER
REQUEST_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
TYPE	VARCHAR2	(80)
SALES_CHANNEL	VARCHAR2	(30)
OBJECT_VERSION_NUMBER	NUMBER		Yes
SPLIT_PCT	NUMBER
SPLIT_STATUS	VARCHAR2	(30)
SECURITY_GROUP_ID	NUMBER
PARENT_HEADER_ID	NUMBER	(15)

Query Text

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


SELECT COMMISSION_HEADER_ID
,      DIRECT_SALESREP_ID
,      PROCESSED_DATE
,      PROCESSED_PERIOD_ID
,      ROLLUP_DATE
,      TRANSACTION_AMOUNT
,      QUANTITY
,      DISCOUNT_PERCENTAGE
,      MARGIN_PERCENTAGE
,      ORIG_CURRENCY_CODE
,      TRANSACTION_AMOUNT_ORIG
,      TRX_TYPE
,      STATUS
,      PRE_PROCESSED_CODE
,      COMM_LINES_API_ID
,      SOURCE_DOC_TYPE
,      SOURCE_TRX_NUMBER
,      QUOTA_ID
,      SRP_PLAN_ASSIGN_ID
,      REVENUE_CLASS_ID
,      ROLE_ID
,      COMP_GROUP_ID
,      COMMISSION_AMOUNT
,      TRX_BATCH_ID
,      REVERSAL_FLAG
,      REVERSAL_HEADER_ID
,      REASON_CODE
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE31
,      ATTRIBUTE32
,      ATTRIBUTE33
,      ATTRIBUTE34
,      ATTRIBUTE35
,      ATTRIBUTE36
,      ATTRIBUTE37
,      ATTRIBUTE38
,      ATTRIBUTE39
,      ATTRIBUTE40
,      ATTRIBUTE41
,      ATTRIBUTE42
,      ATTRIBUTE43
,      ATTRIBUTE44
,      ATTRIBUTE45
,      ATTRIBUTE46
,      ATTRIBUTE47
,      ATTRIBUTE48
,      ATTRIBUTE49
,      ATTRIBUTE50
,      ATTRIBUTE51
,      ATTRIBUTE52
,      ATTRIBUTE53
,      ATTRIBUTE54
,      ATTRIBUTE55
,      ATTRIBUTE56
,      ATTRIBUTE57
,      ATTRIBUTE58
,      ATTRIBUTE59
,      ATTRIBUTE60
,      ATTRIBUTE61
,      ATTRIBUTE62
,      ATTRIBUTE63
,      ATTRIBUTE64
,      ATTRIBUTE65
,      ATTRIBUTE66
,      ATTRIBUTE67
,      ATTRIBUTE68
,      ATTRIBUTE69
,      ATTRIBUTE70
,      ATTRIBUTE71
,      ATTRIBUTE72
,      ATTRIBUTE73
,      ATTRIBUTE74
,      ATTRIBUTE75
,      ATTRIBUTE76
,      ATTRIBUTE77
,      ATTRIBUTE78
,      ATTRIBUTE79
,      ATTRIBUTE80
,      ATTRIBUTE81
,      ATTRIBUTE82
,      ATTRIBUTE83
,      ATTRIBUTE84
,      ATTRIBUTE85
,      ATTRIBUTE86
,      ATTRIBUTE87
,      ATTRIBUTE88
,      ATTRIBUTE89
,      ATTRIBUTE90
,      ATTRIBUTE91
,      ATTRIBUTE92
,      ATTRIBUTE93
,      ATTRIBUTE94
,      ATTRIBUTE95
,      ATTRIBUTE96
,      ATTRIBUTE97
,      ATTRIBUTE98
,      ATTRIBUTE99
,      ATTRIBUTE100
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
,      EXCHANGE_RATE
,      FORECAST_ID
,      UPSIDE_QUANTITY
,      UPSIDE_AMOUNT
,      UOM_CODE
,      SOURCE_TRX_ID
,      SOURCE_TRX_LINE_ID
,      SOURCE_TRX_SALES_LINE_ID
,      NEGATED_FLAG
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      ORDER_NUMBER
,      BOOKED_DATE
,      INVOICE_NUMBER
,      INVOICE_DATE
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      ADJ_COMM_LINES_API_ID
,      ADJUST_DATE
,      ADJUSTED_BY
,      REVENUE_TYPE
,      ADJUST_ROLLUP_FLAG
,      ADJUST_COMMENTS
,      ADJUST_STATUS
,      LINE_NUMBER
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      TYPE
,      SALES_CHANNEL
,      OBJECT_VERSION_NUMBER
,      SPLIT_PCT
,      SPLIT_STATUS
,      SECURITY_GROUP_ID
,      PARENT_HEADER_ID
FROM CN.CN_COMMISSION_HEADERS_ALL#;

Dependencies

[top of page]

CN.CN_COMMISSION_HEADERS_ALL# references the following:

CN: CN_COMMISSION_HEADERS_ALL

CN.CN_COMMISSION_HEADERS_ALL# is referenced by following:

APPS: CN_COMMISSION_HEADERS; CN_COMMISSION_HEADERS_ALL