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_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_LINE_TAXES

Line 483: FROM JAI_RCV_LINE_TAXES a,

479: ) tax_amount*/,
480: a.tax_type,
481: a.tax_id,
482: NVL(b.rounding_factor,0) rounding_factor
483: FROM JAI_RCV_LINE_TAXES a,
484: JAI_CMN_TAXES_ALL b
485: WHERE a.transaction_id = cp_transaction_id
486: AND a.tax_type IN ( select tax_type
487: from jai_regime_tax_types_v

Line 757: FROM JAI_RCV_LINE_TAXES rtl,

753: nvl(rtl.modvat_flag, 'N') modvat_flag,
754: nvl(rtl.currency, jai_constants.func_curr) currency,
755: nvl(jtc.rounding_factor, 0) rnd,
756: nvl(jtc.mod_cr_percentage, 0) modvat_percentage /*Added by Nitin for bug # 6681800*/
757: FROM JAI_RCV_LINE_TAXES rtl,
758: JAI_CMN_TAXES_ALL jtc
759: WHERE shipment_line_id = cp_shipment_line_id
760: AND jtc.tax_id = rtl.tax_id
761: AND rtl.modvat_flag = 'Y'

Line 809: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b

805:
806: CURSOR c_vat_exists(cp_shipment_line_id NUMBER )
807: IS
808: SELECT 1
809: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b
810: WHERE shipment_line_id = cp_shipment_line_id AND
811: b.regime_code= jai_constants.vat_regime
812: and b.tax_type = a.tax_type ;
813:

Line 1206: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,

1202: lv_process_message VARCHAR2(1000);
1203: ln_location_id NUMBER;
1204: ln_statement_id NUMBER;
1205:
1206: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
1207: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
1208: IS
1209: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1210: FROM JAI_RCV_LINE_TAXES

Line 1210: FROM JAI_RCV_LINE_TAXES

1206: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
1207: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
1208: IS
1209: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1210: FROM JAI_RCV_LINE_TAXES
1211: WHERE transaction_id = cp_transaction_id
1212: AND tax_type in (select tax_type
1213: from jai_regime_tax_types_v
1214: where regime_code = jai_constants.vat_regime)

Line 2393: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,

2389: AND a.organization_id = b.organization_id
2390: AND a.location_id = b.location_id
2391: AND b.process_status_flag = 'Z'; /* 'Z' meaning the line is marked for UNCLAIM, but not yet processed*/
2392:
2393: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2394: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2395: IS
2396: SELECT jtl.tax_type,
2397: /*Added by Nitin for Bug # 6681800 */ SUM(DECODE(jtl.currency, jai_constants.func_curr, jtl.tax_amount*(rtl.mod_cr_percentage/100), jtl.tax_amount*(rtl.mod_cr_percentage/100)*cp_currency_conversion_rate)) tax_amount

Line 2399: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/

2395: IS
2396: SELECT jtl.tax_type,
2397: /*Added by Nitin for Bug # 6681800 */ SUM(DECODE(jtl.currency, jai_constants.func_curr, jtl.tax_amount*(rtl.mod_cr_percentage/100), jtl.tax_amount*(rtl.mod_cr_percentage/100)*cp_currency_conversion_rate)) tax_amount
2398: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/
2399: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/
2400: WHERE jtl.transaction_id = cp_transaction_id
2401: AND jtl.tax_type in (select tax_type
2402: from jai_regime_tax_types_v
2403: where regime_code = jai_constants.vat_regime)

Line 2408: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,

2404: AND NVL(jtl.modvat_flag,'N') = 'Y'
2405: AND jtl.tax_id = rtl.tax_id -- Bug 7454592. Added by Lakshmi Gopalsami
2406: GROUP BY jtl.tax_type;
2407:
2408: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2409: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2410: IS
2411: SELECT SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, /*Added by Nitin for bug # 6681800*/a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,1))) tax_amount
2412: FROM JAI_RCV_LINE_TAXES a,

Line 2412: FROM JAI_RCV_LINE_TAXES a,

2408: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2409: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2410: IS
2411: SELECT SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, /*Added by Nitin for bug # 6681800*/a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,1))) tax_amount
2412: FROM JAI_RCV_LINE_TAXES a,
2413: JAI_CMN_TAXES_ALL b
2414: WHERE a.transaction_id = cp_transaction_id
2415: AND a.tax_type in (select tax_type
2416: from jai_regime_tax_types_v

Line 2814: jai_rcv_line_taxes jrtl

2810: WHERE invoice_id = ln_invoice_id
2811: AND invoice_distribution_id /*distribution_line_number*/ IN /*Replaced distribution_line_number by invoice_distribution_id for bug # 11659328*/
2812: (SELECT invoice_distribution_id /*distribution_line_number*/
2813: FROM jai_ap_match_inv_taxes jatd,
2814: jai_rcv_line_taxes jrtl
2815: WHERE jrtl.tax_id = jatd.tax_id
2816: AND jatd.invoice_id = ln_invoice_id
2817: AND jrtl.transaction_id = r_receive_transaction.transaction_id
2818: AND jrtl.shipment_line_id = r_shipment_lines.shipment_line_id

Line 2829: UPDATE JAI_RCV_LINE_TAXES

2825: END IF; /*Bug 11880460 modified the above select statement in sync with the code in 12.1 by abezgam*/
2826: END LOOP;
2827: /*Bug 8648138*/
2828:
2829: UPDATE JAI_RCV_LINE_TAXES
2830: SET modvat_flag = 'N',
2831: last_update_date = SYSDATE,
2832: last_updated_by = fnd_global.user_id,
2833: last_update_login = fnd_global.login_id

Line 3518: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,

3514: p_process_status OUT NOCOPY VARCHAR2,
3515: p_process_message OUT NOCOPY VARCHAR2)
3516: IS
3517:
3518: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
3519: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
3520: IS
3521: SELECT a.tax_type,/*COL (b.mod_cr_percentage/100) added by Nitin for bug #6681800*/
3522: SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,0))) tax_amount

Line 3523: FROM JAI_RCV_LINE_TAXES a,

3519: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
3520: IS
3521: SELECT a.tax_type,/*COL (b.mod_cr_percentage/100) added by Nitin for bug #6681800*/
3522: SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,0))) tax_amount
3523: FROM JAI_RCV_LINE_TAXES a,
3524: JAI_CMN_TAXES_ALL b
3525: WHERE a.transaction_id = cp_transaction_id
3526: AND a.tax_type in (select tax_type
3527: from jai_regime_tax_types_v