Oracle EBS-SQL (INV-11):检查子库存会计信息.sql

select
       
 OOD.ORGANIZATION_CODE                                               库存组织代码,
       
 OOD.ORGANIZATION_NAME                                              
库存组织名称,
       
 MSV.SECONDARY_INVENTORY_NAME                                         
子库存,
        
MSV.SUBINVENTORY_TYPE                                                          
 类型,--1 = 储存 2 = 接收
        
MSV.DESCRIPTION                                                                       
描述,
        
MSV.DISABLE_DATE                                                                无效日期,
   
    
MSV.INVENTORY_ATP_CODE                                              
包括在ATP中,
   
     MSV.AVAILABILITY_TYPE                                                         
可净计算,
   
     MSV.RESERVABLE_TYPE                                                          
允许保留,
   
     MSV.PICKING_ORDER                                                                
挑库单,
   
     MSV.LOCATOR_TYPE                                                               
货位控制,
   
     MSV.QUANTITY_TRACKED                                                      
 跟踪数量,
   
     MSV.ASSET_INVENTORY                                                       资产子库存,
   
     MSV.SOURCE_TYPE                                                           
来源补兖类型,
   
     MSV.DEPRECIABLE_FLAG                                                        
应计折旧,
   
     MSV.STATUS_CODE                                                                     
状态,
   
     MSV.DEFAULT_LOC_STATUS_CODE                                   
默认货位状态,
   
     MSV.DEFAULT_COST_GROUP_NAME                                      默认成本组,
   
     MSV.DROPPING_ORDER                                                            
卸货单,
   
     MSV.PLANNING_LEVEL                                                   
启用PAR层计划,
   
     MSV.DEFAULT_COUNT_TYPE_CODE,
   
     K1.CONCATENATED_SEGMENTS                                                   
 材料,
   
     apps.cux_get_gl_code_name(K1.CODE_COMBINATION_ID)       
材料描述,
   
     K2.CONCATENATED_SEGMENTS                                         
材料间接费用,
   
     apps.cux_get_gl_code_name(K2.CODE_COMBINATION_ID)
材料间接费用描述,
   
     K3.CONCATENATED_SEGMENTS                                                    
资源,
   
     apps.cux_get_gl_code_name(K3.CODE_COMBINATION_ID)       
资源描述,
   
     K4.CONCATENATED_SEGMENTS                                               
制造费用,
   
     apps.cux_get_gl_code_name(K4.CODE_COMBINATION_ID) 
 制造费用描述,
   
     K5.CONCATENATED_SEGMENTS                                               
外协费用,
   
     apps.cux_get_gl_code_name(K5.CODE_COMBINATION_ID) 
 外协费用描述,
   
     K6.CONCATENATED_SEGMENTS                                                  
保留款,
   
     apps.cux_get_gl_code_name(K6.CODE_COMBINATION_ID)     
保留款描述,
   
     K7.CONCATENATED_SEGMENTS                                                     
费用,
   
     apps.cux_get_gl_code_name(K7.CODE_COMBINATION_ID)         费用描述
from

        
apps.GL_CODE_COMBINATIONS_KFV
K7, 
         apps.GL_CODE_COMBINATIONS_KFV
K6,
        
apps.GL_CODE_COMBINATIONS_KFV K5,

        
apps.GL_CODE_COMBINATIONS_KFV K4,

        
apps.GL_CODE_COMBINATIONS_KFV K3,

        
apps.GL_CODE_COMBINATIONS_KFV K2,

        
apps.GL_CODE_COMBINATIONS_KFV
K1, 
        
ORG_ORGANIZATION_DEFINITIONS OOD,
       
 MTL_SECONDARY_INVENTORIES_FK_V 
MSV
WHERE 
            MSV.ORGANIZATION_ID
= X
    AND NVL(MSV.DISABLE_DATE,SYSDATE + 1) >
SYSDATE
    AND MSV.ORGANIZATION_ID =
OOD.ORGANIZATION_ID
    AND MSV.MATERIAL_ACCOUNT =
K1.CODE_COMBINATION_ID(+)
    AND
MSV.MATERIAL_OVERHEAD_ACCOUNT = K2.CODE_COMBINATION_ID(+)
   
