Oracle Ebs-sql (OM-4): Check the shipping network. SQL

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.