[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_SHIPMENTS_V

Object Details

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      QUERY_ID
,      SHIPMENT_ID
,      PLAN_ID
,      SHIP_DATE
,      DOCK_DATE
,      FROM_ORG_ID
,      FROM_ORG_INSTANCE_ID
,      FROM_ORG_CODE
,      TO_ORG_ID
,      TO_ORG_INSTANCE_ID
,      TO_ORG_CODE
,      EXISTING_TRIP
,      TRIP_NAME
,      WEIGHT
,      VOLUME
,      PIECES
,      WEIGHT_UOM
,      VOLUME_UOM
,      AVAILABLE_WEIGHT
,      AVAILABLE_VOLUME
,      WEIGHT_UTILIZATION
,      VOLUME_UTILIZATION
,      SHIP_METHOD
,      MODE_OF_TRANSPORT
,      SERVICE_LEVEL
,      CARRIER_ID
,      CARRIER
,      SELECTED_FOR_RELEASE
,      RELEASED_STATUS
,      RELEASED_DATE
,      SHIPMENT_STATUS
,      FIRM_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STATUS
,      APPLIED
,      INTRANSIT_TIME
,      EARLIEST_SHIP_DATE
,      EARLIEST_NEED_BY_DATE
,      COST_UNDER_UTIL
,      AVAILABLE_WT_RATE
,      AVAILABLE_VL_RATE
,      WEIGHT_CAPACITY
,      VOLUME_CAPACITY
,      MODE_CODE
FROM APPS.MSC_SHIPMENTS_V;

Dependencies

[top of page]

APPS

MSC_CARRIER_SERVICES

MSC_DRP_UTIL - show dependent code

MSC_FORM_QUERY

MSC_GET_NAME - show dependent code

MSC_SHIPMENTS

MSC_TRADING_PARTNERS

APPS.MSC_SHIPMENTS_V is not referenced by any database object