eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FA.FA_DEPRN_TAX_AUTHORITIES

Object Details

Object Name:	FA_DEPRN_TAX_AUTHORITIES
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_DEPRN_TAX_AUTHORITIES
Subobject Name:
Status:	VALID

FA_DEPRN_TAX_AUTHORITIES table is used to store tax-authority-level information required by Japanese Depreciable Assets Tax Reports.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_DEPRN_TAX_AUTHORITIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CODE LEGAL_ENTITY_NAME
FA_DEPRN_TAX_AUTHORITIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_REGISTRATION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
CODE	VARCHAR2	(30)	Yes	Tax authority code
TAX_REGISTRATION_NUMBER	VARCHAR2	(100)		Tax registration number
SHORT_YEAR_DEPRN_FLAG	VARCHAR2	(1)		Indicates whether or not to use Short Year depreciation
BONUS_DEPRN_FLAG	VARCHAR2	(1)		Indicates whether or not to use Bonus depreciation
NON_TAXABLE_ASSETS_FLAG	VARCHAR2	(1)		Indicates whether or not to include non taxable assets
TAX_STANDARD_EXCEPTION_FLAG	VARCHAR2	(1)		Indicates whether or not to have an exception to tax standards
SPECIAL_DEPRN_FLAG	VARCHAR2	(1)		Indicates whether or not to use Special depreciation
DEPRN_METHOD_UNDER_TAX_LAW	VARCHAR2	(1)		Depreciation method code
BLUE_RETURN_FLAG	VARCHAR2	(1)		Indicates whether or not to use Blue return
ASSET_ADDRESS1	VARCHAR2	(200)		Address of the asset location 1 in the selected tax jurisdiction
ASSET_ADDRESS2	VARCHAR2	(200)		Address of the asset location 2 in the selected tax jurisdiction
ASSET_ADDRESS3	VARCHAR2	(200)		Address of the asset location 3 in the selected tax jurisdiction
PRINCIPAL_LOCATION_NUMBER	NUMBER			The number of the principal location among the three asset locations
LEASED_ASSETS_FLAG	VARCHAR2	(1)		Indicates whether or not leased assets exist
LESSOR_NAME	VARCHAR2	(100)		Lessor name
LESSOR_ADDRESS	VARCHAR2	(200)		Lessor address
LESSOR_PHONE	VARCHAR2	(30)		Lessor phone number
LOCATION_OWNERSHIP	VARCHAR2	(1)		Ownership of location. Owned, Leased or both
OWNED_LOCATION_NUMBERS	VARCHAR2	(80)		List of owned locations
LEASED_LOCATION_NUMBERS	VARCHAR2	(80)		List of leased locations
REFERENCE	VARCHAR2	(300)		Comments
NAME	VARCHAR2	(100)		Tax authority name
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LEGAL_ENTITY_NAME	VARCHAR2	(100)	Yes	Legal entity name or owner name
REFERENCE_LINE1	VARCHAR2	(300)		Comments Line 1
REFERENCE_LINE2	VARCHAR2	(300)		Comments Line 2
REFERENCE_LINE3	VARCHAR2	(300)		Comments Line 3
REFERENCE_LINE4	VARCHAR2	(300)		Comments Line 4
REFERENCE_LINE5	VARCHAR2	(300)		Comments Line 5
REFERENCE_LINE6	VARCHAR2	(300)		Comments Line 6
COMPANY_ID	NUMBER	(15)	Yes	Business Identifier

Query Text

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


SELECT CODE
,      TAX_REGISTRATION_NUMBER
,      SHORT_YEAR_DEPRN_FLAG
,      BONUS_DEPRN_FLAG
,      NON_TAXABLE_ASSETS_FLAG
,      TAX_STANDARD_EXCEPTION_FLAG
,      SPECIAL_DEPRN_FLAG
,      DEPRN_METHOD_UNDER_TAX_LAW
,      BLUE_RETURN_FLAG
,      ASSET_ADDRESS1
,      ASSET_ADDRESS2
,      ASSET_ADDRESS3
,      PRINCIPAL_LOCATION_NUMBER
,      LEASED_ASSETS_FLAG
,      LESSOR_NAME
,      LESSOR_ADDRESS
,      LESSOR_PHONE
,      LOCATION_OWNERSHIP
,      OWNED_LOCATION_NUMBERS
,      LEASED_LOCATION_NUMBERS
,      REFERENCE
,      NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LEGAL_ENTITY_NAME
,      REFERENCE_LINE1
,      REFERENCE_LINE2
,      REFERENCE_LINE3
,      REFERENCE_LINE4
,      REFERENCE_LINE5
,      REFERENCE_LINE6
,      COMPANY_ID
FROM FA.FA_DEPRN_TAX_AUTHORITIES;

Dependencies

[top of page]

FA.FA_DEPRN_TAX_AUTHORITIES does not reference any database object

FA.FA_DEPRN_TAX_AUTHORITIES is referenced by following:

FA: FA_DEPRN_TAX_AUTHORITIES#