eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_RMA_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 42: v_old_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;

38: IS
39: v_category oe_order_headers_all.order_category_code % 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;

Line 43: v_new_quantity JAI_OM_WSH_LINES_ALL.quantity % TYPE;

39: v_category oe_order_headers_all.order_category_code % 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;

Line 45: v_quantity JAI_OM_WSH_LINES_ALL.quantity % 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;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;

Line 46: v_cor_amount JAI_OM_WSH_LINES_ALL.tax_amount % 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;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;

Line 47: v_tax_category_id JAI_OM_WSH_LINES_ALL.tax_category_id % 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;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;

Line 48: v_tax_amount JAI_OM_WSH_LINES_ALL.tax_amount % 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;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062

Line 49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % 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;
49: v_delivery_detail_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE;
50: v_excise_return_days JAI_CMN_INVENTORY_ORGS.excise_return_days % TYPE;
51: v_sales_return_days JAI_CMN_INVENTORY_ORGS.sales_return_days % TYPE;
52: v_vat_return_days JAI_CMN_INVENTORY_ORGS.vat_return_days % TYPE; -- added, Harshita for bug#4245062
53: v_excise_flag VARCHAR2(1);

Line 79: FROM JAI_OM_WSH_LINES_ALL

75: v_service_type_code JAI_OM_OE_SO_LINES.service_type_code%type; /* added by ssawant for bug 5879769 */
76:
77: CURSOR Localized_Order_Cur(c_delivery_detail_id NUMBER) IS
78: SELECT 1
79: FROM JAI_OM_WSH_LINES_ALL
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

Line 174: FROM JAI_OM_WSH_LINES_ALL

170: IF v_ord_inv_quantity <> 0
171: THEN
172: FOR pick_rec IN (SELECT quantity,
173: tax_category_id
174: FROM JAI_OM_WSH_LINES_ALL
175: WHERE delivery_detail_id = v_delivery_detail_id)
176: LOOP
177: v_quantity := pick_rec.quantity;
178: v_tax_category_id := pick_rec.tax_category_id;

Line 613: --- For picking shipped quantity, tax amount and tax category from JAI_OM_WSH_LINES_ALL ---

609:
610:
611: v_chk_form := NVL(v_chk_form, 'JAINRCRT');
612:
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,