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]

VIEW: FA.FA_GROUP_REP_ITF#

Object Details

Object Name:	FA_GROUP_REP_ITF#
Object Type:	VIEW
Owner:	FA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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#;

Dependencies

[top of page]

FA.FA_GROUP_REP_ITF# references the following:

FA: FA_GROUP_REP_ITF

FA.FA_GROUP_REP_ITF# is referenced by following:

APPS: FA_GROUP_REP_ITF