FND Design Data [Home] [Help]

View: PAYBV_COST_ALLOCATION_KEYFLEX

Product: PAY - Payroll
Description: Discoverer base view for pay_cost_allocation_keyflex
Implementation/DBA Data: ViewAPPS.PAYBV_COST_ALLOCATION_KEYFLEX
View Text

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

Columns

Name
CONCATENATED_SEGMENTS
ID_FLEX_NUM
SUMMARY_FLAG
ENABLED_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE
"_KF:NAME"
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6
SEGMENT7
SEGMENT8
SEGMENT9
SEGMENT10
SEGMENT11
SEGMENT12
SEGMENT13
SEGMENT14
SEGMENT15
SEGMENT16
SEGMENT17
SEGMENT18
SEGMENT19
SEGMENT20
SEGMENT21
SEGMENT22
SEGMENT23
SEGMENT24
SEGMENT25
SEGMENT26
SEGMENT27
SEGMENT28
SEGMENT29
SEGMENT30
SUMMARY_FLAG_CODE
ENABLED_FLAG_CODE
COST_ALLOCATION_KEYFLEX_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE