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:

SchemaAPPS
SynonymCN_IMP_LINES
APPS.CN_REVENUE_CLASSES_IMP_V is referenced by following:

SchemaAPPS
Package BodyCN_IMP_REV_CL_PVT - show dependent code