FND Design Data [Home] [Help]

View: BENBV_ABR_EXTRA_INFO_V

Product: BEN - Advanced Benefits
Description: This view identifies extra information for Activity Base Rates.
Implementation/DBA Data: ViewAPPS.BENBV_ABR_EXTRA_INFO_V
View Text

SELECT ABI.INFORMATION_TYPE
, ABI.PROGRAM_UPDATE_DATE
, '_DF:BEN:STANDARD RATE INFO DDF:ABI'
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:STANDARD RATE INFORMATION:ABI'
, /* ID COLUMNS */ ABI.ABR_EXTRA_INFO_ID
, ABI.ACTY_BASE_RT_ID
, ABI.REQUEST_ID
, ABI.PROGRAM_APPLICATION_ID
, ABI.PROGRAM_ID
, /* WHO COLUMNS */ ABI.LAST_UPDATE_DATE
, ABI.LAST_UPDATED_BY
, ABI.CREATED_BY
, ABI.CREATION_DATE
FROM BEN_ABR_EXTRA_INFO ABI WITH READ ONLY

Columns

Name
INFORMATION_TYPE
PROGRAM_UPDATE_DATE
"_DF:ABI_EIT"
"_DF:ABI"
ABR_EXTRA_INFO_ID
ACTY_BASE_RT_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE