Mostrar las listas de valores
SELECT list_of_values_name
,lov_type
, list_of_values_query
, lov_entries
FROM apex_application_lovs
WHERE application_id = :application_id
ORDER BY 1,2,3
| 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 |
| 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 | – |