select
msn.FROM_ORGANIZATION_CODE 开始库存组织,
msn.FROM_ORGANIZATION_NAME 开始库存名称,
msn.TO_ORGANIZATION_CODE 结束库存组织,
msn.TO_ORGANIZATION_NAME 结束库存名称,
decode(msn.INTRANSIT_TYPE,1,'直接',2,'在途','未知') 转换类型,
k1.CONCATENATED_SEGMENTS 转帐贷项,
apps.cux_get_gl_code_name(msn.INTERORG_TRANSFER_CR_ACCOUNT) 转帐贷项描述,
k2.CONCATENATED_SEGMENTS 采购价格差异,
apps.cux_get_gl_code_name(msn.INTERORG_PRICE_VAR_ACCOUNT) 采购价格差异描述,
k3.CONCATENATED_SEGMENTS 组织间应收款,
apps.cux_get_gl_code_name(msn.INTERORG_RECEIVABLES_ACCOUNT) 组织间应收款描述,
k4.CONCATENATED_SEGMENTS 组织间应付款,
apps.cux_get_gl_code_name(msn.INTERORG_PAYABLES_ACCOUNT) 组织间应付款描述,
k5.CONCATENATED_SEGMENTS 在途库存,
apps.cux_get_gl_code_name(msn.INTRANSIT_INV_ACCOUNT) 在途库存描述,
k6.CONCATENATED_SEGMENTS 在途利润,
apps.cux_get_gl_code_name(msn.PROFIT_IN_INV_ACCOUNT) 在途利润描述
from
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,
MTL_SHIPPING_NETWORK_VIEW msn
where msn.INTERORG_TRANSFER_CR_ACCOUNT = k1.CODE_COMBINATION_ID(+)
and msn.INTERORG_PRICE_VAR_ACCOUNT = k2.CODE_COMBINATION_ID(+)
and msn.INTERORG_RECEIVABLES_ACCOUNT = k3.CODE_COMBINATION_ID(+)
and msn.INTERORG_PAYABLES_ACCOUNT = k4.CODE_COMBINATION_ID(+)
and msn.INTRANSIT_INV_ACCOUNT = k5.CODE_COMBINATION_ID(+)
and msn.PROFIT_IN_INV_ACCOUNT = k6.CODE_COMBINATION_ID(+)
-- and (msn.FROM_ORGANIZATION_CODE like 'W%' or msn.TO_ORGANIZATION_CODE like 'W%')
order by msn.FROM_ORGANIZATION_CODE