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_REVENUE_CLASSES_IMP_V

Object Details

Object Name:	CN_REVENUE_CLASSES_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_REVENUE_CLASS_IMP_V is the seeded view for importing data into CN_REVENUE_CLASSES_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	Foreign key
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
NAME	VARCHAR2	(240)		Data column
DESCRIPTION	VARCHAR2	(240)		Data column
UNMAP1	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP2	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP3	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP4	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP5	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP6	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP7	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP8	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP9	VARCHAR2	(240)		Dummy column used for unmapped columns.
UNMAP10	VARCHAR2	(240)		Dummy column used for unmapped columns.

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
,      NAME
,      DESCRIPTION
,      UNMAP1
,      UNMAP2
,      UNMAP3
,      UNMAP4
,      UNMAP5
,      UNMAP6
,      UNMAP7
,      UNMAP8
,      UNMAP9
,      UNMAP10
FROM APPS.CN_REVENUE_CLASSES_IMP_V;

Dependencies

[top of page]

APPS.CN_REVENUE_CLASSES_IMP_V references the following:

APPS: CN_IMP_LINES

APPS.CN_REVENUE_CLASSES_IMP_V is referenced by following:

APPS: CN_IMP_REV_CL_PVT - show dependent code