APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_LINES_ALL

Line 12507: l_po_line_matching_basis PO_LINES_ALL.MATCHING_BASIS%TYPE;

12503: l_amt_already_billed NUMBER;
12504: l_outstanding NUMBER;
12505: l_ordered NUMBER;
12506: l_already_billed NUMBER;
12507: l_po_line_matching_basis PO_LINES_ALL.MATCHING_BASIS%TYPE;
12508: l_invalid_shipment_type VARCHAR2(1):= '';
12509: l_invalid_shipment_count NUMBER;
12510: l_positive_price_variance NUMBER;
12511: l_total_match_amount NUMBER;

Line 20558: FROM po_lines_all

20554:
20555: IF (p_invoice_lines_rec.po_line_id IS NOT NULL) THEN
20556: SELECT category_id
20557: INTO l_purchasing_category_id
20558: FROM po_lines_all
20559: WHERE po_line_id = p_invoice_lines_rec.po_line_id;
20560:
20561: ELSE
20562: SELECT pl.category_id

Line 20564: FROM po_lines_all pl, po_line_locations_all pll

20560:
20561: ELSE
20562: SELECT pl.category_id
20563: INTO l_purchasing_category_id
20564: FROM po_lines_all pl, po_line_locations_all pll
20565: WHERE pll.line_location_id = p_invoice_lines_rec.po_line_location_id
20566: AND pl.po_line_id = pll.po_line_id;
20567:
20568: END IF;