[Home] [Help] [Dependency Information]
Object Name: | FA_GROUP_REP_ITF |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | OFA.FA_GROUP_REP_ITF |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_GROUP_REP_ITF_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ORGANIZATION_NAME | VARCHAR2 | (80) | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (30) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
BOOK_TYPE_CODE | VARCHAR2 | (30) | ||
DEPRN_CALENDAR | VARCHAR2 | (15) | ||
FISCAL_YEAR | NUMBER | (15) | ||
GRP_ASSET_NUMBER | VARCHAR2 | (15) | ||
GRP_DESCRIPTION | VARCHAR2 | (80) | ||
GRP_ASSET_TYPE | VARCHAR2 | (30) | ||
GRP_MAJOR_CATEGORY | VARCHAR2 | (30) | ||
GRP_MINOR_CATEGORY | VARCHAR2 | (30) | ||
GRP_OTHER_CATEGORY | VARCHAR2 | (30) | ||
GRP_DATE_PLACED_IN_SERVICE | DATE | |||
GRP_DEPRN_METHOD_CODE | VARCHAR2 | (30) | ||
GRP_RULE_NAME | VARCHAR2 | (80) | ||
GRP_TRACKING_METHOD | VARCHAR2 | (30) | ||
GRP_COST | NUMBER | |||
GRP_SALVAGE_VALUE | NUMBER | |||
GRP_ADJUSTED_RECOVERABLE_COST | NUMBER | |||
GRP_BEGINNING_NBV | NUMBER | |||
GRP_FIRST_HALF_ADDITION | NUMBER | |||
GRP_SECOND_HALF_ADDITION | NUMBER | |||
GRP_ADDITION_AMOUNT | NUMBER | |||
GRP_ADJUSTMENT_AMOUNT | NUMBER | |||
GRP_NET_PROCEEDS | NUMBER | |||
GRP_PROCEEDS_OF_SALE | NUMBER | |||
GRP_COST_OF_REMOVAL | NUMBER | |||
GRP_COST_RETIRED | NUMBER | |||
GRP_RESERVE_RETIRED | NUMBER | |||
GRP_RECAPTURE_AMOUNT | NUMBER | |||
GRP_TERMINAL_GAIN_LOSS_AMOUNT | NUMBER | |||
GRP_NBV_BEFORE_DEPRN | NUMBER | |||
GRP_DEPRN_BASIS_ADJUSTMENT | NUMBER | |||
GRP_REDUCED_NBV | NUMBER | |||
GRP_ADJUSTED_RATE | NUMBER | |||
GRP_LIFE_YEAR_MONTH | NUMBER | |||
GRP_REGULAR_DEPRN_AMOUNT | NUMBER | |||
GRP_REDUCED_DEPRN_AMOUNT | NUMBER | |||
GRP_ANNUAL_DEPRN_AMOUNT | NUMBER | |||
GRP_DEPRN_RESERVE | NUMBER | |||
GRP_ENDING_NBV | NUMBER | |||
MEM_ASSET_NUMBER | VARCHAR2 | (15) | ||
MEM_DESCRIPTION | VARCHAR2 | (80) | ||
MEM_ASSET_TYPE | VARCHAR2 | (30) | ||
MEM_MAJOR_CATEGORY | VARCHAR2 | (30) | ||
MEM_MINOR_CATEGORY | VARCHAR2 | (30) | ||
MEM_OTHER_CATEGORY | VARCHAR2 | (30) | ||
MEM_DATE_PLACED_IN_SERVICE | DATE | |||
MEM_DEPRN_METHOD_CODE | VARCHAR2 | (30) | ||
MEM_RULE_NAME | VARCHAR2 | (80) | ||
MEM_COST | NUMBER | |||
MEM_SALVAGE_VALUE | NUMBER | |||
MEM_ADJUSTED_RECOVERABLE_COST | NUMBER | |||
MEM_BEGINNING_NBV | NUMBER | |||
MEM_FIRST_HALF_ADDITION | NUMBER | |||
MEM_SECOND_HALF_ADDITION | NUMBER | |||
MEM_ADDITION_AMOUNT | NUMBER | |||
MEM_ADJUSTMENT_AMOUNT | NUMBER | |||
MEM_NET_PROCEEDS | NUMBER | |||
MEM_PROCEEDS_OF_SALE | NUMBER | |||
MEM_COST_OF_REMOVAL | NUMBER | |||
MEM_COST_RETIRED | NUMBER | |||
MEM_RESERVE_RETIRED | NUMBER | |||
MEM_NBV_BEFORE_DEPRN | NUMBER | |||
MEM_DEPRN_BASIS_ADJUSTMENT | NUMBER | |||
MEM_REDUCED_NBV | NUMBER | |||
MEM_ADJUSTED_RATE | NUMBER | |||
MEM_LIFE_YEAR_MONTH | NUMBER | |||
MEM_ANNUAL_DEPRN_AMOUNT | NUMBER | |||
MEM_DEPRN_RESERVE | NUMBER | |||
MEM_ENDING_NBV | NUMBER | |||
MEM_STATUS | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE
, SET_OF_BOOKS_ID
, BOOK_TYPE_CODE
, DEPRN_CALENDAR
, FISCAL_YEAR
, GRP_ASSET_NUMBER
, GRP_DESCRIPTION
, GRP_ASSET_TYPE
, GRP_MAJOR_CATEGORY
, GRP_MINOR_CATEGORY
, GRP_OTHER_CATEGORY
, GRP_DATE_PLACED_IN_SERVICE
, GRP_DEPRN_METHOD_CODE
, GRP_RULE_NAME
, GRP_TRACKING_METHOD
, GRP_COST
, GRP_SALVAGE_VALUE
, GRP_ADJUSTED_RECOVERABLE_COST
, GRP_BEGINNING_NBV
, GRP_FIRST_HALF_ADDITION
, GRP_SECOND_HALF_ADDITION
, GRP_ADDITION_AMOUNT
, GRP_ADJUSTMENT_AMOUNT
, GRP_NET_PROCEEDS
, GRP_PROCEEDS_OF_SALE
, GRP_COST_OF_REMOVAL
, GRP_COST_RETIRED
, GRP_RESERVE_RETIRED
, GRP_RECAPTURE_AMOUNT
, GRP_TERMINAL_GAIN_LOSS_AMOUNT
, GRP_NBV_BEFORE_DEPRN
, GRP_DEPRN_BASIS_ADJUSTMENT
, GRP_REDUCED_NBV
, GRP_ADJUSTED_RATE
, GRP_LIFE_YEAR_MONTH
, GRP_REGULAR_DEPRN_AMOUNT
, GRP_REDUCED_DEPRN_AMOUNT
, GRP_ANNUAL_DEPRN_AMOUNT
, GRP_DEPRN_RESERVE
, GRP_ENDING_NBV
, MEM_ASSET_NUMBER
, MEM_DESCRIPTION
, MEM_ASSET_TYPE
, MEM_MAJOR_CATEGORY
, MEM_MINOR_CATEGORY
, MEM_OTHER_CATEGORY
, MEM_DATE_PLACED_IN_SERVICE
, MEM_DEPRN_METHOD_CODE
, MEM_RULE_NAME
, MEM_COST
, MEM_SALVAGE_VALUE
, MEM_ADJUSTED_RECOVERABLE_COST
, MEM_BEGINNING_NBV
, MEM_FIRST_HALF_ADDITION
, MEM_SECOND_HALF_ADDITION
, MEM_ADDITION_AMOUNT
, MEM_ADJUSTMENT_AMOUNT
, MEM_NET_PROCEEDS
, MEM_PROCEEDS_OF_SALE
, MEM_COST_OF_REMOVAL
, MEM_COST_RETIRED
, MEM_RESERVE_RETIRED
, MEM_NBV_BEFORE_DEPRN
, MEM_DEPRN_BASIS_ADJUSTMENT
, MEM_REDUCED_NBV
, MEM_ADJUSTED_RATE
, MEM_LIFE_YEAR_MONTH
, MEM_ANNUAL_DEPRN_AMOUNT
, MEM_DEPRN_RESERVE
, MEM_ENDING_NBV
, MEM_STATUS
FROM FA.FA_GROUP_REP_ITF;
FA.FA_GROUP_REP_ITF does not reference any database object
FA.FA_GROUP_REP_ITF is referenced by following:
|
|
|