DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1795: l_matching_basis po_line_locations_all.matching_basis%TYPE;

1791: l_distribution_count NUMBER := 0;
1792: l_sum_matched_qty NUMBER := 0;
1793: l_sum_matched_amt NUMBER := 0;
1794: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
1795: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1796: i NUMBER := 1;
1797: l_max_line_num
1798: ap_invoice_distributions.distribution_line_number%TYPE;
1799: l_matched_uom VARCHAR2(30);

Line 1911: ,po_line_locations_all pll

1907: NVL(AID.corrected_quantity, 0) + NVL(AID.quantity_invoiced,0))) quantity
1908: from ap_invoice_lines_all ail
1909: ,ap_invoice_distributions_all aid
1910: ,po_distributions_all pod
1911: ,po_line_locations_all pll
1912: where ail.invoice_id = p_line_rec.invoice_id
1913: and ail.line_number = p_line_rec.line_number
1914: and ail.invoice_id = aid.invoice_id
1915: and ail.line_number = aid.invoice_line_number