DBA Data[Home] [Help]

APPS.JE_ES_WHTAX dependencies on PO_VENDORS

Line 681: FROM po_vendors v,

677: decode(dist.line_type_lookup_code,'AWT',0,
678: nvl(dist.base_amount,dist.amount)))) net_amount,
679: sum(decode(dist.line_type_lookup_code,'AWT',
680: nvl(dist.base_amount,dist.amount),0)) withholding_tax_amount
681: FROM po_vendors v,
682: po_vendor_sites_all vs,
683: fnd_lookups fl,
684: ap_invoices_all inv,
685: ap_invoice_lines_all line,

Line 764: po_vendors v,

760: nvl(dist.base_amount,dist.amount)))) net_amount,
761: sum(decode(dist.line_type_lookup_code,'AWT',
762: nvl(dist.base_amount,dist.amount),0)) withholding_tax_amount
763: FROM fnd_lookups fl,
764: po_vendors v,
765: po_vendor_sites_all vs,
766: ap_tax_codes_all atc,
767: ap_awt_tax_rates_all awt,
768: ap_invoices_all inv,

Line 890: po_vendors v,

886: sum(nvl(dist.base_amount,dist.amount)),
887: awt.tax_rate,
888: awt.tax_name
889: FROM fnd_lookups fl,
890: po_vendors v,
891: po_vendor_sites_all vs,
892: ap_invoice_payments_all invpay,
893: ap_checks_all checks,
894: ap_tax_codes_all atc,

Line 1038: po_vendors v,

1034: sum(nvl(dist.base_amount,dist.amount)),
1035: awt.tax_rate,
1036: awt.tax_name
1037: FROM fnd_lookups fl,
1038: po_vendors v,
1039: po_vendor_sites_all vs,
1040: ap_invoice_payments_all invpay,
1041: ap_checks_all checks,
1042: ap_tax_codes_all atc,

Line 1200: po_vendors v,

1196: (nvl(dist.base_amount,dist.amount)),
1197: awt.tax_rate,
1198: awt.tax_name
1199: FROM fnd_lookups fl,
1200: po_vendors v,
1201: po_vendor_sites_all vs,
1202: ap_invoice_payments_all invpay,
1203: ap_checks_all checks,
1204: ap_tax_codes_all atc,

Line 1314: po_vendors v,

1310: (nvl(dist.base_amount,dist.amount)),
1311: awt.tax_rate,
1312: awt.tax_name
1313: FROM fnd_lookups fl,
1314: po_vendors v,
1315: po_vendor_sites_all vs,
1316: ap_invoice_payments_all invpay,
1317: ap_checks_all checks,
1318: ap_tax_codes_all atc,

Line 1445: po_vendors v,

1441: sum(nvl(dist.base_amount,dist.amount)),
1442: awt.tax_rate,
1443: awt.tax_name
1444: FROM fnd_lookups fl,
1445: po_vendors v,
1446: po_vendor_sites_all vs,
1447: ap_invoice_payments_all invpay,
1448: ap_checks_all checks,
1449: ap_tax_codes_all atc,

Line 1589: po_vendors v,

1585: sum(nvl(dist.base_amount,dist.amount)),
1586: awt.tax_rate,
1587: awt.tax_name
1588: FROM fnd_lookups fl,
1589: po_vendors v,
1590: po_vendor_sites_all vs,
1591: ap_invoice_payments_all invpay,
1592: ap_checks_all checks,
1593: ap_tax_codes_all atc,

Line 1741: po_vendors v,

1737: vs.city,
1738: awt.tax_rate,
1739: awt.tax_name
1740: FROM fnd_lookups fl,
1741: po_vendors v,
1742: po_vendor_sites_all vs,
1743: ap_tax_codes_all atc,
1744: ap_awt_tax_rates_all awt,
1745: fnd_document_sequences seq,

Line 1846: po_vendors v,

1842: vs.city,
1843: awt.tax_rate,
1844: awt.tax_name
1845: FROM fnd_lookups fl,
1846: po_vendors v,
1847: po_vendor_sites_all vs,
1848: ap_tax_codes_all atc,
1849: ap_awt_tax_rates_all awt,
1850: fnd_document_sequences seq,