Oracle EBS 成本请求报错

最新推荐文章于 2024-12-29 17:40:42 发布

Jenrry30

最新推荐文章于 2024-12-29 17:40:42 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： CST

本文链接：https://blog.youkuaiyun.com/JenrryMath/article/details/84374618

-- step1 根据参数查找 是否有死循环的数据
SELECT *
  FROM cst_pac_quantity_layers cpql
 WHERE pac_period_id = 13013 --pac_period_id
   AND cost_group_id = 1201 --cost_group_id
   AND NOT EXISTS
 (SELECT 1
          FROM cst_pac_item_costs cpic
         WHERE cpic.cost_layer_id = cpql.cost_layer_id
           AND pac_period_id = cpql.pac_period_id
           AND cost_group_id = cpql.cost_group_id
           AND inventory_item_id = cpql.inventory_item_id);

-- step2 备份如下表的数据
-- 注意 表后面加日期 不重名

  CREATE TABLE CPQL_BKP_180607 AS
  SELECT * FROM CST_PAC_QUANTITY_LAYERS
  WHERE PAC_PERIOD_ID = 13013 --pac_period_id
    AND COST_GROUP_ID = 1201 --cost_group_id
    ;


   CREATE TABLE CPICD_BKP_180607 AS
   SELECT * FROM  CST_PAC_ITEM_COST_DETAILS
   WHERE COST_LAYER_ID IN (SELECT COST_LAYER_ID
                           FROM CST_PAC_ITEM_COSTS
                           WHERE PAC_PERIOD_ID = 13013 --pac_period_id