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 JAI_AP_TDS_VENDOR_HDRS

Line 888: JAI_AP_TDS_VENDOR_HDRS jte,

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
890: WHERE aia.invoice_id = jatit.invoice_id
891: AND jatit.threshold_grp_id IS NOT NULL
892: AND aia.cancelled_date IS NULL

Line 982: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte

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
986: and povs.vendor_site_id = jte.vendor_site_id

Line 1055: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte, po_vendor_sites_all povs

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
1059: -----------------------------------------------------

Line 1184: JAI_AP_TDS_VENDOR_HDRS jte,

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
1186: WHERE aia.invoice_id = jatit.invoice_id
1187: AND jatit.threshold_grp_id IS NOT NULL
1188: AND jatit.threshold_grp_id = c_get_threshold_grp.threshold_grp_id

Line 1284: JAI_AP_TDS_VENDOR_HDRS jte,

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
1286: WHERE aia.invoice_id = jatit.invoice_id
1287: AND jatit.threshold_grp_id IS NOT NULL
1288: AND jatit.threshold_grp_id = c_get_threshold_grp.threshold_grp_id

Line 2083: ,JAI_AP_TDS_VENDOR_HDRS jte -- Added for bug16889298

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
2086: and a.invoice_id = aipa.invoice_id(+) -- Added outer join for bug16889298
2087: --Added for bug16889298 start

Line 5101: FROM JAI_AP_TDS_VENDOR_HDRS

5097: AND lookup_code = p_state_name;
5098:
5099: CURSOR c_deductee_pan(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
5100: SELECT pan_no,confirm_pan_flag /*eTDS FVU3.1 Bug 11896260*/
5101: FROM JAI_AP_TDS_VENDOR_HDRS
5102: WHERE vendor_id = p_vendor_id
5103: AND vendor_site_id = p_vendor_site_id;
5104:
5105: CURSOR c_check_dtls(p_check_id IN NUMBER) IS

Line 5462: FROM jai_ap_tds_vendor_hdrs

5458: group by base_vendor_id, base_vendor_site_id, tds_tax_id, base_invoice_id; /* Added base_invoice_id for bug 16002763 */
5459:
5460: /* cursor c_trans_vendor(p_vendor_id IN NUMBER) IS
5461: SELECT 'T'
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