APPS.AP_PPA_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 241: ap_invoice_distributions d,

237: nvl(i.payment_currency_code,i.invoice_currency_code),
238: i.terms_date,
239: i.goods_received_date
240: FROM ap_terms t,
241: ap_invoice_distributions d,
242: ap_invoices i,
243: ap_payment_schedules ps
244: WHERE i.payment_status_flag = 'N'
245: AND ps.amount_remaining > 0

Line 564: ap_invoice_distributions ad, po_distributions_ap_v d

560: nvl(i.goods_received_date +
561: nvl(p_receipt_acc_days,0),p_inv_date))))))
562: INTO p_start_date
563: FROM ap_invoices i, rcv_transactions rt, rcv_shipment_lines rsl,
564: ap_invoice_distributions ad, po_distributions_ap_v d
565: WHERE i.invoice_id = p_invoice_id
566: AND i.invoice_id = ad.invoice_id(+)
567: AND ad.po_distribution_id = d.po_distribution_id
568: AND d.po_header_id = rsl.po_header_id(+)

Line 584: ap_invoice_distributions ad, po_distributions d

580: Begin
581: SELECT MIN(rt.transaction_date)
582: INTO l_transaction_date
583: FROM rcv_transactions rt, rcv_shipment_lines rsl,
584: ap_invoice_distributions ad, po_distributions d
585: WHERE ad.invoice_id = p_invoice_id
586: AND ad.po_distribution_id = d.po_distribution_id
587: AND d.po_header_id = rsl.po_header_id
588: AND rsl.shipment_line_id = rt.shipment_line_id

Line 701: ap_invoice_distributions id

697:
698: SELECT min(h.terms_id)
699: INTO p_po_term_id
700: FROM po_headers h,po_distributions_ap_v d,
701: ap_invoice_distributions id
702: WHERE id.invoice_id = p_invoice_id
703: AND id.po_distribution_id = d.po_distribution_id
704: AND d.po_header_id = h.po_header_id;
705: