VIEW: APPS.PAY_JP_ITAX_ARCH_V2

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'