eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
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
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)
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:

MSC: MSC_ST_TRADING_PARTNERS

MSC.MSC_ST_TRADING_PARTNERS# is referenced by following:

APPS: MSC_ST_TRADING_PARTNERS