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: APPS.CN_ADJUSTMENTS_V

Object Details

Object Name:	CN_ADJUSTMENTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
COMMISSION_HEADER_ID	NUMBER		Foreign key to CN_COMMISSION_HEADERS
ORG_ID	NUMBER		OrgId
DIRECT_SALESREP_NUMBER	VARCHAR2	(30)	Salesrep number of salesrep directly credited.
DIRECT_SALESREP_NAME	VARCHAR2	(360)	Name of salesrep who is directly credited.
DIRECT_SALESREP_ID	NUMBER	(15)	Salesrep directly credited.
PROCESSED_PERIOD_ID	NUMBER	(15)	Unique identifier of revenue recognition period.
PROCESSED_PERIOD	VARCHAR2	(30)	Period in which revenue is recognized.
PROCESSED_DATE	DATE		Revenue recognition date.
ROLLUP_DATE	DATE		Date that the transaction was rolled up.
TRANSACTION_AMOUNT	NUMBER		Functional transaction amount.
TRANSACTION_AMOUNT_ORIG	NUMBER		Original transaction amount.
QUANTITY	NUMBER		Quantity amount.
DISCOUNT_PERCENTAGE	NUMBER		Discount percentage for discount based commission.
MARGIN_PERCENTAGE	NUMBER		Margin percentage for margin based commission.
ORIG_CURRENCY_CODE	VARCHAR2	(15)	Original Currency Code.
EXCHANGE_RATE	NUMBER		Exchange Rate.
STATUS_DISP	VARCHAR2	(80)	Calculation status.
STATUS	VARCHAR2	(30)	Calculation status code.
TRX_TYPE_DISP	VARCHAR2	(80)	Transaction type.
TRX_TYPE	VARCHAR2	(30)	Transaction type code.
REASON	VARCHAR2	(80)	Manual adjustment reason.
REASON_CODE	VARCHAR2	(30)	Manual adjustment reason code.
COMMENTS	VARCHAR2	(1800)	Comments.
TRX_BATCH_ID	NUMBER		Unique identifier of the batch to which this record belongs.
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_LOGIN	NUMBER	(15)	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)	Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE17	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE18	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE19	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE20	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE21	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE22	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE23	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE24	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE25	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE26	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE27	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE28	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE29	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE30	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE31	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE32	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE33	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE34	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE35	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE36	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE37	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE38	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE39	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE40	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE41	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE42	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE43	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE44	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE45	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE46	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE47	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE48	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE49	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE50	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE51	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE52	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE53	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE54	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE55	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE56	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE57	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE58	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE59	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE60	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE61	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE62	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE63	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE64	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE65	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE66	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE67	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE68	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE69	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE70	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE71	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE72	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE73	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE74	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE75	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE76	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE77	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE78	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE79	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE80	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE81	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE82	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE83	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE84	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE85	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE86	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE87	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE88	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE89	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE90	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE91	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE92	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE93	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE94	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE95	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE96	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE97	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE98	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE99	VARCHAR2	(240)	Descriptive flexfield segment.
ATTRIBUTE100	VARCHAR2	(240)	Descriptive flexfield segment.
QUOTA_ID	NUMBER		Quota that this transaction fells under.
QUOTA_NAME	VARCHAR2	(80)	Name of the quota that this transaction fell under.
REVENUE_CLASS_ID	NUMBER	(15)	Revenue class that this transaction matches.
REVENUE_CLASS_NAME	VARCHAR2	(30)	Name of the revenue class that this transaction matches.
TRX_BATCH_NAME	VARCHAR2	(30)	Transaction batch name.
SOURCE_TRX_NUMBER	VARCHAR2	(80)	Source transaction number.
TRX_SALES_LINE_ID	NUMBER		trx_sales_line_id info from cn_trx_sales_lines
TRX_LINE_ID	NUMBER		trx_sales_line_id info from cn_trx_sales_lines
TRX_ID	NUMBER		Transaction Id
COMM_LINES_API_ID	NUMBER	(15)	Foreign key to cn_comm_lines_api
SOURCE_DOC_TYPE	VARCHAR2	(80)	Source doc type (AR/OE)
UPSIDE_AMOUNT	NUMBER		Upside amount
UPSIDE_QUANTITY	NUMBER		Upside quantity
UOM_CODE	VARCHAR2	(3)	Unit of measurement code
FORECAST_ID	NUMBER	(15)	Forecase unique identifier
PROGRAM_ID	NUMBER		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID	NUMBER		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE	DATE		Concurrent Program who column - date when a program last updated this row).
ADJ_COMM_LINES_API_ID	NUMBER	(15)	Comm lines API ID which points to the parent transaction.
INVOICE_NUMBER	VARCHAR2	(20)	Invoice number
INVOICE_DATE	DATE		Date order gets invoiced
ORDER_NUMBER	NUMBER		Order number
ORDER_DATE	DATE		Date order gets booked
LINE_NUMBER	NUMBER		Line number
CUSTOMER_ID	NUMBER	(15)	Unique Identifier of customer
BILL_TO_ADDRESS_ID	NUMBER		Unique Identifier for bill to address
SHIP_TO_ADDRESS_ID	NUMBER		Unique Identifier for ship to address
BILL_TO_CONTACT_ID	NUMBER		Unique identifier for bill to contact
SHIP_TO_CONTACT_ID	NUMBER		Bill to contact
LOAD_STATUS	VARCHAR2	(30)	Status showing whether this transaction has been loaded into commission header table
REVENUE_TYPE_DISP	VARCHAR2	(80)	Revenue type
REVENUE_TYPE	VARCHAR2	(15)	Revenue type code
ADJUST_ROLLUP_FLAG	VARCHAR2	(1)	Adjust rollup flag
ADJUST_DATE	DATE		Date transaction was adjusted.
ADJUSTED_BY	VARCHAR2	(100)	User ID that transaction was adjusted by.
ADJUST_STATUS_DISP	VARCHAR2	(80)	Adjust status of the transaction.
ADJUST_STATUS	VARCHAR2	(20)	Adjust status code of the transaction.
ADJUST_COMMENTS	VARCHAR2	(2000)	Adjust comments for the transaction.
TYPE	VARCHAR2	(80)	Salesrep type.
PRE_PROCESSED_CODE	VARCHAR2	(30)	Pre-processed code.
COMP_GROUP_ID	NUMBER	(15)	Foreign key to cn_comp_groups.
SRP_PLAN_ASSIGN_ID	NUMBER	(15)	Foreign key to cn_srp_plan_assigns
ROLE_ID	NUMBER	(15)	Foreign key to cn_roles
SALES_CHANNEL	VARCHAR2	(30)	Sales channel.
OBJECT_VERSION_NUMBER	NUMBER

