DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1850: l_matching_basis po_line_locations_all.matching_basis%TYPE;

1846: l_distribution_count NUMBER := 0;
1847: l_sum_matched_qty NUMBER := 0;
1848: l_sum_matched_amt NUMBER := 0;
1849: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
1850: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1851: i NUMBER := 1;
1852: l_max_line_num
1853: ap_invoice_distributions.distribution_line_number%TYPE;
1854: l_matched_uom VARCHAR2(30);

Line 1994: ,po_line_locations_all pll

1990: NVL(AID.corrected_quantity, 0) + NVL(AID.quantity_invoiced,0))) quantity
1991: from ap_invoice_lines_all ail
1992: ,ap_invoice_distributions_all aid
1993: ,po_distributions_all pod
1994: ,po_line_locations_all pll
1995: where ail.invoice_id = p_line_rec.invoice_id
1996: and ail.line_number = p_line_rec.line_number
1997: and ail.invoice_id = aid.invoice_id
1998: and ail.line_number = aid.invoice_line_number