| LIST_OF_VALUES_NAME | LOV_TYPE |
| LIST_OF_VALUES_QUERY |
| ACCESS CONTROL SCOPE | Static |
| ACCESS CONTROL SCOPE1 | Static |
| ACCESS_LEVELS | Dynamic |
| select access_level
d, id r from eba_proj_status_access_levels order by 1 |
| select access_level
d, id r from eba_proj_status_access_levels order by 1 |
| ACTION ITEM OWNERS | Dynamic |
| select distinct
v1.owner d, lower(v1.username) r from ( select
eba_proj_fw.get_name_from_email_address(action_owner_01) owner,
action_owner_01 username from eba_proj_status_ais union all select
eba_proj_fw.get_name_from_email_address(action_owner_02) owner,
action_owner_02 username from eba_proj_status_ais union all select
eba_proj_fw.get_name_from_email_address(action_owner_03) owner,
action_owner_03 username from eba_proj_status_ais union all select
eba_proj_fw.get_name_from_email_address(action_owner_04) owner,
action_owner_04 username from eba_proj_status_ais union all select
eba_proj_fw.get_name_from_email_address(u.username) owner, u.username
username from eba_proj_status_users u where exists ( select null from
eba_proj_status_ais a, eba_proj_user_ref rf where rf.role_id =
a.owner_role_id and rf.project_id = a.project_id and rf.user_id = u.id ) ) v1
where v1.owner is not null order by 1 |
| ACTION ITEM STATUS (OPEN, CLOSED) | Static |
| ACTION ITEM TYPES | Dynamic |
| select AI_TYPE, id
from EBA_PROJ_STATUS_AIS_TYPES where is_active_yn = ‘Y’ order by
display_sequence |
| ACTION ITEM TYPES IRR | Dynamic |
| select ‘Not Set’ as
ai_type, -1 as id from dual union all select AI_TYPE, id from
EBA_PROJ_STATUS_AIS_TYPES where is_active_yn = ‘Y’ order by 1 |
| ACTION ITEMS SORT ORDER | Static |
| ATTACHMENT SORT OPTIONS | Static |
| AVAILABLE PROJECTS (HIERARCHICAL) | Dynamic |
| with
data as ( select parent_project_id, id, project from eba_proj_status where
project_status not in ( select id from eba_proj_status_codes where
is_closed_status = ‘Y’ ) and eba_proj_fw.is_edit_authorized( p_username =>
‘APP_USER’, p_project_id => id ) = ‘Y’ ) select d, r from ( select
ltrim(replace(SYS_CONNECT_BY_PATH(project, ‘:TREESEP:’), ‘:TREESEP:’,’ / ‘),
‘/ ‘) d, id r from data start with parent_project_id is null connect by prior
id = parent_project_id order siblings by project ) union all select
ps.project d, ps.id r from data ps where ps.parent_project_id is not null and
not exists ( select null from data p2 where p2.id = ps.parent_project_id ); |
| CATEGORIES | Dynamic |
| select CATEGORY
display_value, ID return_value from EBA_PROJ_STATUS_CATS where is_active_yn =
‘Y’ order by display_sequence nulls last, 1 |
| CATEGORIES (ALL) | Dynamic |
| select CATEGORY
display_value, ID return_value from EBA_PROJ_STATUS_CATS order by
display_sequence nulls last, 1 |
| CATEGORIES WITH PROJECTS | Dynamic |
| select CATEGORY
display_value, ID return_value from EBA_PROJ_STATUS_CATS c where is_active_yn
= ‘Y’ and exists (select 1 from eba_proj_status p where p.cat_id = c.id)
order by display_sequence nulls last, 1 |
| CATEGORY CREATE OPTIONS | Static |
| COLOR CODES RED, YELLOW, GREEN | Static |
| COUNT OF PROJECT UPDATES OWNERS | Dynamic |
| select
eba_proj_fw.get_name_from_email_address(u.update_owner) || ‘
(‘||count(*)||’)’ d, lower(u.update_owner) r from eba_proj_status_updates u
where u.update_owner is not null group by
eba_proj_fw.get_name_from_email_address(u.update_owner), lower(u.update_owner)
order by 1 |
| COUNTRIES | Dynamic |
| select country_name
d, id r from eba_proj_countries order by lower(country_name) |
| CUSTOM_MENU_ICONS | Static |
| DATA_LOAD_CHARSET | Static |
| DATA_LOAD_OPTION | Static |
| DATE_FORMAT_OPTION | Static |
| DEAL TYPES | Dynamic |
| select deal_type d,
id r from eba_proj_deal_types where is_active_yn = ‘Y’ order by
display_sequence |
| DISTINCT PROJECT OWNERS | Dynamic |
| select
eba_proj_fw.get_name_from_email_address(u.username) d, lower(u.username) r
from eba_proj_status_users u where exists ( select null from
eba_proj_user_ref rf, eba_proj_roles r, eba_proj_status p,
eba_proj_status_codes sc where rf.user_id = u.id and p.id = rf.project_id and
rf.role_id = r.id and eba_proj_fw.is_edit_authorized( u.username,
rf.project_id ) = ‘Y’ and p.project_status = sc.id and sc.is_closed_status !=
‘Y’ ) order by lower(u.username) |
| DISTINCT PROJECT OWNERS BY ID | Dynamic |
| select
eba_proj_fw.get_name_from_email_address(u.username) d, u.id r from
eba_proj_status_users u where exists ( select null from eba_proj_user_ref rf,
eba_proj_roles r, eba_proj_status p, eba_proj_status_codes sc where
rf.user_id = u.id and p.id = rf.project_id and rf.role_id = r.id and
eba_proj_fw.is_edit_authorized( u.username, rf.project_id ) = ‘Y’ and
p.project_status = sc.id and sc.is_closed_status != ‘Y’ ) order by
eba_proj_fw.get_name_from_email_address(u.username) |
| DISTINCT PROJECT OWNERS LOWER | Dynamic |
| select
lower(u.username) d, lower(u.username) r from eba_proj_status_users u where
exists (select null from eba_proj_user_ref rf, eba_proj_status p where
rf.user_id = u.id and rf.project_id = p.id and
eba_proj_fw.is_edit_authorized( u.username, rf.project_id ) = ‘Y’ and
p.project_status not in ( select id from eba_proj_status_codes where
is_closed_status = ‘Y’ ) ) order by lower(u.username) |
| EMAIL SCHEDULE OPTIONS | Static |
| EMAIL TARGET ALL OR USER | Static |
| EMAIL_FROM_PREF_OPTS | Static |
| ENABLED OR DISABLED | Static |
| FEEDBACK STATUSES | Static |
| FEEDBACK TYPES | Dynamic |
| select type, id
from eba_proj_feedback_types order by id |
| |
| FIRST_ROW_OPTION | Static |
| FLEX_COLUMNS | Dynamic |
| select distinct
c.column_name|| ‘ – ‘||c.data_type||
decode(c.data_type,’VARCHAR2’,\'(‘||c.data_length||’)’,null) as dv,
c.column_name as rv from sys.all_tab_columns c, eba_proj_flex_registry f
where c.table_name = :P142_FLEXIBLE_TABLE and c.column_name =
f.flexible_column (+) and nvl(f.active_yn,’N’) = ‘N’ and lower(c.column_name)
like ‘%flex%’ and instr(c.table_name,’FLEX’) = 0 order by 1 |
| FLEX_FIELD_TYPES | Dynamic |
| select
‘Date Picker’ dv, ‘DATE’ rv from dual where — Only date columns
instr(:P144_FLEX_COLUMN,’FLEX_D’) > 0 union all select ‘Large Text Input
Field (Text Area)’ dv, ‘TEXTAREA’ rv from dual where — CLOB and varchar2
columns instr(:P144_FLEX_COLUMN,’FLEX_CLOB’) > 0 or
instr(:P144_FLEX_COLUMN,’FLEX_0′) > 0 union all select ‘Number Field’ dv,
‘NUMBER’ rv from dual where — Only number columns
instr(:P144_FLEX_COLUMN,’FLEX_N’) > 0 union all select ‘Select List’ dv,
‘SELECT_LIST’ rv from dual where — Only number and varchar2 columns
instr(:P144_FLEX_COLUMN,’FLEX_0′) > 0 or instr(:P144_FLEX_COLUMN,’FLEX_N’)
> 0 union all select ‘Text Field’ dv, ‘TEXT’ rv from dual where — Only
varchar2 columns instr(:P144_FLEX_COLUMN,’FLEX_0′) > 0 |
| FLEX_HDR_ALIGNMENTS | Static |
| FLEX_LABEL_ALIGNMENT | Static |
| FLEX_LOV_TYPE | Static |
| FLEX_TABLES | Dynamic |
| select
f.display_name_plrl display_value, f.flexible_table return_value from
eba_proj_flex_registry f where f.assigned_yn = ‘N’ group by
f.display_name_plrl, f.flexible_table order by 1 |
| HOME_PAGE_ICON_TOGGLES | Static |
| I AM FOLLOWING | Static |
| INCLUDE COMPLETED PROJECTS | Static |
| INVOLVEMENT LEVEL | Dynamic |
| select
involvement_level||decode(PERCENTAGE,null,null,’ – ‘||percentage||’%’) d, id
r from eba_proj_involvement_levels order by display_sequence |
| ISSUE CATEGORIES | Dynamic |
| select name as d, id as r from
EBA_PROJ_ISSUE_CATS where is_active_yn = ‘Y’ order by 1 | |
| ISSUE_LEVELS | Dynamic |
| select case when
description is not null then name || ‘ – ‘ || description else name end as d,
id as r from EBA_PROJ_ISSUE_LEVELS where is_active_yn = ‘Y’ order by 1 |
| ISSUES STATUS OPEN CLOSED | Static |
| LABEL_TEMPLATES | Dynamic |
| select
template_name || ‘ (‘ || decode(theme_number, 50, ‘Mobile Theme’, 42,
‘Desktop Theme’) || ‘)’ dv, label_template_id rv from
apex_application_temp_label where application_id = :APP_ID and theme_number
in (select u.theme_number from apex_application_themes t,
apex_appl_user_interfaces u where t.ui_type_id = u.ui_type_id and
t.application_id = u.application_id and t.application_id = :APP_ID and
u.ui_type_name = ‘DESKTOP’) order by 1 |
| LOCKDOWN | Static |
| MAJOR MILESTONES | Static |
| MASS UPDATE ACTION ITEM STATUSES | Static |
| MASS UPDATE MILESTONE STATUSES | Static |
| MASS_UPDATE_ACTIONS | Static |
| MASS_UPDATE_USERS | Static |
| MICROSITE TAG TYPES | Static |
| MILESTONE OR PROJECT OWNER TWO VALUES | Dynamic |
| select
distinct display_owner d, lower(owner) r from ( select
eba_proj_fw.get_name_from_email_address(u.username) as display_owner,
u.username as owner from eba_proj_status_users u, eba_proj_user_ref rf,
eba_proj_roles r, eba_proj_status p where rf.user_id = u.id and rf.role_id =
r.id and eba_proj_fw.is_edit_authorized( u.username, rf.project_id ) = ‘Y’
and rf.project_id = p.id union all select
eba_proj_fw.get_name_from_email_address(milestone_owner) as display_owner,
milestone_owner as owner from eba_proj_status_ms where milestone_owner is not
null and owner_role_id is null union all select
eba_proj_fw.get_name_from_email_address(u.username) as display_owner,
u.username as owner from eba_proj_user_ref rf, eba_proj_status_users u,
eba_proj_roles r, eba_proj_status_ms m where m.owner_role_id is not null and
rf.role_id = m.owner_role_id and rf.project_id = m.project_id and u.id =
rf.user_id and r.id = rf.role_id ) order by 1 |
| MILESTONE OWNERS | Dynamic |
| select distinct
owner d, owner r from ( select lower(x.milestone_owner) owner from
eba_proj_status_ms x where x.owner_role_id is null union all select
lower(u.username) owner from eba_proj_status_ms x, eba_proj_user_ref rf,
eba_proj_status_users u where rf.role_id = x.owner_role_id and rf.project_id
= x.project_id and u.id = rf.user_id ) where owner is not null order by owner |
| MILESTONE STATUS VALUES | Static |
| MILESTONE TYPES | Static |
| MILESTONES SORT ORDER | Static |
| MILESTONES TO INCLUDE ALL OR OPEN | Static |
| MORE OR MINOR OR ALL | Static |
| MS_DELETE_OPTIONS | Static |
| MS_DUE_DATE_SORT_ORDER | Static |
| NOTIFICATION TYPES | Static |
| NUMBER OF ROWS | Static |
| OPT-IN USERS WITH PAST DUE DELIVERABLES | Dynamic |
| select distinct
lower(x.owner) d, lower(x.owner) r from ( select ais.action_owner_01 as
owner, nvl(u.past_due_reminders_freq,’DAILY’) as pdrs from
eba_proj_status_ais ais, eba_proj_status_users u where
upper(ais.action_owner_01) = u.username and ais.owner_role_id is null union
all select ais.action_owner_02 as owner,
nvl(u.past_due_reminders_freq,’DAILY’) as pdrs from eba_proj_status_ais ais,
eba_proj_status_users u where upper(ais.action_owner_02) = u.username and
ais.owner_role_id is null union all select ais.action_owner_03 as owner,
nvl(u.past_due_reminders_freq,’DAILY’) as pdrs from eba_proj_status_ais ais,
eba_proj_status_users u where upper(ais.action_owner_03) = u.username and
ais.owner_role_id is null union all select ais.action_owner_04 as owner,
nvl(u.past_due_reminders_freq,’DAILY’) as pdrs from eba_proj_status_ais ais,
eba_proj_status_users u where upper(ais.action_owner_04) = u.username and
ais.owner_role_id is null union all select u.username as owner,
nvl(u.past_due_reminders_freq,’DAILY’) as pdrs from eba_proj_status_users u
where exists ( select null from eba_proj_status_ais a, eba_proj_user_ref rf
where rf.role_id = a.owner_role_id and rf.project_id = a.project_id and
rf.user_id = u.id ) ) x where x.owner is not null and x.pdrs != ‘NEVER’ and
exists (select null from eba_proj_status_ais$ a, eba_proj_status$ p,
eba_proj_status_codes s where p.id = a.project_id and p.project_status = s.id
(+) and s.is_closed_status != ‘Y’ and p.is_deleted_yn = ‘N’ and
a.action_status = ‘Open’ and a.due_date < sysdate and ( a.action_owner_01
= x.owner or a.action_owner_02 = x.owner or a.action_owner_03 = x.owner or
a.action_owner_04 = x.owner or exists ( select null from eba_proj_user_ref
rf, eba_proj_status_users u where rf.role_id = a.owner_role_id and
rf.project_id = a.project_id and rf.user_id = u.id and u.username = x.owner
and nvl(u.past_due_reminders_freq,’NEVER’) != ‘NEVER’ ) ) union all select
null from eba_proj_status_ms$ m, eba_proj_status$ p, eba_proj_status_codes s
where p.id = m.project_id and p.project_status = s.id (+) and
s.is_closed_status != ‘Y’ and m.milestone_status = ‘Open’ and
m.milestone_date < sysdate and p.is_deleted_yn = ‘N’ and (
m.milestone_owner = x.owner or exists ( select null from eba_proj_user_ref
rf, eba_proj_status_users u where rf.role_id = m.owner_role_id and
rf.project_id = m.project_id and rf.user_id = u.id and u.username = x.owner
and nvl(u.past_due_reminders_freq,’NEVER’) != ‘NEVER’ ) ) ) order by 1 |
| OPT-IN USERS WITH UPCOMING DELIVERABLES | Dynamic |
| select distinct
lower(x.owner) d, lower(x.owner) r from ( select ais.action_owner_01 as
owner, nvl(u.upcoming_reminders_freq,’DAILY’) as urs from eba_proj_status_ais
ais, eba_proj_status_users u where upper(ais.action_owner_01) = u.username
and ais.owner_role_id is null union all select ais.action_owner_02 as owner,
nvl(u.upcoming_reminders_freq,’DAILY’) as urs from eba_proj_status_ais ais,
eba_proj_status_users u where upper(ais.action_owner_02) = u.username and
ais.owner_role_id is null union all select ais.action_owner_03 as owner,
nvl(u.upcoming_reminders_freq,’DAILY’) as urs from eba_proj_status_ais ais,
eba_proj_status_users u where upper(ais.action_owner_03) = u.username and
ais.owner_role_id is null union all select ais.action_owner_04 as owner,
nvl(u.upcoming_reminders_freq,’DAILY’) as urs from eba_proj_status_ais ais,
eba_proj_status_users u where upper(ais.action_owner_04) = u.username and
ais.owner_role_id is null union all select u.username as owner,
nvl(u.upcoming_reminders_freq,’DAILY’) as urs from eba_proj_status_users u
where exists ( select null from eba_proj_status_ais a, eba_proj_user_ref rf
where rf.role_id = a.owner_role_id and rf.project_id = a.project_id and
rf.user_id = u.id ) ) x where x.owner is not null and x.urs != ‘NEVER’ and
exists (select null from eba_proj_status_ais$ a, eba_proj_status$ p,
eba_proj_status_codes s where p.id = a.project_id and p.project_status = s.id
(+) and s.is_closed_status != ‘Y’ and p.is_deleted_yn = ‘N’ and
a.action_status = ‘Open’ and a.due_date between sysdate and sysdate + 7 and (
a.action_owner_01 = x.owner or a.action_owner_02 = x.owner or
a.action_owner_03 = x.owner or a.action_owner_04 = x.owner or exists ( select
null from eba_proj_user_ref rf, eba_proj_status_users u where rf.role_id =
a.owner_role_id and rf.project_id = a.project_id and rf.user_id = u.id and
u.username = x.owner ) ) union all select null from eba_proj_status_ms$ m,
eba_proj_status$ p, eba_proj_status_codes s where p.id = m.project_id and
p.project_status = s.id (+) and s.is_closed_status != ‘Y’ and
m.milestone_status = ‘Open’ and m.milestone_date between sysdate and sysdate
+ 7 and p.is_deleted_yn = ‘N’ and ( m.milestone_owner = x.owner or exists (
select null from eba_proj_user_ref rf, eba_proj_status_users u where
rf.role_id = m.owner_role_id and rf.project_id = m.project_id and rf.user_id
= u.id and u.username = x.owner ) ) ) order by 1 |
| PAGE 2 PROJECT_STATUS | Dynamic |
| select
STATUS_short_desc display_value, ID return_value from EBA_PROJ_STATUS_CODES s
where s.is_active_yn = ‘Y’ or id = :P2_PROJECT_STATUS order by s.is_active_yn
desc, s.display_sequence |
| POPULARITY VIEW OPTIONS P139 | Static |
| PROJECT ACL | Static |
| PROJECT ACL LEVELS | Static |
| PROJECT CREATION ROLES | Static |
| PROJECT DETAILS RECIPIENT OPTIONS | Static |
| PROJECT DETAILS SCOPE OPTIONS | Static |
| PROJECT OPEN | Static |
| PROJECT REPORT FILTERS | Static |
| PROJECT RESOURCE TYPES | Dynamic |
| select
resource_type d, id r from eba_proj_resource_types order by
lower(resource_type) |
| PROJECT ROLES | Dynamic |
| select name as d,
id as r from eba_proj_roles order by 1 |
| PROJECT ROWKEY OPTIONS | Static |
| PROJECT SORT OPTIONS | Static |
| PROJECT STATUS EMAIL MS OPTIONS | Static |
| PROJECT TEMPLATE AIS | Dynamic |
| select name d, id r
from eba_proj_template_ai order by lower(name) |
| PROJECT TEMPLATE MILESTONES | Dynamic |
| select ‘Start of
Project’ d, 0 r from dual union select name d, id r from eba_proj_template_ms
where template_id = nvl(:P184_ID,:P47_TEMPLATE_ID) order by 1 |
| PROJECT TEMPLATES | Dynamic |
| select name as d,
id as r from eba_proj_templates order by 1 |
| PROJECT UPDATES SORT ORDER | Static |
| PROJECTS | Dynamic |
| select project d,
id r from eba_proj_status order by upper(project) |
| PUSH WHAT | Static |
| P142_FLEX_DATA_TYPES | Static |
| P182 TEMPLATE MILESTONES | Dynamic |
| select m.name d,
m.id r from eba_proj_template_ms m where m.template_id = :P182_TEMPLATE_ID
order by m.start_date_offset + m.due_date_offset, lower(m.name) |
| P195_COUNTRIES | Dynamic |
| select country_name
d, id r from eba_proj_countries where (region_id = :P195_REGION_ID and
:P195_REGION_ID is not null) or (region_id is not null and :P195_REGION_ID is
null) order by lower(country_name) |
| P195_REGIONS | Dynamic |
| select distinct
r.region_name d, c.region_id r from eba_proj_countries c, eba_proj_regions r
where c.region_id = r.id and ((c.id = :P195_COUNTRY_ID and :P195_COUNTRY_ID
is not null) or (c.id is not null and :P195_COUNTRY_ID is null)) order by
lower(r.region_name) |
| P2_COUNTRIES | Dynamic |
| select country_name
d, id r from eba_proj_countries where :P2_REGION_ID is null or region_id =
:P2_REGION_ID order by lower(country_name) |
| P3_GOLD_YN | Static |
| P302_COUNTRIES | Dynamic |
| select country_name
d, id r from eba_proj_countries where :P302_REGION_ID is null or region_id =
:P302_REGION_ID order by lower(country_name) |
| P90_COUNTRIES | Dynamic |
| select country_name
d, id r from eba_proj_countries where (region_id = :P90_REGION_ID or
:P90_REGION_ID is null) order by lower(country_name) |
| P90_REGIONS | Dynamic |
| select distinct
r.region_name d, r.id r from eba_proj_regions r order by lower(r.region_name) |
| QUARTER DELIMITER | Static |
| QUARTER_MONTHS | Static |
| QUARTERS | Dynamic |
| select period_name
as d, period_name as r from eba_proj_fy_periods order by first_day asc |
| REGIONS | Dynamic |
| select region_name
d, id r from eba_proj_regions order by lower(region_name) |
| REMOVE AGE IN DAYS | Static |
| REQUIRED PAGES | Dynamic |
| select distinct
page_id || ‘ – ‘ || apex_escape.html(page_name) d, page_id r from
apex_application_page_items where application_id = :APP_ID and is_required =
‘No’ and item_label_template not in (‘Hidden’,’Required’) order by page_id
asc; |
| RISK_VERBOSITY_IN_STATUS_EMAILS | Static |
| ROLE ACCESS LEVELS | Static |
| ROLES WITH ACCESS LEVEL | Dynamic |
| select case
default_acl_status_level when 1 then ‘(Read)’ when 2 then ‘(Edit)’ when 3
then ‘(Full)’ end || ‘ ‘ || name d, id r from eba_proj_roles order by
default_acl_status_level, upper(name) |
| ROLES W/O ACL | Dynamic |
| select name d, id r
from eba_proj_roles order by default_acl_status_level, upper(name) |
| SEARCH ATTRIBUTE LOV | Static |
| SELECT PROJECT | Dynamic |
| select d, r from (
select ltrim(replace(SYS_CONNECT_BY_PATH(project, ‘:TREESEP:’), ‘:TREESEP:’,’
/ ‘), ‘/ ‘) d, id r from eba_proj_status start with parent_project_id is null
connect by prior id = parent_project_id order siblings by project ) union all
select ps.project d, ps.id r from eba_proj_status ps where
ps.parent_project_id is not null and not exists ( select null from
eba_proj_status p2 where p2.id = ps.parent_project_id ); |
| SELECT PROJECT NAME RETURNING ID SORTED | Dynamic |
| select project, id
from eba_proj_status order by 1 |
| SELECT PROJECT (WITHOUT PARENT) | Dynamic |
| select PROJECT d,
id r from eba_proj_status s order by 1 |
| SHOW ALL OPEN | Static |
| SHOW PROJECT VIEWS CHECKBOX | Static |
| STATUS CODES | Dynamic |
| select
STATUS_short_desc display_value, ID return_value from EBA_PROJ_STATUS_CODES
where is_active_yn = ‘Y’ and status_short_desc is not null order by
display_sequence |
| STATUS CODES WITH COUNTS | Dynamic |
| select
display_value, return_value from ( select STATUS_short_desc || ‘
(‘||count(*)||’)’ display_value, sc.ID return_value , sc.display_sequence
from EBA_PROJ_STATUS_CODES sc, eba_proj_status s where is_active_yn = ‘Y’ and
status_short_desc is not null and s.project_status = sc.id group by
sc.STATUS_short_desc, sc.id, sc. display_sequence order by 3,1 ) x |
| STATUS REPORT SUBMITTER | Dynamic |
| select
distinct case when instr(u.update_owner,’@’) > 0 then case when instr(
replace( substr( u.update_owner, 1, instr(u.update_owner,’@’ ) – 1), ‘.’, ‘ ‘
), ‘ ‘, 1, 2 ) > 0 then substr( replace( substr( initcap(u.update_owner),
1, instr(initcap(u.update_owner),’@’ ) – 1), ‘.’, ‘ ‘ ), 1, instr( replace(
substr( initcap(u.update_owner), 1, instr(initcap(u.update_owner),’@’ ) – 1),
‘.’, ‘ ‘ ), ‘ ‘, 1, 1 ) ) || substr( replace( substr(
initcap(u.update_owner), 1, instr(initcap(u.update_owner),’@’ ) – 1), ‘.’, ‘
‘ ), instr( replace( substr( initcap(u.update_owner), 1,
instr(initcap(u.update_owner),’@’ ) – 1), ‘.’, ‘ ‘ ), ‘ ‘, 1, 2 ) ) else
replace( substr( initcap(u.update_owner), 1,
instr(initcap(u.update_owner),’@’ ) – 1), ‘.’, ‘ ‘ ) end else lower(u.update_owner)
end d, lower(u.update_owner) r from EBA_PROJ_STATUS_RPTS u, EBA_PROJ_STATUS p
where p.id = u.project_id order by 1 |
| STATUS REPORTS SORT ORDER | Static |
| STATUS RPTS EDITABLE BY | Static |
| STATUS RPTS VIEWABLE BY | Static |
| SUMMARY_OR_STATUS | Static |
| TAG RULE | Static |
| TAG SEARCH COMPONENTS LOG | Static |
| THEME STYLES | Dynamic |
| select s.name d,
s.theme_style_id r from apex_application_theme_styles s,
apex_application_themes t where s.application_id = t.application_id and
s.theme_number = t.theme_number and s.application_id = :app_id and
t.ui_type_name = ‘DESKTOP’ and t.is_current = ‘Yes’ order by 1 |
| TIMEFRAME – LONGER | Static |
| TIMEFRAME (4 WEEKS) | Dynamic |
| select
wwv_flow_lang.system_message(‘N_MINUTES’,’15’) d,
trim(to_char(15/(24*60),’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t
from dual union all select wwv_flow_lang.system_message(‘N_MINUTES’,’30’) d,
trim(to_char(30/(24*60),’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t
from dual union all select wwv_flow_lang.system_message(‘N_HOUR’,’1′) d,
trim(to_char(1/24,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_MINUTES’,’90’) d,
trim(to_char(90/(24*60),’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t
from dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’2′) d,
trim(to_char(1/12,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’3′) d,
trim(to_char(3/24,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’4′) d,
trim(to_char(4/24,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’5′) d,
trim(to_char(5/24,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’6′) d,
trim(to_char(6/24,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’8′) d,
trim(to_char(8/24,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’10’) d,
trim(to_char(10/24,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’12’) d,
trim(to_char(12/24,’00000.99999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_HOURS’,’16’) d,
trim(to_char(16/24,’00000.9999999999′,’NLS_NUMERIC_CHARACTERS=».,»’)) t from
dual union all select wwv_flow_lang.system_message(‘N_DAY’,’1′) d,
trim(to_char(1,’00000.9999999999′)) t from dual union all select
wwv_flow_lang.system_message(‘N_DAYS’,’2′) d,
trim(to_char(2,’00000.9999999999′)) t from dual union all select
wwv_flow_lang.system_message(‘N_DAYS’,’3′) d,
trim(to_char(3,’00000.9999999999′)) t from dual union all select
wwv_flow_lang.system_message(‘N_DAYS’,’4′) d,
trim(to_char(4,’00000.9999999999′)) t from dual union all select
wwv_flow_lang.system_message(‘N_DAYS’,’5′) d,
trim(to_char(5,’00000.9999999999′)) t from dual union all select
wwv_flow_lang.system_message(‘N_WEEK’,’1′) d, trim(to_char(7,’00000.9999999999′))
t from dual union all select wwv_flow_lang.system_message(‘N_WEEKS’,’2′) d,
trim(to_char(14,’00000.9999999999′)) t from dual union all select
wwv_flow_lang.system_message(‘N_WEEKS’,’3′) d,
trim(to_char(21,’00000.9999999999′)) t from dual union all select
wwv_flow_lang.system_message(‘N_WEEKS’,’4′) d,
trim(to_char(28,’00000.9999999999′)) t from dual order by 2 |
| TIMEZONES | Dynamic |
| select distinct
tzname d, tzname r from V$TIMEZONE_NAMES order by 1 |
| UPDATE TYPES | Dynamic |
| select
status_update_type d, id r from EBA_PROJ_STATUS_UPDATE_TYPES where
is_active_yn = ‘Y’ order by display_sequence |
| UPDATE TYPES (ALL) | Dynamic |
| select
status_update_type||decode(is_active_yn,’Y’,»,’ (Inactive)’) d, id r from
EBA_PROJ_STATUS_UPDATE_TYPES order by is_active_yn desc, display_sequence |
| UPDATED SINCE | Static |
| USER_EMAILS | Dynamic |
| select case when
instr(u.username,’@’) > 0 then lower(u.username) else
lower(u.email_address) end d, case when instr(u.username,’@’) > 0 then
lower(u.username) else lower(u.email_address) end r from
eba_proj_status_users u order by lower(u.username) |
| USERNAME_FORMAT | Static |
| USERS | Dynamic |
| select u.username
d, u.id r from eba_proj_status_users u order by upper(u.username) |
| USERS WITH PAST DUE DELIVERABLES | Dynamic |
| select
distinct lower(x.owner) d, lower(x.owner) r from ( select action_owner_01
owner from eba_proj_status_ais where owner_role_id is null union all select
action_owner_02 owner from eba_proj_status_ais where owner_role_id is null
union all select action_owner_03 owner from eba_proj_status_ais where
owner_role_id is null union all select action_owner_04 owner from
eba_proj_status_ais where owner_role_id is null union all select u.username
owner from eba_proj_status_users u where exists ( select null from
eba_proj_status_ais a, eba_proj_user_ref rf where rf.role_id =
a.owner_role_id and rf.project_id = a.project_id and rf.user_id = u.id ) ) x
where x.owner is not null and exists (select null from eba_proj_status_ais$
a, eba_proj_status$ p, eba_proj_status_codes s where p.id = a.project_id and
p.project_status = s.id (+) and p.is_deleted_yn = ‘N’ and a.action_status =
‘Open’ and a.due_date < sysdate and ( a.action_owner_01 = x.owner or
a.action_owner_02 = x.owner or a.action_owner_03 = x.owner or a.action_owner_04
= x.owner or exists ( select null from eba_proj_user_ref rf,
eba_proj_status_users u where rf.role_id = a.owner_role_id and rf.project_id
= a.project_id and rf.user_id = u.id and u.username = x.owner ) ) union all
select null from eba_proj_status_ms$ m, eba_proj_status$ p,
eba_proj_status_codes s where p.id = m.project_id and p.project_status = s.id
(+) and m.milestone_status = ‘Open’ and m.milestone_date < sysdate and
p.is_deleted_yn = ‘N’ and ( m.milestone_owner = x.owner or exists ( select
null from eba_proj_user_ref rf, eba_proj_status_users u where rf.role_id =
m.owner_role_id and rf.project_id = m.project_id and rf.user_id = u.id and
u.username = x.owner ) ) ) order by 1 |
| USERS WITH UPCOMING DELIVERABLES | Dynamic |
| select
distinct lower(x.owner) d, lower(x.owner) r from ( select action_owner_01
owner from eba_proj_status_ais where owner_role_id is null union all select
action_owner_02 owner from eba_proj_status_ais where owner_role_id is null
union all select action_owner_03 owner from eba_proj_status_ais where
owner_role_id is null union all select action_owner_04 owner from
eba_proj_status_ais where owner_role_id is null union all select u.username
owner from eba_proj_status_users u where exists ( select null from
eba_proj_status_ais a, eba_proj_user_ref rf where rf.role_id =
a.owner_role_id and rf.project_id = a.project_id and rf.user_id = u.id ) and
nvl(u.upcoming_reminders_freq, ‘NEVER’) != ‘NEVER’ ) x where x.owner is not
null and exists (select null from eba_proj_status_ais$ a, eba_proj_status$ p,
eba_proj_status_codes s where p.id = a.project_id and p.project_status = s.id
(+) and p.is_deleted_yn = ‘N’ and a.action_status = ‘Open’ and a.due_date
between sysdate and sysdate + 7 and ( a.action_owner_01 = x.owner or
a.action_owner_02 = x.owner or a.action_owner_03 = x.owner or
a.action_owner_04 = x.owner or exists ( select null from eba_proj_user_ref
rf, eba_proj_status_users u where rf.role_id = a.owner_role_id and
rf.project_id = a.project_id and rf.user_id = u.id and u.username = x.owner )
) union all select null from eba_proj_status_ms$ m, eba_proj_status$ p,
eba_proj_status_codes s where p.id = m.project_id and p.project_status = s.id
(+) and m.milestone_status = ‘Open’ and m.milestone_date between sysdate and
sysdate + 7 and p.is_deleted_yn = ‘N’ and ( m.milestone_owner = x.owner or
exists ( select null from eba_proj_user_ref rf, eba_proj_status_users u where
rf.role_id = m.owner_role_id and rf.project_id = m.project_id and rf.user_id
= u.id and u.username = x.owner ) ) ) order by 1 |
| WIZ_FLEX_COLUMNS | Dynamic |
| with cols as (
select flexible_column, case when flexible_column like ‘%FLEX_N%’ then
‘Number’ when flexible_column like ‘%FLEX_D%’ then ‘Date’ when
flexible_column like ‘%FLEX_CLOB’ then ‘Large Text’ else ‘Text’ end as
col_type from eba_proj_flex_registry where flexible_table = :P143_FLEX_TABLE
and assigned_yn = ‘N’ ) select col_type as dv, min( flexible_column ) as rv
from cols group by col_type order by col_type |
| YEAR_FORMAT | Static |
| YES NO RETURNS Y N | Static |
