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