APPS.AP_AUTOSELECT_PKG dependencies on FV_TPP_ASSIGNMENTS_V

Line 1362: fv_tpp_assignments_v fv, --5017076

1358: from ap_selected_invoices_all asi,
1359: ap_invoices ai, --Bug6040657. Changed from ap_invoices_all to ap_invoices
1360: ap_inv_selection_criteria_all aisc,
1361: ap_payment_schedules_all aps,
1362: fv_tpp_assignments_v fv, --5017076
1363: iby_payment_methods_vl ipm -- Bug 5357689
1364: where asi.invoice_id = ai.invoice_id
1365: and aps.invoice_id = asi.invoice_id
1366: and aps.payment_num = asi.payment_num

Line 3210: FROM FV_TPP_ASSIGNMENTS_V TPP

3206: /* Added SKIP LOCKED for bug 14277979 */
3207: ' WHERE D4.invoice_id = ai.invoice_id) FOR UPDATE OF ps.checkrun_id SKIP LOCKED';
3208: -- bug 6456537
3209: /* AND NOT EXISTS (SELECT ''CCR EXPIRED''
3210: FROM FV_TPP_ASSIGNMENTS_V TPP
3211: WHERE TPP.beneficiary_party_id = inv.party_id
3212: AND TPP.beneficiary_party_site_id = inv.party_site_id
3213: AND NVL(TPP.fv_tpp_pay_flag, ''Y'') = ''N'') ; bug8691645 */
3214: -- 6456537 Checking the validity of CCR of the Third Party for

Line 4029: FROM FV_TPP_ASSIGNMENTS_V TPP

4025: /* Added SKIP LOCKED for bug 14277979 */
4026: ' WHERE D4.invoice_id = ai.invoice_id) FOR UPDATE OF ps.checkrun_id SKIP LOCKED';
4027: -- bug 6456537
4028: /* AND NOT EXISTS (SELECT ''CCR EXPIRED''
4029: FROM FV_TPP_ASSIGNMENTS_V TPP
4030: WHERE TPP.beneficiary_party_id = inv.party_id
4031: AND TPP.beneficiary_party_site_id = inv.party_site_id
4032: AND NVL(TPP.fv_tpp_pay_flag, ''Y'') = ''N'') bug8691645 */
4033: -- 6456537 Checking the validity of CCR of the Third Party for