VIEW: MSC.MSC_ST_TRADING_PARTNERS#

Source

View Text - Preformatted

select PARTNER_ID PARTNER_ID, ORGANIZATION_CODE ORGANIZATION_CODE, SR_TP_ID SR_TP_ID, DISABLE_DATE DISABLE_DATE, STATUS STATUS, MASTER_ORGANIZATION MASTER_ORGANIZATION, 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, MAXIMUM_WEIGHT MAXIMUM_WEIGHT, MAXIMUM_VOLUME MAXIMUM_VOLUME, WEIGHT_UOM WEIGHT_UOM, VOLUME_UOM VOLUME_UOM, PROJECT_REFERENCE_ENABLED PROJECT_REFERENCE_ENABLED, PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL, DEMAND_LATENESS_COST DEMAND_LATENESS_COST, SUPPLIER_CAP_OVERUTIL_COST SUPPLIER_CAP_OVERUTIL_COST, RESOURCE_CAP_OVERUTIL_COST RESOURCE_CAP_OVERUTIL_COST, DELETED_FLAG DELETED_FLAG, 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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, 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, USE_PHANTOM_ROUTINGS USE_PHANTOM_ROUTINGS, INHERIT_PHANTOM_OP_SEQ INHERIT_PHANTOM_OP_SEQ, DEFAULT_ATP_RULE_ID DEFAULT_ATP_RULE_ID, DEFAULT_DEMAND_CLASS DEFAULT_DEMAND_CLASS, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, EXPENSE_ACCOUNT EXPENSE_ACCOUNT, SOURCE_ORG_ID SOURCE_ORG_ID, ORGANIZATION_TYPE ORGANIZATION_TYPE, SERVICE_LEVEL SERVICE_LEVEL, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, DEFAULT_ATP_RULE_NAME DEFAULT_ATP_RULE_NAME, SOURCE_ORG_CODE SOURCE_ORG_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, BATCH_ID BATCH_ID, PLANNING_ENABLED_FLAG PLANNING_ENABLED_FLAG, MODELED_CUSTOMER_NAME MODELED_CUSTOMER_NAME, MODELED_SUPPLIER_NAME MODELED_SUPPLIER_NAME, MODELED_CUSTOMER_SITE_CODE MODELED_CUSTOMER_SITE_CODE, MODELED_SUPPLIER_SITE_CODE MODELED_SUPPLIER_SITE_CODE, MASTER_ORGANIZATION_CODE MASTER_ORGANIZATION_CODE, INHERIT_OC_OP_SEQ_NUM INHERIT_OC_OP_SEQ_NUM, AGGREGATE_DEMAND_FLAG AGGREGATE_DEMAND_FLAG, SOURCE_SOURCE_ORG_ID SOURCE_SOURCE_ORG_ID, SOURCE_SR_TP_ID SOURCE_SR_TP_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGAL_ENTITY LEGAL_ENTITY, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID 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, CUST_ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER, RESOURCE_TYPE RESOURCE_TYPE, CURRENCY_CODE CURRENCY_CODE, SUBCONTRACTING_SOURCE_ORG SUBCONTRACTING_SOURCE_ORG from "MSC"."MSC_ST_TRADING_PARTNERS"

View Text - HTML Formatted

SELECT PARTNER_ID PARTNER_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_TP_ID SR_TP_ID
, DISABLE_DATE DISABLE_DATE
, STATUS STATUS
, MASTER_ORGANIZATION MASTER_ORGANIZATION
, 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
, MAXIMUM_WEIGHT MAXIMUM_WEIGHT
, MAXIMUM_VOLUME MAXIMUM_VOLUME
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_UOM VOLUME_UOM
, PROJECT_REFERENCE_ENABLED PROJECT_REFERENCE_ENABLED
, PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL
, DEMAND_LATENESS_COST DEMAND_LATENESS_COST
, SUPPLIER_CAP_OVERUTIL_COST SUPPLIER_CAP_OVERUTIL_COST
, RESOURCE_CAP_OVERUTIL_COST RESOURCE_CAP_OVERUTIL_COST
, DELETED_FLAG DELETED_FLAG
, 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
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, 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
, USE_PHANTOM_ROUTINGS USE_PHANTOM_ROUTINGS
, INHERIT_PHANTOM_OP_SEQ INHERIT_PHANTOM_OP_SEQ
, DEFAULT_ATP_RULE_ID DEFAULT_ATP_RULE_ID
, DEFAULT_DEMAND_CLASS DEFAULT_DEMAND_CLASS
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, SOURCE_ORG_ID SOURCE_ORG_ID
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, SERVICE_LEVEL SERVICE_LEVEL
, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, DEFAULT_ATP_RULE_NAME DEFAULT_ATP_RULE_NAME
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, BATCH_ID BATCH_ID
, PLANNING_ENABLED_FLAG PLANNING_ENABLED_FLAG
, MODELED_CUSTOMER_NAME MODELED_CUSTOMER_NAME
, MODELED_SUPPLIER_NAME MODELED_SUPPLIER_NAME
, MODELED_CUSTOMER_SITE_CODE MODELED_CUSTOMER_SITE_CODE
, MODELED_SUPPLIER_SITE_CODE MODELED_SUPPLIER_SITE_CODE
, MASTER_ORGANIZATION_CODE MASTER_ORGANIZATION_CODE
, INHERIT_OC_OP_SEQ_NUM INHERIT_OC_OP_SEQ_NUM
, AGGREGATE_DEMAND_FLAG AGGREGATE_DEMAND_FLAG
, SOURCE_SOURCE_ORG_ID SOURCE_SOURCE_ORG_ID
, SOURCE_SR_TP_ID SOURCE_SR_TP_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGAL_ENTITY LEGAL_ENTITY
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID 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
, CUST_ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER
, RESOURCE_TYPE RESOURCE_TYPE
, CURRENCY_CODE CURRENCY_CODE
, SUBCONTRACTING_SOURCE_ORG SUBCONTRACTING_SOURCE_ORG
FROM "MSC"."MSC_ST_TRADING_PARTNERS"