[Home] [Help]
[Dependency Information]
Object Name: | MSD_SR_SHIPMENT_DATA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the Source View for Shipment. This view would be applied to an Oracle Applications 11i instance from which the Shipment information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INV_ORG_PK | NUMBER | Inv Org Pk | ||
INV_ORG | VARCHAR2 | (0) | Inv Org | |
SR_ITEM_PK | NUMBER | Item Pk | ||
ITEM | VARCHAR2 | (0) | Item | |
SR_CUSTOMER_PK | NUMBER | Customer Pk | ||
CUSTOMER | VARCHAR2 | (0) | Customer | |
SR_SALES_CHANNEL_PK | VARCHAR2 | (40) | Sales Channel Pk | |
SALES_CHANNEL | VARCHAR2 | (0) | Sales Channel | |
SR_SALES_REP_PK | NUMBER | Sales Rep Pk | ||
SALES_REP | VARCHAR2 | (0) | Sales Rep | |
SR_SHIP_TO_LOC_PK | NUMBER | Ship To Loc Pk | ||
SHIP_TO_LOC | VARCHAR2 | (0) | Ship To Loc | |
BOOKED_DATE | DATE | Booked Date | ||
REQUESTED_DATE | DATE | Requested Date | ||
PROMISED_DATE | DATE | Promised Date | ||
SCHEDULED_SHIP_DATE | DATE | Scheduled Ship Date | ||
SCHEDULED_ARRIVAL_DATE | DATE | Scheduled Arrival Date | ||
SHIPPED_DATE | DATE | Shipped Date | ||
AMOUNT | NUMBER | Amount | ||
QTY_SHIPPED | NUMBER | Qty Shipped | ||
SR_USER_DEFINED1_PK | NUMBER | User Defined1 Pk | ||
USER_DEFINED1 | VARCHAR2 | (0) | User Defined1 | |
SR_USER_DEFINED2_PK | NUMBER | User Defined2 Pk | ||
USER_DEFINED2 | VARCHAR2 | (0) | User Defined2 | |
SR_ORIGINAL_ITEM_PK | NUMBER | Original Item Pk | ||
SR_PARENT_ITEM_PK | VARCHAR2 | (40) | Source Parent Item Primary Key | |
SR_DEMAND_CLASS_PK | VARCHAR2 | (40) | Source Demand Class Primary Key | |
ORDER_SOURCE_ID | NUMBER | Source of the order. | ||
ORDER_TYPE_ID | NUMBER | Type of the order. |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INV_ORG_PK
, INV_ORG
, SR_ITEM_PK
, ITEM
, SR_CUSTOMER_PK
, CUSTOMER
, SR_SALES_CHANNEL_PK
, SALES_CHANNEL
, SR_SALES_REP_PK
, SALES_REP
, SR_SHIP_TO_LOC_PK
, SHIP_TO_LOC
, BOOKED_DATE
, REQUESTED_DATE
, PROMISED_DATE
, SCHEDULED_SHIP_DATE
, SCHEDULED_ARRIVAL_DATE
, SHIPPED_DATE
, AMOUNT
, QTY_SHIPPED
, SR_USER_DEFINED1_PK
, USER_DEFINED1
, SR_USER_DEFINED2_PK
, USER_DEFINED2
, SR_ORIGINAL_ITEM_PK
, SR_PARENT_ITEM_PK
, SR_DEMAND_CLASS_PK
, ORDER_SOURCE_ID
, ORDER_TYPE_ID
FROM APPS.MSD_SR_SHIPMENT_DATA_V;
APPS.MSD_SR_SHIPMENT_DATA_V is not referenced by any database object
|
|
|