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_POP_RPST_PKG dependencies on JAI_AP_TDS_VENDOR_HDRS

Line 1439: ,JAI_AP_TDS_VENDOR_HDRS jte

1435: ,fnd_global.user_id
1436: FROM ap_invoices_all aia
1437: ,ap_invoice_distributions_all aida
1438: ,jai_ap_tds_inv_taxes jatit
1439: ,JAI_AP_TDS_VENDOR_HDRS jte
1440: ,JAI_CMN_TAXES_ALL jitc
1441: ,JAI_RGM_ORG_REGNS_V jror
1442: WHERE aia.invoice_id = jatit.invoice_id
1443: AND jatit.threshold_grp_id IS NOT NULL

Line 1571: ,JAI_AP_TDS_VENDOR_HDRS jte

1567: ,fnd_global.user_id
1568: FROM ap_invoices_all aia
1569: ,ap_invoice_distributions_all aida
1570: ,jai_ap_tds_inv_taxes jatit
1571: ,JAI_AP_TDS_VENDOR_HDRS jte
1572: ,JAI_CMN_TAXES_ALL jitc
1573: ,JAI_RGM_ORG_REGNS_V jror
1574: WHERE aia.invoice_id = jatit.invoice_id
1575: AND jatit.threshold_grp_id IS NOT NULL

Line 1694: FROM JAI_AP_TDS_VENDOR_HDRS jatvh

1690:
1691:
1692: --Step5. Loop all vendors that have TDS supplier additional information setup.
1693: For r_tds_vendor_rec IN ( SELECT distinct jatvh.vendor_id
1694: FROM JAI_AP_TDS_VENDOR_HDRS jatvh
1695: )
1696: LOOP
1697: -- Step a. Insert 0% transactions under JAI_TDS_SECTION_ZERO_RATE_197,JAI_TDS_SECTION_ZERO_RATE_197A
1698: INSERT INTO jai_ap_tds_repository(

Line 1796: JAI_AP_TDS_VENDOR_HDRS jte,

1792: ,G_Y MIGRATED
1793: FROM ap_invoices_all aia,
1794: ap_invoice_distributions_all aida,
1795: jai_ap_tds_inv_taxes jatit,
1796: JAI_AP_TDS_VENDOR_HDRS jte,
1797: JAI_CMN_TAXES_ALL jitc,
1798: JAI_RGM_ORG_REGNS_V jror
1799: WHERE aia.invoice_id = jatit.invoice_id
1800: AND jatit.threshold_grp_id IS NOT NULL

Line 1933: , jai_ap_tds_vendor_hdrs jte

1929: from jai_cmn_taxes_all a
1930: , ap_invoices_all base_invoices
1931: , po_vendor_sites_all povs
1932: , ap_invoice_distributions_all aida
1933: , jai_ap_tds_vendor_hdrs jte
1934: , JAI_RGM_ORG_REGNS_V jror
1935: where jte.vendor_id = base_invoices.vendor_id
1936: and povs.vendor_id = jte.vendor_id
1937: and povs.vendor_site_id = jte.vendor_site_id

Line 1988: ,jai_ap_tds_vendor_hdrs jte

1984: ,G_Y
1985: ,G_Y
1986: from ap_invoices_all base_invoices
1987: ,ap_invoice_distributions_all aida
1988: ,jai_ap_tds_vendor_hdrs jte
1989: ,po_vendor_sites_all povs
1990: ,JAI_RGM_ORG_REGNS_V jror
1991: where jte.vendor_id = base_invoices.vendor_id
1992: and jte.vendor_site_id = base_invoices.vendor_site_id