SELECT pcak.CONCATENATED_SEGMENTS ,pcak.ID_FLEX_NUM ,pcak.SUMMARY_FLAG ,pcak.ENABLED_FLAG ,pcak.START_DATE_ACTIVE ,pcak.END_DATE_ACTIVE ,'_KF:PAY:COST:pcak' ,pcak.SEGMENT1 ,pcak.SEGMENT2 ,pcak.SEGMENT3 ,pcak.SEGMENT4 ,pcak.SEGMENT5 ,pcak.SEGMENT6 ,pcak.SEGMENT7 ,pcak.SEGMENT8 ,pcak.SEGMENT9 ,pcak.SEGMENT10 ,pcak.SEGMENT11 ,pcak.SEGMENT12 ,pcak.SEGMENT13 ,pcak.SEGMENT14 ,pcak.SEGMENT15 ,pcak.SEGMENT16 ,pcak.SEGMENT17 ,pcak.SEGMENT18 ,pcak.SEGMENT19 ,pcak.SEGMENT20 ,pcak.SEGMENT21 ,pcak.SEGMENT22 ,pcak.SEGMENT23 ,pcak.SEGMENT24 ,pcak.SEGMENT25 ,pcak.SEGMENT26 ,pcak.SEGMENT27 ,pcak.SEGMENT28 ,pcak.SEGMENT29 ,pcak.SEGMENT30 ,hr_bis.bis_decode_lookup('YES_NO',pcak.SUMMARY_FLAG) SUMMARY_FLAG_CODE ,hr_bis.bis_decode_lookup('YES_NO',pcak.ENABLED_FLAG) ENABLED_FLAG_CODE ,pcak.COST_ALLOCATION_KEYFLEX_ID ,pcak.LAST_UPDATE_DATE ,pcak.LAST_UPDATED_BY ,pcak.LAST_UPDATE_LOGIN ,pcak.CREATED_BY ,pcak.CREATION_DATE FROM pay_cost_allocation_keyflex pcak WITH READ ONLY
SELECT PCAK.CONCATENATED_SEGMENTS
, PCAK.ID_FLEX_NUM
, PCAK.SUMMARY_FLAG
, PCAK.ENABLED_FLAG
, PCAK.START_DATE_ACTIVE
, PCAK.END_DATE_ACTIVE
, '_KF:PAY:COST:PCAK'
, PCAK.SEGMENT1
, PCAK.SEGMENT2
, PCAK.SEGMENT3
, PCAK.SEGMENT4
, PCAK.SEGMENT5
, PCAK.SEGMENT6
, PCAK.SEGMENT7
, PCAK.SEGMENT8
, PCAK.SEGMENT9
, PCAK.SEGMENT10
, PCAK.SEGMENT11
, PCAK.SEGMENT12
, PCAK.SEGMENT13
, PCAK.SEGMENT14
, PCAK.SEGMENT15
, PCAK.SEGMENT16
, PCAK.SEGMENT17
, PCAK.SEGMENT18
, PCAK.SEGMENT19
, PCAK.SEGMENT20
, PCAK.SEGMENT21
, PCAK.SEGMENT22
, PCAK.SEGMENT23
, PCAK.SEGMENT24
, PCAK.SEGMENT25
, PCAK.SEGMENT26
, PCAK.SEGMENT27
, PCAK.SEGMENT28
, PCAK.SEGMENT29
, PCAK.SEGMENT30
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCAK.SUMMARY_FLAG) SUMMARY_FLAG_CODE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCAK.ENABLED_FLAG) ENABLED_FLAG_CODE
, PCAK.COST_ALLOCATION_KEYFLEX_ID
, PCAK.LAST_UPDATE_DATE
, PCAK.LAST_UPDATED_BY
, PCAK.LAST_UPDATE_LOGIN
, PCAK.CREATED_BY
, PCAK.CREATION_DATE
FROM PAY_COST_ALLOCATION_KEYFLEX PCAK WITH READ ONLY
|
|
|