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

VIEW: APPS.SO_DELIVERIES_V

Object Details
Object Name: SO_DELIVERIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOE.SO_DELIVERIES_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORDER_NUMBER NUMBER

WAREHOUSE_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (3)
CUSTOMER_ID NUMBER

DEPARTURE_ID NUMBER

DEPARTURE_NAME VARCHAR2 (30)
DEPARTURE_STATUS_CODE VARCHAR2 (2)
DEPARTURE_STATUS VARCHAR2 (80)
DEPARTURE_DATE DATE

DELIVERY_ID NUMBER

DELIVERY_NAME VARCHAR2 (15)
DELIVERY_STATUS_CODE VARCHAR2 (2)
DELIVERY_STATUS VARCHAR2 (80)
WAYBILL VARCHAR2 (30)
EXPECTED_ARRIVAL_DATE DATE

BILL_OF_LADING VARCHAR2 (30)
DPW_ASSIGNED_FLAG VARCHAR2 (1)
FREIGHT_CARRIER_CODE VARCHAR2 (30)
SHIP_TO_SITE_USE_ID NUMBER

SHIP_TO_CONTACT_ID NUMBER

Query Text

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


SELECT ORDER_NUMBER
,      WAREHOUSE_ID
,      ORGANIZATION_CODE
,      CUSTOMER_ID
,      DEPARTURE_ID
,      DEPARTURE_NAME
,      DEPARTURE_STATUS_CODE
,      DEPARTURE_STATUS
,      DEPARTURE_DATE
,      DELIVERY_ID
,      DELIVERY_NAME
,      DELIVERY_STATUS_CODE
,      DELIVERY_STATUS
,      WAYBILL
,      EXPECTED_ARRIVAL_DATE
,      BILL_OF_LADING
,      DPW_ASSIGNED_FLAG
,      FREIGHT_CARRIER_CODE
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
FROM APPS.SO_DELIVERIES_V;

Dependencies

[top of page]

APPS.SO_DELIVERIES_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMTL_PARAMETERS
SynonymSO_HEADERS_ALL
SynonymSO_LINES_ALL
SynonymSO_LINE_DETAILS
SynonymSO_LOOKUPS
SynonymSO_PICKING_HEADERS_ALL
SynonymSO_PICKING_LINES_ALL
SynonymSO_PICKING_LINE_DETAILS
SynonymWSH_DELIVERIES
SynonymWSH_DEPARTURES

APPS.SO_DELIVERIES_V is not referenced by any database object