APPS.WSH_CUSTOM_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 166

SELECT
msi.segment1,
msi.description,
lpad(to_char(wnd.initial_pickup_date,'MM/DD/YYYY'),12),
wnd.waybill,
sum(nvl(wdd.shipped_quantity,0))
FROM
wsh_delivery_details wdd,
wsh_delivery_assignments wda,
wsh_new_deliveries wnd,
mtl_system_items msi
WHERE wdd.delivery_detail_id = wda.delivery_detail_id
AND   wda.delivery_id = wnd.delivery_id
AND   wnd.status_code in ('IT','CL')
AND   wnd.initial_pickup_date > p_last_notif_date
AND   wdd.inventory_item_id = msi.inventory_item_id
AND   wdd.organization_id = msi.organization_id
AND   wdd.source_header_id = p_source_header_id
AND   wdd.source_code = p_source_code
AND   nvl(wnd.shipment_direction, 'O') IN ('O','IO')  --J Inbound Logistics jckwok
AND   decode(p_contact_type,
	   'SHIP_TO',wdd.ship_to_contact_id,
	   'SOLD_TO',wdd.sold_to_contact_id,
	   wdd.customer_id) = p_contact_id
GROUP BY
wdd.source_header_number,
wdd.source_header_type_id,
wdd.source_line_id,
wdd.inventory_item_id,
msi.segment1,
msi.description,
wdd.src_requested_quantity,
wnd.initial_pickup_date,
wnd.waybill
HAVING
sum(nvl(wdd.shipped_quantity,0)) > 0;

Line: 268

SELECT
msi.segment1,
msi.description,
sum(nvl(wdd.requested_quantity,0))
FROM
wsh_delivery_details wdd,
wsh_delivery_assignments wda,
wsh_new_deliveries wnd,
mtl_system_items msi
WHERE wdd.delivery_detail_id = wda.delivery_detail_id
AND   wdd.date_scheduled < sysdate
--AND   wdd.date_scheduled > p_last_notif_date
--AND   wdd.released_status != 'C'
AND   wda.delivery_id = wnd.delivery_id (+)
AND   nvl(wnd.status_code,'XX') not in ('IT','CL')
AND   wdd.inventory_item_id = msi.inventory_item_id
AND   wdd.organization_id = msi.organization_id
AND   wdd.source_header_id = p_source_header_id
AND   wdd.source_code = p_source_code
AND   nvl(wdd.line_direction, 'O') IN ('O','IO')  --J Inbound Logistics jckwok
AND   decode(p_contact_type,
	   'SHIP_TO',wdd.ship_to_contact_id,
	   'SOLD_TO',wdd.sold_to_contact_id,
	   wdd.customer_id) = p_contact_id
GROUP BY
wdd.source_header_number,
wdd.source_header_type_id,
wdd.source_line_id,
wdd.inventory_item_id,
msi.segment1,
msi.description,
wdd.src_requested_quantity
HAVING
sum(nvl(wdd.requested_quantity,0)) > 0;