DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on FV_FACTS_VENDORS_V

Line 2251: fv_facts_vendors_v fvv

2247: fvv.eliminations_id
2248: INTO l_vendor_id, l_vendor_type, l_eliminations_id
2249: FROM ap_invoices_all i,
2250: po_vendors v,
2251: fv_facts_vendors_v fvv
2252: WHERE i.invoice_id = to_number(l_reference_2)
2253: AND i.vendor_id = v.vendor_id
2254: AND fvv.vendor_id = v.vendor_id;
2255: EXCEPTION

Line 2289: fv_facts_vendors_v fvv

2285: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2286: FROM rcv_transactions rt,
2287: po_vendors v,
2288: po_headers_all ph,
2289: fv_facts_vendors_v fvv
2290: WHERE rt.po_header_id = to_number(l_reference_2)
2291: AND rt.transaction_id = to_number(l_reference_5)
2292: AND rt.po_header_id = ph.po_header_id
2293: AND v.vendor_id = ph.vendor_id

Line 2336: fv_facts_vendors_v fvv

2332: INTO l_vendor_id,
2333: l_vendor_type,
2334: l_eliminations_id
2335: FROM po_vendors pov, po_headers_all poh,
2336: fv_facts_vendors_v fvv
2337: WHERE poh.po_header_id = to_number(l_reference_2)
2338: AND pov.vendor_id = poh.vendor_id
2339: AND fvv.vendor_id = poh.vendor_id;
2340: EXCEPTION

Line 2410: fv_facts_vendors_v fvv

2406: fvv.eliminations_id
2407: INTO l_vendor_id,l_vendor_type,l_eliminations_id
2408: FROM ap_checks_all apc,
2409: po_vendors v,
2410: fv_facts_vendors_v fvv
2411: WHERE apc.vendor_id = v.vendor_id
2412: AND apc.check_id = to_number(l_reference_3)
2413: AND fvv.vendor_id = v.vendor_id;
2414: EXCEPTION