DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on PO_VENDORS

Line 140: po_vendors PV

136: , NVL(PV.federal_reportable_flag, 'N') federal_reportable_flag
137: , AI.vendor_site_id vendor_site_id
138: , AI.amount_applicable_to_discount
139: FROM ap_invoices_all AI,
140: po_vendors PV
141: WHERE PV.vendor_id(+) = DECODE(AI.invoice_type_lookup_code,'PAYMENT REQUEST', NULL, AI.vendor_id) --bug8272564
142: AND AI.invoice_id = InvId
143: FOR UPDATE of AI.invoice_id;
144:

Line 1556: FROM po_vendors v

1552: i.legal_entity_id,
1553: i.set_of_books_id,
1554: i.batch_id,
1555: i.org_id
1556: FROM po_vendors v
1557: , ap_invoices_all i
1558: WHERE (v.vendor_id = i.vendor_id)
1559: AND (i.invoice_id = InvId);
1560:

Line 1672: po_vendors pv

1668: pv.party_id
1669: FROM ap_tax_codes_all t,
1670: ap_system_parameters_all p,
1671: po_vendor_sites_all s,
1672: po_vendors pv
1673: WHERE t.tax_id = TaxId
1674: AND pv.vendor_id = s.vendor_id /* Bug 4724120 */
1675: AND s.vendor_id = t.awt_vendor_id
1676: AND s.vendor_site_id = t.awt_vendor_site_id