INV Subinventories
Description
Categories: Enginatics
Repository: Github
Repository: Github
Profile subinventory report with subinventory name, description, status, default cost group, type, restriction attributes, and general ledger account linkages. For BR100.
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
select mp.organization_code, haouv.name organization_name, msifv.secondary_inventory_name name, msifv.description, msifv.status_code status, msifv.default_cost_group_name default_cost_group, xxen_util.meaning(msifv.subinventory_type,'MTL_SUB_TYPES',700) subinventory_type, xxen_util.meaning(msifv.inventory_atp_code,'SYS_YES_NO',700) include_in_atp, xxen_util.meaning(msifv.reservable_type,'SYS_YES_NO',700) allow_reservation, xxen_util.meaning(msifv.availability_type,'SYS_YES_NO',700) nettable, xxen_util.meaning(msifv.quantity_tracked,'SYS_YES_NO',700) quantity_tracked, xxen_util.meaning(msifv.asset_inventory,'SYS_YES_NO',700) asset_subinventory, xxen_util.meaning(msifv.depreciable_flag,'SYS_YES_NO',700) depreciable, xxen_util.meaning(msifv.planning_level,'SYS_YES_NO',700) enable_par_level_planning, &alias_columns xxen_util.meaning(msifv.locator_type,'MTL_LOCATION_CONTROL',700) locator_control, msifv.default_loc_status_code default_locator_status, msifv.picking_order, msifv.dropping_order, msifv.disable_date inactive_on, msifv.notify_list notify, msifv.location_code location, muomv.unit_of_measure_tl picking_uom, xxen_util.meaning(msifv.default_count_type_code,'MTL_COUNT_TYPES',700) default_repl_count_type, msifv.preprocessing_lead_time, msifv.processing_lead_time, msifv.postprocessing_lead_time, xxen_util.meaning(msifv.source_type,'MTL_SOURCE_TYPES',700) source_type, msifv.source_organization_code, haouv2.name source_organization_name, msifv.source_subinventory, hla.location_code, hla.address_line_1, hla.address_line_2, hla.town_or_city, ftv.territory_short_name country, msifv.material_account, xxen_util.concatenated_segments(msifv.material_account) material_account, xxen_util.segments_description(msifv.material_account) material_account_description, xxen_util.concatenated_segments(msifv.outside_processing_account) outside_processing_account, xxen_util.segments_description(msifv.outside_processing_account) outside_process_account_desc, xxen_util.concatenated_segments(msifv.material_overhead_account) material_overhead_account, xxen_util.segments_description(msifv.material_overhead_account) material_overhead_account_desc, xxen_util.concatenated_segments(msifv.overhead_account) overhead_account, xxen_util.segments_description(msifv.overhead_account) overhead_account_desc, xxen_util.concatenated_segments(msifv.resource_account) resource_account, xxen_util.segments_description(msifv.resource_account) resource_account_desc, xxen_util.concatenated_segments(msifv.expense_account) expense_account, xxen_util.segments_description(msifv.expense_account) expense_account_desc, xxen_util.concatenated_segments(msifv.encumbrance_account) encumbrance_account, xxen_util.segments_description(msifv.encumbrance_account) encumbrance_account_desc, xxen_util.user_name(msifv.created_by) created_by, xxen_util.client_time(msifv.creation_date) creation_date, xxen_util.user_name(msifv.last_updated_by) last_updated_by, xxen_util.client_time(msifv.last_update_date) last_update_date from mtl_parameters mp, hr_all_organization_units_vl haouv, mtl_secondary_inventories_fk_v msifv, hr_all_organization_units_vl haouv2, hr_locations_all hla, fnd_territories_vl ftv, mtl_units_of_measure_vl muomv where 1=1 and mp.organization_code in (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and haouv.organization_id=mp.organization_id and mp.organization_id=msifv.organization_id and msifv.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) and msifv.source_organization_id=haouv2.organization_id(+) and msifv.pick_uom_code=muomv.uom_code(+) order by mp.organization_code, msifv.secondary_inventory_name |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Organization Code |
|
LOV |
