CAC Item Master Accounts Setup
Description
Categories: Enginatics
Repository: Github
Repository: Github
Report to show item master accounts and related information by item.
/* +=============================================================================+
-- | Copyright 2011 - 2022 Douglas Volz Consulting, Inc. |
-- | All rights reserved. |
-- | Permission to use this code is granted provided the original ... more
/* +=============================================================================+
-- | Copyright 2011 - 2022 Douglas Volz Consulting, Inc. |
-- | All rights reserved. |
-- | Permission to use this code is granted provided the original ... more
Run
CAC Item Master Accounts Setup and other Oracle EBS reports with Blitz Report™ on our demo environment
select gl.name ledger, haouv.name operating_unit, msiv.organization_code, msiv.segment1 item_number, msiv.description item_description, msiv.primary_uom_code uom_code, &category_columns misv.inventory_item_status_code_tl item_status, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, xxen_util.meaning(msiv.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_or_buy, xxen_util.meaning(msiv.costing_enabled_flag,'YES_NO',0) allow_costs, xxen_util.meaning(cic.inventory_asset_flag,'SYS_YES_NO',700) inventory_asset, xxen_util.meaning(cic.based_on_rollup_flag,'SYS_YES_NO',700) based_on_cost_rollup, cic.shrinkage_rate, cct.cost_type, gl.currency_code, cic.item_cost, &segment_columns xxen_util.user_name(msiv.created_by) item_created_by, xxen_util.client_time(msiv.creation_date) item_creation_date, xxen_util.user_name(msiv.last_updated_by) item_last_updated_by, xxen_util.client_time(msiv.last_update_date) item_last_update_date from gl_ledgers gl, org_organization_definitions ood, hr_all_organization_units_vl haouv, ( select mp.organization_code, mp.primary_cost_method, msiv.* from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_id<>mp.master_organization_id and mp.organization_id=msiv.organization_id ) msiv, mtl_item_status_vl misv, cst_item_costs cic, cst_cost_types cct, gl_code_combinations gcc1, gl_code_combinations gcc2, gl_code_combinations gcc3 where 1=1 and gl.ledger_id=ood.set_of_books_id and ood.organization_id=msiv.organization_id and msiv.inventory_item_status_code=misv.inventory_item_status_code(+) and msiv.organization_id=cic.organization_id(+) and msiv.inventory_item_id=cic.inventory_item_id(+) and decode(msiv.costing_enabled_flag,'Y',msiv.primary_cost_method)=cic.cost_type_id(+) and decode(msiv.costing_enabled_flag,'Y',msiv.primary_cost_method)=cct.cost_type_id(+) and ood.operating_unit=haouv.organization_id and msiv.cost_of_sales_account=gcc1.code_combination_id(+) and msiv.sales_account=gcc2.code_combination_id(+) and msiv.expense_account=gcc3.code_combination_id(+) order by 1,2,3,4,5 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Category Set 1 |
|
LOV | |
Category Set 2 |
|
LOV | |
Item |
|
LOV | |
Include Non-Costed Items |
|
LOV Oracle | |
Organization Code |
|
LOV | |
Operating Unit |
|
LOV | |
Ledger |
|
LOV |