PA 模块常用表2
来源:互联网 发布:用友t3恢复数据在哪里 编辑:程序博客网 时间:2024/05/24 07:21
SELECT * FROM pa_expenditure_items_all 项目支出
select *from pa_cost_distribution_lines_all 支出分配行
SELECT l.project_id, h.project_set_id, h.name, l.project_set_id
FROM pa_project_set_lines l, pa_project_sets_vl h
WHERE l.project_set_id = h.project_set_id; 项目集
SELECT *FROM PA_PROJECT_TYPES_ALL 项目类别
SELECT l.task_id, l.task_number, l.task_name, l.*
FROM pa_tasks l
WHERE l.project_id = 157223; --项目任务
SELECT l.task_name,
l.task_id,
l.resource_class_code, --资源类别
l.task_number,
l.resource_alias,
l.uom_code,
l.uom_description,
l.planned_cost, --计划成本
l.*
FROM pa_tasks_assigns_progress_v l
WHERE l.project_id = 157223
AND l.project_number = '1901140804'
AND l.task_id = 246877; --计划资源
SELECT *FROM PA_RESOURCE_CLASSES_vl 资源类型
--取当前核准有用的收入预算版本
SELECT l.project_id,
l.fin_plan_type_id,
l.budget_version_id, --
l.version_number, --版本号
l.budget_status_code, --状态 B 核准, W 活动
l.current_flag, --当前
l.*
FROM pa_budget_versions l
WHERE l.project_id = 162229
AND l.current_flag = 'Y' --当前的
AND l.budget_status_code = 'B';
--取当前核准有用的收入预算金额
SELECT SUM(decode(bv.version_type,
'ORG_FORECAST',
nvl(revenue, 0),
nvl(bv.total_project_revenue, 0))) +
SUM(nvl(bv.total_tp_revenue_in, 0)) +
SUM(nvl(bv.total_borrowed_revenue, 0)) +
SUM(nvl(bv.total_revenue_adj, 0)) -
SUM(nvl(bv.total_tp_revenue_out, 0)) sss
FROM pa_fin_plan_types_vl pt,
pa_budget_versions bv,
pa_proj_fp_options pfo
WHERE pfo.project_id = bv.project_id(+)
AND pfo.fin_plan_type_id = bv.fin_plan_type_id(+)
AND pfo.fin_plan_type_id = pt.fin_plan_type_id
AND pt.plan_class_code IN ('BUDGET', 'FORECAST')
AND pfo.fin_plan_option_level_code = 'PLAN_TYPE'
AND bv.ci_id IS NULL
AND bv.current_flag(+) = 'Y'
AND nvl(pt.use_for_workplan_flag, 'N') = 'N'
AND bv.fin_plan_type_id = 10020 --FBS预算
AND bv.project_id = 162229;
--计划类型
SELECT pt.fin_plan_type_id, pt.name, pt.description
FROM pa_fin_plan_types_vl pt
WHERE pt.plan_class_code IN ('BUDGET', 'FORECAST')
AND nvl(pt.use_for_workplan_flag, 'N') = 'N'; --FBS预算 10020
- PA 模块常用表2
- PA模块常用表
- pa
- zigbee 780M 无线模块 PA 放大
- sap pa认证培训(项目模块)
- SAP PS PA考试心得 (项目模块)
- SAP PS 项目模块 PA学习笔记——PLM200
- SAP PS 项目模块 PA学习笔记——PLM200
- 最新制作出CC1101+PA无线收发模块
- HR模块PA信息类型的建立以及增强
- MM模块常用表
- PS 模块常用表
- linux va 2 pa walk through
- PO模块常用表结构
- PO模块常用表结构
- BOM模块常用表结构
- PO模块常用表结构
- OE模块常用表结构
- 中病毒spoolsv.exe
- SQL Server日期时间格式转换…
- CollabNet Subversion Server 配置
- deque相关操作
- hdu1969
- PA 模块常用表2
- list相关操作
- C++/C试题(仅供参考!!!)
- android RelaLayout
- Iphone基础面试题
- Android:网络层通信的处理
- C语言之指针专题四:指针做函数参数
- const int *p与int * const p的区别
- cf264 div2E题 E. Caisa and Tree(dfs转化为有根树暴力求解)