[Home] [Help] [Dependency Information]
Object Name: | PAY_JP_ITAX_PERSON_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_JP_ITAX_PERSON_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|