DBA Data[Home] [Help]

APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on WSH_DELIVERY_DETAILS

Line 54: from wsh_delivery_details wdd,

50: where organization_id= p_organization_id;
51:
52: cursor valid_carrier_det_cur is
53: select distinct wc.manifesting_enabled_flag
54: from wsh_delivery_details wdd,
55: wsh_carrier_services wcs,
56: wsh_carriers wc,
57: wsh_new_deliveries wnd,
58: wsh_delivery_assignments_v wda

Line 312: FROM wsh_delivery_details wdd,

308: CURSOR l_Batch_Cur (l_name VARCHAR2) IS --Fulfillment Batch XML Project
309: SELECT wdd.ship_from_location_id Tranding_partner_site_id,
310: wdd.ship_to_location_id,
311: wdd.customer_id
312: FROM wsh_delivery_details wdd,
313: wsh_shipment_batches wsb
314: WHERE wsb.name = l_name
315: AND wdd.shipment_batch_id = wsb.batch_id;
316: