DBA Data[Home] [Help]

APPS.AP_PPA_PKG dependencies on PO_DISTRIBUTIONS_AP_V

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

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