VIEW: MSC.MSC_TRADING_PARTNERS#

Source

View Text - Preformatted

select PARTNER_ID PARTNER_ID, SR_TP_ID SR_TP_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_CODE ORGANIZATION_CODE, DISABLE_DATE DISABLE_DATE, STATUS STATUS, MASTER_ORGANIZATION MASTER_ORGANIZATION, WEIGHT_UOM WEIGHT_UOM, MAXIMUM_WEIGHT MAXIMUM_WEIGHT, VOLUME_UOM VOLUME_UOM, MAXIMUM_VOLUME MAXIMUM_VOLUME, PARTNER_TYPE PARTNER_TYPE, PARTNER_NAME PARTNER_NAME, PARTNER_NUMBER PARTNER_NUMBER, CALENDAR_CODE CALENDAR_CODE, CALENDAR_EXCEPTION_SET_ID CALENDAR_EXCEPTION_SET_ID, OPERATING_UNIT OPERATING_UNIT, PROJECT_REFERENCE_ENABLED PROJECT_REFERENCE_ENABLED, PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL, SOURCE_ORG_ID SOURCE_ORG_ID, DEMAND_LATENESS_COST DEMAND_LATENESS_COST, SUPPLIER_CAP_OVERUTIL_COST SUPPLIER_CAP_OVERUTIL_COST, RESOURCE_CAP_OVERUTIL_COST RESOURCE_CAP_OVERUTIL_COST, DEFAULT_DEMAND_CLASS DEFAULT_DEMAND_CLASS, MODELED_CUSTOMER_ID MODELED_CUSTOMER_ID, MODELED_CUSTOMER_SITE_ID MODELED_CUSTOMER_SITE_ID, MODELED_SUPPLIER_ID MODELED_SUPPLIER_ID, MODELED_SUPPLIER_SITE_ID MODELED_SUPPLIER_SITE_ID, TRANSPORT_CAP_OVER_UTIL_COST TRANSPORT_CAP_OVER_UTIL_COST, REFRESH_NUMBER REFRESH_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, USE_PHANTOM_ROUTINGS USE_PHANTOM_ROUTINGS, INHERIT_PHANTOM_OP_SEQ INHERIT_PHANTOM_OP_SEQ, DEFAULT_ATP_RULE_ID DEFAULT_ATP_RULE_ID, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, EXPENSE_ACCOUNT EXPENSE_ACCOUNT, ORGANIZATION_TYPE ORGANIZATION_TYPE, SERVICE_LEVEL SERVICE_LEVEL, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE, COMPANY_ID COMPANY_ID, ORG_SUPPLIER_MAPPED ORG_SUPPLIER_MAPPED, INHERIT_OC_OP_SEQ_NUM INHERIT_OC_OP_SEQ_NUM, ACCEPT_DEMANDS_FROM_UNMET_PO ACCEPT_DEMANDS_FROM_UNMET_PO, SR_BUSINESS_GROUP_ID SR_BUSINESS_GROUP_ID, SR_LEGAL_ENTITY SR_LEGAL_ENTITY, SR_SET_OF_BOOKS_ID SR_SET_OF_BOOKS_ID, SR_CHART_OF_ACCOUNTS_ID SR_CHART_OF_ACCOUNTS_ID, CUSTOMER_TYPE CUSTOMER_TYPE, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, OPERATING_UNIT_NAME OPERATING_UNIT_NAME, CURRENCY_CODE CURRENCY_CODE, SUBCONTRACTING_SOURCE_ORG SUBCONTRACTING_SOURCE_ORG from "MSC"."MSC_TRADING_PARTNERS"

View Text - HTML Formatted

SELECT PARTNER_ID PARTNER_ID
, SR_TP_ID SR_TP_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, DISABLE_DATE DISABLE_DATE
, STATUS STATUS
, MASTER_ORGANIZATION MASTER_ORGANIZATION
, WEIGHT_UOM WEIGHT_UOM
, MAXIMUM_WEIGHT MAXIMUM_WEIGHT
, VOLUME_UOM VOLUME_UOM
, MAXIMUM_VOLUME MAXIMUM_VOLUME
, PARTNER_TYPE PARTNER_TYPE
, PARTNER_NAME PARTNER_NAME
, PARTNER_NUMBER PARTNER_NUMBER
, CALENDAR_CODE CALENDAR_CODE
, CALENDAR_EXCEPTION_SET_ID CALENDAR_EXCEPTION_SET_ID
, OPERATING_UNIT OPERATING_UNIT
, PROJECT_REFERENCE_ENABLED PROJECT_REFERENCE_ENABLED
, PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL
, SOURCE_ORG_ID SOURCE_ORG_ID
, DEMAND_LATENESS_COST DEMAND_LATENESS_COST
, SUPPLIER_CAP_OVERUTIL_COST SUPPLIER_CAP_OVERUTIL_COST
, RESOURCE_CAP_OVERUTIL_COST RESOURCE_CAP_OVERUTIL_COST
, DEFAULT_DEMAND_CLASS DEFAULT_DEMAND_CLASS
, MODELED_CUSTOMER_ID MODELED_CUSTOMER_ID
, MODELED_CUSTOMER_SITE_ID MODELED_CUSTOMER_SITE_ID
, MODELED_SUPPLIER_ID MODELED_SUPPLIER_ID
, MODELED_SUPPLIER_SITE_ID MODELED_SUPPLIER_SITE_ID
, TRANSPORT_CAP_OVER_UTIL_COST TRANSPORT_CAP_OVER_UTIL_COST
, REFRESH_NUMBER REFRESH_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, USE_PHANTOM_ROUTINGS USE_PHANTOM_ROUTINGS
, INHERIT_PHANTOM_OP_SEQ INHERIT_PHANTOM_OP_SEQ
, DEFAULT_ATP_RULE_ID DEFAULT_ATP_RULE_ID
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, SERVICE_LEVEL SERVICE_LEVEL
, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, COMPANY_ID COMPANY_ID
, ORG_SUPPLIER_MAPPED ORG_SUPPLIER_MAPPED
, INHERIT_OC_OP_SEQ_NUM INHERIT_OC_OP_SEQ_NUM
, ACCEPT_DEMANDS_FROM_UNMET_PO ACCEPT_DEMANDS_FROM_UNMET_PO
, SR_BUSINESS_GROUP_ID SR_BUSINESS_GROUP_ID
, SR_LEGAL_ENTITY SR_LEGAL_ENTITY
, SR_SET_OF_BOOKS_ID SR_SET_OF_BOOKS_ID
, SR_CHART_OF_ACCOUNTS_ID SR_CHART_OF_ACCOUNTS_ID
, CUSTOMER_TYPE CUSTOMER_TYPE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, CURRENCY_CODE CURRENCY_CODE
, SUBCONTRACTING_SOURCE_ORG SUBCONTRACTING_SOURCE_ORG
FROM "MSC"."MSC_TRADING_PARTNERS"