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 346: FROM wsh_delivery_details

342: WHERE delivery_detail_id = p_picking_line_id;
343:
344: CURSOR Header_id (p_picking_line_id IN NUMBER) IS
345: SELECT source_line_id, source_header_id
346: FROM wsh_delivery_details
347: WHERE delivery_detail_id = p_picking_line_id;
348:
349: CURSOR matched_receipt_cur(p_reference_line_id IN NUMBER) IS
350: SELECT A.receipt_id, A.quantity_applied

Line 419: SELECT SOURCE_LINE_ID FROM wsh_delivery_details

415: WHERE delivery_id = p_delivery_id;
416: ----------------------------------------------
417: --Cursor added by Jagdish on 2001/09/13
418: CURSOR get_order_line_id(p_delivery_detail_id NUMBER) IS
419: SELECT SOURCE_LINE_ID FROM wsh_delivery_details
420: WHERE delivery_detail_id = p_delivery_detail_id;
421: --Anuradha Parthasarathy
422:
423: CURSOR get_actual_shipment_date(p_order_line_id NUMBER) IS

Line 1127: wsh_delivery_details wdd ,

1123: at least one delivery detail with inv_interfaced_flag = 'N' */
1124: not exists
1125: ( select 1
1126: FROM
1127: wsh_delivery_details wdd ,
1128: wsh_new_deliveries wnd ,
1129: wsh_delivery_assignments wda
1130: WHERE
1131: wdd.delivery_detail_id = wda.delivery_detail_id AND