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 |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了