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

VIEW: APPS.FA_GROUP_DEPRN_DETAIL_MRC_V

Object Details
Object Name: FA_GROUP_DEPRN_DETAIL_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_GROUP_DEPRN_DETAIL_MRC_V
Subobject Name:
Status: VALID

[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
PERIOD_COUNTER NUMBER (15) Yes
DISTRIBUTION_ID NUMBER (15) Yes
DEPRN_SOURCE_CODE VARCHAR2 (1) Yes
DEPRN_RUN_DATE DATE
Yes
DEPRN_AMOUNT NUMBER
Yes
YTD_DEPRN NUMBER
Yes
DEPRN_RESERVE NUMBER
Yes
ADDITION_COST_TO_CLEAR NUMBER

COST NUMBER

DEPRN_ADJUSTMENT_AMOUNT NUMBER

DEPRN_EXPENSE_JE_LINE_NUM NUMBER

DEPRN_RESERVE_JE_LINE_NUM NUMBER

REVAL_AMORT_JE_LINE_NUM NUMBER

REVAL_RESERVE_JE_LINE_NUM NUMBER

JE_HEADER_ID NUMBER

REVAL_AMORTIZATION NUMBER

REVAL_DEPRN_EXPENSE NUMBER

REVAL_RESERVE NUMBER

YTD_REVAL_DEPRN_EXPENSE 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
,      PERIOD_COUNTER
,      DISTRIBUTION_ID
,      DEPRN_SOURCE_CODE
,      DEPRN_RUN_DATE
,      DEPRN_AMOUNT
,      YTD_DEPRN
,      DEPRN_RESERVE
,      ADDITION_COST_TO_CLEAR
,      COST
,      DEPRN_ADJUSTMENT_AMOUNT
,      DEPRN_EXPENSE_JE_LINE_NUM
,      DEPRN_RESERVE_JE_LINE_NUM
,      REVAL_AMORT_JE_LINE_NUM
,      REVAL_RESERVE_JE_LINE_NUM
,      JE_HEADER_ID
,      REVAL_AMORTIZATION
,      REVAL_DEPRN_EXPENSE
,      REVAL_RESERVE
,      YTD_REVAL_DEPRN_EXPENSE
FROM APPS.FA_GROUP_DEPRN_DETAIL_MRC_V;

Dependencies

[top of page]

APPS.FA_GROUP_DEPRN_DETAIL_MRC_V references the following:

SchemaAPPS
SynonymFA_MC_GROUP_DEPRN_DETAIL

APPS.FA_GROUP_DEPRN_DETAIL_MRC_V is not referenced by any database object