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.PO_ACTIONS dependencies on AP_INVOICES_ALL

Line 493: -- INVOICE CLOSE: maximum invoice date from the ap_invoices_all

489: -- None.
490: --Function:
491: -- This function returns the closure date for a line_location_id
492: -- depending upon the call mode
493: -- INVOICE CLOSE: maximum invoice date from the ap_invoices_all
494: -- RECEIVE CLOSE: maximum transaction date from the rcv_transactions
495: -- CLOSE: maximum of the invoice_date and receving transaction date
496: --Parameters:
497: --IN:

Line 533: ap_invoices_all AP,

529: and RT.po_line_location_id = p_line_location_id
530: union
531: select AP.invoice_date action_date
532: from ap_invoice_distributions_all AD,
533: ap_invoices_all AP,
534: po_distributions_all POD
535: where AD.invoice_id = AP.invoice_id
536: and AD.po_distribution_id = POD.po_distribution_id
537: and POD.line_location_id = p_line_location_id

Line 551: ap_invoices_all AP,

547: elsif p_call_mode = 'INVOICE CLOSE' then
548: select max(AP.invoice_date)
549: into l_closed_date
550: from ap_invoice_distributions_all AD,
551: ap_invoices_all AP,
552: po_distributions_all POD
553: where AD.invoice_id = AP.invoice_id
554: and AD.po_distribution_id = POD.po_distribution_id
555: and POD.line_location_id = p_line_location_id