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.PAY_JP_ITAX_TAX_V

Object Details

Object Name:	PAY_JP_ITAX_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_JP_ITAX_TAX_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
ACTION_INFORMATION_ID	NUMBER	(15)	Yes	Action Information ID
ACTION_CONTEXT_ID	NUMBER	(15)	Yes	Action Context ID
ACTION_CONTEXT_TYPE	VARCHAR2	(15)	Yes	Action Context Type
EFFECTIVE_DATE	DATE			Effective date
ASSIGNMENT_ID	NUMBER	(10)		Assignment id
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
ACTION_INFORMATION_CATEGORY	VARCHAR2	(80)	Yes	Action Information Category
TAXABLE_INCOME	VARCHAR2	(240)		Taxable Income Gross
NET_TAXABLE_INCOME	VARCHAR2	(240)		Taxable Income Net
TOTAL_INCOME_EXEMPT	VARCHAR2	(240)		Exempt Income
WITHHOLDING_ITAX	VARCHAR2	(240)		Withholding Tax
WITHHOLDING_ITAX2	VARCHAR2	(240)		Withholding tax
SPOUSE_SPECIAL_EXEMPT	VARCHAR2	(240)		Spouse sepcial exempt amount
SOCIAL_INSURANCE_PREMIUM	VARCHAR2	(240)		Social Insurance Premium
MUTUAL_AID_PREMIUM	VARCHAR2	(240)		Mutual Aid Premium
LIFE_INSURANCE_PREMIUM_EXEMPT	VARCHAR2	(240)		Life Insurance Premium exempt
DAMAGE_INSURANCE_PREMIUM_EXEM	VARCHAR2	(240)		Damage Insurance Premium exempt
HOUSING_TAX_REDUCTION	VARCHAR2	(240)		Housing Tax Reduction
ITAX_ADJUSTMENT2	VARCHAR2	(240)		Income Tax Adjustment
SPOUSE_NET_TAXABLE_INCOME	VARCHAR2	(240)		Spouse Net Taxable Income
PRIVATE_PENSION_PREMIUM	VARCHAR2	(240)		Private Pension Premium
LONG_DAMAGE_INSURANCE_PREMIUM	VARCHAR2	(240)		Damage Insurance Premium
DISASTER_TAX_REDUCTION	VARCHAR2	(240)		Disaster Tax Reduction
PREV_JOB_EMPLOYER_ADD_KANA	VARCHAR2	(240)		Previous Employer Address Kana
PREV_JOB_EMPLOYER_ADD_KANJI	VARCHAR2	(240)		Previous Employer Address Kanji
PREV_JOB_EMPLOYER_NAME_KANA	VARCHAR2	(240)		Previous Employer Name Kana
PREV_JOB_EMPLOYER_NAME_KANJI	VARCHAR2	(240)		Previous Employer Name Kanji
PREV_JOB_FOREIGN_ADDRESS	VARCHAR2	(240)		Previous Job Foreign address
PREV_JOB_TAXABLE_INCOME	VARCHAR2	(240)		Previous Job Taxable Income
PREV_JOB_ITAX	VARCHAR2	(240)		Previous Job Income tax
PREV_JOB_SI_PREM	VARCHAR2	(240)		Previous Job SI Premium
PREV_JOB_TERMINATION_YEAR	VARCHAR2	(240)		Previous Job Termination Year
PREV_JOB_TERMINATION_MONTH	VARCHAR2	(240)		Previous Job Termination Month
PREV_JOB_TERMINATION_DAY	VARCHAR2	(240)		Previous Job Termination Day
HOUSING_RESIDENCE_YEAR	VARCHAR2	(240)		Housing Residence Year
HOUSING_RESIDENCE_MONTH	VARCHAR2	(240)		Housing Residence Month
HOUSING_RESIDENCE_DAY	VARCHAR2	(240)		Housing Residence Day
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
LAST_UPDATED_BY	NUMBER			Last Updated By
LAST_UPDATE_DATE	DATE			Last Update Date
CREATED_BY	NUMBER			Created By
CREATION_DATE	DATE			Creation Date

Query Text

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


SELECT ROW_ID
,      ACTION_INFORMATION_ID
,      ACTION_CONTEXT_ID
,      ACTION_CONTEXT_TYPE
,      EFFECTIVE_DATE
,      ASSIGNMENT_ID
,      OBJECT_VERSION_NUMBER
,      ACTION_INFORMATION_CATEGORY
,      TAXABLE_INCOME
,      NET_TAXABLE_INCOME
,      TOTAL_INCOME_EXEMPT
,      WITHHOLDING_ITAX
,      WITHHOLDING_ITAX2
,      SPOUSE_SPECIAL_EXEMPT
,      SOCIAL_INSURANCE_PREMIUM
,      MUTUAL_AID_PREMIUM
,      LIFE_INSURANCE_PREMIUM_EXEMPT
,      DAMAGE_INSURANCE_PREMIUM_EXEM
,      HOUSING_TAX_REDUCTION
,      ITAX_ADJUSTMENT2
,      SPOUSE_NET_TAXABLE_INCOME
,      PRIVATE_PENSION_PREMIUM
,      LONG_DAMAGE_INSURANCE_PREMIUM
,      DISASTER_TAX_REDUCTION
,      PREV_JOB_EMPLOYER_ADD_KANA
,      PREV_JOB_EMPLOYER_ADD_KANJI
,      PREV_JOB_EMPLOYER_NAME_KANA
,      PREV_JOB_EMPLOYER_NAME_KANJI
,      PREV_JOB_FOREIGN_ADDRESS
,      PREV_JOB_TAXABLE_INCOME
,      PREV_JOB_ITAX
,      PREV_JOB_SI_PREM
,      PREV_JOB_TERMINATION_YEAR
,      PREV_JOB_TERMINATION_MONTH
,      PREV_JOB_TERMINATION_DAY
,      HOUSING_RESIDENCE_YEAR
,      HOUSING_RESIDENCE_MONTH
,      HOUSING_RESIDENCE_DAY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PAY_JP_ITAX_TAX_V;

Dependencies

[top of page]

APPS.PAY_JP_ITAX_TAX_V references the following:

APPS: PAY_ACTION_INFORMATION

APPS.PAY_JP_ITAX_TAX_V is referenced by following:

APPS: PAY_JP_ITAX_PKG - show dependent code; PAY_JP_ITWB_ARCHIVE_PKG - show dependent code