eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_EDW_SPEND_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 487: ap_invoice_distributions_all aid

483: select min(ack.check_date)
484: into cc_date
485: from ap_checks_all ack,
486: ap_invoice_payments_all aip,
487: ap_invoice_distributions_all aid
488: where aip.check_id = ack.check_id
489: and aip.invoice_id = aid.invoice_id
490: and aid.po_distribution_id = p_po_dist_id;
491:

Line 516: ap_invoice_distributions_all aid

512:
513: select min(ain.invoice_received_date)
514: into inv_rec_date
515: from ap_invoices_all ain,
516: ap_invoice_distributions_all aid
517: where ain.invoice_id = aid.invoice_id
518: and aid.po_distribution_id = p_po_dist_id;
519:
520: RETURN(inv_rec_date);

Line 544: from ap_invoice_distributions_all aid

540: BEGIN
541:
542: select min(aid.creation_date)
543: into inv_creation_date
544: from ap_invoice_distributions_all aid
545: where aid.po_distribution_id = p_po_dist_id;
546:
547: RETURN(inv_creation_date);
548:

Line 597: from ap_invoice_distributions_all

593:
594: BEGIN
595:
596: select SUM(base_invoice_price_variance) into v_ipv
597: from ap_invoice_distributions_all
598: where po_distribution_id = p_po_dist_id;
599:
600: RETURN(v_ipv);
601: