FND Design Data [Home] [Help]

View: PAY_JP_ITWB_EMP_CUST_NUM_V

Product: PAY - Payroll
Description: This view is used for Japanese localization only.
Implementation/DBA Data: ViewAPPS.PAY_JP_ITWB_EMP_CUST_NUM_V
View Text

SELECT ROW_ID
, ACTION_INFORMATION_ID
, OBJECT_VERSION_NUMBER
, ASSIGNMENT_ACTION_ID
, ACTION_CONTEXT_TYPE
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, DATA_TYPE
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION6)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION7)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION8)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION9)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION10)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION11)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION12)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION13)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION14)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION15)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION16)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION17)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION18)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION19)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION20)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION21)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION22)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION23)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION24)
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION25)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_JP_ITWB_EMP_CUST_V
WHERE DATA_TYPE = 'N'

Columns

Name
ROW_ID
ACTION_INFORMATION_ID
OBJECT_VERSION_NUMBER
ASSIGNMENT_ACTION_ID
ACTION_CONTEXT_TYPE
ASSIGNMENT_ID
EFFECTIVE_DATE
ACTION_INFORMATION_CATEGORY
DATA_TYPE
INFORMATION1
INFORMATION2
INFORMATION3
INFORMATION4
INFORMATION5
INFORMATION6
INFORMATION7
INFORMATION8
INFORMATION9
INFORMATION10
INFORMATION11
INFORMATION12
INFORMATION13
INFORMATION14
INFORMATION15
INFORMATION16
INFORMATION17
INFORMATION18
INFORMATION19
INFORMATION20
INFORMATION21
INFORMATION22
INFORMATION23
INFORMATION24
INFORMATION25
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE