[Home] [Help] [Dependency Information]
Object Name: | FII_TMP_PK |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_TMP_PK |
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_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_ID | NUMBER | (15) | Yes | Sequence identifier |
PRIMARY_KEY1 | NUMBER | (15) | Numeric primary key 1 | |
PRIMARY_KEY2 | NUMBER | (15) | Numeric primary key 2 | |
PRIMARY_KEY3 | NUMBER | (15) | Numeric primary key 3 | |
PRIMARY_KEY4 | NUMBER | (15) | Numeric primary key 4 | |
PRIMARY_KEY5 | NUMBER | (15) | Numeric primary key 5 | |
PRIMARY_KEY_CHAR1 | VARCHAR2 | (240) | Character primary key 1 | |
PRIMARY_KEY_CHAR2 | VARCHAR2 | (240) | Character primary key 2 | |
PRIMARY_KEY_CHAR3 | VARCHAR2 | (240) | Character primary key 3 | |
PRIMARY_KEY_CHAR4 | VARCHAR2 | (240) | Character primary key 4 | |
PRIMARY_KEY_CHAR5 | VARCHAR2 | (240) | Character primary key 5 | |
PRIMARY_KEY_DATE1 | DATE | Date primary key 1 | ||
PRIMARY_KEY_DATE2 | DATE | Date primary key 2 | ||
PRIMARY_KEY_DATE3 | DATE | Date primary key 3 | ||
PRIMARY_KEY_DATE4 | DATE | Date primary key 4 | ||
PRIMARY_KEY_DATE5 | DATE | Date primary key 5 |
Cut, paste (and edit) the following text to query this object:
SELECT SEQ_ID
, PRIMARY_KEY1
, PRIMARY_KEY2
, PRIMARY_KEY3
, PRIMARY_KEY4
, PRIMARY_KEY5
, PRIMARY_KEY_CHAR1
, PRIMARY_KEY_CHAR2
, PRIMARY_KEY_CHAR3
, PRIMARY_KEY_CHAR4
, PRIMARY_KEY_CHAR5
, PRIMARY_KEY_DATE1
, PRIMARY_KEY_DATE2
, PRIMARY_KEY_DATE3
, PRIMARY_KEY_DATE4
, PRIMARY_KEY_DATE5
FROM FII.FII_TMP_PK;
FII.FII_TMP_PK does not reference any database object
FII.FII_TMP_PK is referenced by following:
|
|
|