Oracle Ebs-sql (INV-11): Check sub-inventory accounting information. SQL

Source: Internet
Author: User

Select
Ood.organization_code Inventory Organization Code,
Ood.organization_name Inventory organization name,
MSV. Secondary_inventory_name Sub-Inventory,
MSV. Subinventory_type type,--1 = storage 2 = Receive
MSV. DESCRIPTION description,
MSV. Disable_date Invalid date,
MSV. Inventory_atp_code is included in the ATP,
MSV. Availability_type can be net calculated,
MSV. Reservable_type Allow retention,
MSV. Picking_order Pick a library list,
MSV. Locator_type Shelf Control,
MSV. quantity_tracked Trace Quantity,
MSV. Asset_inventory Asset Sub-inventory,
MSV. Source_type type of source tonic,
MSV. Depreciable_flag accrued Depreciation,
MSV. Status_code State,
MSV. Default_loc_status_code default Shelf state,
MSV. Default_cost_group_name default cost group,
MSV. Dropping_order unloading order,
MSV. Planning_level enable par layer planning,
MSV. Default_count_type_code,
K1. Concatenated_segments material,
Apps.cux_get_gl_code_name (K1. CODE_COMBINATION_ID) Material description,
K2. Concatenated_segments Material indirect costs,
Apps.cux_get_gl_code_name (K2. CODE_COMBINATION_ID) Material Indirect cost description,
K3. Concatenated_segments Resources,
Apps.cux_get_gl_code_name (K3. CODE_COMBINATION_ID) Resource Description,
K4. Concatenated_segments manufacturing costs,
Apps.cux_get_gl_code_name (K4. CODE_COMBINATION_ID) manufacturing cost description,
K5. Concatenated_segments Cost of External association,
Apps.cux_get_gl_code_name (K5. CODE_COMBINATION_ID) Outsourcing fee Description,
K6. Concatenated_segments Reserve Money,
Apps.cux_get_gl_code_name (K6. code_combination_id) encumbrance Description,
K7. Concatenated_segments Fee,
Apps.cux_get_gl_code_name (K7. CODE_COMBINATION_ID) Cost Description
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

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.