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

Line 299: JAI_OM_OE_SO_LINES

295: IS
296: SELECT
297: lc_flag
298: FROM
299: JAI_OM_OE_SO_LINES
300: WHERE
301: lc_flag = 'Y' AND
302: header_id = pr_new.source_header_id;
303:

Line 349: -- The following cursor gets the tax amount for the line_id from JAI_OM_OE_SO_LINES table

345: /* end bug#5686360 */
346:
347:
348: -- Following cursors added by sriram - bug # 2689417
349: -- The following cursor gets the tax amount for the line_id from JAI_OM_OE_SO_LINES table
350: CURSOR c_ja_in_so_lines_tax_amt
351: IS
352: SELECT
353: tax_amount

Line 355: JAI_OM_OE_SO_LINES

351: IS
352: SELECT
353: tax_amount
354: FROM
355: JAI_OM_OE_SO_LINES
356: WHERE
357: line_id = pr_new.source_line_id AND
358: header_id = pr_new.source_header_id;
359:

Line 377: v_line_tax_amount Number; --File.Sql.35 Cbabu :=0; -- to hold the tax amount for a line - based on JAI_OM_OE_SO_LINES

373: AND NVL(tax.inclusive_tax_flag,'N') = 'N' ; -- Added by Jia Li for inclusive tax on 2008/01/07
374:
375:
376:
377: v_line_tax_amount Number; --File.Sql.35 Cbabu :=0; -- to hold the tax amount for a line - based on JAI_OM_OE_SO_LINES
378: v_sum_tax_amount Number; --File.Sql.35 Cbabu :=0; -- to hold the sum of taxes for a line - based on JAI_OM_OE_SO_TAXES
379: -- ends here -- cursors added by sriram - bug # 2689417
380:
381:

Line 404: JAI_OM_OE_SO_LINES a

400: a.line_number ,
401: a.shipment_line_number ,
402: quantity -- added by sriram bug# 3441684
403: FROM
404: JAI_OM_OE_SO_LINES a
405: WHERE
406: a.line_id = pr_new.source_line_id AND
407: a.header_id = pr_new.source_header_id ;
408:

Line 409: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;

405: WHERE
406: a.line_id = pr_new.source_line_id AND
407: a.header_id = pr_new.source_header_id ;
408:
409: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
410: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
411: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
412: lv_ret_flag VARCHAR2(10) ;
413: lv_error_msg VARCHAR2(1996) ;

Line 410: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;

406: a.line_id = pr_new.source_line_id AND
407: a.header_id = pr_new.source_header_id ;
408:
409: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
410: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
411: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
412: lv_ret_flag VARCHAR2(10) ;
413: lv_error_msg VARCHAR2(1996) ;
414: v_quantity number;

Line 411: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;

407: a.header_id = pr_new.source_header_id ;
408:
409: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
410: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
411: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
412: lv_ret_flag VARCHAR2(10) ;
413: lv_error_msg VARCHAR2(1996) ;
414: v_quantity number;
415: -- End Of Bug #

Line 563: where the tax amounts in the JAI_OM_OE_SO_TAXES and JAI_OM_OE_SO_LINES do not tally.

559: Also the update statement , which updates the released_flag in the JAI_OM_LC_MATCHINGS table
560: has been commented , because the update should happen after the shipping has completed.
561:
562: Also an error message has to be thrown , when shipping is done , for an order
563: where the tax amounts in the JAI_OM_OE_SO_TAXES and JAI_OM_OE_SO_LINES do not tally.
564:
565: 3. Avishek - Bug # 2928261
566: Added a RAISE_APPLICATION_ERROR to give an error message when a sub-inventory is not
567: associated properly with a location ID.

