DBA Data[Home] [Help]

APPS.FV_THIRD_PARTY_REMIT_PKG dependencies on FV_TPP_ASSIGNMENTS_ALL

Line 514: FROM fv_tpp_check_details fvcd, fv_tpp_assignments_all tpp, ap_invoice_selection_criteria apisc

510:
511: l_row_select := '
512: SELECT fvcd.assignment_id, tpp.original_supplier_id, tpp.original_supplier_site_id,
513: tpp.third_party_agent_id, tpp.third_party_site_id, fvcd.checkrun_name, fvcd.check_number
514: FROM fv_tpp_check_details fvcd, fv_tpp_assignments_all tpp, ap_invoice_selection_criteria apisc
515: WHERE '|| l_where_clause ||'
516: fvcd.checkrun_name = apisc.checkrun_name
517: AND apisc.status = '||''''|| 'CONFIRMED' ||''''||'
518: AND fvcd.set_of_books_id = '|| g_sob_id ||'

Line 694: fv_tpp_assignments_all fv

690: BEGIN
691: SELECT pv.vendor_name, ps.vendor_site_code
692: INTO l_vendor_name, l_site_code
693: FROM po_vendors pv, po_vendor_sites ps,
694: fv_tpp_assignments_all fv
695: WHERE fv.assignment_id = l_assignment_id
696: AND fv.set_of_books_id = g_sob_id
697: AND fv.org_id = g_org_id
698: AND pv.vendor_id = DECODE(i, 1, fv.original_supplier_id,