DBA Data[Home] [Help]

VIEW: APPS.MST_WSH_NEW_DELIVERIES_V

Source

View Text - Preformatted

SELECT del.DELIVERY_ID DELIVERY_ID ,del.PLANNED_FLAG ,decode(del.PLANNED_FLAG,'Y','Y','F','Y',null) Preserve_Grouping_Flag ,del.VENDOR_ID VENDOR_ID ,del.ORGANIZATION_ID ORGANIZATION_ID ,del.INITIAL_PICKUP_LOCATION_ID INITIAL_PICKUP_LOCATION_ID ,to_number(null) DESTINATION_ORGANIZATION_ID ,del.CUSTOMER_ID CUSTOMER_ID ,nvl(ploc.LOCATION_ID, ULTIMATE_DROPOFF_LOCATION_ID) ULTIMATE_DROPOFF_LOCATION_ID ,del.INITIAL_PICKUP_DATE INITIAL_PICKUP_DATE ,del.ULTIMATE_DROPOFF_DATE ULTIMATE_DROPOFF_DATE ,del.GROSS_WEIGHT GROSS_WEIGHT ,del.VOLUME VOLUME ,del.SHIPMENT_DIRECTION SHIPMENT_DIRECTION ,del.Created_by Created_by ,del.Last_updated_by Last_updated_by ,del.MODE_OF_TRANSPORT MODE_OF_TRANSPORT ,del.CARRIER_ID CARRIER_ID ,del.SERVICE_LEVEL SERVICE_LEVEL ,del.NET_WEIGHT NET_WEIGHT ,del.WEIGHT_UOM_CODE WEIGHT_UOM_CODE ,del.VOLUME_UOM_CODE VOLUME_UOM_CODE ,del.EARLIEST_PICKUP_DATE EARLIEST_AVAILABLE_TO_SHIP ,del.LATEST_PICKUP_DATE LATEST_AVAILABLE_TO_SHIP ,del.EARLIEST_DROPOFF_DATE EARLIEST_DELIVERY_DATE ,del.LATEST_DROPOFF_DATE LATEST_DELIVERY_DATE ,del.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE ,to_number(NULL) DIRECT_COST ,STATUS_CODE STATUS_CODE FROM WSH_NEW_DELIVERIES del ,MST_PO_LOCATION_ASSO_V ploc WHERE nvl(del.ignore_for_planning,'N') <> 'Y' AND del.ULTIMATE_DROPOFF_LOCATION_ID = ploc.cust_location_id (+)
View Text - HTML Formatted

SELECT DEL.DELIVERY_ID DELIVERY_ID
, DEL.PLANNED_FLAG
, DECODE(DEL.PLANNED_FLAG
, 'Y'
, 'Y'
, 'F'
, 'Y'
, NULL) PRESERVE_GROUPING_FLAG
, DEL.VENDOR_ID VENDOR_ID
, DEL.ORGANIZATION_ID ORGANIZATION_ID
, DEL.INITIAL_PICKUP_LOCATION_ID INITIAL_PICKUP_LOCATION_ID
, TO_NUMBER(NULL) DESTINATION_ORGANIZATION_ID
, DEL.CUSTOMER_ID CUSTOMER_ID
, NVL(PLOC.LOCATION_ID
, ULTIMATE_DROPOFF_LOCATION_ID) ULTIMATE_DROPOFF_LOCATION_ID
, DEL.INITIAL_PICKUP_DATE INITIAL_PICKUP_DATE
, DEL.ULTIMATE_DROPOFF_DATE ULTIMATE_DROPOFF_DATE
, DEL.GROSS_WEIGHT GROSS_WEIGHT
, DEL.VOLUME VOLUME
, DEL.SHIPMENT_DIRECTION SHIPMENT_DIRECTION
, DEL.CREATED_BY CREATED_BY
, DEL.LAST_UPDATED_BY LAST_UPDATED_BY
, DEL.MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, DEL.CARRIER_ID CARRIER_ID
, DEL.SERVICE_LEVEL SERVICE_LEVEL
, DEL.NET_WEIGHT NET_WEIGHT
, DEL.WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, DEL.VOLUME_UOM_CODE VOLUME_UOM_CODE
, DEL.EARLIEST_PICKUP_DATE EARLIEST_AVAILABLE_TO_SHIP
, DEL.LATEST_PICKUP_DATE LATEST_AVAILABLE_TO_SHIP
, DEL.EARLIEST_DROPOFF_DATE EARLIEST_DELIVERY_DATE
, DEL.LATEST_DROPOFF_DATE LATEST_DELIVERY_DATE
, DEL.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, TO_NUMBER(NULL) DIRECT_COST
, STATUS_CODE STATUS_CODE
FROM WSH_NEW_DELIVERIES DEL
, MST_PO_LOCATION_ASSO_V PLOC
WHERE NVL(DEL.IGNORE_FOR_PLANNING
, 'N') <> 'Y'
AND DEL.ULTIMATE_DROPOFF_LOCATION_ID = PLOC.CUST_LOCATION_ID (+)