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

TABLE: FTE.FTE_INVOICE_HISTORY

Object Details
Object Name: FTE_INVOICE_HISTORY
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_INVOICE_HISTORY
Subobject Name:
Status: VALID


Table to store invoice history information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_INVOICE_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_HISTORY_ID
FTE_INVOICE_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_ID
FTE_INVOICE_HISTORY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_NAME
FTE_INVOICE_HISTORY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOL
Columns
Name Datatype Length Mandatory Comments
INVOICE_HISTORY_ID NUMBER
Yes Invoice History id
PARENT_ID NUMBER
Yes Id refer back to the table defined in parent name column
PARENT_NAME VARCHAR2 (30) Yes Table name for history
BOL VARCHAR2 (30)
Bill of lading number
ACTION VARCHAR2 (30)
Action taken
RESULT VARCHAR2 (30)
Action result
DISCREPANCY_CODE VARCHAR2 (30)
Discrepancy Code
CREATED_BY NUMBER
Yes Standard who columns
CREATION_DATE DATE
Yes Standard who columns
LAST_UPDATED_BY NUMBER
Yes Standard who columns
LAST_UPDATE_DATE DATE

Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
Query Text

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


SELECT INVOICE_HISTORY_ID
,      PARENT_ID
,      PARENT_NAME
,      BOL
,      ACTION
,      RESULT
,      DISCREPANCY_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FTE.FTE_INVOICE_HISTORY;

Dependencies

[top of page]

FTE.FTE_INVOICE_HISTORY does not reference any database object

FTE.FTE_INVOICE_HISTORY is referenced by following:

SchemaFTE
ViewFTE_INVOICE_HISTORY#