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

VIEW: APPS.IGSBV_INCOME_TAXES

Object Details
Object Name: IGSBV_INCOME_TAXES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_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 Mandatory Comments
_LA:TAX_INFO CHAR (51)
Tax information.
TYPE_CODE VARCHAR2 (30)
Tax type code
START_DATE NUMBER

Start Date of the tax filing.
TYPE_CODE_ID DATE

Type Code Id
END_DATE DATE

End Date of the tax filing.
TAX_ID NUMBER (15) Yes A unique identifier for Tax Filing record.
PERSON_ID NUMBER (15) Yes Person identification number
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
Query Text

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


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

Dependencies

[top of page]

APPS.IGSBV_INCOME_TAXES references the following:

SchemaAPPS
SynonymIGS_PE_INCOME_TAX_ALL

APPS.IGSBV_INCOME_TAXES is not referenced by any database object