eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FA.FA_MC_ASSET_INVOICES

Object Details

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

FA_MC_ASSET_INVOICES is an MRC sub-table of FA_ ASSET_INVOICES. This
table stores accounts payable and purchasing information about your
assets in each reporting book.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MC_ASSET_INVOICES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID SOURCE_LINE_ID
FA_MC_ASSET_INVOICES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID ASSET_INVOICE_ID SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Reporting set of books identification number for GL sets of books
EXCHANGE_RATE	NUMBER			Exchange rate as of the invoice date
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
PO_VENDOR_ID	NUMBER	(15)		Supplier identification number
ASSET_INVOICE_ID	NUMBER	(15)		Same as Mass_Addition_id number for this row
FIXED_ASSETS_COST	NUMBER			Cost of asset in Oracle Assets
DATE_EFFECTIVE	DATE		Yes	Date the row became effective
DATE_INEFFECTIVE	DATE			Date the row became ineffective
INVOICE_TRANSACTION_ID_IN	NUMBER	(15)		Transaction number from FA_INVOICE_TRANSACTIONS that created this row
INVOICE_TRANSACTION_ID_OUT	NUMBER	(15)		Transaction number from FA_INVOICE_TRANSACTIONS that terminated this row
DELETED_FLAG	VARCHAR2	(3)	Yes	Indicates whether this row has been deleted in the CIP Adjustment form
PO_NUMBER	VARCHAR2	(20)		Purchase order number
INVOICE_NUMBER	VARCHAR2	(50)		Invoice number
PAYABLES_BATCH_NAME	VARCHAR2	(50)		Name of the payables batch that contained this invoice
PAYABLES_CODE_COMBINATION_ID	NUMBER	(15)		Clearing account number to which this line was posted in accounts payable
FEEDER_SYSTEM_NAME	VARCHAR2	(40)		Name of the feeder system that created the FA_MASS_ADDITIONS row
CREATE_BATCH_DATE	DATE			Date the mass additions batch was created for this row
CREATE_BATCH_ID	NUMBER	(15)		Mass additions create request identification number for this row
INVOICE_DATE	DATE			Invoice date from accounts payable
PAYABLES_COST	NUMBER			Invoice cost from accounts payable
POST_BATCH_ID	NUMBER	(15)		Mass Additions Post request identification number for this row
INVOICE_ID	NUMBER	(15)		Invoice identification number
AP_DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Distribution line identification number
PAYABLES_UNITS	NUMBER			Units from AP_INVOICE_DISTRIBUTIONS row
SPLIT_MERGED_CODE	VARCHAR2	(3)		Indicates if the invoice line is split or merged
DESCRIPTION	VARCHAR2	(80)		Invoice line description
PARENT_MASS_ADDITION_ID	VARCHAR2	(15)		Parent mass addition identification number for the mass addition
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)		Descriptive flexfield structure defining column
UNREVALUED_COST	NUMBER			Cost without regard to any revaluations
MERGED_CODE	VARCHAR2	(3)		Indicates if the mass addition is a merged parent or a merged child.
SPLIT_CODE	VARCHAR2	(3)		Indicates if the mass addition is a split parent or a split child.
MERGE_PARENT_MASS_ADDITIONS_ID	NUMBER	(15)		Merged parent mass addition id.
SPLIT_PARENT_MASS_ADDITIONS_ID	NUMBER	(15)		Split parent mass addition id.
PROJECT_ASSET_LINE_ID	NUMBER	(15)		Identifier of the summarized asset cost line transferred from Oracle Projects to create this line.
PROJECT_ID	NUMBER	(15)		Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.
TASK_ID	NUMBER	(15)		Identifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.
SOURCE_LINE_ID	NUMBER	(15)	Yes	Reserved for system use. Do not use.
DEPRECIATE_IN_GROUP_FLAG	VARCHAR2	(1)		Indicates whether the source line will be included in the depreciable basis of any associated group asset
MATERIAL_INDICATOR_FLAG	VARCHAR2	(1)		Indicates whether the source line is material or non-material in nature
PRIOR_SOURCE_LINE_ID	NUMBER	(15)		Source line identifier corresponding to the row terminated by the invoice transaction which created this row
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice distribution identifier
INVOICE_LINE_NUMBER	NUMBER			Invoice line number
PO_DISTRIBUTION_ID	NUMBER	(15)		Purchase order distribution identifier

Query Text

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


SELECT SET_OF_BOOKS_ID
,      EXCHANGE_RATE
,      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_MC_ASSET_INVOICES;

Dependencies

[top of page]

FA.FA_MC_ASSET_INVOICES does not reference any database object

FA.FA_MC_ASSET_INVOICES is referenced by following:

FA: FA_MC_ASSET_INVOICES#