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_AP_TDS_ETDS_PKG dependencies on AP_INVOICES_ALL

Line 487: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;

483: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
484: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
485: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
486: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
487: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
488:
489: -- added, Harshita for Bug 4525089
490:
491: lv_cert_issue_date DATE ;

Line 561: FROM ap_invoices_all

557: );
558: CURSOR c_gl_date(p_tds_invoice_id IN NUMBER)
559: IS
560: SELECT gl_date
561: FROM ap_invoices_all
562: WHERE invoice_id = p_tds_invoice_id;
563: CURSOR c_chk_threshold_rollback(p_threshold_grp_id IN NUMBER)
564: IS
565: SELECT invoice_to_tds_authority_id

Line 798: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices

794: fnd_global.user_id,
795: sysdate,
796: fnd_global.user_id,
797: sysdate
798: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices
799: where a.parent_invoice_id = base_invoices.invoice_id
800: and a.invoice_id = tds_invoices.invoice_id
801: \*Bug 10020606 - All TDS reports must be based on GL Date or date on which TCS Liability is booked*\
802: and base_invoices.gl_date between p_tds_inv_from_date and p_tds_inv_to_date

Line 885: FROM ap_invoices_all aia,

881: fnd_global.user_id,
882: sysdate,
883: fnd_global.user_id,
884: sysdate
885: FROM ap_invoices_all aia,
886: ap_invoice_distributions_all aida,
887: jai_ap_tds_inv_taxes jatit,
888: JAI_AP_TDS_VENDOR_HDRS jte,
889: JAI_CMN_TAXES_ALL jitc

Line 981: from jai_cmn_taxes_all a, ap_invoices_all base_invoices, po_vendor_sites_all povs, \* Added by Avanija for FVU3.6 *\

977: fnd_global.user_id,
978: sysdate,
979: fnd_global.user_id,
980: sysdate
981: from jai_cmn_taxes_all a, ap_invoices_all base_invoices, po_vendor_sites_all povs, \* Added by Avanija for FVU3.6 *\
982: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte
983: where jte.vendor_id = base_invoices.vendor_id
984: \* FVU3.6 -start *\
985: and povs.vendor_id = jte.vendor_id

Line 1054: from ap_invoices_all base_invoices,

1050: fnd_global.user_id,
1051: sysdate,
1052: fnd_global.user_id,
1053: sysdate
1054: from ap_invoices_all base_invoices,
1055: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte, po_vendor_sites_all povs
1056: where jte.vendor_id = base_invoices.vendor_id
1057: and jte.vendor_site_id = base_invoices.vendor_site_id--Added by Zhhou for bug#15962641 20121205
1058: --Changed by Zhiwei for Bug#15840480 FVU3.6 begin

Line 1181: FROM ap_invoices_all aia,

1177: fnd_global.user_id,
1178: sysdate,
1179: fnd_global.user_id,
1180: sysdate
1181: FROM ap_invoices_all aia,
1182: ap_invoice_distributions_all aida,
1183: jai_ap_tds_inv_taxes jatit,
1184: JAI_AP_TDS_VENDOR_HDRS jte,
1185: JAI_CMN_TAXES_ALL jitc

Line 1281: FROM ap_invoices_all aia,

1277: fnd_global.user_id,
1278: sysdate,
1279: fnd_global.user_id,
1280: sysdate
1281: FROM ap_invoices_all aia,
1282: ap_invoice_distributions_all aida,
1283: jai_ap_tds_inv_taxes jatit,
1284: JAI_AP_TDS_VENDOR_HDRS jte,
1285: JAI_CMN_TAXES_ALL jitc

Line 1386: FROM ap_invoices_all

1382: ln_calculated_inv_amt := 0;
1383: ln_pp_apply_amt := 0;
1384: ln_remain_amt := 0;
1385: SELECT invoice_amount - NVL(amount_paid, 0) INTO ln_calculated_inv_amt
1386: FROM ap_invoices_all
1387: WHERE invoice_id = c_update_amount.base_invoice_id;
1388: fnd_file.put_line(FND_FILE.LOG, 'c_update_amount.base_invoice_id: ' || c_update_amount.base_invoice_id);
1389: fnd_file.put_line(FND_FILE.LOG, 'ln_calculated_inv_amt: ' || ln_calculated_inv_amt);
1390: IF c_update_amount.base_invoice_type_lookup_code = 'STANDARD' THEN

Line 1422: from JAI_AP_ETDS_T a, ap_invoices_all b

