APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 579: wsh_delivery_assignments_v wda

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;
583:

Line 686: wsh_delivery_assignments wda,

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
690: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 703: wsh_delivery_assignments wda,

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
707: AND wdd.shipment_line_number = delivery_detail_int_rec.delivery_detail_id