VIEW: APPS.PAYBV_ELEMENT_ENTRY

Source

View Text - Preformatted

SELECT ele.EFFECTIVE_START_DATE , ele.EFFECTIVE_END_DATE , hr_bis.bis_decode_lookup('CREATOR_TYPE', ele.CREATOR_TYPE) CREATOR_TYPE , hr_bis.bis_decode_lookup('ENTRY_TYPE', ele.ENTRY_TYPE) ENTRY_TYPE , hr_bis.bis_decode_lookup('ELE_ENTRY_REASON',ele.REASON) REASON , ele.SUBPRIORITY , ele.DATE_EARNED , hr_bis.bis_decode_lookup('YES_NO', ele.BALANCE_ADJ_COST_FLAG) BALANCE_ADJ_COST_FLAG , ele.SOURCE_TRIGGER_ENTRY , ele.SOURCE_PERIOD , ele.SOURCE_RUN_TYPE , hr_bis.bis_decode_lookup('ACTION_TYPE', ele.UPDATING_ACTION_TYPE) UPDATING_ACTION_TYPE , ele.SOURCE_START_DATE , ele.SOURCE_END_DATE , '_DF:PAY:PAY_ELEMENT_ENTRIES:ele' , ele.ATTRIBUTE_CATEGORY, ele.ATTRIBUTE1, ele.ATTRIBUTE2, ele.ATTRIBUTE3, ele.ATTRIBUTE4, ele.ATTRIBUTE5, ele.ATTRIBUTE6, ele.ATTRIBUTE7, ele.ATTRIBUTE8, ele.ATTRIBUTE9, ele.ATTRIBUTE10, ele.ATTRIBUTE11, ele.ATTRIBUTE12, ele.ATTRIBUTE13, ele.ATTRIBUTE14, ele.ATTRIBUTE15, ele.ATTRIBUTE16, ele.ATTRIBUTE17, ele.ATTRIBUTE18, ele.ATTRIBUTE19, ele.ATTRIBUTE20, ele.ENTRY_INFORMATION_CATEGORY , ele.ENTRY_INFORMATION1 , ele.ENTRY_INFORMATION2 , ele.ENTRY_INFORMATION3 , ele.ENTRY_INFORMATION4 , ele.ENTRY_INFORMATION5 , ele.ENTRY_INFORMATION6 , ele.ENTRY_INFORMATION7 , ele.ENTRY_INFORMATION8 , ele.ENTRY_INFORMATION9 , ele.ENTRY_INFORMATION10 , ele.ENTRY_INFORMATION11 , ele.ENTRY_INFORMATION12 , ele.ENTRY_INFORMATION13 , ele.ENTRY_INFORMATION14 , ele.ENTRY_INFORMATION15 , ele.ENTRY_INFORMATION16 , ele.ENTRY_INFORMATION17 , ele.ENTRY_INFORMATION18 , ele.ENTRY_INFORMATION19 , ele.ENTRY_INFORMATION20 , ele.ENTRY_INFORMATION21 , ele.ENTRY_INFORMATION22 , ele.ENTRY_INFORMATION23 , ele.ENTRY_INFORMATION24 , ele.ENTRY_INFORMATION25 , ele.ENTRY_INFORMATION26 , ele.ENTRY_INFORMATION27 , ele.ENTRY_INFORMATION28 , ele.ENTRY_INFORMATION29 , ele.ENTRY_INFORMATION30 , ele.OBJECT_VERSION_NUMBER , ele.CREATOR_TYPE CREATOR_TYPE_CODE , ele.ENTRY_TYPE ENTRY_TYPE_CODE , ele.REASON REASON_CODE , ele.BALANCE_ADJ_COST_FLAG BALANCE_ADJ_COST_FLAG_CODE , ele.UPDATING_ACTION_TYPE UPDATING_ACTION_TYPE_CODE , ele.ELEMENT_ENTRY_ID , ele.COST_ALLOCATION_KEYFLEX_ID , ele.ASSIGNMENT_ID , ele.UPDATING_ACTION_ID , ele.ELEMENT_LINK_ID , ele.ORIGINAL_ENTRY_ID , ele.COMMENT_ID , ele.CREATOR_ID , ele.TARGET_ENTRY_ID , ele.PERSONAL_PAYMENT_METHOD_ID , ele.SOURCE_ID , ele.SOURCE_ASG_ACTION_ID , ele.SOURCE_LINK_ID , ele.ELEMENT_TYPE_ID , ele.LAST_UPDATE_DATE , ele.LAST_UPDATED_BY , ele.LAST_UPDATE_LOGIN , ele.CREATED_BY , ele.CREATION_DATE FROM pay_element_entries_f ele WITH READ ONLY

