DBA Data[Home] [Help]

VIEW: APPS.PAY_COST_ALLOCATION_KEYFLE_KFV

Source

View Text - Preformatted

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
View Text - HTML Formatted

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