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