DBA Data[Home] [Help]

APPS.CST_PERENDACCRUALS_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2614: FROM ap_invoice_distributions_all aida,

2610: 1, SUM(aida.amount),
2611: SUM(aida.quantity_invoiced)),
2612: 0)
2613: INTO l_quantity_invoiced
2614: FROM ap_invoice_distributions_all aida,
2615: ap_invoices_all aia
2616: WHERE aida.po_distribution_id = p_dist_id
2617: AND aida.line_type_lookup_code NOT IN ('IPV', 'ERV', 'PREPAY')
2618: AND aida.accounting_date <= p_end_date

Line 2641: FROM ap_invoice_distributions_all aida,

2637: aida.matched_uom_lookup_code,
2638: NVL(pol.unit_meas_lookup_code, poll.unit_meas_lookup_code)))),
2639: 0)
2640: INTO l_quantity_invoiced
2641: FROM ap_invoice_distributions_all aida,
2642: ap_invoices_all aia,
2643: po_lines_all pol,
2644: po_line_locations_all poll,
2645: po_distributions_all pod