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_CMN_RCV_MATCHING_PKG dependencies on JAI_CMN_MATCH_TAXES

Line 62: Fix ; Insert statement into Jai_cmn_match_Taxes did not included the PK

58: Forward porting the changes done in 11i bug#5907436
59:
60: 7. 26/09/2007 rchandan for bug#6447097. File version 120.10
61: Issue : QA observations of Inter org
62: Fix ; Insert statement into Jai_cmn_match_Taxes did not included the PK
63: match_tax_id.
64: 8. 23-apr-2009 vkaranam for bug#8445390,file version 120.18.12010000.2
65: Issue:
66: In Interorg transfer for a trading org ,matching the transaction quantity against the multiple receipts

Line 549: FROM JAI_CMN_MATCH_TAXES

545:
546:
547: CURSOR Chk_Rcd_Cur IS
548: SELECT NVL( COUNT( * ), 0 )
549: FROM JAI_CMN_MATCH_TAXES
550: WHERE Ref_Line_Id = p_ref_line_id
551: AND Subinventory = p_subinventory
552: AND Receipt_Id = p_receipt_id
553: AND Order_Invoice = 'O';

Line 557: FROM JAI_CMN_MATCH_TAXES

553: AND Order_Invoice = 'O';
554:
555: CURSOR Chk_Rcd_AR_Cur IS
556: SELECT NVL( COUNT( * ), 0 )
557: FROM JAI_CMN_MATCH_TAXES
558: WHERE Ref_Line_Id = p_ref_line_id
559: AND Receipt_Id = p_receipt_id
560: AND Order_Invoice = 'I';
561:

Line 564: FROM JAI_CMN_MATCH_TAXES

560: AND Order_Invoice = 'I';
561:
562: CURSOR Fetch_Totals_Cur( line_no IN NUMBER ) IS
563: SELECT SUM( NVL( Tax_Amount, 0 ) )
564: FROM JAI_CMN_MATCH_TAXES
565: WHERE Subinventory = p_subinventory
566: AND Ref_Line_Id = p_ref_line_id
567: AND Tax_Line_No = line_no;
568:

Line 571: FROM JAI_CMN_MATCH_TAXES

567: AND Tax_Line_No = line_no;
568:
569: CURSOR Fetch_Totals_AR_Cur( line_no IN NUMBER ) IS
570: SELECT SUM( NVL( Tax_Amount, 0 ) )
571: FROM JAI_CMN_MATCH_TAXES
572: WHERE Ref_Line_Id = p_ref_line_id
573: AND Tax_Line_No = line_no;
574:
575: CURSOR Fetch_Total_AR_Cur( line_no IN NUMBER ) IS

Line 578: FROM JAI_CMN_MATCH_TAXES

574:
575: CURSOR Fetch_Total_AR_Cur( line_no IN NUMBER ) IS
576: SELECT SUM( NVL( Tax_Amount, 0 ) ) tax_amount, SUM( NVL( Base_Tax_Amount, 0 ) ) base_tax_amount,
577: SUM( NVL( Func_Tax_Amount, 0 ) ) func_tax_amount
578: FROM JAI_CMN_MATCH_TAXES
579: WHERE Ref_Line_Id = p_ref_line_id
580: AND Tax_Line_No = line_no
581: AND Receipt_ID IS NOT NULL;
582:

Line 650: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,

646: CLOSE Fetch_Exempt_Cur;
647:
648: FOR rec in oe_tax_cur LOOP
649: IF v_count = 0 THEN
650: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,
651: SUBINVENTORY,
652: TAX_LINE_NO,
653: PRECEDENCE_1,
654: PRECEDENCE_2,

Line 680: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,

676: RECEIPT_ID,
677: ORDER_INVOICE )
678:
679:
680: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,
681: p_subinventory,
682: z.lno,
683: rec.p_1,
684: rec.p_2,

Line 1109: DELETE JAI_CMN_MATCH_TAXES

1105: OPEN Fetch_Totals_Cur( i );
1106: FETCH Fetch_Totals_Cur INTO v_cum_amount;
1107: CLOSE Fetch_Totals_Cur;
1108: IF p_line_quantity = 0 THEN
1109: DELETE JAI_CMN_MATCH_TAXES
1110: WHERE Ref_Line_Id = p_ref_line_id
1111: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
1112: AND receipt_id = p_receipt_id
1113: AND Tax_Line_No = i;

Line 1115: UPDATE JAI_CMN_MATCH_TAXES

1111: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
1112: AND receipt_id = p_receipt_id
1113: AND Tax_Line_No = i;
1114: ELSE
1115: UPDATE JAI_CMN_MATCH_TAXES
1116: SET Tax_Amount = tax_amt_tab(i),
1117: Base_Tax_Amount = tax_target_tab(i),
1118: Func_Tax_Amount = tax_amt_tab(i) ,
1119: --* NVL( p_curr_conv_factor, 1 ),

Line 1197: FROM JAI_CMN_MATCH_TAXES

