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

浏览数：44 / 时间：2015年06月12日

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,