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

VIEW: APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V

Object Details
Object Name: FA_GROUP_DEPRN_SUMMARY_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_GROUP_DEPRN_SUMMARY_MRC_V
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (30) Yes
GROUP_ASSET_ID NUMBER (15) Yes
DEPRN_RUN_DATE DATE
Yes
DEPRN_AMOUNT NUMBER
Yes
YTD_DEPRN NUMBER
Yes
DEPRN_RESERVE NUMBER
Yes
DEPRN_SOURCE_CODE VARCHAR2 (15)
ADJUSTED_COST NUMBER
Yes
BONUS_RATE NUMBER

LTD_PRODUCTION NUMBER

PERIOD_COUNTER NUMBER
Yes
PRODUCTION NUMBER

REVAL_AMORTIZATION NUMBER

REVAL_AMORTIZATION_BASIS NUMBER

REVAL_DEPRN_EXPENSE NUMBER

REVAL_RESERVE NUMBER

YTD_PRODUCTION NUMBER

YTD_REVAL_DEPRN_EXPENSE NUMBER

PRIOR_FY_EXPENSE NUMBER

CONVERTED_FLAG VARCHAR2 (1) Yes
DEPRN_RATE NUMBER

Query Text

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


SELECT SET_OF_BOOKS_ID
,      BOOK_TYPE_CODE
,      GROUP_ASSET_ID
,      DEPRN_RUN_DATE
,      DEPRN_AMOUNT
,      YTD_DEPRN
,      DEPRN_RESERVE
,      DEPRN_SOURCE_CODE
,      ADJUSTED_COST
,      BONUS_RATE
,      LTD_PRODUCTION
,      PERIOD_COUNTER
,      PRODUCTION
,      REVAL_AMORTIZATION
,      REVAL_AMORTIZATION_BASIS
,      REVAL_DEPRN_EXPENSE
,      REVAL_RESERVE
,      YTD_PRODUCTION
,      YTD_REVAL_DEPRN_EXPENSE
,      PRIOR_FY_EXPENSE
,      CONVERTED_FLAG
,      DEPRN_RATE
FROM APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V;

Dependencies

[top of page]

APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V references the following:

SchemaAPPS
SynonymFA_MC_GROUP_DEPRN_SUMMARY

APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V is not referenced by any database object