1193: WHERE Link_To_Cust_Trx_Line_Id = p_link_to_cust_trx_line_id;
1194:
1195: CURSOR Chk_Tax_Count_Cur IS
1196: SELECT NVL( MAX( Tax_Line_No ), 0 )
1197: FROM JAI_CMN_MATCH_TAXES
1198: WHERE Ref_Line_Id = p_ref_line_id;
1199:
1200: CURSOR Fetch_New_Taxes_Cur IS
1201: SELECT *

Line 1242: Commented insert into JAI_CMN_MATCH_TAXES

1238: Added a cursor Get_Receipt_taxes to fetch taxes from Receipts
1239: When Manual Invoice is matched against a Receipt
1240:
1241: 2. 10/01/2005 brathod for Bug#4111609 Version#115.1
1242: Commented insert into JAI_CMN_MATCH_TAXES
1243: since it is not required
1244: base bug# 4146708 creates objects
1245:
1246: --------------------------------------------------------------------------------------------*/

Line 1274: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,

1270:
1271: /* bug# 4111609 insertion not required. So code commented */
1272:
1273: /*
1274: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,
1275: SUBINVENTORY,
1276: TAX_LINE_NO,
1277: PRECEDENCE_1,
1278: PRECEDENCE_2,

Line 1302: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,

1298: LAST_UPDATE_LOGIN,
1299: LAST_UPDATED_BY,
1300: RECEIPT_ID,
1301: ORDER_INVOICE )
1302: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,
1303: NULL,
1304: rec1.tax_line_no,
1305: rec1.p_1,
1306: rec1.p_2,

Line 1352: DELETE JAI_CMN_MATCH_TAXES

1348: p_qty,
1349: p_curr_conv_factor,
1350: 'I' );
1351: ELSE
1352: DELETE JAI_CMN_MATCH_TAXES
1353: WHERE Ref_Line_Id = p_ref_line_id
1354: AND receipt_id = p_receipt_id;
1355:
1356: FOR Rec IN Fetch_AR_Line_Info_Cur LOOP

Line 1700: FROM JAI_CMN_MATCH_TAXES

1696:
1697:
1698: CURSOR Chk_Rcd_Cur IS
1699: SELECT NVL( COUNT( * ), 0 )
1700: FROM JAI_CMN_MATCH_TAXES
1701: WHERE Ref_Line_Id = p_ref_line_id
1702: AND Subinventory = p_subinventory
1703: AND Receipt_Id = p_receipt_id
1704: AND Order_Invoice = 'O';

Line 1708: FROM JAI_CMN_MATCH_TAXES

1704: AND Order_Invoice = 'O';
1705:
1706: CURSOR Chk_Rcd_AR_Cur IS
1707: SELECT NVL( COUNT( * ), 0 )
1708: FROM JAI_CMN_MATCH_TAXES
1709: WHERE Ref_Line_Id = p_ref_line_id
1710: AND Receipt_Id = p_receipt_id
1711: AND Order_Invoice = 'I';
1712:

Line 1715: FROM JAI_CMN_MATCH_TAXES

1711: AND Order_Invoice = 'I';
1712:
1713: CURSOR Fetch_Totals_Cur( line_no IN NUMBER ) IS
1714: SELECT SUM( NVL( Tax_Amount, 0 ) )
1715: FROM JAI_CMN_MATCH_TAXES
1716: WHERE Subinventory = p_subinventory
1717: AND Ref_Line_Id = p_ref_line_id
1718: AND Tax_Line_No = line_no;
1719:

Line 1722: FROM JAI_CMN_MATCH_TAXES

1718: AND Tax_Line_No = line_no;
1719:
1720: CURSOR Fetch_Totals_AR_Cur( line_no IN NUMBER ) IS
1721: SELECT SUM( NVL( Tax_Amount, 0 ) )
1722: FROM JAI_CMN_MATCH_TAXES
1723: WHERE Ref_Line_Id = p_ref_line_id
1724: AND Tax_Line_No = line_no;
1725:
1726: CURSOR Fetch_Total_AR_Cur( line_no IN NUMBER ) IS

Line 1729: FROM JAI_CMN_MATCH_TAXES

1725:
1726: CURSOR Fetch_Total_AR_Cur( line_no IN NUMBER ) IS
1727: SELECT SUM( NVL( Tax_Amount, 0 ) ) tax_amount, SUM( NVL( Base_Tax_Amount, 0 ) ) base_tax_amount,
1728: SUM( NVL( Func_Tax_Amount, 0 ) ) func_tax_amount
1729: FROM JAI_CMN_MATCH_TAXES
1730: WHERE Ref_Line_Id = p_ref_line_id
1731: AND Tax_Line_No = line_no
1732: AND Receipt_ID IS NOT NULL;
1733:

Line 2080: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,

2076: CLOSE Fetch_Exempt_Cur;
2077:
2078: FOR rec in oe_tax_cur(ln_cess_check, ln_sh_cess_check) LOOP/*Bug 5989740 bduvarag*/
2079: IF v_count = 0 THEN
2080: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,
2081: SUBINVENTORY,
2082: TAX_LINE_NO,
2083: PRECEDENCE_1,
2084: PRECEDENCE_2,

