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

TABLE: MSC.MSC_ST_TRADING_PARTNER_SITES

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

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

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

Trading partner unique identifier
PARTNER_SITE_ID NUMBER

Trading partner site unique identifier
PARTNER_ADDRESS VARCHAR2 (2000)
Trading partner address
SR_TP_ID NUMBER (15)
Trading partner unique identifier from source application
SR_TP_SITE_ID NUMBER

Trading partner site unique identifier from source application
TP_SITE_CODE VARCHAR2 (120)
Site code
LOCATION VARCHAR2 (240)
Partner locaion
PARTNER_TYPE NUMBER

Indicate type of partner: Customer, Supplier, or Organization
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
LONGITUDE NUMBER (10)
Longitute
LATITUDE NUMBER (10)
Latitute
OPERATING_UNIT_NAME VARCHAR2 (240)
Operating unit name
COMPANY_ID NUMBER

Company identifier
COMPANY_NAME VARCHAR2 (255)
Company name
PARTNER_NAME VARCHAR2 (1020)
Name of the supplier or customer
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance 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
BATCH_ID NUMBER

Batch identifier generated during pre-processing
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
COUNTRY VARCHAR2 (60)
Country
STATE VARCHAR2 (150)
State
CITY VARCHAR2 (240)
City
POSTAL_CODE VARCHAR2 (60)
Postal code
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
PARTNER_SITE_NUMBER VARCHAR2 (30)
Partner site number
ADDRESS1 VARCHAR2 (960)
Address column
ADDRESS2 VARCHAR2 (960)
Address column
ADDRESS3 VARCHAR2 (960)
Address column
ADDRESS4 VARCHAR2 (960)
Address column
PROVINCE VARCHAR2 (600)
Province
COUNTY VARCHAR2 (150)
County
OPERATING_UNIT NUMBER

Operating Unit
LOCATION_ID NUMBER

Location Identifier
SHIPPING_CONTROL VARCHAR2 (14)
SOURCE_SR_TP_ID NUMBER

SOURCE_SR_TP_SITE_ID NUMBER

CUST_ACCOUNT_NUMBER VARCHAR2 (240)
Query Text

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


SELECT PARTNER_ID
,      PARTNER_SITE_ID
,      PARTNER_ADDRESS
,      SR_TP_ID
,      SR_TP_SITE_ID
,      TP_SITE_CODE
,      LOCATION
,      PARTNER_TYPE
,      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
,      LONGITUDE
,      LATITUDE
,      OPERATING_UNIT_NAME
,      COMPANY_ID
,      COMPANY_NAME
,      PARTNER_NAME
,      SR_INSTANCE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      BATCH_ID
,      ERROR_TEXT
,      COUNTRY
,      STATE
,      CITY
,      POSTAL_CODE
,      ORGANIZATION_CODE
,      PARTNER_SITE_NUMBER
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      PROVINCE
,      COUNTY
,      OPERATING_UNIT
,      LOCATION_ID
,      SHIPPING_CONTROL
,      SOURCE_SR_TP_ID
,      SOURCE_SR_TP_SITE_ID
,      CUST_ACCOUNT_NUMBER
FROM MSC.MSC_ST_TRADING_PARTNER_SITES;

Dependencies

[top of page]

MSC.MSC_ST_TRADING_PARTNER_SITES does not reference any database object

MSC.MSC_ST_TRADING_PARTNER_SITES is referenced by following:

SchemaMSC
ViewMSC_ST_TRADING_PARTNER_SITES#