PA模块常用表

SELECT  *  FROM  pa_projects_all;  --项目

SELECT  *  FROM  pa_project_types;  --项目类型

SELECT  *  FROM  pa_project_statuses;  --项目状态

SELECT  *  FROM  pa_project_options;  --项目选项

SELECT  *  FROM  pa_lookups l  WHERE  l.lookup_type =  'PA_OPTIONS'  ;

SELECT  *  FROM  pa_project_customers;  --项目客户

SELECT  h.name

   FROM  pa_project_set_lines l, pa_project_sets_vl h

   WHERE  l.project_set_id = h.project_set_id

    AND  l.project_id =  155242  ;  --项目集

--项目预算

SELECT  t. budget_type, l.project_id, l.*, t.*

   FROM  pa_budget_versions l, pa_budget_types t

   WHERE  l.budget_type_code = t.budget_type_code

    AND  l.budget_status_code =  'W'  ;  --活动

--预算状态

SELECT  *  FROM  pa_lookups l  WHERE  l.lookup_type =  'BUDGET STATUS'  ;

--项目角色（经理）

SELECT  *  FROM  pa_project_role_types_vl;

SELECT  l.resource_source_id, he.full_name

   FROM  pa_project_parties l, pa_project_role_types_b t, hr_employees he

   WHERE  l.project_role_id = t.project_role_id

    AND  t.project_role_type =  'PROJECT MANAGER'

    AND  l.resource_source_id = he.employee_id

    AND  l.object_id =  155242  ;

SELECT  *  FROM  pa_role_controls;

--人员默认账户

SELECT  l.default_code_comb_id

-- INTO v_code_comb_id

   FROM  per_all_assignments_f l

   WHERE  l.person_id =  10995

    AND  l.effective_start_date <=  SYSDATE

    AND   nvl  (l.effective_end_date,  SYSDATE  +  1 ) >=  SYSDATE  ；

  

   ;

转载于:https://www.cnblogs.com/wanghang/p/6299243.html