Select
Msn. From_organization_code started the inventory organization,
Msn. From_organization_name Start inventory name,
Msn. To_organization_code End of inventory organization,
Msn. To_organization_name End inventory name,
Decode (MSN. intransit_type,1, ' direct ', 2, ' in transit ', ' unknown ') conversion type,
K1. Concatenated_segments Transfer Credit,
Apps.cux_get_gl_code_name (msn. Interorg_transfer_cr_account) Transfer Credit description,
K2. Concatenated_segments Purchase price difference,
Apps.cux_get_gl_code_name (msn. Interorg_price_var_account) Purchase Price Variance description,
K3. Concatenated_segments inter-organizational receivables,
Apps.cux_get_gl_code_name (msn. Interorg_receivables_account) Inter-organizational receivables description,
K4. Concatenated_segments Inter-organizational payables,
Apps.cux_get_gl_code_name (msn. Interorg_payables_account) Inter-organizational Payables description,
K5. Concatenated_segments in transit inventory,
Apps.cux_get_gl_code_name (msn. Intransit_inv_account) in-Transit inventory description,
K6. Concatenated_segments in-transit profits,
Apps.cux_get_gl_code_name (msn. Profit_in_inv_account) in-transit profit description
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