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

TABLE: FA.FA_TAX_INTERFACE

Object Details
Object Name: FA_TAX_INTERFACE
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_TAX_INTERFACE
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_TAX_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSET_NUMBER
ColumnBOOK_TYPE_CODE
FA_TAX_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBOOK_TYPE_CODE
ColumnPOSTING_STATUS
ColumnTAX_REQUEST_ID
ColumnWORKER_ID
Columns
Name Datatype Length Mandatory Comments
ASSET_NUMBER VARCHAR2 (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
ADJUSTED_RATE NUMBER

BASIC_RATE NUMBER

BONUS_RULE VARCHAR2 (30)
CEILING_NAME VARCHAR2 (30)
COST NUMBER

DATE_PLACED_IN_SERVICE DATE

DEPRECIATE_FLAG VARCHAR2 (3)
DEPRN_METHOD_CODE VARCHAR2 (12)
DEPRN_RESERVE NUMBER

ITC_AMOUNT_ID NUMBER (15)
LIFE_IN_MONTHS NUMBER (4)
ORIGINAL_COST NUMBER

PRODUCTION_CAPACITY NUMBER

PRORATE_CONVENTION_CODE VARCHAR2 (10)
SALVAGE_VALUE NUMBER

YTD_DEPRN NUMBER

POSTING_STATUS VARCHAR2 (15)
TAX_REQUEST_ID NUMBER (15)
SHORT_FISCAL_YEAR_FLAG VARCHAR2 (3)
CONVERSION_DATE DATE

ORIGINAL_DEPRN_START_DATE DATE

AMORTIZE_NBV_FLAG VARCHAR2 (3)
AMORTIZATION_START_DATE DATE

FULLY_RSVD_REVALS_COUNTER NUMBER

REVAL_AMORTIZATION_BASIS NUMBER

REVAL_CEILING NUMBER

REVAL_RESERVE NUMBER

UNREVALUED_COST NUMBER

YTD_REVAL_DEPRN_EXPENSE NUMBER

TRANSACTION_NAME VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY_CODE VARCHAR2 (30)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
GROUP_ASSET_ID NUMBER

ASSET_ID NUMBER (15)
ASSET_TYPE VARCHAR2 (11)
WORKER_ID NUMBER (15)
Query Text

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


SELECT ASSET_NUMBER
,      BOOK_TYPE_CODE
,      ADJUSTED_RATE
,      BASIC_RATE
,      BONUS_RULE
,      CEILING_NAME
,      COST
,      DATE_PLACED_IN_SERVICE
,      DEPRECIATE_FLAG
,      DEPRN_METHOD_CODE
,      DEPRN_RESERVE
,      ITC_AMOUNT_ID
,      LIFE_IN_MONTHS
,      ORIGINAL_COST
,      PRODUCTION_CAPACITY
,      PRORATE_CONVENTION_CODE
,      SALVAGE_VALUE
,      YTD_DEPRN
,      POSTING_STATUS
,      TAX_REQUEST_ID
,      SHORT_FISCAL_YEAR_FLAG
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      AMORTIZE_NBV_FLAG
,      AMORTIZATION_START_DATE
,      FULLY_RSVD_REVALS_COUNTER
,      REVAL_AMORTIZATION_BASIS
,      REVAL_CEILING
,      REVAL_RESERVE
,      UNREVALUED_COST
,      YTD_REVAL_DEPRN_EXPENSE
,      TRANSACTION_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GROUP_ASSET_ID
,      ASSET_ID
,      ASSET_TYPE
,      WORKER_ID
FROM FA.FA_TAX_INTERFACE;

Dependencies

[top of page]

FA.FA_TAX_INTERFACE does not reference any database object

FA.FA_TAX_INTERFACE is referenced by following:

SchemaAPPS
SynonymFA_TAX_INTERFACE