FND Design Data [Home] [Help]

View: PAY_COST_ALLOCATION_KEYFLE_KFV

Product: PAY - Payroll
Description: Used to support user interface
Implementation/DBA Data: ViewAPPS.PAY_COST_ALLOCATION_KEYFLE_KFV
View Text

SELECT ROWID
, COST_ALLOCATION_KEYFLEX_ID
, ID_FLEX_NUM
, (DECODE(ID_FLEX_NUM
, 101
, SEGMENT12
, NULL))
, (DECODE(ID_FLEX_NUM
, 101
, RPAD(NVL(SEGMENT12
, ' ')
, 60)
, NULL))
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM PAY_COST_ALLOCATION_KEYFLEX

Columns

Name
ROW_ID
COST_ALLOCATION_KEYFLEX_ID
ID_FLEX_NUM
CONCATENATED_SEGMENTS
PADDED_CONCATENATED_SEGMENTS
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
SUMMARY_FLAG
ENABLED_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE