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 STANDARD

Line 1455: AND aia.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')

1451: AND aia.vendor_site_id = jte.vendor_site_id
1452: AND aia.invoice_id = aida.invoice_id
1453: AND aida.match_status_flag in ('A','T')
1454: AND aida.prepay_amount_remaining IS NULL
1455: AND aia.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')
1456: AND aia.org_id = jror.organization_id
1457: AND jror.regime_code = G_TDS
1458: AND jror.registration_type = 'OTHERS'
1459: AND jror.attribute_code = 'TAN NO'

Line 1587: AND aia.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')

1583: AND aia.vendor_id = jte.vendor_id
1584: AND aia.vendor_site_id = jte.vendor_site_id
1585: AND aia.invoice_id = aida.invoice_id
1586: AND aida.match_status_flag in ('A','T')
1587: AND aia.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')
1588: AND aia.org_id = jror.organization_id
1589: AND jror.regime_code = G_TDS
1590: AND jror.registration_type = 'OTHERS'
1591: AND jror.attribute_code = 'TAN NO'

Line 1807: AND aia.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')

1803: AND aia.vendor_id = jte.vendor_id
1804: AND aia.vendor_site_id = jte.vendor_site_id
1805: AND aia.invoice_id = aida.invoice_id
1806: AND aida.match_status_flag in ('A','T')
1807: AND aia.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')
1808: and not exists (select 1 from jai_ap_tds_thhold_trxs where invoice_id = jatit.invoice_id)
1809: and jitc.tax_rate = 0
1810: and jitc.vendor_id = r_tds_vendor_rec.vendor_id
1811: AND aia.org_id = jror.organization_id

Line 1946: and base_invoices.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')

1942: and jte.tds_vendor_classification in ('Transporter','Software')
1943: and aida.global_attribute_category = 'JA.IN.APXINWKB.DISTRIBUTIONS'
1944: and aida.invoice_id = base_invoices.invoice_id
1945: and aida.match_status_flag in ('A','T') /*10408793 - Unvalidated Invoices must not be picked*/
1946: and base_invoices.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')
1947: and not exists (select '1' from jai_ap_tds_thhold_trxs jattt where jattt.invoice_id = base_invoices.invoice_id) /*Bug 10408793 - TDS should not be deducted*/
1948: and not exists (select '1'
1949: from jai_ap_tds_repository jatr
1950: where jatr.source_invoice_id = base_invoices.invoice_id

Line 2005: and base_invoices.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')

2001: AND base_invoices.org_id = jror.organization_id
2002: AND jror.regime_code = G_TDS
2003: AND jror.registration_type = 'OTHERS'
2004: AND jror.attribute_code = 'TAN NO'
2005: and base_invoices.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT')
2006: and not exists (select '1' from jai_ap_tds_thhold_trxs jattt where jattt.invoice_id = base_invoices.invoice_id)
2007: and not exists (select '1'
2008: from jai_ap_tds_repository jatr
2009: where jatr.source_invoice_id = base_invoices.invoice_id