Query Text

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


SELECT COMMISSION_HEADER_ID
,      ORG_ID
,      DIRECT_SALESREP_NUMBER
,      DIRECT_SALESREP_NAME
,      DIRECT_SALESREP_ID
,      PROCESSED_PERIOD_ID
,      PROCESSED_PERIOD
,      PROCESSED_DATE
,      ROLLUP_DATE
,      TRANSACTION_AMOUNT
,      TRANSACTION_AMOUNT_ORIG
,      QUANTITY
,      DISCOUNT_PERCENTAGE
,      MARGIN_PERCENTAGE
,      ORIG_CURRENCY_CODE
,      EXCHANGE_RATE
,      STATUS_DISP
,      STATUS
,      TRX_TYPE_DISP
,      TRX_TYPE
,      REASON
,      REASON_CODE
,      COMMENTS
,      TRX_BATCH_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      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
,      QUOTA_ID
,      QUOTA_NAME
,      REVENUE_CLASS_ID
,      REVENUE_CLASS_NAME
,      TRX_BATCH_NAME
,      SOURCE_TRX_NUMBER
,      TRX_SALES_LINE_ID
,      TRX_LINE_ID
,      TRX_ID
,      COMM_LINES_API_ID
,      SOURCE_DOC_TYPE
,      UPSIDE_AMOUNT
,      UPSIDE_QUANTITY
,      UOM_CODE
,      FORECAST_ID
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ADJ_COMM_LINES_API_ID
,      INVOICE_NUMBER
,      INVOICE_DATE
,      ORDER_NUMBER
,      ORDER_DATE
,      LINE_NUMBER
,      CUSTOMER_ID
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_ADDRESS_ID
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      LOAD_STATUS
,      REVENUE_TYPE_DISP
,      REVENUE_TYPE
,      ADJUST_ROLLUP_FLAG
,      ADJUST_DATE
,      ADJUSTED_BY
,      ADJUST_STATUS_DISP
,      ADJUST_STATUS
,      ADJUST_COMMENTS
,      TYPE
,      PRE_PROCESSED_CODE
,      COMP_GROUP_ID
,      SRP_PLAN_ASSIGN_ID
,      ROLE_ID
,      SALES_CHANNEL
,      OBJECT_VERSION_NUMBER
FROM APPS.CN_ADJUSTMENTS_V;

Dependencies

[top of page]

APPS.CN_ADJUSTMENTS_V references the following:

APPS: CN_COMMISSION_HEADERS; CN_COMM_LINES_API; CN_LOOKUPS; CN_PERIOD_STATUSES; CN_QUOTAS; CN_REVENUE_CLASSES; CN_SALESREPS; CN_TRX_BATCHES

APPS.CN_ADJUSTMENTS_V is not referenced by any database object