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.JE_ES_WHTAX dependencies on AP_TAX_CODES_ALL

Line 697: ap_tax_codes_all atc,

693: fnd_lookups fl,
694: ap_invoices_all inv,
695: ap_invoice_lines_all line,
696: ap_invoice_distributions_all dist,
697: ap_tax_codes_all atc,
698: ap_awt_tax_rates_all awt,
699: (SELECT distinct person_id
700: ,national_identifier
701: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

Line 768: (select tax_id from ap_tax_codes_all

764: and dist2.line_type_lookup_code = 'AWT'
765: and dist2.withholding_tax_code_id in
766: -- Bug 2019586: Column name should be tax_id.
767: -- (select tax_code_id from ap_tax_codes
768: (select tax_id from ap_tax_codes_all
769: where vat_transaction_type = p_wht_tax_type))
770: GROUP BY decode(nvl(v.employee_id,-1),-1,'G','A'),
771: decode(nvl(v.employee_id,-1),-1,'01','00'),
772: nvl(substr(nvl(papf.national_identifier,nvl(v.individual_1099,v.num_1099)),1,9),' '),

Line 793: ap_tax_codes_all atc,

789: nvl(dist.base_amount,dist.amount),0)) withholding_tax_amount
790: FROM fnd_lookups fl,
791: po_vendors v,
792: po_vendor_sites_all vs,
793: ap_tax_codes_all atc,
794: ap_awt_tax_rates_all awt,
795: ap_invoices_all inv,
796: ap_invoice_lines_all line,
797: ap_invoice_distributions_all dist,

