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

TABLE: MSC.MSC_ST_TRADING_PARTNERS

Object Details
Object Name: MSC_ST_TRADING_PARTNERS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_TRADING_PARTNERS
Subobject Name:
Status: VALID

The staging table used by the collection program to validate and process data for table MSC_TRADING_PARTNERS.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PARTNER_ID NUMBER

Unique partner identifier which can be customer id, supplier id, or inventory organization id
ORGANIZATION_CODE VARCHAR2 (7)
Organization code
SR_TP_ID NUMBER

Unique partner identifier in the source application instance
DISABLE_DATE DATE

Disable date of the trading partner
STATUS VARCHAR2 (1)
Status of the trading partner
MASTER_ORGANIZATION NUMBER

Master organization identifier
PARTNER_TYPE NUMBER

Specify the type of partner: Customer, Supplier, or organization
PARTNER_NAME VARCHAR2 (1020)
Name of the supplier or customer
PARTNER_NUMBER VARCHAR2 (154)
Number of the supplier or customer
CALENDAR_CODE VARCHAR2 (14)
Calendar used for this partner.The code includes instance code and calendar code from the source app.
CALENDAR_EXCEPTION_SET_ID NUMBER

Calendar exception set identifier
OPERATING_UNIT NUMBER

Operating unit
MAXIMUM_WEIGHT NUMBER

Maximum weight
MAXIMUM_VOLUME NUMBER

Maximum volume
WEIGHT_UOM VARCHAR2 (3)
Weight unit of measure
VOLUME_UOM VARCHAR2 (3)
Volume unit of measure
PROJECT_REFERENCE_ENABLED NUMBER

Project reference enabled flag
PROJECT_CONTROL_LEVEL NUMBER

Project control level
DEMAND_LATENESS_COST NUMBER

Demand lateness cost
SUPPLIER_CAP_OVERUTIL_COST NUMBER

Supplier over-utilization cost
RESOURCE_CAP_OVERUTIL_COST NUMBER

Resource over-utilization cost
DELETED_FLAG NUMBER

Yes/No flag indicates whether corresponding record in ODS will be deleted
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
SR_INSTANCE_ID NUMBER

Source application instance identifier
REFRESH_ID NUMBER

Refresh identifier
MODELED_CUSTOMER_ID NUMBER

Customer identifier which is modelled as inventory organization
MODELED_CUSTOMER_SITE_ID NUMBER

Customer site identifier which is modelled as inventory organization
MODELED_SUPPLIER_ID NUMBER

Supplier dentifier which is modelled as inventory organization
MODELED_SUPPLIER_SITE_ID NUMBER

Supplier site identifier which is modelled as inventory organization
TRANSPORT_CAP_OVER_UTIL_COST NUMBER

Transportation over-utilization cost
USE_PHANTOM_ROUTINGS NUMBER

Use phantom routings
INHERIT_PHANTOM_OP_SEQ NUMBER

Inherit phantom op sequence
DEFAULT_ATP_RULE_ID NUMBER

Default ATP rule identifier
DEFAULT_DEMAND_CLASS VARCHAR2 (34)
Default demand class
MATERIAL_ACCOUNT NUMBER

Material account
EXPENSE_ACCOUNT NUMBER

Expense account
SOURCE_ORG_ID NUMBER

Organization to source items from
ORGANIZATION_TYPE NUMBER

Organization
SERVICE_LEVEL NUMBER

Service level
CUSTOMER_CLASS_CODE VARCHAR2 (30)
Customer Class Code
COMPANY_ID NUMBER

Company identifier
COMPANY_NAME VARCHAR2 (255)
Company name
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance code
DEFAULT_ATP_RULE_NAME VARCHAR2 (80)
ATP Rule
SOURCE_ORG_CODE VARCHAR2 (7)
Source Organization code
MESSAGE_ID NUMBER

This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER

Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
DATA_SOURCE_TYPE VARCHAR2 (15)
Source Type indicating the source of the records
ST_TRANSACTION_ID NUMBER

Transaction ID generated during pre-processing to uniquely identify a record in the staging table
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
BATCH_ID NUMBER

Batch identifier generated during pre-processing
PLANNING_ENABLED_FLAG VARCHAR2 (1)
Planning Enabled Flag
MODELED_CUSTOMER_NAME VARCHAR2 (255)
For Cross Instance Planning, represents the customer code for the instance modelled as customer
MODELED_SUPPLIER_NAME VARCHAR2 (255)
For Cross Instance Planning, represents the supplier for the instance modelled as supplier
MODELED_CUSTOMER_SITE_CODE VARCHAR2 (30)
For Cross Instance Planning, represents the customer code for the instance modelled as customer
MODELED_SUPPLIER_SITE_CODE VARCHAR2 (30)
For Cross Instance Planning, represents the supplier code for the instance modelled as supplier
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

LEGAL_ENTITY NUMBER

SET_OF_BOOKS_ID NUMBER

CHART_OF_ACCOUNTS_ID NUMBER

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

CURRENCY_CODE VARCHAR2 (14)
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
FROM MSC.MSC_ST_TRADING_PARTNERS;

Dependencies

[top of page]

MSC.MSC_ST_TRADING_PARTNERS does not reference any database object

MSC.MSC_ST_TRADING_PARTNERS is referenced by following:

SchemaAPPS
SynonymMSC_ST_TRADING_PARTNERS