[Home] [Help] [Dependency Information]
Object Name: | FA_BALANCES_REPORTS_ITF |
---|---|
Object Type: | TABLE |
Owner: | FA |
Subobject Name: | |
Status: | VALID |
FA_BALANCES_REPORTS_ITF is an interface table for balances reports.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_BALANCES_REPORTS_ITF_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
ASSET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSET_ID | NUMBER | Asset identification number | ||
DISTRIBUTION_CCID | NUMBER | Depreciation expense account for the asset | ||
ADJUSTMENT_CCID | NUMBER | (15) | Accounting flexfield combination being adjusted | |
CATEGORY_BOOKS_ACCOUNT | VARCHAR2 | (25) | Account being adjusted, or depreciation reserve account | |
SOURCE_TYPE_CODE | VARCHAR2 | (15) | Transaction or balance this row describes | |
AMOUNT | NUMBER | Transaction or balance this row describes | ||
COST_ACCOUNT | VARCHAR2 | (25) | Asset cost account | |
COST_BEGIN_BALANCE | NUMBER | Depreciation, adjustment, cost, or reserve balance amount | ||
GROUP_ASSET_ID | NUMBER | Group asset identifier for any associated group asset | ||
REQUEST_ID | NUMBER | Request Id for the report Run |
Cut, paste (and edit) the following text to query this object:
SELECT ASSET_ID
, DISTRIBUTION_CCID
, ADJUSTMENT_CCID
, CATEGORY_BOOKS_ACCOUNT
, SOURCE_TYPE_CODE
, AMOUNT
, COST_ACCOUNT
, COST_BEGIN_BALANCE
, GROUP_ASSET_ID
, REQUEST_ID
FROM FA.FA_BALANCES_REPORTS_ITF;
FA.FA_BALANCES_REPORTS_ITF does not reference any database object
FA.FA_BALANCES_REPORTS_ITF is referenced by following:
|
|
|