VIEW: APPS.GHR_ELEMENT_ENTRIES_H_V

Source

View Text - Preformatted

SELECT PA_HISTORY_ID , PROCESS_DATE , EFFECTIVE_DATE , DML_OPERATION , PRE_VALUES_FLAG , ALTERED_PA_REQUEST_ID , PA_REQUEST_ID , NATURE_OF_ACTION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION1) ELEMENT_ENTRY_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE , FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE , GHR_GENERAL.RETURN_NUMBER(INFORMATION4) COST_ALLOCATION_KEYFLEX_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION5) ASSIGNMENT_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION6) UPDATING_ACTION_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION7) ELEMENT_LINK_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION8) ORIGINAL_ENTRY_ID , SUBSTR(INFORMATION9,1,10) CREATOR_TYPE , SUBSTR(INFORMATION10,1,1) ENTRY_TYPE , GHR_GENERAL.RETURN_NUMBER(INFORMATION11) COMMENT_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION12) CREATOR_ID , SUBSTR(INFORMATION13,1,30) REASON , GHR_GENERAL.RETURN_NUMBER(INFORMATION14) TARGET_ENTRY_ID , GHR_GENERAL.RETURN_NUMBER(INFORMATION15) SUBPRIORITY , GHR_GENERAL.RETURN_NUMBER(INFORMATION16) PERSONAL_PAYMENT_METHOD_ID , FND_DATE.CANONICAL_TO_DATE(INFORMATION17) DATE_EARNED , SUBSTR(INFORMATION121,1,30) ATTRIBUTE_CATEGORY , SUBSTR(INFORMATION122,1,150) ATTRIBUTE1 , SUBSTR(INFORMATION123,1,150) ATTRIBUTE2 , SUBSTR(INFORMATION124,1,150) ATTRIBUTE3 , SUBSTR(INFORMATION125,1,150) ATTRIBUTE4 , SUBSTR(INFORMATION126,1,150) ATTRIBUTE5 , SUBSTR(INFORMATION127,1,150) ATTRIBUTE6 , SUBSTR(INFORMATION128,1,150) ATTRIBUTE7 , SUBSTR(INFORMATION129,1,150) ATTRIBUTE8 , SUBSTR(INFORMATION130,1,150) ATTRIBUTE9 , SUBSTR(INFORMATION131,1,150) ATTRIBUTE10 , SUBSTR(INFORMATION132,1,150) ATTRIBUTE11 , SUBSTR(INFORMATION133,1,150) ATTRIBUTE12 , SUBSTR(INFORMATION134,1,150) ATTRIBUTE13 , SUBSTR(INFORMATION135,1,150) ATTRIBUTE14 , SUBSTR(INFORMATION136,1,150) ATTRIBUTE15 , SUBSTR(INFORMATION137,1,150) ATTRIBUTE16 , SUBSTR(INFORMATION138,1,150) ATTRIBUTE17 , SUBSTR(INFORMATION139,1,150) ATTRIBUTE18 , SUBSTR(INFORMATION140,1,150) ATTRIBUTE19 , SUBSTR(INFORMATION141,1,150) ATTRIBUTE20 FROM GHR_PA_HISTORY WHERE TABLE_NAME = 'PAY_ELEMENT_ENTRIES_F'

View Text - HTML Formatted

SELECT PA_HISTORY_ID
, PROCESS_DATE
, EFFECTIVE_DATE
, DML_OPERATION
, PRE_VALUES_FLAG
, ALTERED_PA_REQUEST_ID
, PA_REQUEST_ID
, NATURE_OF_ACTION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) ELEMENT_ENTRY_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION4) COST_ALLOCATION_KEYFLEX_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION5) ASSIGNMENT_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION6) UPDATING_ACTION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION7) ELEMENT_LINK_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION8) ORIGINAL_ENTRY_ID
, SUBSTR(INFORMATION9
, 1
, 10) CREATOR_TYPE
, SUBSTR(INFORMATION10
, 1
, 1) ENTRY_TYPE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION11) COMMENT_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION12) CREATOR_ID
, SUBSTR(INFORMATION13
, 1
, 30) REASON
, GHR_GENERAL.RETURN_NUMBER(INFORMATION14) TARGET_ENTRY_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION15) SUBPRIORITY
, GHR_GENERAL.RETURN_NUMBER(INFORMATION16) PERSONAL_PAYMENT_METHOD_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION17) DATE_EARNED
, SUBSTR(INFORMATION121
, 1
, 30) ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION122
, 1
, 150) ATTRIBUTE1
, SUBSTR(INFORMATION123
, 1
, 150) ATTRIBUTE2
, SUBSTR(INFORMATION124
, 1
, 150) ATTRIBUTE3
, SUBSTR(INFORMATION125
, 1
, 150) ATTRIBUTE4
, SUBSTR(INFORMATION126
, 1
, 150) ATTRIBUTE5
, SUBSTR(INFORMATION127
, 1
, 150) ATTRIBUTE6
, SUBSTR(INFORMATION128
, 1
, 150) ATTRIBUTE7
, SUBSTR(INFORMATION129
, 1
, 150) ATTRIBUTE8
, SUBSTR(INFORMATION130
, 1
, 150) ATTRIBUTE9
, SUBSTR(INFORMATION131
, 1
, 150) ATTRIBUTE10
, SUBSTR(INFORMATION132
, 1
, 150) ATTRIBUTE11
, SUBSTR(INFORMATION133
, 1
, 150) ATTRIBUTE12
, SUBSTR(INFORMATION134
, 1
, 150) ATTRIBUTE13
, SUBSTR(INFORMATION135
, 1
, 150) ATTRIBUTE14
, SUBSTR(INFORMATION136
, 1
, 150) ATTRIBUTE15
, SUBSTR(INFORMATION137
, 1
, 150) ATTRIBUTE16
, SUBSTR(INFORMATION138
, 1
, 150) ATTRIBUTE17
, SUBSTR(INFORMATION139
, 1
, 150) ATTRIBUTE18
, SUBSTR(INFORMATION140
, 1
, 150) ATTRIBUTE19
, SUBSTR(INFORMATION141
, 1
, 150) ATTRIBUTE20
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'PAY_ELEMENT_ENTRIES_F'