Line 2108: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,

2104: LAST_UPDATE_LOGIN,
2105: LAST_UPDATED_BY,
2106: RECEIPT_ID,
2107: ORDER_INVOICE )
2108: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,
2109: p_subinventory,
2110: rec.lno,
2111: rec.p_1,
2112: rec.p_2,

Line 2440: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,

2436: FOR rec in ar_tax_cur(ln_cess_check, ln_sh_cess_check) LOOP/*Bug 5989740 bduvarag*/
2437:
2438: IF v_count = 0 THEN
2439:
2440: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,
2441: SUBINVENTORY,
2442: TAX_LINE_NO,
2443: PRECEDENCE_1,
2444: PRECEDENCE_2,

Line 2468: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,

2464: LAST_UPDATE_LOGIN,
2465: LAST_UPDATED_BY,
2466: RECEIPT_ID,
2467: ORDER_INVOICE )
2468: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,
2469: p_subinventory,
2470: rec.lno,
2471: rec.p_1,
2472: rec.p_2,

Line 2812: INSERT INTO Jai_cmn_match_Taxes( match_tax_id, --6447097

2808: IF v_count = 0 THEN
2809:
2810:
2811:
2812: INSERT INTO Jai_cmn_match_Taxes( match_tax_id, --6447097
2813: REF_LINE_ID,
2814: SUBINVENTORY,
2815: TAX_LINE_NO,
2816: PRECEDENCE_1,

Line 2842: VALUES ( jai_cmn_match_taxes_s.nextval,--6447097

2838: PRECEDENCE_8,
2839: PRECEDENCE_9,
2840: PRECEDENCE_10
2841: )
2842: VALUES ( jai_cmn_match_taxes_s.nextval,--6447097
2843: p_ref_line_id,
2844: p_subinventory,
2845: rec.lno,
2846: rec.p_1,

Line 4467: DELETE JAI_CMN_MATCH_TAXES

4463: OPEN Fetch_Totals_Cur( i );
4464: FETCH Fetch_Totals_Cur INTO v_cum_amount;
4465: CLOSE Fetch_Totals_Cur;
4466: IF p_line_quantity = 0 THEN
4467: DELETE JAI_CMN_MATCH_TAXES
4468: WHERE Ref_Line_Id = p_ref_line_id
4469: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
4470: AND receipt_id = p_receipt_id
4471: AND Tax_Line_No = i;

Line 4474: UPDATE JAI_CMN_MATCH_TAXES

4470: AND receipt_id = p_receipt_id
4471: AND Tax_Line_No = i;
4472: ELSE
4473: -- insert into jai_debug values('before update base_tax_amount_nr_tab(I) ',base_tax_amount_nr_tab(I)); 9794835
4474: UPDATE JAI_CMN_MATCH_TAXES
4475: SET Tax_Amount = tax_amt_tab(i),
4476: -- Base_Tax_Amount = tax_target_tab(i),
4477: Base_Tax_Amount = lt_base_tax_amt_tab(i) --bug#9794853
4478: ,Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 ),

Line 4490: DELETE JAI_CMN_MATCH_TAXES

4486: OPEN Fetch_Totals_AR_Cur( i );
4487: FETCH Fetch_Totals_AR_Cur INTO v_cum_amount;
4488: CLOSE Fetch_Totals_AR_Cur;
4489: IF p_line_quantity = 0 THEN
4490: DELETE JAI_CMN_MATCH_TAXES
4491: WHERE Ref_Line_Id = p_ref_line_id
4492: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
4493: AND receipt_id = p_receipt_id
4494: AND Tax_Line_No = i;

Line 4496: UPDATE JAI_CMN_MATCH_TAXES

4492: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
4493: AND receipt_id = p_receipt_id
4494: AND Tax_Line_No = i;
4495: ELSE
4496: UPDATE JAI_CMN_MATCH_TAXES
4497: SET Tax_Amount = tax_amt_tab(i),
4498: -- Base_Tax_Amount = tax_target_tab(i),
4499: Base_Tax_Amount = lt_base_tax_amt_tab(i) --bug#9794853
4500: ,Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 ),

Line 4536: UPDATE Jai_cmn_match_Taxes

4532: WHERE source_doc_line_id = p_ref_line_id
4533: AND source_doc_type = 'INTERORG_XFER'
4534: AND Tax_Line_No = i;
4535:
4536: UPDATE Jai_cmn_match_Taxes
4537: SET Tax_Amount = tax_amt_tab(i),
4538: -- Base_Tax_Amount = tax_target_tab(i),
4539: Base_Tax_Amount = lt_base_tax_amt_tab(i) --bug#9794853
4540: ,Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 )