DBA Data[Home] [Help]

APPS.CST_PERENDACCRUALS_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2727: FROM ap_invoice_distributions_all aida,

2723: nvl(aida.corrected_quantity,aida.quantity_invoiced))
2724: )),
2725: 0)
2726: INTO l_quantity_invoiced
2727: FROM ap_invoice_distributions_all aida,
2728: ap_invoices_all aia
2729: WHERE aida.po_distribution_id = p_dist_id
2730: AND aida.line_type_lookup_code NOT IN ('IPV', 'ERV', 'PREPAY','REC_TAX')
2731: AND aida.accounting_date <= p_end_date

Line 2756: FROM ap_invoice_distributions_all aida,

2752: aida.matched_uom_lookup_code,
2753: NVL(pol.unit_meas_lookup_code, poll.unit_meas_lookup_code))))),
2754: 0)
2755: INTO l_quantity_invoiced
2756: FROM ap_invoice_distributions_all aida,
2757: ap_invoices_all aia,
2758: po_lines_all pol,
2759: po_line_locations_all poll,
2760: po_distributions_all pod