DBA Data[Home] [Help]

APPS.JE_ITWHYE_AP_PKG dependencies on AP_SUPPLIERS

Line 271: ap_suppliers aps,

267: inv.invoice_num
268: ,dist.exempt_amount
269: ,inv.invoice_type_lookup_code
270: FROM ap_supplier_sites_all apss,
271: ap_suppliers aps,
272: (SELECT DISTINCT person_id, national_identifier
273: FROM per_all_people_f) papf
274: ,(SELECT SUM (DECODE (dist1.line_type_lookup_code,
275: 'ITEM', NVL (SIGN (dist1.awt_group_id) - 1, 1)

Line 696: ap_suppliers aps

692: FROM ap_invoice_distributions dist,
693: ap_tax_codes atc,
694: ap_invoices inv1,
695: ap_awt_tax_rates awt,
696: ap_suppliers aps
697: WHERE dist.invoice_id = inv1.invoice_id
698: AND inv1.invoice_id = cur_withholding_extract_rec.invoice_id
699: AND dist.line_type_lookup_code = atc.tax_type
700: AND dist.line_type_lookup_code = 'AWT'

Line 748: ap_suppliers aps

744: FROM ap_invoice_distributions dist,
745: ap_tax_codes atc,
746: ap_invoices inv1,
747: ap_awt_tax_rates awt,
748: ap_suppliers aps
749: WHERE dist.invoice_id = inv1.invoice_id
750: AND inv1.invoice_id = cur_withholding_extract_rec.invoice_id
751: AND dist.line_type_lookup_code = atc.tax_type
752: AND dist.line_type_lookup_code = 'AWT'