Line 800: /* RAISE_APPLICATION_ERROR(-20405,'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id);

796: FETCH c_ja_in_so_tax_lines_tax_amt INTO v_sum_tax_amount;
797: CLOSE c_ja_in_so_tax_lines_tax_amt;
798:
799: IF NVL(v_line_tax_amount,0) <> NVL(v_sum_tax_amount,0) THEN
800: /* RAISE_APPLICATION_ERROR(-20405,'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id);
801: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id ; return ;
802: END IF;
803: -- ends here bug # 2689417
804:

Line 801: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id ; return ;

797: CLOSE c_ja_in_so_tax_lines_tax_amt;
798:
799: IF NVL(v_line_tax_amount,0) <> NVL(v_sum_tax_amount,0) THEN
800: /* RAISE_APPLICATION_ERROR(-20405,'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id);
801: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id ; return ;
802: END IF;
803: -- ends here bug # 2689417
804:
805: -- Start Of Bug #3392528,

Line 809: that can exists between JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the

805: -- Start Of Bug #3392528,
806: /*
807: This code has been added by aiyer for the bug 3392528.
808: Call the function jai_om_utils_pkg.validate_excise_exemption to validate the different valid combination of values
809: that can exists between JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the
810: table JAI_OM_OE_SO_TAXES
811: */
812:
813: OPEN c_chk_exc_exmpt_rule;

Line 1367: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;

1363: --Ends here for Enh2415656
1364: -- end of addition by subbu
1365:
1366: -- Added by Brathod for Bug#4215808
1367: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
1368: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
1369: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
1370: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
1371: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;

Line 1402: FROM JAI_OM_OE_SO_LINES

1398:
1399: -- End of Addition
1400: CURSOR Get_So_Lines_Count_Cur IS
1401: SELECT COUNT(*)
1402: FROM JAI_OM_OE_SO_LINES
1403: WHERE Line_id = v_source_line_id;
1404:
1405: CURSOR Get_So_Lines_Details_Cur IS
1406: SELECT NVL(Selling_Price,0),

Line 1420: FROM JAI_OM_OE_SO_LINES

1416: vat_exemption_type,
1417: vat_exemption_date,
1418: vat_exemption_refno
1419: -- End of Bug#4215808
1420: FROM JAI_OM_OE_SO_LINES
1421: WHERE Line_id = v_source_line_id;
1422: /*
1423: Code changed by aiyer for the bug #3139718.
1424: Added the cursor to details required for currency conversion.

Line 1686: FROM JAI_OM_OE_SO_LINES

1682: -- following cursors added by sriram bug# 2165355
1683:
1684: CURSOR C_CHECK_LC_ORDER IS
1685: SELECT LC_FLAG
1686: FROM JAI_OM_OE_SO_LINES
1687: WHERE LC_FLAG = 'Y' AND
1688: HEADER_ID = pr_new.SOURCE_HEADER_ID;
1689:
1690: CURSOR C_MATCHED_QTY_CUR IS

Line 1964: Else take it from JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES table.

1960: With this the check becomes that if a organization is trdable, item is tradable , excisable and the order
1961: associated to the bond register is Trading Domestic With Excise and Export With Excise only then
1962: it can be assumed that there would be data in table JAI_CMN_MATCH_TAXES (Match receipts has been performed).
1963: In such a case take the tax_amoutn ,base_tax_amount and func_tax_amoutn for the above table.
1964: Else take it from JAI_OM_OE_SO_LINES and JAI_OM_OE_SO_TAXES table.
1965:
1966:
1967: Dependency Introduced Due to this Bug : -
1968: None

Line 2108: from JAI_OM_OE_SO_LINES table. Also populated jai_vat_preocessing_t temporery

2104:
2105: 23. 2005/03/15 brathod - Bug#4215808- File version 115.5
2106: Trigger modified for VAT Implementation.
2107: New VAT fields in JAI_OM_WSH_LINES_ALL are populated by fetching them
2108: from JAI_OM_OE_SO_LINES table. Also populated jai_vat_preocessing_t temporery
2109: table for VAT invoice number generation
2110:
2111: 24 26/04/2005 Brathod for Bug# 4299606 File Version 116.1
2112: Issue:-

Line 3565: JAI_OM_OE_SO_LINES

3561: IS
3562: SELECT
3563: lc_flag
3564: FROM
3565: JAI_OM_OE_SO_LINES
3566: WHERE
3567: lc_flag = 'Y' AND
3568: header_id = pr_new.source_header_id;
3569: