APPS.ONT_FREIGHT_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 113: wsh_delivery_details dd,

109: pa.list_line_type_code,
110: pa.adjusted_amount,
111: pa.operand
112: from oe_price_adjustments pa,
113: wsh_delivery_details dd,
114: wsh_delivery_assignments da,
115: wsh_new_deliveries dl
116: where dl.name = 'delivery_name'
117: and dl.delivery_id = da.delivery_id

Line 380: From wsh_delivery_details

376: DBMS_DEBUG('Checking if the line has been inventory interfaced');
377: Begin
378: Select inv_interfaced_flag, oe_interfaced_flag
379: Into l_inv_interfaced_flag,l_oe_interfaced_flag
380: From wsh_delivery_details
381: Where source_line_id = l_line_rec.line_id;
382:
383: If nvl(l_inv_interfaced_flag,'X') <> 'Y' Then
384: DBMS_DEBUG(' This line has not been inventory interfaced. Shipping could not happen before inventory interface. Please check with inventory about this issue.');

Line 394: DBMS_DEBUG('Line Id:'||l_line_rec.line_id||' can not be found in wsh_delivery_details');

390: End If;
391:
392: Exception
393: When no_data_found Then
394: DBMS_DEBUG('Line Id:'||l_line_rec.line_id||' can not be found in wsh_delivery_details');
395: Return;
396: When Others Then
397: DBMS_DEBUG(SQLERRM);
398: End;