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 91: -- FROM JAI_OM_WSH_LINES_ALL

87:
88: -- modified by Allen Yang for bug 9666476 28-apr-2010, begin
89: --CURSOR Localized_Order_Cur(c_delivery_detail_id NUMBER) IS
90: -- SELECT 1
91: -- FROM JAI_OM_WSH_LINES_ALL
92: -- WHERE delivery_detail_id = c_delivery_detail_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
93: CURSOR Localized_Order_Cur(c_delivery_detail_id NUMBER, c_order_line_id NUMBER) IS
94: SELECT 1
95: FROM JAI_OM_WSH_LINES_ALL

Line 95: FROM JAI_OM_WSH_LINES_ALL

91: -- FROM JAI_OM_WSH_LINES_ALL
92: -- WHERE delivery_detail_id = c_delivery_detail_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
93: CURSOR Localized_Order_Cur(c_delivery_detail_id NUMBER, c_order_line_id NUMBER) IS
94: SELECT 1
95: FROM JAI_OM_WSH_LINES_ALL
96: WHERE delivery_detail_id = c_delivery_detail_id
97: OR (SHIPPABLE_FLAG = 'N' AND ORDER_LINE_ID = c_order_line_id);
98: -- modified by Allen Yang for bug 9666476 28-apr-2010, end
99:

Line 192: FROM JAI_OM_WSH_LINES_ALL

188: IF v_ord_inv_quantity <> 0
189: THEN
190: FOR pick_rec IN (SELECT quantity,
191: tax_category_id
192: FROM JAI_OM_WSH_LINES_ALL
193: WHERE delivery_detail_id = v_delivery_detail_id)
194: LOOP
195: v_quantity := pick_rec.quantity;
196: v_tax_category_id := pick_rec.tax_category_id;

Line 474: FROM JAI_OM_WSH_LINES_ALL

470: FOR pick_rec IN (SELECT tax_category_id
471: -- added by Allen Yang for bug 9691880 10-May-2010, begin
472: ,creation_date
473: -- added by Allen Yang for bug 9691880 10-May-2010, end
474: FROM JAI_OM_WSH_LINES_ALL
475: WHERE shippable_flag = 'N'
476: AND order_line_id = p_new_reference_line_id)
477: LOOP
478: v_tax_category_id := pick_rec.tax_category_id;

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

845:
846:
847: v_chk_form := NVL(v_chk_form, 'JAINRCRT');
848:
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,