View: PAY_JP_ITAX_ARCH_V2

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

View Text

SELECT ROWID
, ACTION_INFORMATION_ID
, ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, OBJECT_VERSION_NUMBER
, ACTION_INFORMATION_CATEGORY
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION1)
, FND_NUMBER.CANONICAL_TO_NUMBER(ACTION_INFORMATION2)
, FND_NUMBER.CANONICAL_TO_NUMBER(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_INFORMATION12)
, ACTION_INFORMATION13
, ACTION_INFORMATION14
, ACTION_INFORMATION15
, SUBSTRB(ACTION_INFORMATION16
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION17
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION18
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION19
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION20
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION21
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION22
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION23
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION24
, 1
, 60)
, SUBSTRB(ACTION_INFORMATION25
, 1
, 60)
, ACTION_INFORMATION26
, ACTION_INFORMATION27
, ACTION_INFORMATION28
, ACTION_INFORMATION29
, 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_ARCH'

Columns