DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_LINES_ALL

Line 13859: l_po_line_matching_basis PO_LINES_ALL.MATCHING_BASIS%TYPE;

13855: l_amt_already_billed NUMBER;
13856: l_outstanding NUMBER;
13857: l_ordered NUMBER;
13858: l_already_billed NUMBER;
13859: l_po_line_matching_basis PO_LINES_ALL.MATCHING_BASIS%TYPE;
13860: l_invalid_shipment_type VARCHAR2(1):= '';
13861: l_invalid_shipment_count NUMBER;
13862: l_positive_price_variance NUMBER;
13863: l_total_match_amount NUMBER;

Line 22383: FROM po_lines_all

22379:
22380: IF (p_invoice_lines_rec.po_line_id IS NOT NULL) THEN
22381: SELECT category_id
22382: INTO l_purchasing_category_id
22383: FROM po_lines_all
22384: WHERE po_line_id = p_invoice_lines_rec.po_line_id;
22385:
22386: ELSE
22387: SELECT pl.category_id

Line 22389: FROM po_lines_all pl, po_line_locations_all pll

22385:
22386: ELSE
22387: SELECT pl.category_id
22388: INTO l_purchasing_category_id
22389: FROM po_lines_all pl, po_line_locations_all pll
22390: WHERE pll.line_location_id = p_invoice_lines_rec.po_line_location_id
22391: AND pl.po_line_id = pll.po_line_id;
22392:
22393: END IF;