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

TABLE: JA.JA_AU_SRW_TAX_DEPRN_TMP

Object Details
Object Name: JA_AU_SRW_TAX_DEPRN_TMP
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JA_AU_SRW_TAX_DEPRN_TMP
Subobject Name:
Status: VALID


JA_AU_SRW_TAX_DEPRN_TMP is a temporary table used by the
Australian Tax Depreciation Schedule report. Its purpose is to
store data processed by the PL/SQL stored package
JA_AU_FA_BAL_CHG.Schedule32. This table is purged on each
execution of the report.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JA_AU_SRW_TAX_DEPRN_TMP_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSET_ID
JA_AU_SRW_TAX_DEPRN_TMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER (15) Yes Asset identifier
ASSET_NUMBER VARCHAR2 (15) Yes User assigned asset number
ASSET_DESC VARCHAR2 (80) Yes Asset description
CATEGORY_ID NUMBER (15)
Identifier of category to which the asset belongs
CATEGORY_NUMBER VARCHAR2 (60)
Category number
CATEGORY_DESC VARCHAR2 (40)
Category description
ORIGINAL_COST_START NUMBER

Original cost start
ORIGINAL_COST_END NUMBER

Original cost end
COST_START NUMBER

Cost start
COST_END NUMBER

Cost end
DEPRN_RSRVE_START NUMBER

Depreciation reserve start
DEPRN_RSRVE_END NUMBER

Depreciation reserve end
DEPRN_AMOUNT NUMBER

Depreciation amount
ADDITION_DATE DATE

Addition date
IN_SERVICE DATE

Date placed in service
DEPRN_RATE NUMBER

Depreciation rate
DEPRN_BASIS_RULE VARCHAR2 (4)
Depreciation basis
NET_BOOK_VALUE NUMBER

Net book value
DATE_RETIRED DATE

Retirement date
BAL_CHG_APPLIED NUMBER

Balancing charge applied
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
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 does not reference any database object

JA.JA_AU_SRW_TAX_DEPRN_TMP is referenced by following:

SchemaAPPS
SynonymJA_AU_SRW_TAX_DEPRN_TMP