VIEW: APPS.PAY_JP_ITWB_EMP_CUST_DATE_V

Source

View Text - Preformatted

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_date.canonical_to_date(information1), fnd_date.canonical_to_date(information2), fnd_date.canonical_to_date(information3), fnd_date.canonical_to_date(information4), fnd_date.canonical_to_date(information5), fnd_date.canonical_to_date(information6), fnd_date.canonical_to_date(information7), fnd_date.canonical_to_date(information8), fnd_date.canonical_to_date(information9), fnd_date.canonical_to_date(information10), fnd_date.canonical_to_date(information11), fnd_date.canonical_to_date(information12), fnd_date.canonical_to_date(information13), fnd_date.canonical_to_date(information14), fnd_date.canonical_to_date(information15), fnd_date.canonical_to_date(information16), fnd_date.canonical_to_date(information17), fnd_date.canonical_to_date(information18), fnd_date.canonical_to_date(information19), fnd_date.canonical_to_date(information20), fnd_date.canonical_to_date(information21), fnd_date.canonical_to_date(information22), fnd_date.canonical_to_date(information23), fnd_date.canonical_to_date(information24), fnd_date.canonical_to_date(information25), last_update_login, last_updated_by, last_update_date, created_by, creation_date from pay_jp_itwb_emp_cust_v where data_type = 'D'

View Text - HTML Formatted

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_DATE.CANONICAL_TO_DATE(INFORMATION1)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION2)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION3)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION4)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION5)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION6)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION7)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION8)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION9)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION10)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION11)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION12)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION13)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION14)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION15)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION16)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION17)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION18)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION19)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION20)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION21)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION22)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION23)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION24)
, FND_DATE.CANONICAL_TO_DATE(INFORMATION25)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_JP_ITWB_EMP_CUST_V
WHERE DATA_TYPE = 'D'