MSC_ORGANIZATIONS

Details

Schema: FUSION
Object owner: FUSION
Object type: VIEW

Columns

Name
SR_INSTANCE_ID ORGANIZATION_CODE SR_ORGANIZATION_CODE ORGANIZATION_NAME ORGANIZATION_ID SR_ORGANIZATION_ID ORG_GROUP WEIGHT_UOM MAXIMUM_WEIGHT VOLUME_UOM MAXIMUM_VOLUME CALENDAR_CODE CALENDAR_EXCEPTION_SET_ID OPERATING_UNIT PROJECT_REFERENCE_ENABLED PROJECT_CONTROL_LEVEL DEMAND_LATENESS_COST SUPPLIER_CAP_OVERUTIL_COST RESOURCE_CAP_OVERUTIL_COST DEFAULT_DEMAND_CLASS MODELED_CUSTOMER_ID MODELED_CUSTOMER_SITE_ID MODELED_SUPPLIER_ID MODELED_SUPPLIER_SITE_ID TRANSPORT_CAP_OVER_UTIL_COST REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN USE_PHANTOM_ROUTINGS INHERIT_PHANTOM_OP_SEQ DEFAULT_ATP_RULE_ID MATERIAL_ACCOUNT EXPENSE_ACCOUNT ORGANIZATION_TYPE SERVICE_LEVEL ORG_SUPPLIER_MAPPED ACCEPT_DEMANDS_FROM_UNMET_PO INHERIT_OC_OP_SEQ_NUM SR_BUSINESS_GROUP_ID SR_LEGAL_ENTITY SR_SET_OF_BOOKS_ID SR_CHART_OF_ACCOUNTS_ID BUSINESS_GROUP_NAME LEGAL_ENTITY_NAME OPERATING_UNIT_NAME CURRENCY_CODE SUBINV_PLANNING_ENABLED

Name

SR_INSTANCE_ID

ORGANIZATION_CODE

SR_ORGANIZATION_CODE

ORGANIZATION_NAME

ORGANIZATION_ID

SR_ORGANIZATION_ID

ORG_GROUP

WEIGHT_UOM

MAXIMUM_WEIGHT

VOLUME_UOM

MAXIMUM_VOLUME

CALENDAR_CODE

CALENDAR_EXCEPTION_SET_ID

OPERATING_UNIT

PROJECT_REFERENCE_ENABLED

PROJECT_CONTROL_LEVEL

DEMAND_LATENESS_COST

SUPPLIER_CAP_OVERUTIL_COST

RESOURCE_CAP_OVERUTIL_COST

DEFAULT_DEMAND_CLASS

MODELED_CUSTOMER_ID

MODELED_CUSTOMER_SITE_ID

MODELED_SUPPLIER_ID

MODELED_SUPPLIER_SITE_ID

TRANSPORT_CAP_OVER_UTIL_COST

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

USE_PHANTOM_ROUTINGS

INHERIT_PHANTOM_OP_SEQ

DEFAULT_ATP_RULE_ID

MATERIAL_ACCOUNT

EXPENSE_ACCOUNT

ORGANIZATION_TYPE

SERVICE_LEVEL

ORG_SUPPLIER_MAPPED

ACCEPT_DEMANDS_FROM_UNMET_PO

INHERIT_OC_OP_SEQ_NUM

SR_BUSINESS_GROUP_ID

SR_LEGAL_ENTITY

SR_SET_OF_BOOKS_ID

SR_CHART_OF_ACCOUNTS_ID

BUSINESS_GROUP_NAME

LEGAL_ENTITY_NAME

OPERATING_UNIT_NAME

CURRENCY_CODE

SUBINV_PLANNING_ENABLED

Query

