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_AR_IMPORT_POPU_PKG dependencies on JAI_OM_OE_SO_LINES

Line 72: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c

68: A.func_tax_amount,
69: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
70: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
71: c.tax_type
72: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c
73: WHERE A.line_id = b.line_id
74: AND b.line_id = TO_NUMBER(v_interface_line_attribute6)
75: AND A.tax_id = c.tax_id
76: and c.tax_type <> lc_modvat_tax

Line 279: from JAI_OM_OE_SO_LINES

275: A.order_line_id = TO_NUMBER(v_interface_line_attribute6);
276:
277: CURSOR C_JA_SO_LINES_ASSESSABLE_VAL IS
278: SELECT assessable_value, service_type_code
279: from JAI_OM_OE_SO_LINES
280: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
281:
282: CURSOR c_so_picking_tax_amt_ns(p_tax_id NUMBER)
283: IS

Line 323: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b

319: AND order_line_id = TO_NUMBER(v_interface_line_attribute6);
320:
321: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS
322: SELECT DISTINCT 1
323: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b
324: WHERE A.line_id = TO_NUMBER(v_interface_line_attribute6)
325: AND A.line_id = b.line_id;
326:
327: CURSOR c_duplicate_tax(cp_tax_id JAI_AR_TRX_TAX_LINES.tax_id%TYPE,

Line 339: FROM JAI_OM_OE_SO_LINES

335: CURSOR ja_so_lines_info IS
336: SELECT tax_category_id, tax_amount, assessable_value, excise_exempt_type,excise_exempt_refno, excise_exempt_date,
337: vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno, vat_assessable_value -- added, Harshita for bug#4245062
338: ,service_type_code
339: FROM JAI_OM_OE_SO_LINES
340: WHERE line_id = to_number(v_interface_line_attribute6);
341: rec_so_lines JA_SO_LINES_INFO%rowtype;
342:
343: CURSOR DUPLICATE_LINES_CUR IS

Line 469: FROM JAI_OM_OE_SO_LINES

465: unit_code ,
466: inventory_item_id ,
467: quantity ,
468: service_type_code
469: FROM JAI_OM_OE_SO_LINES
470: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
471:
472: cursor c_get_amounts is
473: select sum(tax_amount) tax_amt , sum(line_amount) line_amt

Line 1233: FROM JAI_OM_OE_SO_LINES

1229: and item_type_code = cp_item_code;
1230:
1231: CURSOR c_get_om_lines(v_ato_line_id Varchar2) is
1232: SELECT *
1233: FROM JAI_OM_OE_SO_LINES
1234: WHERE line_id = v_ato_line_id;
1235:
1236: cursor c_so_picking_data (v_ato_line_id Varchar2) is
1237: SELECT excise_invoice_no , register , preprinted_excise_inv_no , ar3_form_no ,ar3_form_date

Line 2293: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL

2289: IF v_register_code = 'BOND_REG' THEN
2290: v_tax_amount := v_bond_tax_amt / v_qty;
2291: END IF;
2292:
2293: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL
2294: OPEN C_JA_SO_LINES_ASSESSABLE_VAL;
2295: FETCH C_JA_SO_LINES_ASSESSABLE_VAL into v_assessable_value,v_service_type;
2296: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
2297:

Line 2507: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL

2503:
2504: IF v_register_code = 'BOND_REG' THEN
2505: v_tax_amount := v_bond_tax_amt / v_qty;
2506: END IF;
2507: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL
2508: OPEN C_JA_SO_LINES_ASSESSABLE_VAL;
2509: FETCH C_JA_SO_LINES_ASSESSABLE_VAL into v_assessable_value,v_service_type;
2510: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
2511: END IF; -- NVL(v_exist_flag,0) = 1

Line 2612: Code should return only in case of an RMA i.e return only when a line does not exist in JAI_OM_OE_SO_LINES table

2608: ELSE /* ELSE FOR IF NVL(v_exist_flag,0) = 1 */
2609: /*
2610: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
2611: would come here.
2612: Code should return only in case of an RMA i.e return only when a line does not exist in JAI_OM_OE_SO_LINES table
2613: for the given line_id.
2614: */
2615: DECLARE
2616: CURSOR c_so_lines_exists

Line 2619: FROM JAI_OM_OE_SO_LINES

2615: DECLARE
2616: CURSOR c_so_lines_exists
2617: IS
2618: SELECT 1
2619: FROM JAI_OM_OE_SO_LINES
2620: WHERE line_id = pr_new.interface_line_attribute6;
2621: lv_exists VARCHAR2(1);
2622: BEGIN
2623: pv_return_code := jai_constants.successful ;

Line 2628: --fnd_file.put_line(FND_FILE.LOG,'no lines in jai_om_oe_so_lines -return');

2624: OPEN c_so_lines_exists ;
2625: FETCH c_so_lines_exists INTO lv_exists;
2626: IF c_so_lines_exists%NOTFOUND THEN
2627: CLOSE c_so_lines_exists;
2628: --fnd_file.put_line(FND_FILE.LOG,'no lines in jai_om_oe_so_lines -return');
2629: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2630: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2631: G_MODULE_NAME || l_api_name || '.IN',
2632: G_PKG_NAME || ': ' || l_api_name || '().'||' no lines in jai_om_oe_so_lines -return '

Line 2632: G_PKG_NAME || ': ' || l_api_name || '().'||' no lines in jai_om_oe_so_lines -return '

2628: --fnd_file.put_line(FND_FILE.LOG,'no lines in jai_om_oe_so_lines -return');
2629: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2630: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2631: G_MODULE_NAME || l_api_name || '.IN',
2632: G_PKG_NAME || ': ' || l_api_name || '().'||' no lines in jai_om_oe_so_lines -return '
2633: );
2634: end if;
2635: return;
2636: END IF;

Line 4399: FROM JAI_OM_OE_SO_LINES

4395: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
4396:
4397: CURSOR JA_SO_LINES_RECORD_CHECK IS
4398: SELECT 1
4399: FROM JAI_OM_OE_SO_LINES
4400: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
4401:
4402: v_line_count NUMBER;
4403: v_tax_line_count NUMBER;