Line 888: (select tax_id from ap_tax_codes_all

884: and dist2.line_type_lookup_code = 'AWT'
885: and dist2.withholding_tax_code_id in
886: -- Bug 2019586: Column name should be tax_id.
887: -- (select tax_code_id from ap_tax_codes
888: (select tax_id from ap_tax_codes_all
889: where vat_transaction_type = p_wht_tax_type))
890: GROUP BY decode(nvl(v.employee_id,-1),-1,'G','A'),
891: decode(nvl(v.employee_id,-1),-1,'01','00'),
892: nvl(substr(nvl(papf.national_identifier,nvl(v.individual_1099,v.num_1099)),1,9),' '),

Line 943: ap_tax_codes_all atc,

939: po_vendors v,
940: po_vendor_sites_all vs,
941: ap_invoice_payments_all invpay,
942: ap_checks_all checks,
943: ap_tax_codes_all atc,
944: ap_awt_tax_rates_all awt,
945: fnd_document_sequences seq,
946: ap_invoices_all inv,
947: ap_invoice_lines_all line,

Line 1031: from ap_tax_codes_all

1027: and dist2.withholding_tax_code_id in
1028: -- Bug 2019586: Column name should be tax_id.
1029: -- (select tax_code_id from ap_tax_codes
1030: (select tax_id
1031: from ap_tax_codes_all
1032: where vat_transaction_type = p_wht_tax_type))
1033: AND NOT EXISTS ( select dist2.invoice_id
1034: from ap_invoice_distributions_all dist2
1035: where inv.invoice_id = dist2.invoice_id

Line 1122: ap_tax_codes_all atc,

1118: po_vendors v,
1119: po_vendor_sites_all vs,
1120: ap_invoice_payments_all invpay,
1121: ap_checks_all checks,
1122: ap_tax_codes_all atc,
1123: ap_awt_tax_rates_all awt,
1124: fnd_document_sequences seq,
1125: ap_invoices_all inv,
1126: ap_invoice_lines_all line,

Line 1226: from ap_tax_codes_all

1222: and dist2.withholding_tax_code_id in
1223: -- Bug 2019586: Column name should be tax_id.
1224: -- (select tax_code_id from ap_tax_codes
1225: (select tax_id
1226: from ap_tax_codes_all
1227: where vat_transaction_type = p_wht_tax_type))
1228: AND NOT EXISTS ( select dist2.invoice_id
1229: from ap_invoice_distributions_all dist2
1230: where inv.invoice_id = dist2.invoice_id

Line 1314: ap_tax_codes_all atc,

1310: po_vendors v,
1311: po_vendor_sites_all vs,
1312: ap_invoice_payments_all invpay,
1313: ap_checks_all checks,
1314: ap_tax_codes_all atc,
1315: ap_awt_tax_rates_all awt,
1316: fnd_document_sequences seq,
1317: ap_invoices_all inv,
1318: ap_invoice_lines_all line,

Line 1399: from ap_tax_codes_all

1395: and dist2.withholding_tax_code_id in
1396: -- Bug 2019586: Column name should be tax_id.
1397: -- (select tax_code_id from ap_tax_codes
1398: (select tax_id
1399: from ap_tax_codes_all
1400: where vat_transaction_type = p_wht_tax_type))
1401: AND NOT EXISTS ( select dist2.invoice_id
1402: from ap_invoice_distributions_all dist2
1403: where inv.invoice_id = dist2.invoice_id

Line 1490: ap_tax_codes_all atc,

1486: po_vendors v,
1487: po_vendor_sites_all vs,
1488: ap_invoice_payments_all invpay,
1489: ap_checks_all checks,
1490: ap_tax_codes_all atc,
1491: ap_awt_tax_rates_all awt,
1492: fnd_document_sequences seq,
1493: ap_invoices_all inv,
1494: ap_invoice_lines_all line,

Line 1593: from ap_tax_codes_all

1589: and dist2.withholding_tax_code_id in
1590: -- Bug 2019586: Column name should be tax_id.
1591: -- (select tax_code_id from ap_tax_codes
1592: (select tax_id
1593: from ap_tax_codes_all
1594: where vat_transaction_type = p_wht_tax_type))
1595: AND NOT EXISTS ( select dist2.invoice_id
1596: from ap_invoice_distributions_all dist2
1597: where inv.invoice_id = dist2.invoice_id

Line 1680: ap_tax_codes_all atc,

1676: po_vendors v,
1677: po_vendor_sites_all vs,
1678: ap_invoice_payments_all invpay,
1679: ap_checks_all checks,
1680: ap_tax_codes_all atc,
1681: ap_awt_tax_rates_all awt,
1682: fnd_document_sequences seq,
1683: ap_invoices_all inv,
1684: ap_invoice_lines_all line,

Line 1763: from ap_tax_codes_all

1759: and dist2.withholding_tax_code_id in
1760: -- Bug 2019586: Column name should be tax_id.
1761: -- (select tax_code_id from ap_tax_codes
1762: (select tax_id
1763: from ap_tax_codes_all
1764: where vat_transaction_type = p_wht_tax_type))
1765: AND EXISTS ( select dist2.invoice_id
1766: from ap_invoice_distributions_all dist2
1767: where inv.invoice_id = dist2.invoice_id

Line 1854: ap_tax_codes_all atc,

1850: po_vendors v,
1851: po_vendor_sites_all vs,
1852: ap_invoice_payments_all invpay,
1853: ap_checks_all checks,
1854: ap_tax_codes_all atc,
1855: ap_awt_tax_rates_all awt,
1856: fnd_document_sequences seq,
1857: ap_invoices_all inv,
1858: ap_invoice_lines_all line,

Line 1955: from ap_tax_codes_all

1951: and dist2.withholding_tax_code_id in
1952: -- Bug 2019586: Column name should be tax_id.
1953: -- (select tax_code_id from ap_tax_codes
1954: (select tax_id
1955: from ap_tax_codes_all
1956: where vat_transaction_type = p_wht_tax_type))
1957: AND EXISTS ( select dist2.invoice_id
1958: from ap_invoice_distributions_all dist2
1959: where inv.invoice_id = dist2.invoice_id

Line 2032: ap_tax_codes_all atc,

2028: 'N'
2029: FROM fnd_lookups fl,
2030: po_vendors v,
2031: po_vendor_sites_all vs,
2032: ap_tax_codes_all atc,
2033: ap_awt_tax_rates_all awt,
2034: fnd_document_sequences seq,
2035: ap_invoices_all inv,
2036: ap_invoice_lines_all line,

Line 2109: (select tax_id from ap_tax_codes_all

2105: and dist2.line_type_lookup_code = 'AWT'
2106: and dist2.withholding_tax_code_id in
2107: -- Bug 2019586: Column name should be tax_id.
2108: -- (select tax_code_id from ap_tax_codes
2109: (select tax_id from ap_tax_codes_all
2110: where vat_transaction_type = p_wht_tax_type))
2111: GROUP BY decode(nvl(v.employee_id,-1),-1,'G','A'),
2112: decode(nvl(v.employee_id,-1),-1,'01','00'),
2113: nvl(substr(nvl(papf.national_identifier,nvl(v.individual_1099,v.num_1099)),1,9),' '),

Line 2167: ap_tax_codes_all atc,

2163: 'Y'
2164: FROM fnd_lookups fl,
2165: po_vendors v,
2166: po_vendor_sites_all vs,
2167: ap_tax_codes_all atc,
2168: ap_awt_tax_rates_all awt,
2169: fnd_document_sequences seq,
2170: ap_invoices_all inv,
2171: ap_invoice_lines_all line,

Line 2262: (select tax_id from ap_tax_codes_all

2258: and dist2.line_type_lookup_code = 'AWT'
2259: and dist2.withholding_tax_code_id in
2260: -- Bug 2019586: Column name should be tax_id.
2261: -- (select tax_code_id from ap_tax_codes
2262: (select tax_id from ap_tax_codes_all
2263: where vat_transaction_type = p_wht_tax_type))
2264: GROUP BY decode(nvl(v.employee_id,-1),-1,'G','A'),
2265: decode(nvl(v.employee_id,-1),-1,'01','00'),
2266: nvl(substr(nvl(papf.national_identifier,nvl(v.individual_1099,v.num_1099)),1,9),' '),

Line 2399: from ap_tax_codes_all atc, ap_awt_tax_rates_all awt

2395:
2396:
2397: select awt.tax_rate, awt.tax_name
2398: into l_tax_rate, l_tax_name
2399: from ap_tax_codes_all atc, ap_awt_tax_rates_all awt
2400: where atc.name = awt.tax_name(+)
2401: and atc.tax_id = l_tax_code_id
2402: and l_accounting_date between nvl(awt.start_date,l_accounting_date)
2403: and nvl(awt.end_date,l_accounting_date)