[Home] [Help]
108: aid.project_id,
109: aid.invoice_distribution_id line_number
110: FROM ap_invoice_distributions_all aid,
111: xla_events_gt e,
112: ap_invoices_all ai
113: WHERE aid.bc_event_id = e.event_id
114: AND e.application_id = p_application_id
115: AND e.entity_code = 'AP_INVOICES'
116: AND aid.line_type_lookup_code NOT IN ('ACCRUAL')
161: asat.project_id,
162: asat.invoice_distribution_id line_number
163: FROM ap_self_assessed_tax_dist_all asat,
164: xla_events_gt e,
165: ap_invoices_all ai
166: WHERE asat.bc_event_id = e.event_id
167: AND e.application_id = p_application_id
168: AND e.entity_code = 'AP_INVOICES'
169: AND asat.line_type_lookup_code NOT IN ('ACCRUAL')
215: apad.prepay_app_dist_id line_number
216: FROM ap_invoice_distributions_all aid,
217: ap_prepay_app_dists apad,
218: xla_events_gt e,
219: ap_invoices_all ai
220: WHERE aid.bc_event_id = e.event_id
221: AND e.application_id = p_application_id
222: AND e.entity_code = 'AP_INVOICES'
223: AND aid.line_type_lookup_code NOT IN ('ACCRUAL')
567: ap_payment_hist_dists aphd,
568: ap_invoice_distributions_all aid,
569: ap_payment_history_all aph,
570: xla_events_gt e,
571: ap_invoices_all ai
572: WHERE aphd.accounting_event_id = e.event_id
573: AND e.application_id = p_application_id
574: AND aphd.invoice_distribution_id = aid.invoice_distribution_id
575: AND aphd.payment_history_id = aph.payment_history_id
616: FROM ap_payment_hist_dists aphd,
617: ap_invoice_distributions_all aid,
618: ap_payment_history_all aph,
619: xla_events_gt e,
620: ap_invoices_all ai,
621: fv_treasury_confirmations_all ftc,
622: ap_checks_all aca
623: WHERE ftc.event_id = e.event_id
624: AND aca.payment_instruction_id = ftc.payment_instruction_id
663: FROM ap_payment_hist_dists aphd,
664: ap_invoice_distributions_all aid,
665: ap_payment_history_all aph,
666: xla_events_gt e,
667: ap_invoices_all ai,
668: fv_voided_checks fvc,
669: ap_checks_all aca
670: WHERE fvc.event_id = e.event_id
671: AND aca.payment_instruction_id = fvc.payment_instruction_id