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]

VIEW: APPS.IGSFV_INCOME_TAXES

Object Details

Object Name:	IGSFV_INCOME_TAXES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_INCOME_TAXES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity contains information about the person's income tax details

[View Source]

Columns

Name	Datatype	Length	Comments
_LA:TAX_INFO	CHAR	(51)	Tax info meaning
TYPE_CODE	VARCHAR2	(30)	Tax type code
TYPE_CODE_ID	NUMBER		Type Code Id
START_DATE	DATE		Start Date of the tax filing.
END_DATE	DATE		End Date of the tax filing.
DESCRIPTION	VARCHAR2	(360)	Description of the type code.
PERSON_NUMBER	VARCHAR2	(30)	Person number
TAX_ID	NUMBER	(15)	A unique identifier for Tax filing record.
PERSON_ID	NUMBER	(15)	Unique identifier of the person
CREATED_BY	NUMBER	(15)	Standard WHO column
CREATION_DATE	DATE		Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO column
LAST_UPDATE_DATE	DATE		Standard WHO column

Query Text

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


SELECT _LA:TAX_INFO
,      TYPE_CODE
,      TYPE_CODE_ID
,      START_DATE
,      END_DATE
,      DESCRIPTION
,      PERSON_NUMBER
,      TAX_ID
,      PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_INCOME_TAXES;

Dependencies

[top of page]

APPS.IGSFV_INCOME_TAXES references the following:

APPS: FND_PROFILE - show dependent code; FND_TERRITORIES_TL; HZ_GEOGRAPHIES; HZ_PARTIES; IGS_PE_INCOME_TAX_ALL

APPS.IGSFV_INCOME_TAXES is not referenced by any database object