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

TABLE: FII.FII_AP_TMP_LINE_PK

Object Details
Object Name: FII_AP_TMP_LINE_PK
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AP_TMP_LINE_PK
Subobject Name:
Status: VALID


This is a temporary table used by Financial Intelligence to improve the data collection performance. It holds transaction record primary keys during a data collection run and is cleaned up after.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER (15)
Sequence identifier
PRIMARY_KEY1 NUMBER (15)
Numeric primary key 1
PRIMARY_KEY2 NUMBER (15)
Numeric primary key 2
PRIMARY_KEY3 NUMBER

Numeric primary key 3
PRIMARY_KEY4 NUMBER

Numeric primary key 4
PRIMARY_KEY5 NUMBER

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
Query Text

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_AP_TMP_LINE_PK;

Dependencies

[top of page]

FII.FII_AP_TMP_LINE_PK does not reference any database object

FII.FII_AP_TMP_LINE_PK is referenced by following:

SchemaAPPS
SynonymFII_AP_TMP_LINE_PK