[Home] [Help] [Dependency Information]
Object Name: | JL_ZZ_FA_ADJ_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JL.JL_ZZ_FA_ADJ_SUMMARY_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.JL_ZZ_FA_ADJ_SUMMARY_V is not referenced by any database object
|
|
|