RCS_MNT_PARAMETERS

Details

Schema: FUSION
Object owner: RCS
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

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

Query

SQL_Statement
SELECT MP.ORGANIZATION_ID, MP.ORGANIZATION_CODE, MP.ORGANIZATION_NAME ORGANIZATION_NAME, MP.INVENTORY_ENABLED_FLAG, MP.BUSINESS_UNIT_ID, MP.INVENTORY_FLAG INVENTORY_FLAG, MP.EAM_ENABLED_FLAG, MP.CONTRACT_MFG_FLAG, MP.SUPPLIER_ID, MP.SUPPLIER_SITE_ID, MFG.MFG_CALENDAR, MFG.DEF_SUPPLY_SUBINV, MFG.DEF_SUPPLY_LOCATOR, MFG.DEF_COMPLTN_SUBINV, MFG.DEF_COMPLTN_LOCATOR, MFG.STARTING_OPRN_SEQ, MFG.OPRN_SEQ_INCREMENT, MFG.PHNTM_OPRN_INHERIT, MFG.WORK_ORDER_PREFIX, MFG.INC_COMP_YIELD_FLAG, MFG.DEF_OVERCOMPLTN_TOL, MFG.DEF_TRANS_MODE, MFG.DEF_TRANS_QTY, MFG.QTY_CHNG_BACKFLUSH, MFG.AUTO_ASSC_SER_NUM_WO, MFG.WO_STARTING_NUMBER, MFG.WO_DOC_SEQ_CAT_CODE, MFG.WO_DOC_SEQ_ID, MFG.PURCHASE_REQ_CREATE_TIME, MFG.DEF_WO_TRAVELER_TMPLT, MFG.DEF_LABEL_TMPLT, MFG.DEF_MNT_SCHED_METHOD, MFG.FORECAST_HORIZON, MFG.GEN_WO_HORIZON, MFG.ALLOW_DIRECT_PURCH_WO, MP.PROJECT_REFERENCE_ENABLED, MP.TRACK_COUNTRY_OF_ORIGIN_FLAG, MFG.ALLOW_RESRVTNS_WO_FLAG, MFG.MAX_SCHED_DURATION, MFG.DEFAULT_LOT_BHVR_CODE, MFG.RESTRICT_LOT_FOR_RETURNS, MFG.DEF_UNDERCOMPLTN_TOL, MFG.DEFAULT_INSPECTION_PLAN, MFG.DEFAULT_INCL_PLAN_BULK, MFG.DEFAULT_INCL_PLAN_SUPPLIER, MFG.ENABLE_ROBOTICS, MFG.DEF_MRB_SUBINV, MFG.DEF_MRB_LOCATOR FROM RCS_ORG_DEFINITIONS_LW_V MP, RCS_MFG_PARAMETERS MFG WHERE MP.ORGANIZATION_ID = MFG.ORGANIZATION_ID AND MP.EAM_ENABLED_FLAG = 'Y'

SQL_Statement

SELECT

MP.ORGANIZATION_ID,

MP.ORGANIZATION_CODE,

MP.ORGANIZATION_NAME ORGANIZATION_NAME,

MP.INVENTORY_ENABLED_FLAG,

MP.BUSINESS_UNIT_ID,

MP.INVENTORY_FLAG INVENTORY_FLAG,

MP.EAM_ENABLED_FLAG,

MP.CONTRACT_MFG_FLAG,

MP.SUPPLIER_ID,

MP.SUPPLIER_SITE_ID,

MFG.MFG_CALENDAR,

MFG.DEF_SUPPLY_SUBINV,

MFG.DEF_SUPPLY_LOCATOR,

MFG.DEF_COMPLTN_SUBINV,

MFG.DEF_COMPLTN_LOCATOR,

MFG.STARTING_OPRN_SEQ,

MFG.OPRN_SEQ_INCREMENT,

MFG.PHNTM_OPRN_INHERIT,

MFG.WORK_ORDER_PREFIX,

MFG.INC_COMP_YIELD_FLAG,

MFG.DEF_OVERCOMPLTN_TOL,

MFG.DEF_TRANS_MODE,

MFG.DEF_TRANS_QTY,

MFG.QTY_CHNG_BACKFLUSH,

MFG.AUTO_ASSC_SER_NUM_WO,

MFG.WO_STARTING_NUMBER,

MFG.WO_DOC_SEQ_CAT_CODE,

MFG.WO_DOC_SEQ_ID,

MFG.PURCHASE_REQ_CREATE_TIME,

MFG.DEF_WO_TRAVELER_TMPLT,

MFG.DEF_LABEL_TMPLT,

MFG.DEF_MNT_SCHED_METHOD,

MFG.FORECAST_HORIZON,

MFG.GEN_WO_HORIZON,

MFG.ALLOW_DIRECT_PURCH_WO,

MP.PROJECT_REFERENCE_ENABLED,

MP.TRACK_COUNTRY_OF_ORIGIN_FLAG,

MFG.ALLOW_RESRVTNS_WO_FLAG,

MFG.MAX_SCHED_DURATION,

MFG.DEFAULT_LOT_BHVR_CODE,

MFG.RESTRICT_LOT_FOR_RETURNS,

MFG.DEF_UNDERCOMPLTN_TOL,

MFG.DEFAULT_INSPECTION_PLAN,

MFG.DEFAULT_INCL_PLAN_BULK,

MFG.DEFAULT_INCL_PLAN_SUPPLIER,

MFG.ENABLE_ROBOTICS,

MFG.DEF_MRB_SUBINV,

MFG.DEF_MRB_LOCATOR

FROM

RCS_ORG_DEFINITIONS_LW_V MP,

RCS_MFG_PARAMETERS MFG

WHERE

MP.ORGANIZATION_ID = MFG.ORGANIZATION_ID AND MP.EAM_ENABLED_FLAG = 'Y'