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

TABLE: ICX.ICX_CAT_R12_UPG_EXCEP_FILES

Object Details
Object Name: ICX_CAT_R12_UPG_EXCEP_FILES
Object Type: TABLE
Owner: ICX
Subobject Name:
Status: VALID


This table is used to store R12 upgrade exception files.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000401962C00008$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
ICX_CAT_R12_UPG_EXCEP_FILES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_HEADER_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
INTERFACE_HEADER_ID NUMBER
Yes Interface header Id
VENDOR_ID NUMBER

Supplier Id
VENDOR_SITE_ID NUMBER

Supplier Site Id
ORG_ID NUMBER

Operating Unit Id
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CONTRACT_NUM NUMBER

Contract Number
FILE_NAME VARCHAR2 (50)
File Name
DATA_FILE CLOB (4000)
XML File
LANGUAGE VARCHAR2 (10)
Language Code
CREATED_BY NUMBER
Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_HEADER_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORG_ID
,      CURRENCY_CODE
,      CONTRACT_NUM
,      FILE_NAME
,      DATA_FILE
,      LANGUAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_CAT_R12_UPG_EXCEP_FILES;

Dependencies

[top of page]

ICX.ICX_CAT_R12_UPG_EXCEP_FILES does not reference any database object

ICX.ICX_CAT_R12_UPG_EXCEP_FILES is referenced by following:

SchemaICX
ViewICX_CAT_R12_UPG_EXCEP_FILES#