[Home] [Help] [Dependency Information]

TABLE: FA.FA_ASSET_INVOICES

Object Details

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

FA_ASSET_INVOICES stores accounts payable and purchasing
information about your assets so you can track your assets to their
source. This table also stores all costs interfaced from projects
including labor and expenses.
.
Oracle Assets inserts a row into this table for each asset when you
use Mass Additions to automatically add your assets. For manual
additions, Oracle Assets inserts a row only if you complete the
purchasing zone of the Additions form. This becomes an "active"
row for the asset. You can have multiple "active" rows for each
asset.
.
Oracle Assets inserts an "active" row into this table when you use
the CIP Asset Adjustments form to add an invoice line to a CIP
asset. If you delete an invoice line using this form, Oracle
Assets marks the row as obsolete. If you change an invoice line
using the CIP Asset Adjustments form or the Transfer Invoices form,
Oracle Assets inserts another row into this table, which then
becomes an "active" row, and marks the previous row as obsolete.
.
When Oracle Assets terminates a row, the DATE_INEFFECTIVE and
INVOICE_TRANSACTION_ID_OUT are set to the DATE_EFFECTIVE and
INVOICE_TRANSACTION_ID_IN of the new row, respectively. This
means that you can easily identify rows affected by the same
transaction because they have the same DATE_EFFECTIVE /
DATE_INEFFECTIVE and INVOICE_TRANSACTION_ID_IN /
INVOICE_TRANSACTION_ID_OUT pairs. When Oracle Assets created the
new row, the value used for the INVOICE_TRANSACTION_ID_IN column
is the same as the INVOICE_TRANSACTION_ID in the row inserted in
FA_INVOICE_TRANSACTIONS, and the DATE_EFFECTIVE is the system date.
Oracle Assets also inserts a row in FA_TRANSACTION_HEADERS in which
the INVOICE_TRANSACTION_ID is the same as the
INVOICE_TRANSACTION_ID in FA_INVOICE_TRANSACTIONS.
.
FEEDER_SYSTEM_NAME identifies the system from which the mass
additions originated.
.
POST_BATCH_ID identifies the Mass Additions Post concurrent request
that posted your mass additions to Oracle Assets.
.
DELETED_FLAG is set to 'YES' when you delete an invoice using the
CIP Asset Adjustments form.
.
DATE_EFFECTIVE is the date on which you entered the transaction
into Oracle Assets.
.
SPLIT_MERGED_CODE tells you whether an invoice was split or merged:
.
{{FB}}MC{{F0}}
{{TAB}}Merged child - Oracle Assets merged this invoice
line into another mass addition.
.
{{FB}}MP{{F0}}
{{TAB}}Merged parent - Oracle Assets merged other invoice
lines into this mass addition.
.
{{FB}}SC{{F0}}
{{TAB}}Split child - Oracle Assets created this mass
addition from a multi-unit mass addition.
.
{{FB}}SP{{F0}}
{{TAB}}Split parent - Oracle Assets split this multi-unit
mass addition into individual mass additions.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_ASSET_INVOICES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_LINE_ID
FA_ASSET_INVOICES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID PO_VENDOR_ID INVOICE_NUMBER
FA_ASSET_INVOICES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID PO_VENDOR_ID PO_NUMBER
FA_ASSET_INVOICES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_NUMBER
FA_ASSET_INVOICES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_INVOICE_ID
FA_ASSET_INVOICES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_VENDOR_ID
FA_ASSET_INVOICES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ASSET_LINE_ID
FA_ASSET_INVOICES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_DISTRIBUTION_ID
FA_ASSET_INVOICES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID

Columns

Query Text

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

SELECT ASSET_ID
,      PO_VENDOR_ID
,      ASSET_INVOICE_ID
,      FIXED_ASSETS_COST
,      DATE_EFFECTIVE
,      DATE_INEFFECTIVE
,      INVOICE_TRANSACTION_ID_IN
,      INVOICE_TRANSACTION_ID_OUT
,      DELETED_FLAG
,      PO_NUMBER
,      INVOICE_NUMBER
,      PAYABLES_BATCH_NAME
,      PAYABLES_CODE_COMBINATION_ID
,      FEEDER_SYSTEM_NAME
,      CREATE_BATCH_DATE
,      CREATE_BATCH_ID
,      INVOICE_DATE
,      PAYABLES_COST
,      POST_BATCH_ID
,      INVOICE_ID
,      AP_DISTRIBUTION_LINE_NUMBER
,      PAYABLES_UNITS
,      SPLIT_MERGED_CODE
,      DESCRIPTION
,      PARENT_MASS_ADDITION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      UNREVALUED_COST
,      MERGED_CODE
,      SPLIT_CODE
,      MERGE_PARENT_MASS_ADDITIONS_ID
,      SPLIT_PARENT_MASS_ADDITIONS_ID
,      PROJECT_ASSET_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      SOURCE_LINE_ID
,      DEPRECIATE_IN_GROUP_FLAG
,      MATERIAL_INDICATOR_FLAG
,      PRIOR_SOURCE_LINE_ID
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_LINE_NUMBER
,      PO_DISTRIBUTION_ID
FROM FA.FA_ASSET_INVOICES;

Dependencies

[top of page]

FA.FA_ASSET_INVOICES does not reference any database object

FA.FA_ASSET_INVOICES is referenced by following:

FA

FA_ASSET_INVOICES#