DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CN_HIERARCHY_IMP_V

Object Details
Object Name: CN_HIERARCHY_IMP_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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
HIERARCHY_TYPE VARCHAR2 (240)
Hierarchy Type
BASE_TABLE_NAME VARCHAR2 (240)
Base table name
PRIMARY_KEY VARCHAR2 (240)
Primary key
HIERARCHY_VALUE VARCHAR2 (240)
Hierarchy value
HIERARCHY_NAME VARCHAR2 (240)
Hierarchy name
START_DATE VARCHAR2 (240)
Hierarchy start date
END_DATE VARCHAR2 (240)
Hierarchy end date
DEFAULT_NODE_FLAG VARCHAR2 (240)
Default node flag
PARENT_NODE_NAME VARCHAR2 (240)
Parent node name
NODE_NAME VARCHAR2 (240)
Node name
LEVEL_NUM VARCHAR2 (240)
Level number
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.
UNMAP11 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP12 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP13 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP14 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP15 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP16 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP17 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP18 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP19 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP20 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP21 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP22 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP23 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP24 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP25 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP26 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP27 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP28 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP29 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP30 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP31 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP32 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP33 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP34 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP35 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP36 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP37 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP38 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP39 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP40 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP41 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP42 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP43 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP44 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP45 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP46 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP47 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP48 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP49 VARCHAR2 (240)
Dummy column used for unmapped columns.
UNMAP50 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
,      HIERARCHY_TYPE
,      BASE_TABLE_NAME
,      PRIMARY_KEY
,      HIERARCHY_VALUE
,      HIERARCHY_NAME
,      START_DATE
,      END_DATE
,      DEFAULT_NODE_FLAG
,      PARENT_NODE_NAME
,      NODE_NAME
,      LEVEL_NUM
,      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
FROM APPS.CN_HIERARCHY_IMP_V;

Dependencies

[top of page]

APPS.CN_HIERARCHY_IMP_V references the following:

SchemaAPPS
SynonymCN_IMP_LINES
APPS.CN_HIERARCHY_IMP_V is referenced by following:

SchemaAPPS
Package BodyCN_IMP_HIERARCHY_PVT - show dependent code