MSC_TRADING_PARTNERS

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PARTNER_ID SR_INSTANCE_ID ORGANIZATION_CODE DISABLE_DATE STATUS COMPANY_ID PARTNER_TYPE PARTNER_NAME PARTNER_NUMBER CUSTOMER_TYPE CUSTOMER_CLASS_CODE MASTER_ORGANIZATION ORGANIZATION_ID WEIGHT_UOM MAXIMUM_WEIGHT VOLUME_UOM MAXIMUM_VOLUME CALENDAR_CODE CALENDAR_EXCEPTION_SET_ID OPERATING_UNIT PROJECT_REFERENCE_ENABLED PROJECT_CONTROL_LEVEL SOURCE_ORG_ID 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 REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE 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

Name

PARTNER_ID

SR_INSTANCE_ID

ORGANIZATION_CODE

DISABLE_DATE

STATUS

COMPANY_ID

PARTNER_TYPE

PARTNER_NAME

PARTNER_NUMBER

CUSTOMER_TYPE

CUSTOMER_CLASS_CODE

MASTER_ORGANIZATION

ORGANIZATION_ID

WEIGHT_UOM

MAXIMUM_WEIGHT

VOLUME_UOM

MAXIMUM_VOLUME

CALENDAR_CODE

CALENDAR_EXCEPTION_SET_ID

OPERATING_UNIT

PROJECT_REFERENCE_ENABLED

PROJECT_CONTROL_LEVEL

SOURCE_ORG_ID

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

REQUEST_ID

PROGRAM_APPLICATION_ID

PROGRAM_ID

PROGRAM_UPDATE_DATE

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

Query

SQL_Statement
select /* For Suppliers and Carriers only / tp_id Partner_id, to_number(NULL) Sr_instance_id, NULL organization_code, Disable_date, to_char(Status) Status, Company_id, PARTNER_TYPE, Partner_name, PARTNER_NUMBER, NULL CUSTOMER_TYPE, NULL CUSTOMER_CLASS_CODE, to_number(NULL) MASTER_ORGANIZATION, to_number(NULL) ORGANIZATION_ID, to_number(NULL) WEIGHT_UOM, to_number(NULL) MAXIMUM_WEIGHT, to_number(NULL) VOLUME_UOM, to_number(NULL) MAXIMUM_VOLUME, NULL CALENDAR_CODE, to_number(NULL) CALENDAR_EXCEPTION_SET_ID, to_number(NULL) OPERATING_UNIT, to_number(NULL) PROJECT_REFERENCE_ENABLED, to_number(NULL) PROJECT_CONTROL_LEVEL, to_number(NULL) SOURCE_ORG_ID, to_number(NULL) DEMAND_LATENESS_COST, to_number(NULL) SUPPLIER_CAP_OVERUTIL_COST, to_number(NULL) RESOURCE_CAP_OVERUTIL_COST, to_number(NULL) DEFAULT_DEMAND_CLASS, to_number(NULL) MODELED_CUSTOMER_ID, to_number(NULL) MODELED_CUSTOMER_SITE_ID, to_number(NULL) MODELED_SUPPLIER_ID, to_number(NULL) MODELED_SUPPLIER_SITE_ID, to_number(NULL) TRANSPORT_CAP_OVER_UTIL_COST, REFRESH_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, to_number(NULL) REQUEST_ID, to_number(NULL) PROGRAM_APPLICATION_ID, to_number(NULL) PROGRAM_ID, to_number(NULL) PROGRAM_UPDATE_DATE, to_number(NULL) USE_PHANTOM_ROUTINGS, to_number(NULL) INHERIT_PHANTOM_OP_SEQ, to_number(NULL) DEFAULT_ATP_RULE_ID, to_number(NULL) MATERIAL_ACCOUNT, to_number(NULL) EXPENSE_ACCOUNT, to_number(NULL) ORGANIZATION_TYPE, to_number(NULL) SERVICE_LEVEL, to_number(NULL) ORG_SUPPLIER_MAPPED, to_number(NULL) ACCEPT_DEMANDS_FROM_UNMET_PO, to_number(NULL) INHERIT_OC_OP_SEQ_NUM, to_number(NULL) SR_BUSINESS_GROUP_ID, to_number(NULL) SR_LEGAL_ENTITY, to_number(NULL) SR_SET_OF_BOOKS_ID, to_number(NULL) SR_CHART_OF_ACCOUNTS_ID, NULL BUSINESS_GROUP_NAME, NULL LEGAL_ENTITY_NAME, NULL OPERATING_UNIT_NAME, NULL CURRENCY_CODE from msc_global_trading_partners where PARTNER_TYPE in (1,4) UNION ALL / For Organizations / select mp.Partner_id, mio.Sr_instance_id, mp.Organization_Code, to_date(NULL) Disable_date, NULL Status, mp.Company_id, 3 PARTNER_TYPE, mp.Organization_name Partner_Name, NULL PARTNER_NUMBER, null CUSTOMER_TYPE, null CUSTOMER_CLASS_CODE, to_number(NULL) MASTER_ORGANIZATION, mp.ORGANIZATION_id, 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, to_number(NULL) SOURCE_ORG_ID, 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, NULL REQUEST_ID, NULL PROGRAM_APPLICATION_ID, NULL PROGRAM_ID, NULL PROGRAM_UPDATE_DATE, 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 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.drop_ship_val_org_flag = 1)) UNION ALL select / For Customers */ mcv.tp_id, NULL Sr_instance_id, to_char(Null) organization_code, to_date(NULL) Disable_date, to_char(Status), NULL Company_id, 2 PARTNER_TYPE, mcv.Partner_name , mcv.PARTNER_NUMBER , NULL CUSTOMER_TYPE, NULL CUSTOMER_CLASS_CODE, to_number(NULL) MASTER_ORGANIZATION, to_number(NULL) ORGANIZATION_ID, NULL WEIGHT_UOM , NULL MAXIMUM_WEIGHT, NULL VOLUME_UOM, NULL MAXIMUM_VOLUME , NULL CALENDAR_CODE, NULL CALENDAR_EXCEPTION_SET_ID, NULL OPERATING_UNIT, NULL PROJECT_REFERENCE_ENABLED, NULL PROJECT_CONTROL_LEVEL, NULL SOURCE_ORG_ID, NULL DEMAND_LATENESS_COST, NULL SUPPLIER_CAP_OVERUTIL_COST, NULL RESOURCE_CAP_OVERUTIL_COST, NULL DEFAULT_DEMAND_CLASS, NULL MODELED_CUSTOMER_ID, NULL MODELED_CUSTOMER_SITE_ID, NULL MODELED_SUPPLIER_ID, NULL MODELED_SUPPLIER_SITE_ID, NULL TRANSPORT_CAP_OVER_UTIL_COST, NULL REFRESH_NUMBER , NULL LAST_UPDATE_DATE, NULL LAST_UPDATED_BY, NULL CREATION_DATE, NULL CREATED_BY, NULL LAST_UPDATE_LOGIN , NULL REQUEST_ID, NULL PROGRAM_APPLICATION_ID, NULL PROGRAM_ID, NULL PROGRAM_UPDATE_DATE, NULL USE_PHANTOM_ROUTINGS, NULL INHERIT_PHANTOM_OP_SEQ, NULL DEFAULT_ATP_RULE_ID, NULL MATERIAL_ACCOUNT, NULL EXPENSE_ACCOUNT, NULL ORGANIZATION_TYPE, NULL SERVICE_LEVEL, NULL ORG_SUPPLIER_MAPPED, NULL ACCEPT_DEMANDS_FROM_UNMET_PO, NULL INHERIT_OC_OP_SEQ_NUM, NULL SR_BUSINESS_GROUP_ID, NULL SR_LEGAL_ENTITY, NULL SR_SET_OF_BOOKS_ID, NULL SR_CHART_OF_ACCOUNTS_ID, NULL BUSINESS_GROUP_NAME, NULL LEGAL_ENTITY_NAME, NULL OPERATING_UNIT_NAME, NULL CURRENCY_CODE from msc_customers_v mcv

