[Home] [Help] [Dependency Information]
Object Name: | WSH_DELIVERIES_DPW_LOV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OE.WSH_DELIVERIES_DPW_LOV_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_ID | NUMBER | Yes | ||
DELIVERY_NAME | VARCHAR2 | (15) | Yes | |
ORGANIZATION_ID | NUMBER | Yes | ||
STATUS_CODE | VARCHAR2 | (2) | Yes | |
SOURCE_CODE | VARCHAR2 | (1) | Yes | |
EXPECTED_ARRIVAL_DATE | DATE | |||
ACTUAL_DEPARTURE_ID | NUMBER | |||
DEPARTURE_NAME | VARCHAR2 | (30) | ||
CUSTOMER_ID | NUMBER | Yes | ||
ULTIMATE_SHIP_TO_ID | NUMBER | Yes | ||
INTERMEDIATE_SHIP_TO_ID | NUMBER | |||
FOB_CODE | VARCHAR2 | (30) | ||
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_ID
, DELIVERY_NAME
, ORGANIZATION_ID
, STATUS_CODE
, SOURCE_CODE
, EXPECTED_ARRIVAL_DATE
, ACTUAL_DEPARTURE_ID
, DEPARTURE_NAME
, CUSTOMER_ID
, ULTIMATE_SHIP_TO_ID
, INTERMEDIATE_SHIP_TO_ID
, FOB_CODE
, FREIGHT_TERMS_CODE
, FREIGHT_CARRIER_CODE
, CURRENCY_CODE
FROM APPS.WSH_DELIVERIES_DPW_LOV_V;
APPS.WSH_DELIVERIES_DPW_LOV_V is not referenced by any database object
|
|
|