VIEW: APPS.WSH_DLVB_SHIP_FROM_TO_V

Source

View Text - Preformatted

SELECT to_number(null) delivery_id, to_char(null) delivery_name, container_flag, delivery_detail_id, container_name, organization_id, inventory_item_id, ship_from_location_id, ship_to_location_id from wsh_delivery_details WHERE nvl(line_direction, 'O') IN ('O', 'IO')

View Text - HTML Formatted

SELECT TO_NUMBER(NULL) DELIVERY_ID
, TO_CHAR(NULL) DELIVERY_NAME
, CONTAINER_FLAG
, DELIVERY_DETAIL_ID
, CONTAINER_NAME
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SHIP_FROM_LOCATION_ID
, SHIP_TO_LOCATION_ID
FROM WSH_DELIVERY_DETAILS
WHERE NVL(LINE_DIRECTION
, 'O') IN ('O'
, 'IO')