EBS: COST 资源

成本>>设置>>子要素>>资源

以下代码所有有APPS权限。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
-- N: BOM>>BILL>>工艺路线>>资源
-- N: 成本>>设置>>子要素>>资源 
SELECT OOD.ORGANIZATION_ID AS 组织ID,
       OOD.ORGANIZATION_CODE AS "ORG_CODE",
         OOD.ORGANIZATION_NAME AS "组织名",
         BR.RESOURCE_ID AS 资源ID,
         BR.RESOURCE_CODE AS 资源,
         BR.DESCRIPTION AS 说明,
         BR.DISABLE_DATE 失效日期,
         BR.RESOURCE_TYPE AS "类型ID",
         DECODE(BR.RESOURCE_TYPE,'1','设备','2','人员','4','杂项','5','金额','6','币种',BR.RESOURCE_TYPE) AS "类型",
         BR.UNIT_OF_MEASURE AS "单位",
         BR.AUTOCHARGE_TYPE AS "计费类型ID",
         DECODE(BR.AUTOCHARGE_TYPE,'1','WIP 移动','2','人工','3','PO 接收','4','PO 移动',
         BR.AUTOCHARGE_TYPE) AS "计费类型",
         DECODE(BR.DEFAULT_BASIS_TYPE,'1','物料','3','批次',BR.DEFAULT_BASIS_TYPE) AS "基准",
         BR.COST_ELEMENT_ID AS 要素ID,
         CCE.COST_ELEMENT AS "要素",
         PURCHASE_ITEM_ID AS 外协加工物料ID,
         (SELECT SEGMENT1 FROM INV.MTL_SYSTEM_ITEMS_B MSI
           WHERE MSI.INVENTORY_ITEM_ID =BR.PURCHASE_ITEM_ID
           AND MSI.ORGANIZATION_ID= BR.organization_id
           AND ROWNUM =1)  AS "外协加工物料",
         (SELECT MSI.DESCRIPTION FROM INV.MTL_SYSTEM_ITEMS_B MSI
           WHERE MSI.INVENTORY_ITEM_ID =BR.PURCHASE_ITEM_ID
           AND MSI.ORGANIZATION_ID= BR.organization_id
           AND ROWNUM =1)  AS "外协加工物料描述",
         br.absorption_account 吸收帐户ID,
         apps.fnd_flex_ext.get_segs('SQLGL','GL#',50350, br.absorption_account) AS 吸收帐户,
         APPS.xla_oa_functions_pkg.get_ccid_description(50350, br.absorption_account) AS 吸收帐户描述,
         br.rate_variance_account 差异帐户ID,
         apps.fnd_flex_ext.get_segs('SQLGL','GL#',50350, br.rate_variance_account) AS 差异帐户,
         APPS.xla_oa_functions_pkg.get_ccid_description(50350, br.rate_variance_account) AS 差异帐户描述
        -- BR.*
 FROM APPS.BOM_RESOURCES_V BR,
   APPS.ORG_ORGANIZATION_DEFINITIONS OOD,
   BOM.CST_COST_ELEMENTS CCE
 WHERE BR.ORGANIZATION_ID = OOD.ORGANIZATION_ID
--  AND OOD.ORGANIZATION_CODE IN (401,402)
  AND BR.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID
  AND BR.COST_ELEMENT_ID IN (3,4) -- 5:制造费用, 1:物料  
  AND CCE.COST_ELEMENT IN ('资源','外协加工')
 ORDER BY   OOD.ORGANIZATION_CODE, BR.RESOURCE_CODE
    

  

posted @   samrv  阅读(86)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示