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

VIEW: APPS.JL_ZZ_FA_ADJ_SUMMARY_V

Object Details
Object Name: JL_ZZ_FA_ADJ_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJL.JL_ZZ_FA_ADJ_SUMMARY_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
ASSET_ID NUMBER (15)
ASSET_NUMBER VARCHAR2 (15)
TAG_NUMBER VARCHAR2 (15)
ASSET_TYPE VARCHAR2 (11)
CURRENT_UNITS NUMBER

DESCRIPTION VARCHAR2 (80)
ASSET_CATEGORY_ID NUMBER (15)
PARENT_ASSET_ID NUMBER (15)
ADJ_BOOK_TYPE_CODE VARCHAR2 (15)
CORP_BOOK_TYPE_CODE VARCHAR2 (15)
PERIOD_COUNTER NUMBER (15)
PERIOD_NAME VARCHAR2 (15)
ADJ_COST NUMBER

ADJ_DEPRN_RESERVE NUMBER

ADJ_YTD_DEPRN NUMBER

CORP_COST NUMBER

CORP_DEPRN_RESERVE NUMBER

CORP_YTD_DEPRN NUMBER

Query Text

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


SELECT ASSET_ID
,      ASSET_NUMBER
,      TAG_NUMBER
,      ASSET_TYPE
,      CURRENT_UNITS
,      DESCRIPTION
,      ASSET_CATEGORY_ID
,      PARENT_ASSET_ID
,      ADJ_BOOK_TYPE_CODE
,      CORP_BOOK_TYPE_CODE
,      PERIOD_COUNTER
,      PERIOD_NAME
,      ADJ_COST
,      ADJ_DEPRN_RESERVE
,      ADJ_YTD_DEPRN
,      CORP_COST
,      CORP_DEPRN_RESERVE
,      CORP_YTD_DEPRN
FROM APPS.JL_ZZ_FA_ADJ_SUMMARY_V;

Dependencies

[top of page]

APPS.JL_ZZ_FA_ADJ_SUMMARY_V references the following:

SchemaAPPS
SynonymFA_ADDITIONS
SynonymFA_BOOKS
SynonymFA_BOOK_CONTROLS
SynonymFA_DEPRN_PERIODS
SynonymFA_DEPRN_SUMMARY
PL/SQL PackageJL_ZZ_FA_CALC_ADJUSTMENT_PKG - show dependent code

APPS.JL_ZZ_FA_ADJ_SUMMARY_V is not referenced by any database object