APPS.JAI_OM_RMA_PKG dependencies on WSH_DELIVERY_DETAILS

Line 44: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;

40: v_order_number oe_order_headers_all.order_number % TYPE;
41: v_ord_inv_quantity oe_order_lines_all.ordered_quantity % TYPE;
42: v_old_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
43: v_new_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
44: v_shipped_quantity wsh_delivery_details.shipped_quantity % TYPE;
45: v_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;
46: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;
47: v_tax_category_id JAI_OM_WSH_LINES_ALL.tax_category_id % TYPE;
48: v_tax_amount JAI_OM_WSH_LINES_ALL.tax_amount % TYPE;

Line 84: SELECT requested_quantity_uom FROM wsh_delivery_details

80: WHERE delivery_detail_id = c_delivery_detail_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
81:
82: -- cbabu for Bug#2523313, Start
83: CURSOR requested_qty_uom_cur(p_delivery_detail_id NUMBER) IS
84: SELECT requested_quantity_uom FROM wsh_delivery_details
85: WHERE delivery_detail_id = p_delivery_detail_id;
86:
87: v_conversion_rate NUMBER := 0;
88: v_requested_quantity_uom VARCHAR2(3);

Line 128: wsh_delivery_details wdd,

124: cursor c_confirmed_date (p_delivery_Detail_id Number) is
125: select
126: confirm_date
127: FROM
128: wsh_delivery_details wdd,
129: wsh_delivery_assignments wda,
130: wsh_new_deliveries wnd
131: WHERE
132: wdd.delivery_detail_id = (p_delivery_Detail_id)

Line 448: FROM wsh_delivery_details wdd

444:
445: IF p_new_reference_line_id IS NOT NULL THEN
446:
447: FOR conf_rec IN (SELECT NVL(wdd.delivery_detail_id, 0) pic
448: FROM wsh_delivery_details wdd
449: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
450: AND (wdd.inventory_item_id IN
451: (SELECT inventory_item_id
452: FROM mtl_system_items

Line 464: FROM wsh_delivery_details wdd,

460:
461: ELSIF p_new_ref_customer_trx_line_id IS NOT NULL THEN
462:
463: FOR conf_rec IN (SELECT NVL(wdd.delivery_detail_id, 0) pic
464: FROM wsh_delivery_details wdd,
465: ra_customer_trx_lines_all rctla
466: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
467: AND rctla.customer_trx_line_id = p_new_ref_customer_trx_line_id
468: AND rctla.inventory_item_id = p_inventory_item_id

Line 551: FROM wsh_delivery_details wdd

547: --2001/07/03 Anuradha Parthasarathy
548:
549:
550: FOR pick_rec IN (SELECT SUM(wdd.shipped_quantity) qty
551: FROM wsh_delivery_details wdd
552: WHERE wdd.delivery_detail_id = v_delivery_detail_id
553: AND wdd.inventory_item_id = p_inventory_item_id)
554: LOOP
555: v_shipped_quantity := pick_rec.qty;

Line 617: FROM wsh_delivery_details wdd,

613: --- For picking shipped quantity, tax amount and tax category from JAI_OM_WSH_LINES_ALL ---
614:
615: FOR pick_lrec IN (SELECT wdd.delivery_detail_id,
616: wnd.confirm_date
617: FROM wsh_delivery_details wdd,
618: wsh_delivery_assignments wda,
619: wsh_new_deliveries wnd
620: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
621: AND wda.delivery_detail_id = wdd.delivery_detail_id