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

VIEW: APPS.CN_PERZ_QUOTA_API_IMP_V

Object Details
Object Name: CN_PERZ_QUOTA_API_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
COMP_GROUP_NAME VARCHAR2 (240)
Data column
RESOURCE_NAME VARCHAR2 (240)
Data column
EMPLOYEE_NUMBER VARCHAR2 (240)
Data column
ROLE_NAME VARCHAR2 (240)
Data column
ORGANIZATION VARCHAR2 (240)
Data column
START_DATE VARCHAR2 (240)
Data column
END_DATE VARCHAR2 (240)
Data column
QUOTA_CATEGORY_NAME VARCHAR2 (240)
Data column
QUOTA_CATEGORY_TYPE VARCHAR2 (240)
Data column
ANNUAL_OTE VARCHAR2 (240)
Data column
PRORATED_OTE VARCHAR2 (240)
Data column
ANNUAL_QUOTA VARCHAR2 (240)
Data column
PRORATED_QUOTA VARCHAR2 (240)
Data column
CLUB_AMOUNT VARCHAR2 (240)
Data column
SIMPLE_RATE VARCHAR2 (240)
Data column
ENC_KEY 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.
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.
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
,      COMP_GROUP_NAME
,      RESOURCE_NAME
,      EMPLOYEE_NUMBER
,      ROLE_NAME
,      ORGANIZATION
,      START_DATE
,      END_DATE
,      QUOTA_CATEGORY_NAME
,      QUOTA_CATEGORY_TYPE
,      ANNUAL_OTE
,      PRORATED_OTE
,      ANNUAL_QUOTA
,      PRORATED_QUOTA
,      CLUB_AMOUNT
,      SIMPLE_RATE
,      ENC_KEY
,      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
FROM APPS.CN_PERZ_QUOTA_API_IMP_V;

Dependencies

[top of page]

APPS.CN_PERZ_QUOTA_API_IMP_V references the following:

SchemaAPPS
SynonymCN_IMP_LINES

APPS.CN_PERZ_QUOTA_API_IMP_V is not referenced by any database object