eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WMS_WP_WWB_LINES_V

Object Details

Object Name:	WMS_WP_WWB_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WMS.WMS_WP_WWB_LINES_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORDER_NUMBER	VARCHAR2	(150)
DELIVER_TO	VARCHAR2	(500)
DELIVERY	VARCHAR2	(30)
EXCEPTION_ID	NUMBER
ITEM	VARCHAR2	(40)
REQUESTED_QTY	NUMBER		Yes
PLANNED_FILL_RATE	NUMBER
RELEASE_FILL_RATE	NUMBER
PICK_FILL_RATE	NUMBER
SHIP_TO	VARCHAR2	(500)
SHIPPED_QTY	NUMBER
DATE_SCHEDULED	DATE
BATCH	NUMBER
CARRIER	VARCHAR2	(30)
LINE_SHIP_TO_CONTACT	VARCHAR2	(500)
CUST_MODEL_SERIAL_NUMBER	VARCHAR2	(50)
LINE_REQUEST_DATE	DATE
DELIVER_TO_CONTACT	VARCHAR2	(500)
DELIVER_TO_LOCATION	VARCHAR2	(500)
DELIVERED_QUANTITY	NUMBER
EARLIEST_DROPOFF_DATE	DATE
EARLIEST_SHIP_DATE	DATE
FOB_CODE	VARCHAR2	(30)
FREIGHT_TERMS_CODE	VARCHAR2	(30)
PREFERRED_GRADE	VARCHAR2	(150)
GROSS_WEIGHT	NUMBER
HAZARD_CLASS_ID	NUMBER
IGNORE_FOR_PLANNING	VARCHAR2	(1)
INSPECTION_FLAG	VARCHAR2	(1)
INTMED_SHIP_TO_LOCATION	VARCHAR2	(500)
INTMED_SHIP_TO_CONTACT	VARCHAR2	(500)
ITEM_DESCRIPTION	VARCHAR2	(250)
LATEST_DROPOFF_DATE	DATE
LOAD_SEQ_NUMBER	NUMBER
LOCATOR	CHAR	(1)
LOT_NUMBER	VARCHAR2	(80)
MAXIMUM_LOAD_WEIGHT	NUMBER
MAXIMUM_VOLUME	NUMBER
MINIMUM_FILL_PERCENT	NUMBER
MODE_OF_TRANSPORT	VARCHAR2	(30)
NET_WEIGHT	NUMBER
ORDER_TYPE	VARCHAR2	(240)
ORGANIZATION_CODE	VARCHAR2	(3)
PACKING_INSTRUCTIONS	VARCHAR2	(2000)
REQUESTED_QUANTITY_UOM	VARCHAR2	(3)	Yes
REVISION	VARCHAR2	(3)
SEAL_CODE	VARCHAR2	(30)
CANCELLED_QUANTITY2	NUMBER
DELIVERED_QUANTITY2	NUMBER
REQUESTED_QUANTITY2	NUMBER
REQUESTED_QUANTITY_UOM2	VARCHAR2	(3)
SHIPPED_QUANTITY2	NUMBER
SRC_REQUESTED_QUANTITY2	NUMBER
SRC_REQUESTED_QUANTITY_UOM2	VARCHAR2	(3)
SERVICE_LEVEL	VARCHAR2	(30)
SHIP_METHOD	VARCHAR2	(30)
SHIP_MODEL_COMPLETE_FLAG	VARCHAR2	(1)
SHIP_SET_ID	NUMBER
SHIP_TO_CONTACT	VARCHAR2	(500)
SHIP_TO_CUSTOMER	VARCHAR2	(360)
SHIPMENT_PRIORITY	VARCHAR2	(30)
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
SOURCE_LINE_NUMBER	VARCHAR2	(150)
SRC_REQUESTED_QUANTITY	NUMBER
SRC_REQUESTED_QUANTITY_UOM	VARCHAR2	(3)
TARE_WEIGHT	NUMBER
TASK_NUMBER	NUMBER
TRACKING_NUMBER	VARCHAR2	(30)
UNIT_NUMBER	VARCHAR2	(30)
VOLUME	NUMBER
VOLUME_UOM_CODE	VARCHAR2	(3)
WEIGHT_UOM_CODE	VARCHAR2	(3)
CUSTOMER	VARCHAR2	(360)	Yes
PROJECT	NUMBER
CUSTOMER_CLASS	VARCHAR2	(30)
TRIP	NUMBER
LINE_STATUS	VARCHAR2	(21)
LINE_PROGRESS	VARCHAR2	(21)
LINE_PROGRESS_ID	NUMBER
WAVE_HEADER_ID	NUMBER		Yes
REMOVE_FROM_WAVE_FLAG	VARCHAR2	(1)
WAVE_FIRMED_FLAG	VARCHAR2	(1)
DELIVERY_ID	NUMBER
DELIVERY_DETAIL_ID	NUMBER		Yes
SOURCE_HEADER_ID	NUMBER
SOURCE_LINE_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER
MESSAGE	VARCHAR2	(2000)

