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_COMMLINE_API_IMP_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

CN_COMMLINE_API_IMP_V is the seeded view for importing data into CN_COMM_LINES_API_ALL.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
IMP_LINE_ID	NUMBER	(15)	Yes	Identifier
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created 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).
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard Who column
IMP_HEADER_ID	NUMBER	(15)	Yes	Import header ID
IMPORT_TYPE_CODE	VARCHAR2	(30)	Yes	Import Type code
STATUS_CODE	VARCHAR2	(30)	Yes	Import status
ERROR_CODE	VARCHAR2	(30)		Import error
ERROR_MSG	VARCHAR2	(2000)		Error messages
RECORD_NUM	NUMBER			Record Number
RESOURCE_NAME	VARCHAR2	(240)		Resource Name
EMPLOYEE_NUMBER	VARCHAR2	(240)		Employee Number
PROCESSED_DATE	VARCHAR2	(240)		Transaction process date
TRANSACTION_AMOUNT	VARCHAR2	(240)		Transaction amount
QUANTITY	VARCHAR2	(240)		Transaction quantity
ORDER_NUMBER	VARCHAR2	(240)		Order number
ORDER_DATE	VARCHAR2	(240)		Order date
INVOICE_NUMBER	VARCHAR2	(240)		Invoice number
INVOICE_DATE	VARCHAR2	(240)		Invoice date
REVENUE_TYPE	VARCHAR2	(240)		Revenue Type
SALES_CHANNEL	VARCHAR2	(240)		Sales channel
REVENUE_CLASS_NAME	VARCHAR2	(240)		Revenue Class name
ATTRIBUTE_CATEGORY	VARCHAR2	(240)		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
UNMAP1	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP2	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP3	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP4	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP5	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP6	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP7	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP8	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP9	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP10	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP11	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP12	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP13	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP14	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP15	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP16	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP17	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP18	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP19	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP20	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP21	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP22	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP23	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP24	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP25	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP26	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP27	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP28	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP29	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP30	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP31	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP32	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP33	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP34	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP35	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP36	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP37	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP38	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP39	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP40	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP41	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP42	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP43	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP44	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP45	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP46	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP47	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP48	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP49	VARCHAR2	(240)		Dummy column for unmapped data file column.
UNMAP50	VARCHAR2	(240)		Dummy column for unmapped data file column.
COMMISSION_AMOUNT	VARCHAR2	(240)		Commission Amount
EXCHANGE_RATE	VARCHAR2	(240)		Exchange Rate
TRANSACTION_CURRENCY_CODE	VARCHAR2	(240)		Transaction currecny code
DISCOUNT_PERCENTAGE	VARCHAR2	(240)		Discount percentage
MARGIN_PERCENTAGE	VARCHAR2	(240)		Margin percentage
REASON_CODE	VARCHAR2	(240)		Reason Code
PRE_PROCESSED_CODE	VARCHAR2	(240)		Pre Processed Code
COMPENSATION_GROUP_NAME	VARCHAR2	(240)		Compensation group name
PLAN_ELEMENT_NAME	VARCHAR2	(240)		Plan element name
ROLE_NAME	VARCHAR2	(240)		Role name
ROLLUP_DATE	VARCHAR2	(240)		Rollup date
LINE_NUMBER	VARCHAR2	(240)		Line Number
SPLIT_PCT	VARCHAR2	(240)		Split percentage
PRESERVE_CREDIT_OVERRIDE_FLAG	VARCHAR2	(240)		Flag to disable Sales Credit Allocation
ADJUST_COMMENTS	VARCHAR2	(240)

Query Text

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


SELECT IMP_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      IMP_HEADER_ID
,      IMPORT_TYPE_CODE
,      STATUS_CODE
,      ERROR_CODE
,      ERROR_MSG
,      RECORD_NUM
,      RESOURCE_NAME
,      EMPLOYEE_NUMBER
,      PROCESSED_DATE
,      TRANSACTION_AMOUNT
,      QUANTITY
,      ORDER_NUMBER
,      ORDER_DATE
,      INVOICE_NUMBER
,      INVOICE_DATE
,      REVENUE_TYPE
,      SALES_CHANNEL
,      REVENUE_CLASS_NAME
,      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
,      UNMAP1
,      UNMAP2
,      UNMAP3
,      UNMAP4
,      UNMAP5
,      UNMAP6
,      UNMAP7
,      UNMAP8
,      UNMAP9
,      UNMAP10
,      UNMAP11
,      UNMAP12
,      UNMAP13
,      UNMAP14
,      UNMAP15
,      UNMAP16
,      UNMAP17
,      UNMAP18
,      UNMAP19
,      UNMAP20
,      UNMAP21
,      UNMAP22
,      UNMAP23
,      UNMAP24
,      UNMAP25
,      UNMAP26
,      UNMAP27
,      UNMAP28
,      UNMAP29
,      UNMAP30
,      UNMAP31
,      UNMAP32
,      UNMAP33
,      UNMAP34
,      UNMAP35
,      UNMAP36
,      UNMAP37
,      UNMAP38
,      UNMAP39
,      UNMAP40
,      UNMAP41
,      UNMAP42
,      UNMAP43
,      UNMAP44
,      UNMAP45
,      UNMAP46
,      UNMAP47
,      UNMAP48
,      UNMAP49
,      UNMAP50
,      COMMISSION_AMOUNT
,      EXCHANGE_RATE
,      TRANSACTION_CURRENCY_CODE
,      DISCOUNT_PERCENTAGE
,      MARGIN_PERCENTAGE
,      REASON_CODE
,      PRE_PROCESSED_CODE
,      COMPENSATION_GROUP_NAME
,      PLAN_ELEMENT_NAME
,      ROLE_NAME
,      ROLLUP_DATE
,      LINE_NUMBER
,      SPLIT_PCT
,      PRESERVE_CREDIT_OVERRIDE_FLAG
,      ADJUST_COMMENTS
FROM APPS.CN_COMMLINE_API_IMP_V;

Dependencies

[top of page]

APPS.CN_COMMLINE_API_IMP_V references the following:

APPS: CN_IMP_LINES

APPS.CN_COMMLINE_API_IMP_V is referenced by following:

APPS: CN_IMP_TRXAPI_PVT - show dependent code