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

VIEW: MSC.MSC_OUTBOUND_ENTRIES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_NUMBER VARCHAR2 (240)
RESPONSE_NUMBER VARCHAR2 (240)
PUBLISHER_NAME VARCHAR2 (255)
PUBLISHER_SITE_NAME VARCHAR2 (40)
CUSTOMER_NAME VARCHAR2 (255)
CUSTOMER_SITE_NAME VARCHAR2 (40)
SUPPLIER_NAME VARCHAR2 (255)
SUPPLIER_SITE_NAME VARCHAR2 (40)
SHIP_TO_PARTY_NAME VARCHAR2 (255)
SHIP_TO_PARTY_SITE_NAME VARCHAR2 (40)
SHIP_FROM_PARTY_NAME VARCHAR2 (255)
SHIP_FROM_PARTY_SITE_NAME VARCHAR2 (40)
ITEM_NAME VARCHAR2 (240)
PUBLISHER_ORDER_TYPE VARCHAR2 (80)
REF_HEADER_ID NUMBER

QUANTITY NUMBER

SHIP_DATE DATE

RECEIPT_DATE DATE

KEY_DATE DATE

BUCKET_TYPE VARCHAR2 (30)
UOM_CODE VARCHAR2 (3)
DESIGNATOR VARCHAR2 (100)
VERSION VARCHAR2 (240)
COMMENTS VARCHAR2 (1000)
SOURCE_LOCATION_CODE VARCHAR2 (200)
EXTERNAL_LOCATION_CODE VARCHAR2 (200)
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# references the following:

SchemaMSC
TableMSC_OUTBOUND_ENTRIES
MSC.MSC_OUTBOUND_ENTRIES# is referenced by following:

SchemaAPPS
SynonymMSC_OUTBOUND_ENTRIES