Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: MSC.MSC_ST_TRADING_PARTNERS#

Object Details
Object Name: MSC_ST_TRADING_PARTNERS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTNER_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (7)
SR_TP_ID NUMBER

DISABLE_DATE DATE

STATUS VARCHAR2 (1)
MASTER_ORGANIZATION NUMBER

PARTNER_TYPE NUMBER

PARTNER_NAME VARCHAR2 (1020)
PARTNER_NUMBER VARCHAR2 (154)
CALENDAR_CODE VARCHAR2 (14)
CALENDAR_EXCEPTION_SET_ID NUMBER

OPERATING_UNIT NUMBER

MAXIMUM_WEIGHT NUMBER

MAXIMUM_VOLUME NUMBER

WEIGHT_UOM VARCHAR2 (3)
VOLUME_UOM VARCHAR2 (3)
PROJECT_REFERENCE_ENABLED NUMBER

PROJECT_CONTROL_LEVEL NUMBER

DEMAND_LATENESS_COST NUMBER

SUPPLIER_CAP_OVERUTIL_COST NUMBER

RESOURCE_CAP_OVERUTIL_COST NUMBER

DELETED_FLAG NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SR_INSTANCE_ID NUMBER

REFRESH_ID NUMBER

MODELED_CUSTOMER_ID NUMBER

MODELED_CUSTOMER_SITE_ID NUMBER

MODELED_SUPPLIER_ID NUMBER

MODELED_SUPPLIER_SITE_ID NUMBER

TRANSPORT_CAP_OVER_UTIL_COST NUMBER

USE_PHANTOM_ROUTINGS NUMBER

INHERIT_PHANTOM_OP_SEQ NUMBER

DEFAULT_ATP_RULE_ID NUMBER

DEFAULT_DEMAND_CLASS VARCHAR2 (34)
MATERIAL_ACCOUNT NUMBER

EXPENSE_ACCOUNT NUMBER

SOURCE_ORG_ID NUMBER

ORGANIZATION_TYPE NUMBER

SERVICE_LEVEL NUMBER

CUSTOMER_CLASS_CODE VARCHAR2 (30)
COMPANY_ID NUMBER

COMPANY_NAME VARCHAR2 (255)
SR_INSTANCE_CODE VARCHAR2 (3)
DEFAULT_ATP_RULE_NAME VARCHAR2 (80)
SOURCE_ORG_CODE VARCHAR2 (7)
MESSAGE_ID NUMBER

PROCESS_FLAG NUMBER

DATA_SOURCE_TYPE VARCHAR2 (15)
ST_TRANSACTION_ID NUMBER

ERROR_TEXT VARCHAR2 (2000)
BATCH_ID NUMBER

PLANNING_ENABLED_FLAG VARCHAR2 (1)
MODELED_CUSTOMER_NAME VARCHAR2 (255)
MODELED_SUPPLIER_NAME VARCHAR2 (255)
MODELED_CUSTOMER_SITE_CODE VARCHAR2 (30)
MODELED_SUPPLIER_SITE_CODE VARCHAR2 (30)
MASTER_ORGANIZATION_CODE VARCHAR2 (7)
INHERIT_OC_OP_SEQ_NUM NUMBER

AGGREGATE_DEMAND_FLAG NUMBER

SOURCE_SOURCE_ORG_ID NUMBER

SOURCE_SR_TP_ID NUMBER

BUSINESS_GROUP_ID NUMBER

SET_OF_BOOKS_ID NUMBER

CHART_OF_ACCOUNTS_ID NUMBER

CUSTOMER_TYPE VARCHAR2 (240)
BUSINESS_GROUP_NAME VARCHAR2 (240)
OPERATING_UNIT_NAME VARCHAR2 (240)
CUST_ACCOUNT_NUMBER VARCHAR2 (240)
RESOURCE_TYPE NUMBER

CURRENCY_CODE VARCHAR2 (14)
SUBCONTRACTING_SOURCE_ORG NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARTNER_ID
,      ORGANIZATION_CODE
,      SR_TP_ID
,      DISABLE_DATE
,      STATUS
,      MASTER_ORGANIZATION
,      PARTNER_TYPE
,      PARTNER_NAME
,      PARTNER_NUMBER
,      CALENDAR_CODE
,      CALENDAR_EXCEPTION_SET_ID
,      OPERATING_UNIT
,      MAXIMUM_WEIGHT
,      MAXIMUM_VOLUME
,      WEIGHT_UOM
,      VOLUME_UOM
,      PROJECT_REFERENCE_ENABLED
,      PROJECT_CONTROL_LEVEL
,      DEMAND_LATENESS_COST
,      SUPPLIER_CAP_OVERUTIL_COST
,      RESOURCE_CAP_OVERUTIL_COST
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      REFRESH_ID
,      MODELED_CUSTOMER_ID
,      MODELED_CUSTOMER_SITE_ID
,      MODELED_SUPPLIER_ID
,      MODELED_SUPPLIER_SITE_ID
,      TRANSPORT_CAP_OVER_UTIL_COST
,      USE_PHANTOM_ROUTINGS
,      INHERIT_PHANTOM_OP_SEQ
,      DEFAULT_ATP_RULE_ID
,      DEFAULT_DEMAND_CLASS
,      MATERIAL_ACCOUNT
,      EXPENSE_ACCOUNT
,      SOURCE_ORG_ID
,      ORGANIZATION_TYPE
,      SERVICE_LEVEL
,      CUSTOMER_CLASS_CODE
,      COMPANY_ID
,      COMPANY_NAME
,      SR_INSTANCE_CODE
,      DEFAULT_ATP_RULE_NAME
,      SOURCE_ORG_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      BATCH_ID
,      PLANNING_ENABLED_FLAG
,      MODELED_CUSTOMER_NAME
,      MODELED_SUPPLIER_NAME
,      MODELED_CUSTOMER_SITE_CODE
,      MODELED_SUPPLIER_SITE_CODE
,      MASTER_ORGANIZATION_CODE
,      INHERIT_OC_OP_SEQ_NUM
,      AGGREGATE_DEMAND_FLAG
,      SOURCE_SOURCE_ORG_ID
,      SOURCE_SR_TP_ID
,      BUSINESS_GROUP_ID
,      LEGAL_ENTITY
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      CUSTOMER_TYPE
,      BUSINESS_GROUP_NAME
,      LEGAL_ENTITY_NAME
,      OPERATING_UNIT_NAME
,      CUST_ACCOUNT_NUMBER
,      RESOURCE_TYPE
,      CURRENCY_CODE
,      SUBCONTRACTING_SOURCE_ORG
FROM MSC.MSC_ST_TRADING_PARTNERS#;

Dependencies

[top of page]

MSC.MSC_ST_TRADING_PARTNERS# references the following:

SchemaMSC
TableMSC_ST_TRADING_PARTNERS
MSC.MSC_ST_TRADING_PARTNERS# is referenced by following:

SchemaAPPS
SynonymMSC_ST_TRADING_PARTNERS