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 PO_VENDOR_SITES_ALL

Line 692: po_vendor_sites_all vs,

688: nvl(dist.base_amount,dist.amount)))) net_amount,
689: sum(decode(dist.line_type_lookup_code,'AWT',
690: nvl(dist.base_amount,dist.amount),0)) withholding_tax_amount
691: FROM po_vendors v,
692: po_vendor_sites_all vs,
693: fnd_lookups fl,
694: ap_invoices_all inv,
695: ap_invoice_lines_all line,
696: ap_invoice_distributions_all dist,

Line 707: from po_vendor_sites_all

703: AND nvl(v.employee_id,-99) = papf.person_id (+)
704: -- bug 8551359 - start
705: --AND vs.tax_reporting_site_flag = 'Y'
706: AND exists (select 'x'
707: from po_vendor_sites_all
708: where vendor_id = v.vendor_id
709: and tax_reporting_site_flag = 'Y'
710: and org_id = p_rep_site_ou)
711: -- bug 8551359 - end

Line 792: po_vendor_sites_all vs,

788: sum(decode(dist.line_type_lookup_code,'AWT',
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,

Line 806: from po_vendor_sites_all

802: AND nvl(v.employee_id,-99) = papf.person_id (+)
803: -- bug 8551359 - start
804: --AND vs.tax_reporting_site_flag = 'Y'
805: AND exists (select 'x'
806: from po_vendor_sites_all
807: where vendor_id = v.vendor_id
808: and tax_reporting_site_flag = 'Y'
809: and org_id = p_rep_site_ou)
810: -- bug 8551359 - end

Line 940: po_vendor_sites_all vs,

936: awt.tax_name,
937: 'N'
938: FROM fnd_lookups fl,
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,

Line 962: from po_vendor_sites_all

958: AND v.vendor_id = vs.vendor_id
959: -- bug 8551359 - start
960: --AND vs.tax_reporting_site_flag = 'Y'
961: AND exists (select 'x'
962: from po_vendor_sites_all
963: where vendor_id = v.vendor_id
964: and tax_reporting_site_flag = 'Y'
965: and org_id = p_rep_site_ou)
966: -- bug 8551359 - end

Line 1119: po_vendor_sites_all vs,

1115: awt.tax_name,
1116: 'Y'
1117: FROM fnd_lookups fl,
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,

Line 1141: from po_vendor_sites_all

1137: AND v.vendor_id = vs.vendor_id
1138: -- bug 8551359 - start
1139: --AND vs.tax_reporting_site_flag = 'Y'
1140: AND exists (select 'x'
1141: from po_vendor_sites_all
1142: where vendor_id = v.vendor_id
1143: and tax_reporting_site_flag = 'Y'
1144: and org_id = p_rep_site_ou)
1145: -- bug 8551359 - end

Line 1311: po_vendor_sites_all vs,

1307: awt.tax_name,
1308: 'N'
1309: FROM fnd_lookups fl,
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,

Line 1333: from po_vendor_sites_all

1329: and vs.vendor_site_id = inv.vendor_site_id
1330: -- bug 8551359 - start
1331: --AND vs.tax_reporting_site_flag = 'Y'
1332: AND exists (select 'x'
1333: from po_vendor_sites_all
1334: where vendor_id = v.vendor_id
1335: and tax_reporting_site_flag = 'Y'
1336: and org_id = p_rep_site_ou)
1337: -- bug 8551359 - end

Line 1487: po_vendor_sites_all vs,

1483: awt.tax_name,
1484: 'Y'
1485: FROM fnd_lookups fl,
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,

Line 1509: from po_vendor_sites_all

1505: and vs.vendor_site_id = inv.vendor_site_id
1506: -- bug 8551359 - start
1507: --AND vs.tax_reporting_site_flag = 'Y'
1508: AND exists (select 'x'
1509: from po_vendor_sites_all
1510: where vendor_id = v.vendor_id
1511: and tax_reporting_site_flag = 'Y'
1512: and org_id = p_rep_site_ou)
1513: -- bug 8551359 - end

Line 1677: po_vendor_sites_all vs,

1673: awt.tax_name,
1674: 'N'
1675: FROM fnd_lookups fl,
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,

Line 1699: from po_vendor_sites_all

1695: and vs.vendor_site_id = inv.vendor_site_id
1696: -- bug 8551359 - start
1697: --AND vs.tax_reporting_site_flag = 'Y'
1698: AND exists (select 'x'
1699: from po_vendor_sites_all
1700: where vendor_id = v.vendor_id
1701: and tax_reporting_site_flag = 'Y'
1702: and org_id = p_rep_site_ou)
1703: -- bug 8551359 - end

Line 1851: po_vendor_sites_all vs,

1847: awt.tax_name,
1848: 'Y'
1849: FROM fnd_lookups fl,
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,

Line 1873: from po_vendor_sites_all

1869: and vs.vendor_site_id = inv.vendor_site_id
1870: -- bug 8551359 - start
1871: --AND vs.tax_reporting_site_flag = 'Y'
1872: AND exists (select 'x'
1873: from po_vendor_sites_all
1874: where vendor_id = v.vendor_id
1875: and tax_reporting_site_flag = 'Y'
1876: and org_id = p_rep_site_ou)
1877: -- bug 8551359 - end

Line 2031: po_vendor_sites_all vs,

2027: awt.tax_name,
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,

Line 2051: from po_vendor_sites_all

2047: and vs.vendor_site_id = inv.vendor_site_id
2048: -- bug 8551359 - start
2049: --AND vs.tax_reporting_site_flag = 'Y'
2050: AND exists (select 'x'
2051: from po_vendor_sites_all
2052: where vendor_id = v.vendor_id
2053: and tax_reporting_site_flag = 'Y'
2054: and org_id = p_rep_site_ou)
2055: -- bug 8551359 - end

Line 2166: po_vendor_sites_all vs,

2162: awt.tax_name,
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,

Line 2186: from po_vendor_sites_all

2182: and vs.vendor_site_id = inv.vendor_site_id
2183: -- bug 8551359 - start
2184: --AND vs.tax_reporting_site_flag = 'Y'
2185: AND exists (select 'x'
2186: from po_vendor_sites_all
2187: where vendor_id = v.vendor_id
2188: and tax_reporting_site_flag = 'Y'
2189: and org_id = p_rep_site_ou)
2190: -- bug 8551359 - end