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.

[Home] [Help]

View: PAY_JP_ITAX_PERSON_V2

Product:	PAY - Payroll
Description:	This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_ITAX_PERSON_V2

View Text

SELECT ROWID
, ACTION_INFORMATION_ID
, ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, OBJECT_VERSION_NUMBER
, ACTION_INFORMATION_CATEGORY
, ACTION_INFORMATION1
, ACTION_INFORMATION2
, ACTION_INFORMATION3
, ACTION_INFORMATION4
, ACTION_INFORMATION5
, ACTION_INFORMATION6
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION7)
, ACTION_INFORMATION8
, ACTION_INFORMATION9
, ACTION_INFORMATION10
, ACTION_INFORMATION11
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION11)
, ACTION_INFORMATION12
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION13)
, ACTION_INFORMATION14
, ACTION_INFORMATION15
, ACTION_INFORMATION16
, ACTION_INFORMATION17
, ACTION_INFORMATION18
, ACTION_INFORMATION19
, ACTION_INFORMATION20
, ACTION_INFORMATION21
, ACTION_INFORMATION22
, ACTION_INFORMATION23
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION24)
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION25)
, ACTION_INFORMATION26
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION26)
, ACTION_INFORMATION27
, ACTION_INFORMATION27
, ACTION_INFORMATION28
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION29)
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION29)
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION30)
, FND_DATE.CANONICAL_TO_DATE(ACTION_INFORMATION30)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE FROM PAY_ACTION_INFORMATION WHERE ACTION_CONTEXT_TYPE = 'AAP' AND ACTION_INFORMATION_CATEGORY = 'JP_ITAX_PERSON'

Columns

Name
ROW_ID
ACTION_INFORMATION_ID
ACTION_CONTEXT_ID
ACTION_CONTEXT_TYPE
EFFECTIVE_DATE
ASSIGNMENT_ID
OBJECT_VERSION_NUMBER
ACTION_INFORMATION_CATEGORY
EMPLOYEE_NUMBER
LAST_NAME_KANA
FIRST_NAME_KANA
LAST_NAME_KANJI
FIRST_NAME_KANJI
SEX
ADDRESS_ID
ADDRESS_KANA
ADDRESS_KANJI
COUNTRY
JP_DATE_START
DATE_START
LEAVING_REASON
DATE_OF_BIRTH
DATE_OF_BIRTH_MEIJI
DATE_OF_BIRTH_TAISHOU
DATE_OF_BIRTH_SHOUWA
DATE_OF_BIRTH_HEISEI
DATE_OF_BIRTH_YEAR
DATE_OF_BIRTH_MONTH
DATE_OF_BIRTH_DAY
EMPLOYMENT_DATE_YEAR
EMPLOYMENT_DATE_MONTH
EMPLOYMENT_DATE_DAY
ITAX_ORGANIZATION_ID
ACTUAL_TERMINATION_DATE
ORG_NAME
ORGANIZATION_ID
PAYROLL_NAME
PUBLICATION_PERIOD_STATUS
DISTRICT_CODE
OPEN_DATE
PUBLICATION_START_DATE
CLOSE_DATE
PUBLICATION_END_DATE
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE