DBA Data[Home] [Help]

APPS.AP_PPA_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 263: ap_invoice_distributions d,

259: nvl(i.payment_currency_code,i.invoice_currency_code),
260: i.terms_date,
261: i.goods_received_date
262: FROM ap_terms t,
263: ap_invoice_distributions d,
264: ap_invoices i,
265: ap_payment_schedules ps
266: WHERE i.payment_status_flag = 'N'
267: AND ps.amount_remaining > 0

Line 589: ap_invoice_distributions ad, po_distributions_ap_v d

585: nvl(i.goods_received_date +
586: nvl(p_receipt_acc_days,0),p_inv_date))))))
587: INTO p_start_date
588: FROM ap_invoices i, rcv_transactions rt, rcv_shipment_lines rsl,
589: ap_invoice_distributions ad, po_distributions_ap_v d
590: WHERE i.invoice_id = p_invoice_id
591: AND i.invoice_id = ad.invoice_id(+)
592: AND ad.po_distribution_id = d.po_distribution_id
593: AND d.po_header_id = rsl.po_header_id(+)

Line 609: ap_invoice_distributions ad, po_distributions d

605: Begin
606: SELECT MIN(rt.transaction_date)
607: INTO l_transaction_date
608: FROM rcv_transactions rt, rcv_shipment_lines rsl,
609: ap_invoice_distributions ad, po_distributions d
610: WHERE ad.invoice_id = p_invoice_id
611: AND ad.po_distribution_id = d.po_distribution_id
612: AND d.po_header_id = rsl.po_header_id
613: AND rsl.shipment_line_id = rt.shipment_line_id

Line 726: ap_invoice_distributions id

722:
723: SELECT min(h.terms_id)
724: INTO p_po_term_id
725: FROM po_headers h,po_distributions_ap_v d,
726: ap_invoice_distributions id
727: WHERE id.invoice_id = p_invoice_id
728: AND id.po_distribution_id = d.po_distribution_id
729: AND d.po_header_id = h.po_header_id;
730: