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

VIEW: MSD.MSD_SHIPMENT_DATA#

Object Details
Object Name: MSD_SHIPMENT_DATA#
Object Type: VIEW
Owner: MSD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40) Yes
INV_ORG VARCHAR2 (320)
ITEM VARCHAR2 (320)
CUSTOMER VARCHAR2 (320)
SALES_CHANNEL VARCHAR2 (320)
SALES_REP VARCHAR2 (1000)
SHIP_TO_LOC VARCHAR2 (320)
USER_DEFINED1 VARCHAR2 (320)
USER_DEFINED2 VARCHAR2 (320)
BOOKED_DATE DATE

REQUESTED_DATE DATE

PROMISED_DATE DATE

SHIPPED_DATE DATE
Yes
AMOUNT NUMBER

QTY_SHIPPED NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SR_INV_ORG_PK VARCHAR2 (240) Yes
SR_ITEM_PK VARCHAR2 (240) Yes
SR_CUSTOMER_PK VARCHAR2 (240)
SR_SALES_CHANNEL_PK VARCHAR2 (240) Yes
SR_SALES_REP_PK VARCHAR2 (240) Yes
SR_SHIP_TO_LOC_PK VARCHAR2 (240) Yes
SR_USER_DEFINED1_PK VARCHAR2 (240) Yes
SR_USER_DEFINED2_PK VARCHAR2 (240) Yes
SR_ORIGINAL_ITEM_PK VARCHAR2 (240)
LAST_REFRESH_NUM NUMBER

CREATED_BY_REFRESH_NUM NUMBER

ACTION_CODE VARCHAR2 (30)
SR_PARENT_ITEM_PK VARCHAR2 (240)
SCHEDULED_SHIP_DATE DATE

SCHEDULED_ARRIVAL_DATE DATE

SR_DEMAND_CLASS_PK VARCHAR2 (240)
ORDER_SOURCE_ID NUMBER

Query Text

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


SELECT INSTANCE
,      INV_ORG
,      ITEM
,      CUSTOMER
,      SALES_CHANNEL
,      SALES_REP
,      SHIP_TO_LOC
,      USER_DEFINED1
,      USER_DEFINED2
,      BOOKED_DATE
,      REQUESTED_DATE
,      PROMISED_DATE
,      SHIPPED_DATE
,      AMOUNT
,      QTY_SHIPPED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INV_ORG_PK
,      SR_ITEM_PK
,      SR_CUSTOMER_PK
,      SR_SALES_CHANNEL_PK
,      SR_SALES_REP_PK
,      SR_SHIP_TO_LOC_PK
,      SR_USER_DEFINED1_PK
,      SR_USER_DEFINED2_PK
,      SR_ORIGINAL_ITEM_PK
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
,      SR_PARENT_ITEM_PK
,      SCHEDULED_SHIP_DATE
,      SCHEDULED_ARRIVAL_DATE
,      SR_DEMAND_CLASS_PK
,      ORDER_SOURCE_ID
FROM MSD.MSD_SHIPMENT_DATA#;

Dependencies

[top of page]

MSD.MSD_SHIPMENT_DATA# references the following:

SchemaMSD
TableMSD_SHIPMENT_DATA
MSD.MSD_SHIPMENT_DATA# is referenced by following:

SchemaAPPS
SynonymMSD_SHIPMENT_DATA