MSC_ORGS_WITH_PIMID

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
ORGANIZATION_ID SR_INSTANCE_ID ORGANIZATION_CODE CALENDAR_CODE CALENDAR_EXCEPTION_SET_ID DEFAULT_ATP_RULE_ID DEFAULT_DEMAND_CLASS MASTER_ORGANIZATION_ID MAXIMUM_VOLUME MAXIMUM_WEIGHT MODELED_CUSTOMER_ID MODELED_CUSTOMER_SITE_ID MODELED_SUPPLIER_ID MODELED_SUPPLIER_SITE_ID OPERATING_UNIT PROJECT_REFERENCE_ENABLED VOLUME_UOM WEIGHT_UOM ORGANIZATION_NAME ORGANIZATION_TYPE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATION_DATE ACCEPT_DEMANDS_FROM_UNMET_PO BUSINESS_GROUP_NAME COLLECTED_FLAG COMPANY_ID CONSIDER_PO CONSIDER_RESERVATIONS CONSIDER_WIP CURRENCY_CODE CUSTOMER_CLASS_CODE DEFAULT_ABC_ASSIGNMENT_GROUP DEMAND_LATENESS_COST DEMAND_TIME_FENCE_FLAG EXPENSE_ACCOUNT INCLUDE_MDS_DAYS INCLUDE_PAST_DUE_FORECAST INCLUDE_REP_SUPPLY_DAYS INHERIT_OC_OP_SEQ_NUM INHERIT_PHANTOM_OP_SEQ LEGAL_ENTITY_NAME MATERIAL_ACCOUNT NETWORK_SCHEDULING_METHOD NET_ON_HAND OPERATING_UNIT_NAME OPERATION_SCHEDULE_TYPE ORG_SUPPLIER_MAPPED PARTNER_ID PART_INCLUDE_TYPE PERIOD_TYPE PLANNING_TIME_FENCE_FLAG PLAN_DATE_DEFAULT_TYPE PLAN_SAFETY_STOCK PROJECT_CONTROL_LEVEL REPETITIVE_ANCHOR_DATE REPETITIVE_BUCKET_SIZE1 REPETITIVE_BUCKET_SIZE2 REPETITIVE_BUCKET_SIZE3 REPETITIVE_HORIZON1 REPETITIVE_HORIZON2 RESCHED_ASSUMPTION RESOURCE_CAP_OVERUTIL_COST SERVICE_LEVEL SNAPSHOT_LOCK SR_BUSINESS_GROUP_ID SR_CHART_OF_ACCOUNTS_ID SR_LEGAL_ENTITY SR_SET_OF_BOOKS_ID SUPPLIER_CAP_OVERUTIL_COST TRANSPORT_CAP_OVER_UTIL_COST USE_PHANTOM_ROUTINGS ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 BUSINESS_UNIT_ID BUSINESS_UNIT_NAME DROP_SHIP_VAL_ORG_FLAG FIXED_DATE_ENABLED_FLAG OPERATING_UNIT_ID PAST_DUE_FORECAST_DAYS PAST_DUE_SO_DAYS PAST_DUE_SUPPLY_DAYS PLANT_FLAG REFRESH_NUMBER

Name

ORGANIZATION_ID

SR_INSTANCE_ID

ORGANIZATION_CODE

CALENDAR_CODE

CALENDAR_EXCEPTION_SET_ID

DEFAULT_ATP_RULE_ID

DEFAULT_DEMAND_CLASS

MASTER_ORGANIZATION_ID

MAXIMUM_VOLUME

MAXIMUM_WEIGHT

MODELED_CUSTOMER_ID

MODELED_CUSTOMER_SITE_ID

MODELED_SUPPLIER_ID

MODELED_SUPPLIER_SITE_ID

OPERATING_UNIT

PROJECT_REFERENCE_ENABLED

VOLUME_UOM

WEIGHT_UOM

ORGANIZATION_NAME

ORGANIZATION_TYPE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

CREATION_DATE

ACCEPT_DEMANDS_FROM_UNMET_PO

BUSINESS_GROUP_NAME

COLLECTED_FLAG

COMPANY_ID

CONSIDER_PO

CONSIDER_RESERVATIONS

CONSIDER_WIP

