ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US A95C471001B20DD1E0530100007FBF83 GL Ledger (all) Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'NONE',1,'PRIMARY',2,'SECONDARY',3,'ALC',4), gl.name D Alle Hauptbücher E Todos los libros de contabilidad F Tous les livres I Tutti i libri contabili US All ledgers 8E2FF36EDE8879D2E0530100007F1FF2 HR Operating Unit (all) Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US 8E2FF36EDEA279D2E0530100007F1FF2 INV Organization Code (all) Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US All active inventory organization codes 0122D7ECDE753F7EE0630100007F3B91 select gl.name ledger, hou.name operating_unit, mpv.organization_code, haouv.name organization_name, haouv.date_to disable_date, ftv.territory_short_name country, nvl2(hla.address_line_1,hla.address_line_1||' ','')|| nvl2(hla.address_line_2,hla.address_line_2||' ','')|| nvl2(hla.address_line_3,hla.address_line_3||' ','')|| nvl2(hla.town_or_city,hla.town_or_city||' ','')|| nvl2(hla.region_2,hla.region_2||' ','')|| hla.postal_code address, mpv.master_org master_organization, mpv.calendar_code, mpv.def_demand_dummy demand_class, mpv.txn_approval_timeout_period move_order_timeout_period, xxen_util.meaning(mpv.mo_approval_timeout_action,'TXN_APPROVAL_TIMEOUT_ACTION',700) move_order_timeout_action, xxen_util.meaning(mpv.stock_locator_control_code,'MTL_LOCATION_CONTROL',700) locator_control, (select mmsv.status_code from mtl_material_statuses_vl mmsv where mpv.default_status_id=mmsv.status_id) default_onhand_material_status, xxen_util.yes(mpv.enforce_locator_alis_unq_flag) enforce_locator_alias_unique, xxen_util.yes(mpv.qa_skipping_insp_flag) quality_skip_inspect_control, xxen_util.meaning(decode(mpv.negative_inv_receipt_code,1,1),'SYS_YES_NO',700) allow_negative_balances, xxen_util.yes(mpv.auto_del_alloc_flag) auto_delete_allocations, xxen_util.yes(mpv.trading_partner_org_flag) manufacturing_partner_org, mpv.trading_partner_org_type manufacturing_partner_org_type, xxen_util.yes(mpv.eam_enabled_flag) eam_enabled, xxen_util.yes(mpv.wms_enabled_flag) wms_enabled, xxen_util.yes(mpv.wcs_enabled) wcs_enabled, xxen_util.yes(mpv.lcm_enabled_flag) lcm_enabled, xxen_util.meaning(decode(mpv.enable_ekanban,1,1),'SYS_YES_NO',700) ekanban_enabled, xxen_util.yes(mpv.process_enabled_flag) process_manufacturing_enabled, mpv.process_orgn_code, ood2.organization_code eam_organization_code, ood2.organization_name eam_organization_name, mpv.org_max_weight max_load_weight, mpv.org_max_weight_uom_code max_weight_uom_code, mpv.org_max_volume max_volume, mpv.org_max_volume_uom_code max_volume_uom_code, (select haouv.name from hr_all_organization_units_vl haouv where mpv.cost_organization_id=haouv.organization_id) costing_organization, mpv.primary_cost_dummy costing_method, (select cct.cost_type from cst_cost_types cct where mpv.avg_rates_cost_type_id=cct.cost_type_id) rates_cost_type, xxen_util.meaning(decode(mpv.general_ledger_update_code,1,1),'SYS_YES_NO',700) transfer_to_gl, xxen_util.meaning(decode(mpv.encumbrance_reversal_flag,1,1),'SYS_YES_NO',700) reverse_encumbrance, xxen_util.meaning(decode(mpv.pm_cost_collection_enabled,1,1),'SYS_YES_NO',700) project_cost_collect_enabled, xxen_util.meaning(decode(mpv.defer_logical_transactions,1,1),'SYS_YES_NO',700) defer_logical_transactions, mpv.cost_cutoff_date, mpv.default_material_sub default_material_subelement, (select br.resource_code from bom_resources br where mpv.default_matl_ovhd_cost_id=br.resource_id) material_overhead_subelement, (select ccg.cost_group from cst_cost_groups ccg where mpv.default_cost_group_id=ccg.cost_group_id) default_cost_group, xxen_util.concatenated_segments(mpv.material_account) material_account, xxen_util.segments_description(mpv.material_account) material_account_description, xxen_util.concatenated_segments(mpv.outside_processing_account) outside_processing_account, xxen_util.segments_description(mpv.outside_processing_account) outside_processing_accnt_desc, xxen_util.concatenated_segments(mpv.material_overhead_account) material_overhead_account, xxen_util.segments_description(mpv.material_overhead_account) material_overhead_account_desc, xxen_util.concatenated_segments(mpv.overhead_account) overhead_account, xxen_util.segments_description(mpv.overhead_account) overhead_account_description, xxen_util.concatenated_segments(mpv.resource_account) resource_account, xxen_util.segments_description(mpv.resource_account) resource_account_description, xxen_util.concatenated_segments(mpv.expense_account) expense_account, xxen_util.segments_description(mpv.expense_account) expense_account_description, mpv.starting_revision, decode(mpv.lot_number_uniqueness,1,'Across items','None') lot_number_uniqueness, xxen_util.meaning(mpv.lot_number_generation,'MTL_LOT_GENERATION',700) lot_number_generation, xxen_util.meaning(decode(mpv.lot_number_zero_padding,1,1),'SYS_YES_NO',700) lot_number_zero_padding, mpv.auto_lot_alpha_prefix lot_number_prefix, mpv.lot_number_length, xxen_util.meaning(mpv.allocate_lot_flag,'YES_NO',0) allocate_lot, xxen_util.meaning(mpv.parent_child_generation_flag,'INV_PARENT_CHILD_GENERATION',0) child_lot_generation, xxen_util.yes(mpv.child_lot_zero_padding_flag) child_lot_zero_padding, mpv.child_lot_alpha_prefix child_lot_prefix, mpv.child_lot_number_length child_lot_length, xxen_util.yes(mpv.child_lot_validation_flag) child_lot_format_validation, xxen_util.yes(mpv.copy_lot_attribute_flag) copy_child_lot_attributes, decode(mpv.create_lot_uom_conversion,1,'Yes',2,'No',3,'User confirmation') auto_create_lot_uom_conversion, decode(mpv.allow_different_status,1,'Yes',2,'No',3,'With exception') allow_different_material_status, decode(mpv.serial_number_type,1,'Within inventory model and items',2,'Within organization',3,'Across organizations',4,'Within inventory items') serial_control_uniqueness, xxen_util.meaning(mpv.serial_number_generation,'MTL_LOT_GENERATION',700) serial_control_generation, mpv.auto_serial_alpha_prefix prefix, mpv.start_auto_serial_number starting_serial_number, decode(mpv.allocate_serial_flag,'Y','Yes','N','No','C','Yes - User Defined') allocate_serial_numbers, mpv.total_lpn_length, mpv.lpn_starting_number starting_lpn_number, mpv.lpn_prefix, mpv.lpn_suffix, xxen_util.yes(mpv.ucc_128_suffix_flag) ucc_128_suffix, xxen_util.user_name(mpv.created_by) created_by, xxen_util.client_time(mpv.creation_date) creation_date, xxen_util.user_name(mpv.last_updated_by) last_updated_by, xxen_util.client_time(mpv.last_update_date) last_update_date from mtl_parameters_view mpv, hr_all_organization_units_vl haouv, org_organization_definitions ood, gl_ledgers gl, hr_operating_units hou, hr_locations_all hla, fnd_territories_vl ftv, org_organization_definitions ood2 where 1=1 and mpv.organization_id=ood.organization_id(+) and mpv.organization_id=haouv.organization_id and ood.set_of_books_id=gl.ledger_id(+) and ood.operating_unit=hou.organization_id(+) and haouv.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) and mpv.maint_organization_id=ood2.organization_id(+) order by gl.name, hou.name, mpv.organization_code Y US INV Organization Parameters Enginatics R12 only 1=1 1 10 1=1 gl.name=:ledger LOV GL Ledger (all) A95C471001B20DD1E0530100007FBF83 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'NONE',1,'PRIMARY',2,'SECONDARY',3,'ALC',4), gl.name US Ledger 2 20 1=1 hou.name=:operating_unit LOV HR Operating Unit (all) 8E2FF36EDE8879D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US Operating Unit 3 30 1=1 ftv.territory_short_name=:country LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US Country 4 40 1=1 mpv.organization_code=:organization_code LOV INV Organization Code (all) 8E2FF36EDEA279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US Organization Code :$flex$.ledger Ledger Operating Unit :$flex$.ledger Ledger Organization Code :$flex$.operating_unit Operating Unit Organization Code