EBS 库存估价配置科目查询SQL

wx_liuliuliu

于 2024-10-24 10:22:19 发布

阅读量158

点赞数 1

CC 4.0 BY-SA版权

分类专栏： EBS日常运维小记 EBS 查询脚本 EBS 财务文章标签： 1024程序员节 oracle 数据库运维

本文链接：https://blog.youkuaiyun.com/aLicE_Fail/article/details/143202065

EBS日常运维小记同时被 3 个专栏收录

4 篇文章

订阅专栏

EBS 财务

4 篇文章

订阅专栏

EBS 查询脚本

2 篇文章

订阅专栏

--获取组织
SELECT mp.organization_code,
       oo.organization_name,
       gcc.segment3,
       gcc.concatenated_segments,
       mp.material_account,
       mp.material_overhead_account,
       mp.overhead_account,
       mp.outside_processing_account,
       mp.resource_account,
       mp.creation_date
FROM   apps.mtl_parameters               mp,
       apps.org_organization_definitions oo,
       apps.gl_code_combinations_kfv     gcc
WHERE  1 = 1
AND    mp.organization_id = oo.organization_id
AND    mp.material_account = gcc.code_combination_id;

--获取子库 
SELECT oo.organization_code,
       oo.organization_name,
       mp.secondary_inventory_name,
       gcc.segment3,
       gcc.concatenated_segments,
       mp.material_account,
       mp.material_overhead_account,
       mp.overhead_account,
       mp.outside_processing_account,
       mp.resource_account,
       mp.creation_date
FROM   apps.mtl_secondary_inventories    mp,
       apps.org_organization_definitions oo,
       apps.gl_code_combinations_kfv     gcc
WHERE  1 = 1
AND    mp.organization_id = oo.organization_id
AND    mp.material_account = gcc.code_combination_id;

--获取成本组上的库存科目,成本组优先级最高

SELECT le.name                       分类帐,
       oo.organization_code          库存组织,
       oo.organization_name          库存组织名称,
       cg.cost_group                 成本组,
       gcc.segment3                  科目段,
       gcc.concatenated_segments     科目组合,
       cg.creation_date              创建时间,
       cg.last_update_date           更新时间,
       ga.material_account,
       ga.material_overhead_account,
       ga.overhead_account,
       ga.outside_processing_account,
       ga.resource_account
FROM   apps.cst_cost_groups              cg,
       apps.org_organization_definitions oo,
       apps.cst_cost_group_accounts      ga,
       apps.gl_code_combinations_kfv     gcc,
       gl_ledgers                        le
WHERE  1 = 1
AND    oo.set_of_books_id = le.ledger_id
AND    cg.cost_group_id = ga.cost_group_id
AND    cg.organization_id = oo.organization_id
AND    ga.material_account = gcc.code_combination_id;