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

VIEW: APPS.PAY_JP_ITAX_PERSON_V

Object Details
Object Name: PAY_JP_ITAX_PERSON_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_JP_ITAX_PERSON_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
EMPLOYEE_NUMBER VARCHAR2 (240)
Emp Number
LAST_NAME_KANA VARCHAR2 (240)
Kana Last Name
FIRST_NAME_KANA VARCHAR2 (240)
Kana First Name
LAST_NAME_KANJI VARCHAR2 (240)
Kanji Last Name
FIRST_NAME_KANJI VARCHAR2 (240)
Kanji First Name
SEX VARCHAR2 (240)
Sex
ADDRESS_ID VARCHAR2 (240)
Address ID
ADDRESS_KANA VARCHAR2 (240)
Kana Address
ADDRESS_KANJI VARCHAR2 (240)
Kanji Address
COUNTRY VARCHAR2 (240)
Country
JP_DATE_START VARCHAR2 (240)
Start Date in Japan
LEAVING_REASON VARCHAR2 (240)
Leaving reason
DATE_OF_BIRTH VARCHAR2 (240)
Date Of Birth
DATE_OF_BIRTH_MEIJI VARCHAR2 (240)
Meiji DOB
DATE_OF_BIRTH_TAISHOU VARCHAR2 (240)
Taishou DOB
DATE_OF_BIRTH_SHOUWA VARCHAR2 (240)
Shouwa DOB
DATE_OF_BIRTH_HEISEI VARCHAR2 (240)
HeiSei DOB
DATE_OF_BIRTH_YEAR VARCHAR2 (240)
Year of birth
DATE_OF_BIRTH_MONTH VARCHAR2 (240)
Month of Birth
DATE_OF_BIRTH_DAY VARCHAR2 (240)
Day Of Birth
EMPLOYMENT_DATE_YEAR VARCHAR2 (240)
Year of employment
EMPLOYMENT_DATE_MONTH VARCHAR2 (240)
Month of employment
EMPLOYMENT_DATE_DAY VARCHAR2 (240)
Day of employment
ITAX_ORGANIZATION_ID VARCHAR2 (240)
Income Tax Organization
ACTUAL_TERMINATION_DATE VARCHAR2 (240)
Termination Date
ORG_NAME VARCHAR2 (240)
Organization
PAYROLL_NAME VARCHAR2 (240)
Payroll Name
DISTRICT_CODE VARCHAR2 (240)
District Code
OPEN_DATE VARCHAR2 (240)
Open Date
CLOSE_DATE VARCHAR2 (240)
Close Date
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
,      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
,      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
,      PAYROLL_NAME
,      DISTRICT_CODE
,      OPEN_DATE
,      CLOSE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PAY_JP_ITAX_PERSON_V;

Dependencies

[top of page]

APPS.PAY_JP_ITAX_PERSON_V references the following:

SchemaAPPS
SynonymPAY_ACTION_INFORMATION
APPS.PAY_JP_ITAX_PERSON_V is referenced by following:

SchemaAPPS
Package BodyPAY_JP_ITAX_PKG - show dependent code
Package BodyPAY_JP_ITAX_REPORT_PKG - show dependent code
SchemaPUBLIC
SynonymPAY_JP_ITAX_PERSON_V