DBA Data[Home] [Help]

VIEW: APPS.PAY_JP_ITWB_EMP_CUST_TXT_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, 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 from pay_jp_itwb_emp_cust_v where data_type = 'T'
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
, 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
FROM PAY_JP_ITWB_EMP_CUST_V
WHERE DATA_TYPE = 'T'