View Text - HTML Formatted

SELECT ELE.EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('CREATOR_TYPE'
, ELE.CREATOR_TYPE) CREATOR_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('ENTRY_TYPE'
, ELE.ENTRY_TYPE) ENTRY_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('ELE_ENTRY_REASON'
, ELE.REASON) REASON
, ELE.SUBPRIORITY
, ELE.DATE_EARNED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELE.BALANCE_ADJ_COST_FLAG) BALANCE_ADJ_COST_FLAG
, ELE.SOURCE_TRIGGER_ENTRY
, ELE.SOURCE_PERIOD
, ELE.SOURCE_RUN_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('ACTION_TYPE'
, ELE.UPDATING_ACTION_TYPE) UPDATING_ACTION_TYPE
, ELE.SOURCE_START_DATE
, ELE.SOURCE_END_DATE
, '_DF:PAY:PAY_ELEMENT_ENTRIES:ELE'
, ELE.ATTRIBUTE_CATEGORY
, ELE.ATTRIBUTE1
, ELE.ATTRIBUTE2
, ELE.ATTRIBUTE3
, ELE.ATTRIBUTE4
, ELE.ATTRIBUTE5
, ELE.ATTRIBUTE6
, ELE.ATTRIBUTE7
, ELE.ATTRIBUTE8
, ELE.ATTRIBUTE9
, ELE.ATTRIBUTE10
, ELE.ATTRIBUTE11
, ELE.ATTRIBUTE12
, ELE.ATTRIBUTE13
, ELE.ATTRIBUTE14
, ELE.ATTRIBUTE15
, ELE.ATTRIBUTE16
, ELE.ATTRIBUTE17
, ELE.ATTRIBUTE18
, ELE.ATTRIBUTE19
, ELE.ATTRIBUTE20
, ELE.ENTRY_INFORMATION_CATEGORY
, ELE.ENTRY_INFORMATION1
, ELE.ENTRY_INFORMATION2
, ELE.ENTRY_INFORMATION3
, ELE.ENTRY_INFORMATION4
, ELE.ENTRY_INFORMATION5
, ELE.ENTRY_INFORMATION6
, ELE.ENTRY_INFORMATION7
, ELE.ENTRY_INFORMATION8
, ELE.ENTRY_INFORMATION9
, ELE.ENTRY_INFORMATION10
, ELE.ENTRY_INFORMATION11
, ELE.ENTRY_INFORMATION12
, ELE.ENTRY_INFORMATION13
, ELE.ENTRY_INFORMATION14
, ELE.ENTRY_INFORMATION15
, ELE.ENTRY_INFORMATION16
, ELE.ENTRY_INFORMATION17
, ELE.ENTRY_INFORMATION18
, ELE.ENTRY_INFORMATION19
, ELE.ENTRY_INFORMATION20
, ELE.ENTRY_INFORMATION21
, ELE.ENTRY_INFORMATION22
, ELE.ENTRY_INFORMATION23
, ELE.ENTRY_INFORMATION24
, ELE.ENTRY_INFORMATION25
, ELE.ENTRY_INFORMATION26
, ELE.ENTRY_INFORMATION27
, ELE.ENTRY_INFORMATION28
, ELE.ENTRY_INFORMATION29
, ELE.ENTRY_INFORMATION30
, ELE.OBJECT_VERSION_NUMBER
, ELE.CREATOR_TYPE CREATOR_TYPE_CODE
, ELE.ENTRY_TYPE ENTRY_TYPE_CODE
, ELE.REASON REASON_CODE
, ELE.BALANCE_ADJ_COST_FLAG BALANCE_ADJ_COST_FLAG_CODE
, ELE.UPDATING_ACTION_TYPE UPDATING_ACTION_TYPE_CODE
, ELE.ELEMENT_ENTRY_ID
, ELE.COST_ALLOCATION_KEYFLEX_ID
, ELE.ASSIGNMENT_ID
, ELE.UPDATING_ACTION_ID
, ELE.ELEMENT_LINK_ID
, ELE.ORIGINAL_ENTRY_ID
, ELE.COMMENT_ID
, ELE.CREATOR_ID
, ELE.TARGET_ENTRY_ID
, ELE.PERSONAL_PAYMENT_METHOD_ID
, ELE.SOURCE_ID
, ELE.SOURCE_ASG_ACTION_ID
, ELE.SOURCE_LINK_ID
, ELE.ELEMENT_TYPE_ID
, ELE.LAST_UPDATE_DATE
, ELE.LAST_UPDATED_BY
, ELE.LAST_UPDATE_LOGIN
, ELE.CREATED_BY
, ELE.CREATION_DATE
FROM PAY_ELEMENT_ENTRIES_F ELE WITH READ ONLY