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]

TABLE: MSC.MSC_OUTBOUND_ENTRIES

Object Details

Object Name:	MSC_OUTBOUND_ENTRIES
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_OUTBOUND_ENTRIES
Subobject Name:
Status:	VALID

Outbound XML transactions from Collaborative Planning

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
DOCUMENT_NUMBER	VARCHAR2	(240)	Document Number
RESPONSE_NUMBER	VARCHAR2	(240)	Response Number
PUBLISHER_NAME	VARCHAR2	(255)	Publisher Name
PUBLISHER_SITE_NAME	VARCHAR2	(40)	Publisher Site Name
CUSTOMER_NAME	VARCHAR2	(255)	Customer Name
CUSTOMER_SITE_NAME	VARCHAR2	(40)	Customer Site Name
SUPPLIER_NAME	VARCHAR2	(255)	Supplier Name
SUPPLIER_SITE_NAME	VARCHAR2	(40)	Supplier Site Name
SHIP_TO_PARTY_NAME	VARCHAR2	(255)	Ship To Party Name
SHIP_TO_PARTY_SITE_NAME	VARCHAR2	(40)	Ship To Party Site Name
SHIP_FROM_PARTY_NAME	VARCHAR2	(255)	Ship From Party Name
SHIP_FROM_PARTY_SITE_NAME	VARCHAR2	(40)	Ship From Party Site Name
ITEM_NAME	VARCHAR2	(240)	Item Name
PUBLISHER_ORDER_TYPE	VARCHAR2	(80)	Publisher Order Type
REF_HEADER_ID	NUMBER		Ref Header Id
QUANTITY	NUMBER		Quantity
SHIP_DATE	DATE		Ship Date
RECEIPT_DATE	DATE		Receipt Date
KEY_DATE	DATE		Key Date
BUCKET_TYPE	VARCHAR2	(30)	Bucket Type
UOM_CODE	VARCHAR2	(3)	Uom Code
DESIGNATOR	VARCHAR2	(100)	Designator
VERSION	VARCHAR2	(240)	Version
COMMENTS	VARCHAR2	(1000)	Comments
SOURCE_LOCATION_CODE	VARCHAR2	(200)	Source Location Code
EXTERNAL_LOCATION_CODE	VARCHAR2	(200)	External Location Code

Query Text

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


SELECT DOCUMENT_NUMBER
,      RESPONSE_NUMBER
,      PUBLISHER_NAME
,      PUBLISHER_SITE_NAME
,      CUSTOMER_NAME
,      CUSTOMER_SITE_NAME
,      SUPPLIER_NAME
,      SUPPLIER_SITE_NAME
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_PARTY_SITE_NAME
,      SHIP_FROM_PARTY_NAME
,      SHIP_FROM_PARTY_SITE_NAME
,      ITEM_NAME
,      PUBLISHER_ORDER_TYPE
,      REF_HEADER_ID
,      QUANTITY
,      SHIP_DATE
,      RECEIPT_DATE
,      KEY_DATE
,      BUCKET_TYPE
,      UOM_CODE
,      DESIGNATOR
,      VERSION
,      COMMENTS
,      SOURCE_LOCATION_CODE
,      EXTERNAL_LOCATION_CODE
FROM MSC.MSC_OUTBOUND_ENTRIES;

Dependencies

[top of page]

MSC.MSC_OUTBOUND_ENTRIES does not reference any database object

MSC.MSC_OUTBOUND_ENTRIES is referenced by following:

MSC: MSC_OUTBOUND_ENTRIES#