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_MASSADD_REP_ITF

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MASSADD_REP_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Comments
REQUEST_ID	NUMBER		Concurrent request ID
BOOK_TYPE_CODE	VARCHAR2	(15)	Book name
QUEUE_NAME	VARCHAR2	(15)	Mass additions queue name
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Invoice currency code of the asset
PERIOD_NAME	VARCHAR2	(15)	Period name of the asset
ENTITY_NAME	VARCHAR2	(30)	Entity name of the asset
TRANSACTION_TYPE	VARCHAR2	(30)	Transaction type of the asset
REPORT_DATE	DATE		Report date of the asset
MASS_ADDITION_ID	NUMBER	(15)	Identification number of the mass addition
STATUS	VARCHAR2	(15)	Status of the mass addition
POSTING_STATUS	VARCHAR2	(15)	Shows the status of the mass addition
POST_BATCH_ID	NUMBER	(15)	Concurrent request identification number of the mass addition post program
ASSET_NUMBER	VARCHAR2	(15)	User assigned asset number
TAG_NUMBER	VARCHAR2	(15)	Tag number of the asset
SERIAL_NUMBER	VARCHAR2	(35)	Serial number of the asset
ASSET_KEY	VARCHAR2	(240)	The asset key flexfield combination
DESCRIPTION	VARCHAR2	(80)	Description of the asset
ASSET_CATEGORY_ID	NUMBER	(15)	Identifies the asset category
CATEGORY	VARCHAR2	(80)	Category ccid of the asset
AP_COMPANY	VARCHAR2	(30)	Accounts payable company
COMPANY_NAME	VARCHAR2	(30)	Company name of the asset
ASSET_CLEARING_ACCT	VARCHAR2	(25)	Asset clearing account of the asset
ASSET_COST_ACCOUNT	VARCHAR2	(25)	Asset cost account of the asset
ASSET_COST_ACCOUNT_CCID	NUMBER	(15)	Asset cost account ccid of the asset
ASSET_CLEARING_ACCT_CCID	NUMBER	(15)	Asset clearing account ccid of the asset
DEPRN_EXPENSE_ACCT	VARCHAR2	(25)	Depreciation expense account of the asset
DEPRN_RESERVE_ACCT	VARCHAR2	(25)	Depreciation reserve account of the asset
COST_CENTER	VARCHAR2	(30)	Cost center of the asset
EXPENSE_ACCT	VARCHAR2	(30)	Expense account of the asset
LOCATION_ID	NUMBER		The location identifier that corresponds to the location of the asset
LOCATION	VARCHAR2	(50)	Location of the asset
VENDOR_NUMBER	VARCHAR2	(30)	Vendor number of the asset
VENDOR_NAME	VARCHAR2	(240)	Vendor name of the asset
INVOICE_NUMBER	VARCHAR2	(50)	Invoice number from accounts payable
INVOICE_DATE	DATE		Invoice date
SOURCE_SYSTEMS	VARCHAR2	(30)	Source system of the asset
AP_BATCH_NAME	VARCHAR2	(50)	Accounts payable batch name
AP_DISTRIBUTION_LINE_NUMBER	NUMBER		Accounts payable distribution line number
PO_NUMBER	VARCHAR2	(20)	Purchase Order number entered by the user from purchasing through accounts payable
PAYABLES_BATCH_NAME	VARCHAR2	(50)	Payables batch name of the invoices
PAYABLES_CODE_COMBINATION_ID	NUMBER	(15)	Account debited in accounts payable
PAYABLES_COST	NUMBER		Cost of the asset in accounts payable
PAYABLES_UNITS	NUMBER		Number of units from accounts payable
FIXED_ASSETS_COST	NUMBER		Cost of the asset in Oracle Assets
FOREIGN_CURRENCY_CODE	VARCHAR2	(15)	Foreign currency code
FOREIGN_CURRENCY_AMOUNT	NUMBER		Foreign currency amount
REVIEWER_COMMENTS	VARCHAR2	(60)	Comments
DEPRN_METHOD	VARCHAR2	(30)	Depreciation method of the asset
LIFE_IN_MONTHS	NUMBER		Life of the asset
BASIC_RATE	NUMBER		Base rate used to calculate depreciation amount for flat-rate methods
ADJUSTED_RATE	NUMBER		Actual rate used to calculate depreciation amount for flat-rate methods
PRODUCTION_CAPACITY	NUMBER		Capacity of a units of production asset
UNIT_OF_MEASURE	VARCHAR2	(25)	Unit of measure of a units of production asset
PRORATE_CONVENTION	VARCHAR2	(25)	Depreciation prorate convention
LAST_UPDATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
CREATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
INVENTORIAL	VARCHAR2	(3)	Indicates whether the asset should be included in physical inventory
ASSET_TYPE	VARCHAR2	(15)	Indicates whether the asset is CIP, capitalized, expensed or group.
GROUP_ASSET_NUMBER	VARCHAR2	(15)	Group Asset number for any associated group assigned to the mass addition line.
MASS_PROPERTY_FLAG	VARCHAR2	(1)	Indicates whether Mass Property is eligible or not for assets added to this category.
WARRANTY_NUMBER	VARCHAR2	(15)	User assigned warranty number
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 REQUEST_ID
,      BOOK_TYPE_CODE
,      QUEUE_NAME
,      INVOICE_CURRENCY_CODE
,      PERIOD_NAME
,      ENTITY_NAME
,      TRANSACTION_TYPE
,      REPORT_DATE
,      MASS_ADDITION_ID
,      STATUS
,      POSTING_STATUS
,      POST_BATCH_ID
,      ASSET_NUMBER
,      TAG_NUMBER
,      SERIAL_NUMBER
,      ASSET_KEY
,      DESCRIPTION
,      ASSET_CATEGORY_ID
,      CATEGORY
,      AP_COMPANY
,      COMPANY_NAME
,      ASSET_CLEARING_ACCT
,      ASSET_COST_ACCOUNT
,      ASSET_COST_ACCOUNT_CCID
,      ASSET_CLEARING_ACCT_CCID
,      DEPRN_EXPENSE_ACCT
,      DEPRN_RESERVE_ACCT
,      COST_CENTER
,      EXPENSE_ACCT
,      LOCATION_ID
,      LOCATION
,      VENDOR_NUMBER
,      VENDOR_NAME
,      INVOICE_NUMBER
,      INVOICE_DATE
,      SOURCE_SYSTEMS
,      AP_BATCH_NAME
,      AP_DISTRIBUTION_LINE_NUMBER
,      PO_NUMBER
,      PAYABLES_BATCH_NAME
,      PAYABLES_CODE_COMBINATION_ID
,      PAYABLES_COST
,      PAYABLES_UNITS
,      FIXED_ASSETS_COST
,      FOREIGN_CURRENCY_CODE
,      FOREIGN_CURRENCY_AMOUNT
,      REVIEWER_COMMENTS
,      DEPRN_METHOD
,      LIFE_IN_MONTHS
,      BASIC_RATE
,      ADJUSTED_RATE
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      PRORATE_CONVENTION
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      INVENTORIAL
,      ASSET_TYPE
,      GROUP_ASSET_NUMBER
,      MASS_PROPERTY_FLAG
,      WARRANTY_NUMBER
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_LINE_NUMBER
,      PO_DISTRIBUTION_ID
FROM FA.FA_MASSADD_REP_ITF;

Dependencies

[top of page]

FA.FA_MASSADD_REP_ITF does not reference any database object

FA.FA_MASSADD_REP_ITF is referenced by following:

FA: FA_MASSADD_REP_ITF#