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 102: SELECT requested_quantity_uom FROM wsh_delivery_details

98: -- modified by Allen Yang for bug 9666476 28-apr-2010, end
99:
100: -- cbabu for Bug#2523313, Start
101: CURSOR requested_qty_uom_cur(p_delivery_detail_id NUMBER) IS
102: SELECT requested_quantity_uom FROM wsh_delivery_details
103: WHERE delivery_detail_id = p_delivery_detail_id;
104:
105: v_conversion_rate NUMBER := 0;
106: v_requested_quantity_uom VARCHAR2(3);

Line 146: wsh_delivery_details wdd,

142: cursor c_confirmed_date (p_delivery_Detail_id Number) is
143: select
144: confirm_date
145: FROM
146: wsh_delivery_details wdd,
147: wsh_delivery_assignments wda,
148: wsh_new_deliveries wnd
149: WHERE
150: wdd.delivery_detail_id = (p_delivery_Detail_id)

Line 684: FROM wsh_delivery_details wdd

680:
681: IF p_new_reference_line_id IS NOT NULL THEN
682:
683: FOR conf_rec IN (SELECT NVL(wdd.delivery_detail_id, 0) pic
684: FROM wsh_delivery_details wdd
685: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
686: AND (wdd.inventory_item_id IN
687: (SELECT inventory_item_id
688: FROM mtl_system_items

Line 700: FROM wsh_delivery_details wdd,

696:
697: ELSIF p_new_ref_customer_trx_line_id IS NOT NULL THEN
698:
699: FOR conf_rec IN (SELECT NVL(wdd.delivery_detail_id, 0) pic
700: FROM wsh_delivery_details wdd,
701: ra_customer_trx_lines_all rctla
702: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
703: AND rctla.customer_trx_line_id = p_new_ref_customer_trx_line_id
704: AND rctla.inventory_item_id = p_inventory_item_id

Line 787: FROM wsh_delivery_details wdd

783: --2001/07/03 Anuradha Parthasarathy
784:
785:
786: FOR pick_rec IN (SELECT SUM(wdd.shipped_quantity) qty
787: FROM wsh_delivery_details wdd
788: WHERE wdd.delivery_detail_id = v_delivery_detail_id
789: AND wdd.inventory_item_id = p_inventory_item_id)
790: LOOP
791: v_shipped_quantity := pick_rec.qty;

Line 853: FROM wsh_delivery_details wdd,

849: --- For picking shipped quantity, tax amount and tax category from JAI_OM_WSH_LINES_ALL ---
850:
851: FOR pick_lrec IN (SELECT wdd.delivery_detail_id,
852: wnd.confirm_date
853: FROM wsh_delivery_details wdd,
854: wsh_delivery_assignments wda,
855: wsh_new_deliveries wnd
856: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
857: AND wda.delivery_detail_id = wdd.delivery_detail_id