Oracle Seeker, Oracle探索者

CREATE OR REPLACE VIEW HX_DBI_PROJECTS_LOV_V AS
SELECT project_id id, NAME || '(' || segment1 || ')' VALUE
  FROM pa_projects
 ORDER BY segment1;
 
CREATE OR REPLACE VIEW hx_dbi_org_lov_v
AS
SELECT organization_id ID, NAME VALUE
  FROM pa_organizations_v
 ORDER BY NAME;
 
CREATE OR REPLACE VIEW hx_dbi_proj_type_v
AS
select project_type ID, DESCRIPTION VALUE
  from pa.pa_project_types_all t ;
 
CREATE OR REPLACE VIEW hx_dbi_proj_stat_v
AS
select project_status_code ID, project_status_name VALUE
 from pa.pa_project_statuses t ;
 
CREATE OR REPLACE VIEW hx_tasks_v
AS
SELECT pt.project_id,
       pt.task_id,
       pp.segment1 project_number,
       pp.NAME project_name,
       pt.task_number,
       pt.task_name,
       pt.long_task_name,
       pt.description
  FROM pa_projects_all pp, pa_tasks pt
 WHERE pp.project_id = pt.project_id ;