DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on PO_VENDORS

Line 2250: po_vendors v,

2246: v.vendor_type_lookup_code vendor_type,
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;

Line 2287: po_vendors v,

2283: v.vendor_type_lookup_code VENDOR_TYPE,
2284: fvv.eliminations_id
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)

Line 2335: FROM po_vendors pov, po_headers_all poh,

2331: fvv.eliminations_id
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;

Line 2409: po_vendors v,

2405: v.vendor_type_lookup_code vendor_type,
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;