Query Text

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


SELECT ORDER_NUMBER
,      DELIVER_TO
,      DELIVERY
,      EXCEPTION_ID
,      ITEM
,      REQUESTED_QTY
,      PLANNED_FILL_RATE
,      RELEASE_FILL_RATE
,      PICK_FILL_RATE
,      SHIP_TO
,      SHIPPED_QTY
,      DATE_SCHEDULED
,      BATCH
,      CARRIER
,      LINE_SHIP_TO_CONTACT
,      CUST_MODEL_SERIAL_NUMBER
,      LINE_REQUEST_DATE
,      DELIVER_TO_CONTACT
,      DELIVER_TO_LOCATION
,      DELIVERED_QUANTITY
,      EARLIEST_DROPOFF_DATE
,      EARLIEST_SHIP_DATE
,      FOB_CODE
,      FREIGHT_TERMS_CODE
,      PREFERRED_GRADE
,      GROSS_WEIGHT
,      HAZARD_CLASS_ID
,      IGNORE_FOR_PLANNING
,      INSPECTION_FLAG
,      INTMED_SHIP_TO_LOCATION
,      INTMED_SHIP_TO_CONTACT
,      ITEM_DESCRIPTION
,      LATEST_DROPOFF_DATE
,      LOAD_SEQ_NUMBER
,      LOCATOR
,      LOT_NUMBER
,      MAXIMUM_LOAD_WEIGHT
,      MAXIMUM_VOLUME
,      MINIMUM_FILL_PERCENT
,      MODE_OF_TRANSPORT
,      NET_WEIGHT
,      ORDER_TYPE
,      ORGANIZATION_CODE
,      PACKING_INSTRUCTIONS
,      REQUESTED_QUANTITY_UOM
,      REVISION
,      SEAL_CODE
,      CANCELLED_QUANTITY2
,      DELIVERED_QUANTITY2
,      REQUESTED_QUANTITY2
,      REQUESTED_QUANTITY_UOM2
,      SHIPPED_QUANTITY2
,      SRC_REQUESTED_QUANTITY2
,      SRC_REQUESTED_QUANTITY_UOM2
,      SERVICE_LEVEL
,      SHIP_METHOD
,      SHIP_MODEL_COMPLETE_FLAG
,      SHIP_SET_ID
,      SHIP_TO_CONTACT
,      SHIP_TO_CUSTOMER
,      SHIPMENT_PRIORITY
,      SHIPPING_INSTRUCTIONS
,      SOURCE_LINE_NUMBER
,      SRC_REQUESTED_QUANTITY
,      SRC_REQUESTED_QUANTITY_UOM
,      TARE_WEIGHT
,      TASK_NUMBER
,      TRACKING_NUMBER
,      UNIT_NUMBER
,      VOLUME
,      VOLUME_UOM_CODE
,      WEIGHT_UOM_CODE
,      CUSTOMER
,      PROJECT
,      CUSTOMER_CLASS
,      TRIP
,      LINE_STATUS
,      LINE_PROGRESS
,      LINE_PROGRESS_ID
,      WAVE_HEADER_ID
,      REMOVE_FROM_WAVE_FLAG
,      WAVE_FIRMED_FLAG
,      DELIVERY_ID
,      DELIVERY_DETAIL_ID
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      ORGANIZATION_ID
,      MESSAGE
FROM APPS.WMS_WP_WWB_LINES_V;

Dependencies

[top of page]

APPS.WMS_WP_WWB_LINES_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_PARTIES; HZ_PARTY_SITES; MTL_ITEM_LOCATIONS_KFV; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; OE_ORDER_LINES_ALL; WMS_LICENSE_PLATE_NUMBERS; WMS_WAVE_PLANNING_PVT - show dependent code; WMS_WP_WAVE_HEADERS_VL; WMS_WP_WAVE_LINES; WSH_CARRIERS; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_DELIVERY_LEGS; WSH_LOCATIONS; WSH_NEW_DELIVERIES; WSH_TRIP_STOPS

APPS.WMS_WP_WWB_LINES_V is referenced by following:

APPS: WMS_WAVE_PLANNING_PVT - show dependent code; WMS_WP_WWB_ORDERS_V