AND MSV.RESOURCE_ACCOUNT = K3.CODE_COMBINATION_ID(+)
    AND
MSV.OVERHEAD_ACCOUNT = K4.CODE_COMBINATION_ID(+)
    AND
MSV.OUTSIDE_PROCESSING_ACCOUNT = K5.CODE_COMBINATION_ID(+)
   
AND MSV.ENCUMBRANCE_ACCOUNT = K6.CODE_COMBINATION_ID(+)
   
AND MSV.EXPENSE_ACCOUNT = K7.CODE_COMBINATION_ID(+)
ORDER BY
MSV.ORGANIZATION_ID,

MSV.SECONDARY_INVENTORY_NAME ASC

Oracle EBS-SQL (INV-11):检查子库存会计信息.sql,布布扣,bubuko.com

时间: 06-11

Oracle EBS-SQL (INV-11):检查子库存会计信息.sql的相关文章

Oracle EBS-SQL (INV-3):检查仓库库存价值明细.sql

SELECT      a.subinventory_code                                 子库代码     ,d.DESCRIPTION                                        子库描述     ,b.segment1                                              物料编码     ,b.description                                  

Oracle EBS-SQL (INV-10):检查库存接口.sql

/*检查库存接口表*/ select msi.segment1                            项目编码, msi.description                          项目说明, msi.organization_id                 项目组织号, a.organization_id               事物处理组织号, a.transaction_quantity           事物处理数量, a.source_code

Oracle EBS-SQL (BOM-14):检查工艺路线明细.sql

select msi.segment1                                         装配件编码,       msi.description                                        装配件描述,       bos.operation_seq_num                                    序号,       bso.operation_code                        

Oracle EBS-SQL (BOM-9):检查系统BOM总数.sql

SELECT      ITM.SEGMENT1                         物料编码     ,ITM.DESCRIPTION                     物料描述     ,bom2.CREATION_DATE              创建日期     ,BOM2.ALTERNATE_BOM_DESIGNATOR  替代BOM     ,FU.description                           操作者FROM INV.MTL_SYST

Oracle EBS-SQL (OM-3):销售连接停靠站时冲减库存出错处理.sql

DELETE FROM INV.MTL_RESERVATIONS MRWHERE EXISTS (SELECT 1 FROM WSH.WSH_DELIVERY_ASSIGNMENTS WDA                            ,WSH.WSH_DELIVERY_DETAILS    WDD                 WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID                     AND

windows环境下安装连接远程oracle工具PL/SQL Developer 11.0

官网下载所需的3个软件包(为了连接11g数据库) 1:oracle client(oracle客户端) http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/112010-win64soft-086667-zhs.html 下载win64_11gR2_client.zip具体安装方法可参考百度 2:PL/SQL Developer 11.0 http://files.allroundautomatio

Oracle EBS-SQL (OM-5):检查订单事务处理类型.sql

SELECT            HO.NAME OU                                                                           名称,           t.NAME                                                                   订单事务处理类型,           t.DESCRIPTION                           

Oracle EBS OM RMA销售退货异常处理(Datafix)

系统版本: RDBMS : 9.2.0.6.0 Oracle 应用产品 : 11.5.10.2 问题症状:       1.通过物料事务处理查看销售订单行退货记录显示已经入库为40: 2.销售退货订单行已经接收入库.但是,订单行状态仍然是"等待退货",发运数量为空: 3.销售退货仍然能做RMA接收40数量.但是,查看接收事务处理记录显示已经接收入库了: 4.AR接口行和AR事务处理没有找到对应销售退货订单行的记录: 5.销售退货订单行工作流报错: EBS群下的朋友说要Datafix.但

Oracle EBS WMS功能介绍(二)

(版权声明,本人原创或者翻译的文章如需转载,如转载用于个人学习,请注明出处:否则请与本人联系,违者必究) 出货物流逻辑主要包括 1.      打包,可以进行多层嵌套式的打包,并通知用户为订单所做的特殊打包方法.打包可以在拣货时做,也可以作为一个独立的操作来做. 2.      为行程进行码头预约,可以使仓库经理计划出库运输公司的预约,码头门的可用性和仓库内的待装区的使用. 3.      拣货方法,为不同订单的拣货需要选择不同的拣货方法. 4.      管理拣货,可以使订单基于移动手持应用拣