SQL_Statement

select /* For Suppliers and Carriers only */

tp_id Partner_id,

to_number(NULL) Sr_instance_id,

NULL organization_code,

Disable_date,

to_char(Status) Status,

Company_id,

PARTNER_TYPE,

Partner_name,

PARTNER_NUMBER,

NULL CUSTOMER_TYPE,

NULL CUSTOMER_CLASS_CODE,

to_number(NULL) MASTER_ORGANIZATION,

to_number(NULL) ORGANIZATION_ID,

to_number(NULL) WEIGHT_UOM,

to_number(NULL) MAXIMUM_WEIGHT,

to_number(NULL) VOLUME_UOM,

to_number(NULL) MAXIMUM_VOLUME,

NULL CALENDAR_CODE,

to_number(NULL) CALENDAR_EXCEPTION_SET_ID,

to_number(NULL) OPERATING_UNIT,

to_number(NULL) PROJECT_REFERENCE_ENABLED,

to_number(NULL) PROJECT_CONTROL_LEVEL,

to_number(NULL) SOURCE_ORG_ID,

to_number(NULL) DEMAND_LATENESS_COST,

to_number(NULL) SUPPLIER_CAP_OVERUTIL_COST,

to_number(NULL) RESOURCE_CAP_OVERUTIL_COST,

to_number(NULL) DEFAULT_DEMAND_CLASS,

to_number(NULL) MODELED_CUSTOMER_ID,

to_number(NULL) MODELED_CUSTOMER_SITE_ID,

to_number(NULL) MODELED_SUPPLIER_ID,

to_number(NULL) MODELED_SUPPLIER_SITE_ID,

to_number(NULL) TRANSPORT_CAP_OVER_UTIL_COST,

REFRESH_NUMBER,

LAST_UPDATE_DATE,

LAST_UPDATED_BY,

CREATION_DATE,

CREATED_BY,

LAST_UPDATE_LOGIN,

to_number(NULL) REQUEST_ID,

