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

VIEW: JA.JA_AU_SRW_TAX_DEPRN_TMP#

Object Details
Object Name: JA_AU_SRW_TAX_DEPRN_TMP#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Yes
ASSET_NUMBER VARCHAR2 (15) Yes
ASSET_DESC VARCHAR2 (80) Yes
CATEGORY_ID NUMBER (15)
CATEGORY_NUMBER VARCHAR2 (60)
CATEGORY_DESC VARCHAR2 (40)
ORIGINAL_COST_START NUMBER

ORIGINAL_COST_END NUMBER

COST_START NUMBER

COST_END NUMBER

DEPRN_RSRVE_START NUMBER

DEPRN_RSRVE_END NUMBER

DEPRN_AMOUNT NUMBER

ADDITION_DATE DATE

IN_SERVICE DATE

DEPRN_RATE NUMBER

DEPRN_BASIS_RULE VARCHAR2 (4)
NET_BOOK_VALUE NUMBER

DATE_RETIRED DATE

BAL_CHG_APPLIED NUMBER

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)
Query Text

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


SELECT ASSET_ID
,      ASSET_NUMBER
,      ASSET_DESC
,      CATEGORY_ID
,      CATEGORY_NUMBER
,      CATEGORY_DESC
,      ORIGINAL_COST_START
,      ORIGINAL_COST_END
,      COST_START
,      COST_END
,      DEPRN_RSRVE_START
,      DEPRN_RSRVE_END
,      DEPRN_AMOUNT
,      ADDITION_DATE
,      IN_SERVICE
,      DEPRN_RATE
,      DEPRN_BASIS_RULE
,      NET_BOOK_VALUE
,      DATE_RETIRED
,      BAL_CHG_APPLIED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JA.JA_AU_SRW_TAX_DEPRN_TMP#;

Dependencies

[top of page]

JA.JA_AU_SRW_TAX_DEPRN_TMP# references the following:

SchemaJA
TableJA_AU_SRW_TAX_DEPRN_TMP
JA.JA_AU_SRW_TAX_DEPRN_TMP# is referenced by following:

SchemaAPPS
SynonymJA_AU_SRW_TAX_DEPRN_TMP