SQL_Statement
SELECT MIO.SR_INSTANCE_ID, MP.ORGANIZATION_CODE, MIO.SR_ORGANIZATION_CODE, MP.ORGANIZATION_NAME, MP.ORGANIZATION_ID, MIO.SR_ORGANIZATION_ID, MIO.ORG_GROUP, MP.WEIGHT_UOM, MP.MAXIMUM_WEIGHT, MP.VOLUME_UOM, MP.MAXIMUM_VOLUME, MP.CALENDAR_CODE, MP.CALENDAR_EXCEPTION_SET_ID, MP.OPERATING_UNIT, MP.PROJECT_REFERENCE_ENABLED, MP.PROJECT_CONTROL_LEVEL, MP.DEMAND_LATENESS_COST, MP.SUPPLIER_CAP_OVERUTIL_COST, MP.RESOURCE_CAP_OVERUTIL_COST, MP.DEFAULT_DEMAND_CLASS, MP.MODELED_CUSTOMER_ID, MP.MODELED_CUSTOMER_SITE_ID, MP.MODELED_SUPPLIER_ID, MP.MODELED_SUPPLIER_SITE_ID, MP.TRANSPORT_CAP_OVER_UTIL_COST, MP.REFRESH_NUMBER, MP.LAST_UPDATE_DATE, MP.LAST_UPDATED_BY, MP.CREATION_DATE, MP.CREATED_BY, MP.LAST_UPDATE_LOGIN, MP.USE_PHANTOM_ROUTINGS, MP.INHERIT_PHANTOM_OP_SEQ, MP.DEFAULT_ATP_RULE_ID, MP.MATERIAL_ACCOUNT, MP.EXPENSE_ACCOUNT, MP.ORGANIZATION_TYPE, MP.SERVICE_LEVEL, MP.ORG_SUPPLIER_MAPPED, MP.ACCEPT_DEMANDS_FROM_UNMET_PO, MP.INHERIT_OC_OP_SEQ_NUM, MP.SR_BUSINESS_GROUP_ID, MP.SR_LEGAL_ENTITY, MP.SR_SET_OF_BOOKS_ID, MP.SR_CHART_OF_ACCOUNTS_ID, MP.BUSINESS_GROUP_NAME, MP.LEGAL_ENTITY_NAME, MP.OPERATING_UNIT_NAME, MP.CURRENCY_CODE , MP.SUBINV_PLANNING_ENABLED FROM MSC_PARAMETERS MP, MSC_INSTANCE_ORGS MIO WHERE MP.ORGANIZATION_ID = MIO.ORGANIZATION_ID AND (MIO.FULFILLMENT_INSTANCE_FLAG = 1 OR (MIO.FULFILLMENT_INSTANCE_FLAG = 2 AND MIO.INVENTORY_FLAG = 'N'))

SQL_Statement

SELECT

MIO.SR_INSTANCE_ID,

MP.ORGANIZATION_CODE,

MIO.SR_ORGANIZATION_CODE,

MP.ORGANIZATION_NAME,

MP.ORGANIZATION_ID,

MIO.SR_ORGANIZATION_ID,

MIO.ORG_GROUP,

MP.WEIGHT_UOM,

MP.MAXIMUM_WEIGHT,

MP.VOLUME_UOM,

MP.MAXIMUM_VOLUME,

MP.CALENDAR_CODE,

MP.CALENDAR_EXCEPTION_SET_ID,

MP.OPERATING_UNIT,

MP.PROJECT_REFERENCE_ENABLED,

MP.PROJECT_CONTROL_LEVEL,

MP.DEMAND_LATENESS_COST,

MP.SUPPLIER_CAP_OVERUTIL_COST,

MP.RESOURCE_CAP_OVERUTIL_COST,

MP.DEFAULT_DEMAND_CLASS,

MP.MODELED_CUSTOMER_ID,

MP.MODELED_CUSTOMER_SITE_ID,

MP.MODELED_SUPPLIER_ID,

MP.MODELED_SUPPLIER_SITE_ID,

MP.TRANSPORT_CAP_OVER_UTIL_COST,

MP.REFRESH_NUMBER,

MP.LAST_UPDATE_DATE,

MP.LAST_UPDATED_BY,

MP.CREATION_DATE,

MP.CREATED_BY,

MP.LAST_UPDATE_LOGIN,

MP.USE_PHANTOM_ROUTINGS,

MP.INHERIT_PHANTOM_OP_SEQ,

MP.DEFAULT_ATP_RULE_ID,

MP.MATERIAL_ACCOUNT,

MP.EXPENSE_ACCOUNT,

MP.ORGANIZATION_TYPE,

MP.SERVICE_LEVEL,

MP.ORG_SUPPLIER_MAPPED,

MP.ACCEPT_DEMANDS_FROM_UNMET_PO,

MP.INHERIT_OC_OP_SEQ_NUM,

MP.SR_BUSINESS_GROUP_ID,

MP.SR_LEGAL_ENTITY,

MP.SR_SET_OF_BOOKS_ID,

MP.SR_CHART_OF_ACCOUNTS_ID,

MP.BUSINESS_GROUP_NAME,

MP.LEGAL_ENTITY_NAME,

MP.OPERATING_UNIT_NAME,

MP.CURRENCY_CODE ,

MP.SUBINV_PLANNING_ENABLED

FROM

MSC_PARAMETERS MP, MSC_INSTANCE_ORGS MIO

WHERE MP.ORGANIZATION_ID = MIO.ORGANIZATION_ID AND (MIO.FULFILLMENT_INSTANCE_FLAG = 1 OR (MIO.FULFILLMENT_INSTANCE_FLAG = 2 AND MIO.INVENTORY_FLAG = 'N'))