DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on PO_VENDORS

Line 2336: po_vendors v,

2332: v.vendor_type_lookup_code vendor_type,
2333: fvv.eliminations_id
2334: INTO l_vendor_id, l_vendor_type, l_eliminations_id
2335: FROM ap_invoices_all i,
2336: po_vendors v,
2337: fv_facts_vendors_v fvv
2338: WHERE i.invoice_id = to_number(l_reference_2)
2339: AND i.vendor_id = v.vendor_id
2340: AND fvv.vendor_id = v.vendor_id;

Line 2373: po_vendors v,

2369: v.vendor_type_lookup_code VENDOR_TYPE,
2370: fvv.eliminations_id
2371: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2372: FROM rcv_transactions rt,
2373: po_vendors v,
2374: po_headers_all ph,
2375: fv_facts_vendors_v fvv
2376: WHERE rt.po_header_id = to_number(l_reference_2)
2377: AND rt.transaction_id = to_number(l_reference_5)

Line 2421: FROM po_vendors pov, po_headers_all poh,

2417: fvv.eliminations_id
2418: INTO l_vendor_id,
2419: l_vendor_type,
2420: l_eliminations_id
2421: FROM po_vendors pov, po_headers_all poh,
2422: fv_facts_vendors_v fvv
2423: WHERE poh.po_header_id = to_number(l_reference_2)
2424: AND pov.vendor_id = poh.vendor_id
2425: AND fvv.vendor_id = poh.vendor_id;

Line 2543: po_vendors v,

2539: v.vendor_type_lookup_code vendor_type,
2540: fvv.eliminations_id
2541: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2542: FROM ap_checks_all apc,
2543: po_vendors v,
2544: fv_facts_vendors_v fvv
2545: WHERE apc.vendor_id = v.vendor_id
2546: AND apc.check_id = to_number(l_reference_3)
2547: AND fvv.vendor_id = v.vendor_id;