DBA Data[Home] [Help]

APPS.FV_SLA_AP_PROCESSING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 110: FROM ap_invoice_distributions_all aid,

106: ai.reference_key2 ref_key2,
107: ai.vendor_id,
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

Line 216: FROM ap_invoice_distributions_all aid,

212: ai.reference_key2 ref_key2,
213: ai.vendor_id,
214: aid.project_id,
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

Line 568: ap_invoice_distributions_all aid,

564: ai.reference_key2 ref_key2,
565: ai.vendor_id
566: FROM ap_checks_all aca,
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

Line 617: ap_invoice_distributions_all aid,

613: ai.reference_key1 ref_key1,
614: ai.reference_key2 ref_key2,
615: ai.vendor_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,

Line 664: ap_invoice_distributions_all aid,

660: ai.reference_key1 ref_key1,
661: ai.reference_key2 ref_key2,
662: ai.vendor_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,