MNT_ACCESSIBLE_ORGANIZATIONS

Details

Schema: FUSION
Object owner: MNT
Object type: VIEW

Columns

Name
ORGANIZATION_ID ORGANIZATION_CODE ORGANIZATION_NAME INVENTORY_ENABLED_FLAG BUSINESS_UNIT_ID INVENTORY_FLAG EAM_ENABLED_FLAG CONTRACT_MFG_FLAG SUPPLIER_ID SUPPLIER_SITE_ID MFG_CALENDAR DEF_SUPPLY_SUBINV DEF_SUPPLY_LOCATOR DEF_COMPLTN_SUBINV DEF_COMPLTN_LOCATOR STARTING_OPRN_SEQ OPRN_SEQ_INCREMENT PHNTM_OPRN_INHERIT WORK_ORDER_PREFIX INC_COMP_YIELD_FLAG DEF_OVERCOMPLTN_TOL DEF_TRANS_MODE DEF_TRANS_QTY QTY_CHNG_BACKFLUSH AUTO_ASSC_SER_NUM_WO WO_STARTING_NUMBER WO_DOC_SEQ_CAT_CODE WO_DOC_SEQ_ID PURCHASE_REQ_CREATE_TIME DEF_WO_TRAVELER_TMPLT DEF_LABEL_TMPLT DEF_MNT_SCHED_METHOD FORECAST_HORIZON GEN_WO_HORIZON ALLOW_DIRECT_PURCH_WO PROJECT_REFERENCE_ENABLED TRACK_COUNTRY_OF_ORIGIN_FLAG ALLOW_RESRVTNS_WO_FLAG MAX_SCHED_DURATION DEFAULT_LOT_BHVR_CODE RESTRICT_LOT_FOR_RETURNS DEF_UNDERCOMPLTN_TOL DEFAULT_INSPECTION_PLAN DEFAULT_INCL_PLAN_BULK DEFAULT_INCL_PLAN_SUPPLIER ENABLE_ROBOTICS DEF_MRB_SUBINV DEF_MRB_LOCATOR MAINT_TECH_WB_ENABLED_FLAG MANUALLY_COMPLETE_WO_FLAG ALLOW_REPEATING_INGRED_FLAG PREVENT_EXPIRED_LOTS_FLAG

Name

ORGANIZATION_ID

ORGANIZATION_CODE

ORGANIZATION_NAME

INVENTORY_ENABLED_FLAG

BUSINESS_UNIT_ID

INVENTORY_FLAG

EAM_ENABLED_FLAG

CONTRACT_MFG_FLAG

SUPPLIER_ID

SUPPLIER_SITE_ID

MFG_CALENDAR

DEF_SUPPLY_SUBINV

DEF_SUPPLY_LOCATOR

DEF_COMPLTN_SUBINV

DEF_COMPLTN_LOCATOR

STARTING_OPRN_SEQ

OPRN_SEQ_INCREMENT

PHNTM_OPRN_INHERIT

WORK_ORDER_PREFIX

INC_COMP_YIELD_FLAG

DEF_OVERCOMPLTN_TOL

DEF_TRANS_MODE

DEF_TRANS_QTY

QTY_CHNG_BACKFLUSH

AUTO_ASSC_SER_NUM_WO

WO_STARTING_NUMBER

WO_DOC_SEQ_CAT_CODE

WO_DOC_SEQ_ID

PURCHASE_REQ_CREATE_TIME

DEF_WO_TRAVELER_TMPLT

DEF_LABEL_TMPLT

DEF_MNT_SCHED_METHOD

FORECAST_HORIZON

GEN_WO_HORIZON

ALLOW_DIRECT_PURCH_WO

PROJECT_REFERENCE_ENABLED

TRACK_COUNTRY_OF_ORIGIN_FLAG

ALLOW_RESRVTNS_WO_FLAG

MAX_SCHED_DURATION

DEFAULT_LOT_BHVR_CODE

RESTRICT_LOT_FOR_RETURNS

DEF_UNDERCOMPLTN_TOL

DEFAULT_INSPECTION_PLAN

DEFAULT_INCL_PLAN_BULK

DEFAULT_INCL_PLAN_SUPPLIER

ENABLE_ROBOTICS

DEF_MRB_SUBINV

DEF_MRB_LOCATOR

MAINT_TECH_WB_ENABLED_FLAG

MANUALLY_COMPLETE_WO_FLAG

ALLOW_REPEATING_INGRED_FLAG

PREVENT_EXPIRED_LOTS_FLAG

Query

SQL_Statement
select organization_id, organization_code, organization_name, inventory_enabled_flag, business_unit_id, inventory_flag, eam_enabled_flag, contract_mfg_flag, supplier_id, supplier_site_id, mfg_calendar, def_supply_subinv, def_supply_locator, def_compltn_subinv, def_compltn_locator, starting_oprn_seq, oprn_seq_increment, phntm_oprn_inherit, work_order_prefix , inc_comp_yield_flag, def_overcompltn_tol, def_trans_mode, def_trans_qty, qty_chng_backflush, auto_assc_ser_num_wo, wo_starting_number, wo_doc_seq_cat_code, wo_doc_seq_id, purchase_req_create_time, def_wo_traveler_tmplt, def_label_tmplt, def_mnt_sched_method, forecast_horizon, gen_wo_horizon, allow_direct_purch_wo, project_reference_enabled, track_country_of_origin_flag, allow_resrvtns_wo_flag, max_sched_duration, default_lot_bhvr_code, restrict_lot_for_returns, def_undercompltn_tol, default_inspection_plan, default_incl_plan_bulk, default_incl_plan_supplier, enable_robotics, def_mrb_subinv, def_mrb_locator, maint_tech_wb_enabled_flag, manually_complete_wo_flag, allow_repeating_ingred_flag, prevent_expired_lots_flag from rcs_mnt_parameters_v

SQL_Statement

select

organization_id,

organization_code,

organization_name,

inventory_enabled_flag,

business_unit_id,

inventory_flag,

eam_enabled_flag,

contract_mfg_flag,

supplier_id,

supplier_site_id,

mfg_calendar,

def_supply_subinv,

def_supply_locator,

def_compltn_subinv,

def_compltn_locator,

starting_oprn_seq,

oprn_seq_increment,

phntm_oprn_inherit,

work_order_prefix ,

inc_comp_yield_flag,

def_overcompltn_tol,

def_trans_mode,

def_trans_qty,

qty_chng_backflush,

auto_assc_ser_num_wo,

wo_starting_number,

wo_doc_seq_cat_code,

wo_doc_seq_id,

purchase_req_create_time,

def_wo_traveler_tmplt,

def_label_tmplt,

def_mnt_sched_method,

forecast_horizon,

gen_wo_horizon,

allow_direct_purch_wo,

project_reference_enabled,

track_country_of_origin_flag,

allow_resrvtns_wo_flag,

max_sched_duration,

default_lot_bhvr_code,

restrict_lot_for_returns,

def_undercompltn_tol,

default_inspection_plan,

default_incl_plan_bulk,

default_incl_plan_supplier,

enable_robotics,

def_mrb_subinv,

def_mrb_locator,

maint_tech_wb_enabled_flag,

manually_complete_wo_flag,

allow_repeating_ingred_flag,

prevent_expired_lots_flag

from rcs_mnt_parameters_v