APPS.JAI_OM_WSH_PKG dependencies on WSH_DELIVERY_DETAILS

Line 55: v_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE ;

51: v_last_update_date DATE ;
52: v_last_updated_by NUMBER ;
53: v_last_update_login NUMBER ;
54: v_order_type_id NUMBER ;
55: v_subinventory WSH_DELIVERY_DETAILS.SUBINVENTORY%TYPE ;
56: v_bonded_flag VARCHAR2(1) ;
57: v_trading_flag VARCHAR2(1) ;
58: v_pref_rg23a NUMBER ;
59: v_pref_rg23c NUMBER ;

Line 351: FROM wsh_delivery_details

347: WHERE delivery_detail_id = p_picking_line_id;
348:
349: CURSOR Header_id (p_picking_line_id IN NUMBER) IS
350: SELECT source_line_id, source_header_id
351: FROM wsh_delivery_details
352: WHERE delivery_detail_id = p_picking_line_id;
353:
354: CURSOR matched_receipt_cur(p_reference_line_id IN NUMBER) IS
355: SELECT A.receipt_id, A.quantity_applied

Line 432: SELECT SOURCE_LINE_ID FROM wsh_delivery_details

428: WHERE delivery_id = p_delivery_id;
429: ----------------------------------------------
430: --Cursor added by Jagdish on 2001/09/13
431: CURSOR get_order_line_id(p_delivery_detail_id NUMBER) IS
432: SELECT SOURCE_LINE_ID FROM wsh_delivery_details
433: WHERE delivery_detail_id = p_delivery_detail_id;
434: --Anuradha Parthasarathy
435:
436: CURSOR get_actual_shipment_date(p_order_line_id NUMBER) IS

Line 1207: wsh_delivery_details wdd ,

1203: at least one delivery detail with inv_interfaced_flag = 'N' */
1204: not exists
1205: ( select 1
1206: FROM
1207: wsh_delivery_details wdd ,
1208: wsh_new_deliveries wnd ,
1209: wsh_delivery_assignments wda
1210: WHERE
1211: wdd.delivery_detail_id = wda.delivery_detail_id AND