Recently the APEX environment at a client site was upgraded from 3.2 to 4.2. As a part of the upgrade we performed an "application upgrade" on each application. One suggestion as part of the application upgrade is to change items that are using the "Date Picker (Classic)" to the newer "Date Picker" type which gives you the inline date picker functionality as opposed to the popup date picker.
After going into production it was discovered that in some instances the users needed to choose a date in a different month/year and that by default the settings for the newer "Date Picker" did not display the Month/Year navigation lists.
The product manager issued a directive, "change/standardize the Oracle calendars throughout the modules", meaning have all the date pickers in all the applications (over a dozen) look and behave the same. It easy enough to change this for the date pickers that users had already identified, yet I needed to find them all. Luckily instead of going through each page of each application looking for date picker items I can query an APEX view.
The following query identifies all the "Date Picker" items found in my "APPS1" workspace..
select APPLICATION_ID,
APPLICATION_NAME,
PAGE_ID,
ITEM_NAME,
DISPLAY_AS,
format_mask,
ATTRIBUTE_01 AS HIGHLIGHT_DATE,
ATTRIBUTE_02 AS MIN_DATE,
ATTRIBUTE_03 AS MAX_DATE,
ATTRIBUTE_07 AS NAV_LIST,
ATTRIBUTE_08 AS YEAR_RANGE
from APEX_APPLICATION_PAGE_ITEMS
where DISPLAY_AS = 'Date Picker'
and WORKSPACE = 'APPS1'
order by APPLICATION_ID, PAGE_ID