APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_DELIVERY_DETAILS

Line 578: FROM wsh_delivery_details wdd,

574: FOR delivery_detail_int_rec IN delivery_detail_int_cur (p_delivery_id) LOOP
575: BEGIN
576: SELECT 'X'
577: INTO x_delivery_detail_exists
578: FROM wsh_delivery_details wdd,
579: wsh_delivery_assignments_v wda
580: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
581: AND wdd.delivery_detail_id = delivery_detail_int_rec.delivery_detail_id
582: AND wda.delivery_id = p_delivery_id;

Line 685: FROM wsh_delivery_details wdd,

681: BEGIN
682: IF (delivery_detail_int_rec.line_direction = 'IO') THEN
683: SELECT distinct 'X'
684: INTO l_delivery_detail_exists
685: FROM wsh_delivery_details wdd,
686: wsh_delivery_assignments wda,
687: oe_order_lines_all ol,
688: po_requisition_lines_all pl,
689: po_requisition_headers_all ph

Line 702: FROM wsh_delivery_details wdd,

698: AND ph.segment1 = delivery_detail_int_rec.source_header_number;
699: ELSE
700: SELECT distinct 'X'
701: INTO l_delivery_detail_exists
702: FROM wsh_delivery_details wdd,
703: wsh_delivery_assignments wda,
704: wsh_shipment_batches wsb,
705: wsh_transactions_history wth
706: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 783: FROM wsh_delivery_details

779: SELECT DISTINCT delivery_detail_id, customer_id, customer_item_id,
780: deliver_to_location_id, intmed_ship_to_location_id,
781: inventory_item_id, organization_id, ship_from_location_id,
782: ship_to_location_id
783: FROM wsh_delivery_details
784: WHERE delivery_detail_id = p_delivery_detail_id;
785:
786: CURSOR delivery_int_cur
787: IS