[Home] [Help] [Dependency Information]
Object Name: | ICX_POR_UPLOADER_SUBTABLE |
---|---|
Object Type: | TABLE |
Owner: | ICX |
FND Design Data: | ICX.ICX_POR_UPLOADER_SUBTABLE |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ICX_POR_UPLOADER_SUBTABLE_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | JOB_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NUMBER | NUMBER | Upload job number | ||
BUSINESS_GROUP_ID | NUMBER | Business group ID | ||
OPERATING_UNIT | VARCHAR2 | (250) | Operating Unit | |
SUPPLIER_NAME | VARCHAR2 | (250) | Supplier name | |
SUPPLIER_SITE | VARCHAR2 | (250) | Supplier Site | |
CONTRACT_REFERENCE_NUM | VARCHAR2 | (20) | Contract Reference Number |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_NUMBER
, BUSINESS_GROUP_ID
, OPERATING_UNIT
, SUPPLIER_NAME
, SUPPLIER_SITE
, CONTRACT_REFERENCE_NUM
FROM ICX.ICX_POR_UPLOADER_SUBTABLE;
ICX.ICX_POR_UPLOADER_SUBTABLE does not reference any database object
ICX.ICX_POR_UPLOADER_SUBTABLE is referenced by following:
|
|
|