VIEW: APPS.WSH_DELIVERY_LEGS_OB_GRP_V

Source

View Text - Preformatted

SELECT wdl.DELIVERY_LEG_ID , wdl. DELIVERY_ID , wdl. SEQUENCE_NUMBER , wdl. LOADING_ORDER_FLAG , wdl. PICK_UP_STOP_ID , wdl. DROP_OFF_STOP_ID , wdl. GROSS_WEIGHT , wdl. NET_WEIGHT , wdl. WEIGHT_UOM_CODE , wdl. VOLUME , wdl. VOLUME_UOM_CODE , wdl. CREATION_DATE , wdl. CREATED_BY , wdl. LAST_UPDATE_DATE , wdl. LAST_UPDATED_BY , wdl. LAST_UPDATE_LOGIN , wdl. PROGRAM_APPLICATION_ID , wdl. PROGRAM_ID , wdl. PROGRAM_UPDATE_DATE , wdl. REQUEST_ID , wdl. LOAD_TENDER_STATUS , wdl. SHIPPER_TITLE , wdl. SHIPPER_PHONE , wdl. POD_FLAG , wdl. POD_BY , wdl. POD_DATE , wdl. EXPECTED_POD_DATE , wdl. BOOKING_OFFICE , wdl. SHIPPER_EXPORT_REF , wdl. CARRIER_EXPORT_REF , wdl. DOC_NOTIFY_PARTY , wdl. AETC_NUMBER , wdl. SHIPPER_SIGNED_BY , wdl. SHIPPER_DATE , wdl. CARRIER_SIGNED_BY , wdl. CARRIER_DATE , wdl. DOC_ISSUE_OFFICE , wdl. DOC_ISSUED_BY , wdl. DOC_DATE_ISSUED , wdl. SHIPPER_HM_BY , wdl. SHIPPER_HM_DATE , wdl. CARRIER_HM_BY , wdl. CARRIER_HM_DATE , wdl. BOOKING_NUMBER , wdl. PORT_OF_LOADING , wdl. PORT_OF_DISCHARGE , wdl. SERVICE_CONTRACT , wdl. BILL_FREIGHT_TO , wdl. FTE_TRIP_ID , wdl. REPRICE_REQUIRED , wdl. ACTUAL_ARRIVAL_DATE , wdl. ACTUAL_DEPARTURE_DATE , wdl. ACTUAL_RECEIPT_DATE , wdl. TRACKING_DRILLDOWN_FLAG , wdl. STATUS_CODE , wdl. TRACKING_REMARKS , wdl. CARRIER_EST_DEPARTURE_DATE , wdl. CARRIER_EST_ARRIVAL_DATE , wdl. LOADING_START_DATETIME , wdl. LOADING_END_DATETIME , wdl. UNLOADING_START_DATETIME , wdl. UNLOADING_END_DATETIME , wdl. DELIVERED_QUANTITY , wdl. LOADED_QUANTITY , wdl. RECEIVED_QUANTITY , wdl. ORIGIN_STOP_ID , wdl. DESTINATION_STOP_ID , wdl.PARENT_DELIVERY_LEG_ID from wsh_delivery_legs wdl, wsh_new_deliveries wnd WHERE wdl.delivery_id = wnd.delivery_id and NVL(wnd.shipment_direction ,'O') IN ('O','IO')

View Text - HTML Formatted

SELECT WDL.DELIVERY_LEG_ID
, WDL. DELIVERY_ID
, WDL. SEQUENCE_NUMBER
, WDL. LOADING_ORDER_FLAG
, WDL. PICK_UP_STOP_ID
, WDL. DROP_OFF_STOP_ID
, WDL. GROSS_WEIGHT
, WDL. NET_WEIGHT
, WDL. WEIGHT_UOM_CODE
, WDL. VOLUME
, WDL. VOLUME_UOM_CODE
, WDL. CREATION_DATE
, WDL. CREATED_BY
, WDL. LAST_UPDATE_DATE
, WDL. LAST_UPDATED_BY
, WDL. LAST_UPDATE_LOGIN
, WDL. PROGRAM_APPLICATION_ID
, WDL. PROGRAM_ID
, WDL. PROGRAM_UPDATE_DATE
, WDL. REQUEST_ID
, WDL. LOAD_TENDER_STATUS
, WDL. SHIPPER_TITLE
, WDL. SHIPPER_PHONE
, WDL. POD_FLAG
, WDL. POD_BY
, WDL. POD_DATE
, WDL. EXPECTED_POD_DATE
, WDL. BOOKING_OFFICE
, WDL. SHIPPER_EXPORT_REF
, WDL. CARRIER_EXPORT_REF
, WDL. DOC_NOTIFY_PARTY
, WDL. AETC_NUMBER
, WDL. SHIPPER_SIGNED_BY
, WDL. SHIPPER_DATE
, WDL. CARRIER_SIGNED_BY
, WDL. CARRIER_DATE
, WDL. DOC_ISSUE_OFFICE
, WDL. DOC_ISSUED_BY
, WDL. DOC_DATE_ISSUED
, WDL. SHIPPER_HM_BY
, WDL. SHIPPER_HM_DATE
, WDL. CARRIER_HM_BY
, WDL. CARRIER_HM_DATE
, WDL. BOOKING_NUMBER
, WDL. PORT_OF_LOADING
, WDL. PORT_OF_DISCHARGE
, WDL. SERVICE_CONTRACT
, WDL. BILL_FREIGHT_TO
, WDL. FTE_TRIP_ID
, WDL. REPRICE_REQUIRED
, WDL. ACTUAL_ARRIVAL_DATE
, WDL. ACTUAL_DEPARTURE_DATE
, WDL. ACTUAL_RECEIPT_DATE
, WDL. TRACKING_DRILLDOWN_FLAG
, WDL. STATUS_CODE
, WDL. TRACKING_REMARKS
, WDL. CARRIER_EST_DEPARTURE_DATE
, WDL. CARRIER_EST_ARRIVAL_DATE
, WDL. LOADING_START_DATETIME
, WDL. LOADING_END_DATETIME
, WDL. UNLOADING_START_DATETIME
, WDL. UNLOADING_END_DATETIME
, WDL. DELIVERED_QUANTITY
, WDL. LOADED_QUANTITY
, WDL. RECEIVED_QUANTITY
, WDL. ORIGIN_STOP_ID
, WDL. DESTINATION_STOP_ID
, WDL.PARENT_DELIVERY_LEG_ID
FROM WSH_DELIVERY_LEGS WDL
, WSH_NEW_DELIVERIES WND
WHERE WDL.DELIVERY_ID = WND.DELIVERY_ID
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')