DBA Data[Home] [Help]

APPS.JE_ES_WHTAX dependencies on PO_VENDORS

Line 691: FROM po_vendors v,

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

Line 791: po_vendors v,

787: nvl(dist.base_amount,dist.amount)))) net_amount,
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,

Line 939: po_vendors v,

935: awt.tax_rate,
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,

Line 1118: po_vendors v,

1114: awt.tax_rate,
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,

Line 1310: po_vendors v,

1306: awt.tax_rate,
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,

Line 1486: po_vendors v,

1482: awt.tax_rate,
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,

Line 1676: po_vendors v,

1672: awt.tax_rate,
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,

Line 1850: po_vendors v,

1846: awt.tax_rate,
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,

Line 2030: po_vendors v,

2026: awt.tax_rate,
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,

Line 2165: po_vendors v,

2161: awt.tax_rate,
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,