APPS.AP_AUTOSELECT_PKG dependencies on FV_TPP_ASSIGNMENTS_V

Line 971: fv_tpp_assignments_v fv, --5017076

967: from ap_selected_invoices_all asi,
968: ap_invoices ai, --Bug6040657. Changed from ap_invoices_all to ap_invoices
969: ap_inv_selection_criteria_all aisc,
970: ap_payment_schedules_all aps,
971: fv_tpp_assignments_v fv, --5017076
972: iby_payment_methods_vl ipm -- Bug 5357689
973: where asi.invoice_id = ai.invoice_id
974: and aps.invoice_id = asi.invoice_id
975: and aps.payment_num = asi.payment_num

Line 2160: FROM FV_TPP_ASSIGNMENTS_V TPP

2156: FROM ap_invoice_distributions D4
2157: WHERE D4.invoice_id = inv.invoice_id)
2158: -- bug 6456537
2159: AND NOT EXISTS (SELECT 'CCR EXPIRED'
2160: FROM FV_TPP_ASSIGNMENTS_V TPP
2161: WHERE TPP.beneficiary_party_id = inv.party_id
2162: AND TPP.beneficiary_party_site_id = inv.party_site_id
2163: AND NVL(TPP.fv_tpp_pay_flag, 'Y') = 'N');
2164: -- 6456537 Checking the validity of CCR of the Third Party for

Line 2446: FROM FV_TPP_ASSIGNMENTS_V TPP

2442: FROM ap_invoice_distributions_all D4
2443: WHERE D4.invoice_id = inv.invoice_id)
2444: -- bug 6456537
2445: AND NOT EXISTS (SELECT 'CCR EXPIRED'
2446: FROM FV_TPP_ASSIGNMENTS_V TPP
2447: WHERE TPP.beneficiary_party_id = inv.party_id
2448: AND TPP.beneficiary_party_site_id = inv.party_site_id
2449: AND NVL(TPP.fv_tpp_pay_flag, 'Y') = 'N');
2450: -- 6456537 Checking the validity of CCR of the Third Party for