to_number(NULL) PROGRAM_APPLICATION_ID,

to_number(NULL) PROGRAM_ID,

to_number(NULL) PROGRAM_UPDATE_DATE,

to_number(NULL) USE_PHANTOM_ROUTINGS,

to_number(NULL) INHERIT_PHANTOM_OP_SEQ,

to_number(NULL) DEFAULT_ATP_RULE_ID,

to_number(NULL) MATERIAL_ACCOUNT,

to_number(NULL) EXPENSE_ACCOUNT,

to_number(NULL) ORGANIZATION_TYPE,

to_number(NULL) SERVICE_LEVEL,

to_number(NULL) ORG_SUPPLIER_MAPPED,

to_number(NULL) ACCEPT_DEMANDS_FROM_UNMET_PO,

to_number(NULL) INHERIT_OC_OP_SEQ_NUM,

to_number(NULL) SR_BUSINESS_GROUP_ID,

to_number(NULL) SR_LEGAL_ENTITY,

to_number(NULL) SR_SET_OF_BOOKS_ID,

to_number(NULL) SR_CHART_OF_ACCOUNTS_ID,

NULL BUSINESS_GROUP_NAME,

NULL LEGAL_ENTITY_NAME,

NULL OPERATING_UNIT_NAME,

NULL CURRENCY_CODE

from

msc_global_trading_partners

where PARTNER_TYPE in (1,4)

UNION ALL /* For Organizations */

select

mp.Partner_id,

mio.Sr_instance_id,

mp.Organization_Code,

to_date(NULL) Disable_date,

NULL Status,

mp.Company_id,

3 PARTNER_TYPE,

mp.Organization_name Partner_Name,

NULL PARTNER_NUMBER,

null CUSTOMER_TYPE,

null CUSTOMER_CLASS_CODE,

to_number(NULL) MASTER_ORGANIZATION,

mp.ORGANIZATION_id,

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,

to_number(NULL) SOURCE_ORG_ID,

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,

NULL REQUEST_ID,

NULL PROGRAM_APPLICATION_ID,

NULL PROGRAM_ID,

NULL PROGRAM_UPDATE_DATE,

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

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.drop_ship_val_org_flag = 1))

UNION ALL

select /* For Customers */

mcv.tp_id,

NULL Sr_instance_id,

to_char(Null) organization_code,

to_date(NULL) Disable_date,

to_char(Status),

NULL Company_id,

2 PARTNER_TYPE,

mcv.Partner_name ,

mcv.PARTNER_NUMBER ,

NULL CUSTOMER_TYPE,

NULL CUSTOMER_CLASS_CODE,

to_number(NULL) MASTER_ORGANIZATION,

to_number(NULL) ORGANIZATION_ID,

NULL WEIGHT_UOM ,

NULL MAXIMUM_WEIGHT,

NULL VOLUME_UOM,

NULL MAXIMUM_VOLUME ,

NULL CALENDAR_CODE,

NULL CALENDAR_EXCEPTION_SET_ID,

NULL OPERATING_UNIT,

NULL PROJECT_REFERENCE_ENABLED,

NULL PROJECT_CONTROL_LEVEL,

NULL SOURCE_ORG_ID,

NULL DEMAND_LATENESS_COST,

NULL SUPPLIER_CAP_OVERUTIL_COST,

NULL RESOURCE_CAP_OVERUTIL_COST,

NULL DEFAULT_DEMAND_CLASS,

NULL MODELED_CUSTOMER_ID,

NULL MODELED_CUSTOMER_SITE_ID,

NULL MODELED_SUPPLIER_ID,

NULL MODELED_SUPPLIER_SITE_ID,

NULL TRANSPORT_CAP_OVER_UTIL_COST,

NULL REFRESH_NUMBER ,

NULL LAST_UPDATE_DATE,

NULL LAST_UPDATED_BY,

NULL CREATION_DATE,

NULL CREATED_BY,

NULL LAST_UPDATE_LOGIN ,

NULL REQUEST_ID,

NULL PROGRAM_APPLICATION_ID,

NULL PROGRAM_ID,

NULL PROGRAM_UPDATE_DATE,

NULL USE_PHANTOM_ROUTINGS,

NULL INHERIT_PHANTOM_OP_SEQ,

NULL DEFAULT_ATP_RULE_ID,

NULL MATERIAL_ACCOUNT,

NULL EXPENSE_ACCOUNT,

NULL ORGANIZATION_TYPE,

NULL SERVICE_LEVEL,

NULL ORG_SUPPLIER_MAPPED,

NULL ACCEPT_DEMANDS_FROM_UNMET_PO,

NULL INHERIT_OC_OP_SEQ_NUM,

NULL SR_BUSINESS_GROUP_ID,

NULL SR_LEGAL_ENTITY,

NULL SR_SET_OF_BOOKS_ID,

NULL SR_CHART_OF_ACCOUNTS_ID,

NULL BUSINESS_GROUP_NAME,

NULL LEGAL_ENTITY_NAME,

NULL OPERATING_UNIT_NAME,

NULL CURRENCY_CODE

from

msc_customers_v mcv