168: aid.org_id org_id,
169: aid.type_1099 type_1099,
170: aid.income_tax_region income_tax_region
171: FROM ap_invoice_distributions aid,
172: gl_code_combinations gl,
173: ap_invoice_payments aip,
174: ap_invoice_relationships air,
175: ap_lookup_codes alc
176: WHERE air.related_invoice_id = aid.invoice_id
597:
598: SELECT MAX(aid.distribution_line_number)
599: INTO l_max_dist_line_num
600: FROM ap_invoice_distributions aid,
601: gl_code_combinations gl,
602: ap_invoice_payments aip,
603: ap_invoice_relationships air,
604: ap_lookup_codes alc
605: WHERE air.related_invoice_id = aid.invoice_id