DBA Data[Home] [Help]

APPS.JE_ES_WHTAX dependencies on FND_LOOKUPS

Line 693: fnd_lookups fl,

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,
697: ap_tax_codes_all atc,

Line 790: FROM fnd_lookups fl,

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

Line 938: FROM fnd_lookups fl,

934: dist.awt_flag dist_awt_flag, --bug 8709676
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,

Line 1117: FROM fnd_lookups fl,

1113: dist.awt_flag dist_awt_flag, --bug 8709676
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,

Line 1309: FROM fnd_lookups fl,

1305: dist.awt_flag dist_awt_flag, -- bug 8709676
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,

Line 1485: FROM fnd_lookups fl,

1481: dist.awt_flag dist_awt_flag, -- bug 8709676
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,

Line 1675: FROM fnd_lookups fl,

1671: dist.awt_flag dist_awt_flag, --bug 8709676
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,

Line 1849: FROM fnd_lookups fl,

1845: dist.awt_flag dist_awt_flag, --bug 8709676
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,

Line 2029: FROM fnd_lookups fl,

2025: substr(vs.city,1,25), --bug12649867
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,

Line 2164: FROM fnd_lookups fl,

2160: substr(vs.city,1,25), --bug12649867
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,