VIEW: APPS.WSHBV_DELIVERIES

Source

View Text - Preformatted

SELECT wnd.DELIVERY_ID , wnd.NAME , wnd.ORGANIZATION_ID , wnd. CREATION_DATE ,wnd. CREATED_BY ,wnd. LAST_UPDATE_DATE ,wnd. LAST_UPDATED_BY ,wnd. LAST_UPDATE_LOGIN , '_LA:STATUS_CODE:WSH_LOOKUPS:DELIVERY_STATUS:MEANING' , wnd.CONFIRM_DATE ,wnd. LOADING_SEQUENCE , wnd.CUSTOMER_ID , LOC.SOURCE_LOCATION_ID, LOC1.SOURCE_LOCATION_ID, LOC2.SOURCE_LOCATION_ID, WAYBILL ,GROSS_WEIGHT , WEIGHT_UOM_CODE , VOLUME , VOLUME_UOM_CODE , ULTIMATE_DROPOFF_DATE , ASN_DATE_SENT , ASN_SEQ_NUMBER , LOADING_ORDER_FLAG , FREIGHT_TERMS_CODE , CURRENCY_CODE ,'_LA:PLANNED_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,INITIAL_PICKUP_DATE, LOC3.SOURCE_LOCATION_ID, LOC4.SOURCE_LOCATION_ID ,'_LA:ACCEPTANCE_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,ACCEPTED_BY ,ACCEPTED_DATE ,ACKNOWLEDGED_BY ,CONFIRMED_BY ,REASON_OF_TRANSPORT ,DESCRIPTION ,NET_WEIGHT ,PORT_OF_DISCHARGE ,PORT_OF_LOADING ,ADDITIONAL_SHIPMENT_INFO ,BOOKING_NUMBER ,COD_AMOUNT ,COD_CURRENCY_CODE ,SERVICE_CONTRACT ,COD_REMIT_TO ,COD_CHARGE_PAID_BY ,PROBLEM_CONTACT_REFERENCE ,BILL_FREIGHT_TO ,CARRIED_BY ,DOCK_CODE ,DELIVERY_TYPE ,CARRIER_ID ,NUMBER_OF_LPN ,'_LA:SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING' ,'_LA:FOB_CODE:FND_LOOKUP_VALUES_VL:FOB:MEANING' FROM WSH_NEW_DELIVERIES WND, WSH_LOCATIONS LOC, WSH_LOCATIONS LOC1, WSH_LOCATIONS LOC2, WSH_LOCATIONS LOC3, WSH_LOCATIONS LOC4 WHERE WND.ULTIMATE_DROPOFF_LOCATION_ID = LOC.WSH_LOCATION_ID AND WND.INTMED_SHIP_TO_LOCATION_ID = LOC1.WSH_LOCATION_ID(+) AND WND.POOLED_SHIP_TO_LOCATION_ID = LOC2.WSH_LOCATION_ID(+) AND WND.INITIAL_PICKUP_LOCATION_ID = LOC3.WSH_LOCATION_ID AND WND.FOB_LOCATION_ID = LOC4.WSH_LOCATION_ID(+) AND '_SEC:WND.ORGANIZATION_ID' IS NOT NULL AND NVL(WND.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') WITH READ ONLY

View Text - HTML Formatted

SELECT WND.DELIVERY_ID
, WND.NAME
, WND.ORGANIZATION_ID
, WND. CREATION_DATE
, WND. CREATED_BY
, WND. LAST_UPDATE_DATE
, WND. LAST_UPDATED_BY
, WND. LAST_UPDATE_LOGIN
, '_LA:STATUS_CODE:WSH_LOOKUPS:DELIVERY_STATUS:MEANING'
, WND.CONFIRM_DATE
, WND. LOADING_SEQUENCE
, WND.CUSTOMER_ID
, LOC.SOURCE_LOCATION_ID
, LOC1.SOURCE_LOCATION_ID
, LOC2.SOURCE_LOCATION_ID
, WAYBILL
, GROSS_WEIGHT
, WEIGHT_UOM_CODE
, VOLUME
, VOLUME_UOM_CODE
, ULTIMATE_DROPOFF_DATE
, ASN_DATE_SENT
, ASN_SEQ_NUMBER
, LOADING_ORDER_FLAG
, FREIGHT_TERMS_CODE
, CURRENCY_CODE
, '_LA:PLANNED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, INITIAL_PICKUP_DATE
, LOC3.SOURCE_LOCATION_ID
, LOC4.SOURCE_LOCATION_ID
, '_LA:ACCEPTANCE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, ACCEPTED_BY
, ACCEPTED_DATE
, ACKNOWLEDGED_BY
, CONFIRMED_BY
, REASON_OF_TRANSPORT
, DESCRIPTION
, NET_WEIGHT
, PORT_OF_DISCHARGE
, PORT_OF_LOADING
, ADDITIONAL_SHIPMENT_INFO
, BOOKING_NUMBER
, COD_AMOUNT
, COD_CURRENCY_CODE
, SERVICE_CONTRACT
, COD_REMIT_TO
, COD_CHARGE_PAID_BY
, PROBLEM_CONTACT_REFERENCE
, BILL_FREIGHT_TO
, CARRIED_BY
, DOCK_CODE
, DELIVERY_TYPE
, CARRIER_ID
, NUMBER_OF_LPN
, '_LA:SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, '_LA:FOB_CODE:FND_LOOKUP_VALUES_VL:FOB:MEANING'
FROM WSH_NEW_DELIVERIES WND
, WSH_LOCATIONS LOC
, WSH_LOCATIONS LOC1
, WSH_LOCATIONS LOC2
, WSH_LOCATIONS LOC3
, WSH_LOCATIONS LOC4
WHERE WND.ULTIMATE_DROPOFF_LOCATION_ID = LOC.WSH_LOCATION_ID
AND WND.INTMED_SHIP_TO_LOCATION_ID = LOC1.WSH_LOCATION_ID(+)
AND WND.POOLED_SHIP_TO_LOCATION_ID = LOC2.WSH_LOCATION_ID(+)
AND WND.INITIAL_PICKUP_LOCATION_ID = LOC3.WSH_LOCATION_ID
AND WND.FOB_LOCATION_ID = LOC4.WSH_LOCATION_ID(+)
AND '_SEC:WND.ORGANIZATION_ID' IS NOT NULL
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY