[Home] [Help] [Dependency Information]

TABLE: FA.FA_INVOICE_TRANSACTIONS

Object Details

Object Name:	FA_INVOICE_TRANSACTIONS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_INVOICE_TRANSACTIONS
Subobject Name:
Status:	VALID

FA_INVOICE_TRANSACTIONS tracks all the transactions you perform on
invoice lines within Oracle Assets.
.
Oracle Assets inserts rows in this table and in
FA_TRANSACTION_HEADERS each time you perform a transaction on an
invoice line.
.
TRANSACTION_TYPE identifies the type of transaction:
.
{{FB}}INVOICE ADDITION{{F0}}
{{TAB}}Created by the CIP Adjustments form when you add an
invoice line.
.
{{FB}}INVOICE ADJUSTMENT{{F0}}
{{TAB}}Created by the CIP Adjustments form when you perform
a cost change on an invoice line.
.
{{FB}}INVOICE DELETE{{F0}}
{{TAB}}Created by the CIP Adjustments form when you delete
an invoice line.
.
{{FB}}INVOICE REINSTATE{{F0}}
{{TAB}}Created by the CIP Adjustments form when you
reinstate an invoice line you previously deleted.
.
{{FB}}INVOICE TRANSFER{{F0}}
{{TAB}}Created by the Transfer Invoices form when you transfer
an invoice between CIP assets or between a CIP and a capitalized
asset.
.
{{FB}}MASS ADDITION{{F0}}
{{TAB}}Created by the mass additions posting program when
you send mass additions to Oracle Assets.
.
DATE_EFFECTIVE is the date on which you entered the transaction
into Oracle Assets.
.
INVOICE_TRANSACTION_ID uniquely identifies each invoice
transaction.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_INVOICE_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_TRANSACTION_ID
FA_INVOICE_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE DATE_EFFECTIVE

Columns

Query Text

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

SELECT INVOICE_TRANSACTION_ID
,      BOOK_TYPE_CODE
,      TRANSACTION_TYPE
,      DATE_EFFECTIVE
FROM FA.FA_INVOICE_TRANSACTIONS;

Dependencies

[top of page]

FA.FA_INVOICE_TRANSACTIONS does not reference any database object

FA.FA_INVOICE_TRANSACTIONS is referenced by following:

FA

FA_INVOICE_TRANSACTIONS#