APPS.FV_GTAS_TRX_REGISTER dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2398: FROM ap_invoice_distributions_all aid

2394: SELECT aid.invoice_id,
2395: aid.distribution_line_number
2396: INTO l_reference_2,
2397: l_reference_8
2398: FROM ap_invoice_distributions_all aid
2399: WHERE aid.invoice_distribution_id = l_source_distribution_id_num_1;
2400: EXCEPTION
2401: WHEN NO_DATA_FOUND THEN
2402: log(l_module, 'No data found for distribution id(1) '

Line 2411: FROM ap_invoice_distributions_all aid

2407: SELECT aid.invoice_id,
2408: aid.distribution_line_number
2409: INTO l_reference_2,
2410: l_reference_8
2411: FROM ap_invoice_distributions_all aid
2412: WHERE aid.invoice_distribution_id = l_applied_to_dist_id_num_1;
2413: EXCEPTION
2414: WHEN NO_DATA_FOUND THEN
2415: log(l_module, 'No data found for distribution id(1a) '

Line 2427: ap_invoice_distributions_all aid,

2423: INTO l_reference_3,
2424: l_reference_4,
2425: l_reference_6
2426: FROM ap_payment_hist_dists aphd,
2427: ap_invoice_distributions_all aid,
2428: ap_invoice_payments_all aip
2429: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
2430: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
2431: AND aip.invoice_payment_id = aphd.invoice_payment_id;

Line 2530: ap_invoice_distributions_all aid,

2526: INTO l_reference_3,
2527: l_reference_4,
2528: l_reference_6
2529: FROM ap_payment_hist_dists aphd,
2530: ap_invoice_distributions_all aid,
2531: ap_invoice_payments_all aip
2532: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
2533: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
2534: AND aip.invoice_payment_id = aphd.invoice_payment_id;