1418: \*11896260 - Changes for FVU 3.1 - End*\
1419:
1420: FOR dtl IN (select a.rowid row_id, a.*,
1421: b.vendor_id vendor_id, b.vendor_site_id vendor_site_id, b.invoice_type_lookup_code inv_type
1422: from JAI_AP_ETDS_T a, ap_invoices_all b
1423: where a.batch_id = p_batch_id and a.base_invoice_id = b.invoice_id
1424: and a.tds_invoice_id not in ( -9999, -9997) ) \* Added Condition for Bug#10315928 *\ \* ER: 13514846 *\
1425: LOOP
1426:

Line 1738: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;

1734: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1735: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1736: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
1737: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
1738: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
1739:
1740: -- added, Harshita for Bug 4525089
1741:
1742: lv_cert_issue_date DATE ;

Line 1812: FROM ap_invoices_all

1808: );
1809: CURSOR c_gl_date(p_tds_invoice_id IN NUMBER)
1810: IS
1811: SELECT gl_date
1812: FROM ap_invoices_all
1813: WHERE invoice_id = p_tds_invoice_id;
1814: CURSOR c_chk_threshold_rollback(p_threshold_grp_id IN NUMBER)
1815: IS
1816: SELECT invoice_to_tds_authority_id

Line 2080: ,ap_invoices_all base_invoices

2076: sysdate,
2077: fnd_global.user_id,
2078: sysdate
2079: from jai_ap_tds_repository a
2080: ,ap_invoices_all base_invoices
2081: ,ap_invoices_all tds_invoices
2082: ,ap_invoice_payments_all aipa
2083: ,JAI_AP_TDS_VENDOR_HDRS jte -- Added for bug16889298
2084: where a.source_invoice_id = base_invoices.invoice_id

Line 2081: ,ap_invoices_all tds_invoices

2077: fnd_global.user_id,
2078: sysdate
2079: from jai_ap_tds_repository a
2080: ,ap_invoices_all base_invoices
2081: ,ap_invoices_all tds_invoices
2082: ,ap_invoice_payments_all aipa
2083: ,JAI_AP_TDS_VENDOR_HDRS jte -- Added for bug16889298
2084: where a.source_invoice_id = base_invoices.invoice_id
2085: and a.invoice_id = tds_invoices.invoice_id(+) -- Added outer join for bug16889298

Line 2125: ,ap_invoices_all b

2121: ,b.vendor_id vendor_id
2122: ,b.vendor_site_id vendor_site_id
2123: ,b.invoice_type_lookup_code inv_type
2124: from JAI_AP_ETDS_T a
2125: ,ap_invoices_all b
2126: where a.batch_id = p_batch_id
2127: and a.base_invoice_id = b.invoice_id
2128: and a.tds_invoice_id not in ( -9999, -9997) )
2129: LOOP

Line 5320: FROM ap_invoices_all

5316: /* Bug#10315928 - End */
5317: /*Bug 10188600-Start*/
5318: CURSOR get_gl_date(p_base_invoice_id IN NUMBER) IS
5319: SELECT gl_date
5320: FROM ap_invoices_all
5321: WHERE invoice_id = p_base_invoice_id;
5322: /*Bug 10188600-End*/
5323:
5324:

Line 5466: CURSOR c_get_tds_gl_date(cp_invoice_id ap_invoices_all.invoice_id%type) IS

5462: FROM jai_ap_tds_vendor_hdrs
5463: WHERE vendor_id = p_vendor_id;*/
5464:
5465: /* Bug#10315928 - End */
5466: CURSOR c_get_tds_gl_date(cp_invoice_id ap_invoices_all.invoice_id%type) IS
5467: SELECT gl_date
5468: FROM ap_invoices_all
5469: WHERE invoice_id = cp_invoice_id;
5470:

Line 5468: FROM ap_invoices_all

5464:
5465: /* Bug#10315928 - End */
5466: CURSOR c_get_tds_gl_date(cp_invoice_id ap_invoices_all.invoice_id%type) IS
5467: SELECT gl_date
5468: FROM ap_invoices_all
5469: WHERE invoice_id = cp_invoice_id;
5470:
5471: ld_tds_gl_date date;
5472:

Line 5609: v_base_gl_date ap_invoices_all.gl_date%TYPE;/Bug 10188600/

5605: v_deductee_pan VARCHAR2(20);
5606: v_confirm_pan_flag VARCHAR2(1);/*ETDS FVU3.1 Bug 11896260 */
5607: v_stform_name VARCHAR2(25);
5608: v_vendor_name PO_VENDORS.vendor_name%TYPE;
5609: v_base_gl_date ap_invoices_all.gl_date%TYPE;/*Bug 10188600*/
5610: v_site_dtls c_deductee_site_dtls%ROWTYPE;
5611: v_base_inv_check_dtls c_check_dtls%ROWTYPE;
5612: v_tds_inv_check_dtls c_check_dtls%ROWTYPE;
5613: v_cert_issue_date DATE;