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

VIEW: APPS.CN_RULES_IMP_V

Object Details
Object Name: CN_RULES_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
RULESET_NAME VARCHAR2 (240)
Data column
START_DATE VARCHAR2 (240)
Data column
END_DATE VARCHAR2 (240)
Data column
RULESET_TYPE VARCHAR2 (240)
Data column
RULE_NAME VARCHAR2 (240)
Data column
PARENT_RULE_NAME VARCHAR2 (240)
Data column
REVENUE_CLASS_NAME VARCHAR2 (240)
Data column
EXPENSE_CODE VARCHAR2 (240)
Data column
LIABILITY_CODE VARCHAR2 (240)
Data column
RULE_ATTRIBUTE VARCHAR2 (240)
Data column
RULE_HIERARCHY VARCHAR2 (240)
Data column
RULE_VALUE VARCHAR2 (240)
Data column
RULE_LOW_VALUE VARCHAR2 (240)
Data column
RULE_HIGH_VALUE VARCHAR2 (240)
Data column
NOT_FLAG 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.
UNMAP11 VARCHAR2 (240)
Dummy column used for unmapped columns.
LEVEL_NUM VARCHAR2 (240)
Level Number to indicate hierarchy level
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
,      RULESET_NAME
,      START_DATE
,      END_DATE
,      RULESET_TYPE
,      RULE_NAME
,      PARENT_RULE_NAME
,      REVENUE_CLASS_NAME
,      EXPENSE_CODE
,      LIABILITY_CODE
,      RULE_ATTRIBUTE
,      RULE_HIERARCHY
,      RULE_VALUE
,      RULE_LOW_VALUE
,      RULE_HIGH_VALUE
,      NOT_FLAG
,      UNMAP1
,      UNMAP2
,      UNMAP3
,      UNMAP4
,      UNMAP5
,      UNMAP6
,      UNMAP7
,      UNMAP8
,      UNMAP9
,      UNMAP10
,      UNMAP11
,      LEVEL_NUM
FROM APPS.CN_RULES_IMP_V;

Dependencies

[top of page]

APPS.CN_RULES_IMP_V references the following:

SchemaAPPS
SynonymCN_IMP_LINES
APPS.CN_RULES_IMP_V is referenced by following:

SchemaAPPS
Package BodyCN_IMP_RULE_PVT - show dependent code