APPS.AP_PPA_PKG dependencies on PO_DISTRIBUTIONS_AP_V

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 725: FROM po_headers h,po_distributions_ap_v d,

721: -- Retrieve po terms rank, and terms id and terms name
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;