CURRENCY_CODE

CUSTOMER_CLASS_CODE

DEFAULT_ABC_ASSIGNMENT_GROUP

DEMAND_LATENESS_COST

DEMAND_TIME_FENCE_FLAG

EXPENSE_ACCOUNT

INCLUDE_MDS_DAYS

INCLUDE_PAST_DUE_FORECAST

INCLUDE_REP_SUPPLY_DAYS

INHERIT_OC_OP_SEQ_NUM

INHERIT_PHANTOM_OP_SEQ

LEGAL_ENTITY_NAME

MATERIAL_ACCOUNT

NETWORK_SCHEDULING_METHOD

NET_ON_HAND

OPERATING_UNIT_NAME

OPERATION_SCHEDULE_TYPE

ORG_SUPPLIER_MAPPED

PARTNER_ID

PART_INCLUDE_TYPE

PERIOD_TYPE

PLANNING_TIME_FENCE_FLAG

PLAN_DATE_DEFAULT_TYPE

PLAN_SAFETY_STOCK

PROJECT_CONTROL_LEVEL

REPETITIVE_ANCHOR_DATE

REPETITIVE_BUCKET_SIZE1

REPETITIVE_BUCKET_SIZE2

REPETITIVE_BUCKET_SIZE3

REPETITIVE_HORIZON1

REPETITIVE_HORIZON2

RESCHED_ASSUMPTION

RESOURCE_CAP_OVERUTIL_COST

SERVICE_LEVEL

SNAPSHOT_LOCK

SR_BUSINESS_GROUP_ID

SR_CHART_OF_ACCOUNTS_ID

SR_LEGAL_ENTITY

SR_SET_OF_BOOKS_ID

SUPPLIER_CAP_OVERUTIL_COST

TRANSPORT_CAP_OVER_UTIL_COST

USE_PHANTOM_ROUTINGS

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

BUSINESS_UNIT_ID

BUSINESS_UNIT_NAME

DROP_SHIP_VAL_ORG_FLAG

FIXED_DATE_ENABLED_FLAG

OPERATING_UNIT_ID

PAST_DUE_FORECAST_DAYS

PAST_DUE_SO_DAYS

PAST_DUE_SUPPLY_DAYS

PLANT_FLAG

REFRESH_NUMBER

Query

SQL_Statement
select mio.sr_organization_id organization_id, fulfil.sr_instance_id sr_instance_id, mp.ORGANIZATION_CODE, mp.CALENDAR_CODE, mp.CALENDAR_EXCEPTION_SET_ID, mp.DEFAULT_ATP_RULE_ID, mp.DEFAULT_DEMAND_CLASS, mp.MASTER_ORGANIZATION_ID, mp.MAXIMUM_VOLUME, mp.MAXIMUM_WEIGHT, mp.MODELED_CUSTOMER_ID, mp.MODELED_CUSTOMER_SITE_ID, mp.MODELED_SUPPLIER_ID, mp.MODELED_SUPPLIER_SITE_ID, mp.OPERATING_UNIT, mp.PROJECT_REFERENCE_ENABLED, mp.VOLUME_UOM, mp.WEIGHT_UOM, mp.ORGANIZATION_NAME, mp.ORGANIZATION_TYPE, mp.CREATED_BY, mp.LAST_UPDATED_BY, mp.LAST_UPDATE_DATE, mp.LAST_UPDATE_LOGIN, mp.CREATION_DATE, mp.ACCEPT_DEMANDS_FROM_UNMET_PO, mp.BUSINESS_GROUP_NAME, mp.COLLECTED_FLAG, mp.COMPANY_ID, mp.CONSIDER_PO, mp.CONSIDER_RESERVATIONS, mp.CONSIDER_WIP, mp.CURRENCY_CODE, mp.CUSTOMER_CLASS_CODE, mp.DEFAULT_ABC_ASSIGNMENT_GROUP, mp.DEMAND_LATENESS_COST, mp.DEMAND_TIME_FENCE_FLAG, mp.EXPENSE_ACCOUNT, mp.INCLUDE_MDS_DAYS, mp.INCLUDE_PAST_DUE_FORECAST, mp.INCLUDE_REP_SUPPLY_DAYS, mp.INHERIT_OC_OP_SEQ_NUM, mp.INHERIT_PHANTOM_OP_SEQ, mp.LEGAL_ENTITY_NAME, mp.MATERIAL_ACCOUNT, mp.NETWORK_SCHEDULING_METHOD, mp.NET_ON_HAND, mp.OPERATING_UNIT_NAME, mp.OPERATION_SCHEDULE_TYPE, mp.ORG_SUPPLIER_MAPPED, mp.PARTNER_ID, mp.PART_INCLUDE_TYPE, mp.PERIOD_TYPE, mp.PLANNING_TIME_FENCE_FLAG, mp.PLAN_DATE_DEFAULT_TYPE, mp.PLAN_SAFETY_STOCK, mp.PROJECT_CONTROL_LEVEL, mp.REPETITIVE_ANCHOR_DATE, mp.REPETITIVE_BUCKET_SIZE1, mp.REPETITIVE_BUCKET_SIZE2, mp.REPETITIVE_BUCKET_SIZE3, mp.REPETITIVE_HORIZON1, mp.REPETITIVE_HORIZON2, mp.RESCHED_ASSUMPTION, mp.RESOURCE_CAP_OVERUTIL_COST, mp.SERVICE_LEVEL, mp.SNAPSHOT_LOCK, mp.SR_BUSINESS_GROUP_ID, mp.SR_CHART_OF_ACCOUNTS_ID, mp.SR_LEGAL_ENTITY, mp.SR_SET_OF_BOOKS_ID, mp.SUPPLIER_CAP_OVERUTIL_COST, mp.TRANSPORT_CAP_OVER_UTIL_COST, mp.USE_PHANTOM_ROUTINGS, mp.ATTRIBUTE_CATEGORY, mp.ATTRIBUTE1, mp.ATTRIBUTE2, mp.ATTRIBUTE3, mp.ATTRIBUTE4, mp.ATTRIBUTE5, mp.ATTRIBUTE6, mp.ATTRIBUTE7, mp.ATTRIBUTE8, mp.ATTRIBUTE9, mp.ATTRIBUTE10, mp.ATTRIBUTE11, mp.ATTRIBUTE12, mp.ATTRIBUTE13, mp.ATTRIBUTE14, mp.ATTRIBUTE15, mp.BUSINESS_UNIT_ID, mp.BUSINESS_UNIT_NAME, mp.DROP_SHIP_VAL_ORG_FLAG, mp.FIXED_DATE_ENABLED_FLAG, mp.OPERATING_UNIT_ID, mp.PAST_DUE_FORECAST_DAYS, mp.PAST_DUE_SO_DAYS, mp.PAST_DUE_SUPPLY_DAYS, mp.PLANT_FLAG, mp.REFRESH_NUMBER from msc_instance_orgs mio, msc_parameters mp, msc_apps_dest_instance dest, msc_instance_orgs fulfil where mio.organization_id = mp.organization_id and MIO.SR_INSTANCE_ID = dest.INSTANCE_ID and fulfil.fulfillment_instance_flag =1 and FULFIL.ORGANIZATION_ID = MIO.ORGANIZATION_ID

SQL_Statement

select

mio.sr_organization_id organization_id,

fulfil.sr_instance_id sr_instance_id,

mp.ORGANIZATION_CODE,

mp.CALENDAR_CODE,

mp.CALENDAR_EXCEPTION_SET_ID,

mp.DEFAULT_ATP_RULE_ID,

mp.DEFAULT_DEMAND_CLASS,

mp.MASTER_ORGANIZATION_ID,

mp.MAXIMUM_VOLUME,

mp.MAXIMUM_WEIGHT,

mp.MODELED_CUSTOMER_ID,

mp.MODELED_CUSTOMER_SITE_ID,

mp.MODELED_SUPPLIER_ID,

mp.MODELED_SUPPLIER_SITE_ID,

mp.OPERATING_UNIT,

mp.PROJECT_REFERENCE_ENABLED,

mp.VOLUME_UOM,

mp.WEIGHT_UOM,

mp.ORGANIZATION_NAME,

mp.ORGANIZATION_TYPE,

mp.CREATED_BY,

mp.LAST_UPDATED_BY,

mp.LAST_UPDATE_DATE,

mp.LAST_UPDATE_LOGIN,

mp.CREATION_DATE,

mp.ACCEPT_DEMANDS_FROM_UNMET_PO,

mp.BUSINESS_GROUP_NAME,

mp.COLLECTED_FLAG,

mp.COMPANY_ID,

mp.CONSIDER_PO,

mp.CONSIDER_RESERVATIONS,

mp.CONSIDER_WIP,

mp.CURRENCY_CODE,

mp.CUSTOMER_CLASS_CODE,

mp.DEFAULT_ABC_ASSIGNMENT_GROUP,

mp.DEMAND_LATENESS_COST,

mp.DEMAND_TIME_FENCE_FLAG,

mp.EXPENSE_ACCOUNT,

mp.INCLUDE_MDS_DAYS,

mp.INCLUDE_PAST_DUE_FORECAST,

mp.INCLUDE_REP_SUPPLY_DAYS,

mp.INHERIT_OC_OP_SEQ_NUM,

mp.INHERIT_PHANTOM_OP_SEQ,

mp.LEGAL_ENTITY_NAME,

mp.MATERIAL_ACCOUNT,

mp.NETWORK_SCHEDULING_METHOD,

mp.NET_ON_HAND,

mp.OPERATING_UNIT_NAME,

mp.OPERATION_SCHEDULE_TYPE,

mp.ORG_SUPPLIER_MAPPED,

mp.PARTNER_ID,

mp.PART_INCLUDE_TYPE,

mp.PERIOD_TYPE,

mp.PLANNING_TIME_FENCE_FLAG,

mp.PLAN_DATE_DEFAULT_TYPE,

mp.PLAN_SAFETY_STOCK,

mp.PROJECT_CONTROL_LEVEL,

mp.REPETITIVE_ANCHOR_DATE,

mp.REPETITIVE_BUCKET_SIZE1,

mp.REPETITIVE_BUCKET_SIZE2,

mp.REPETITIVE_BUCKET_SIZE3,

mp.REPETITIVE_HORIZON1,

mp.REPETITIVE_HORIZON2,

mp.RESCHED_ASSUMPTION,

mp.RESOURCE_CAP_OVERUTIL_COST,

mp.SERVICE_LEVEL,

mp.SNAPSHOT_LOCK,

mp.SR_BUSINESS_GROUP_ID,

mp.SR_CHART_OF_ACCOUNTS_ID,

mp.SR_LEGAL_ENTITY,

mp.SR_SET_OF_BOOKS_ID,

mp.SUPPLIER_CAP_OVERUTIL_COST,

mp.TRANSPORT_CAP_OVER_UTIL_COST,

mp.USE_PHANTOM_ROUTINGS,

mp.ATTRIBUTE_CATEGORY,

mp.ATTRIBUTE1,

mp.ATTRIBUTE2,

mp.ATTRIBUTE3,

mp.ATTRIBUTE4,

mp.ATTRIBUTE5,

mp.ATTRIBUTE6,

mp.ATTRIBUTE7,

mp.ATTRIBUTE8,

mp.ATTRIBUTE9,

mp.ATTRIBUTE10,

mp.ATTRIBUTE11,

mp.ATTRIBUTE12,

mp.ATTRIBUTE13,

mp.ATTRIBUTE14,

mp.ATTRIBUTE15,

mp.BUSINESS_UNIT_ID,

mp.BUSINESS_UNIT_NAME,

mp.DROP_SHIP_VAL_ORG_FLAG,

mp.FIXED_DATE_ENABLED_FLAG,

mp.OPERATING_UNIT_ID,

mp.PAST_DUE_FORECAST_DAYS,

mp.PAST_DUE_SO_DAYS,

mp.PAST_DUE_SUPPLY_DAYS,

mp.PLANT_FLAG,

mp.REFRESH_NUMBER

from msc_instance_orgs mio,

msc_parameters mp,

msc_apps_dest_instance dest,

msc_instance_orgs fulfil

where mio.organization_id = mp.organization_id

and MIO.SR_INSTANCE_ID = dest.INSTANCE_ID

and fulfil.fulfillment_instance_flag =1

and FULFIL.ORGANIZATION_ID = MIO.ORGANIZATION_ID