APPS.PO_APPROVED_SUPPLIER_LIST_SV dependencies on PO_LINES_ALL

Line 326: FROM po_lines_all pol --

322: SELECT pol.unit_meas_lookup_code,
323: pol.vendor_product_num
324: INTO x_purch_uom,
325: x_vendor_product_num
326: FROM po_lines_all pol --
327: WHERE po_line_id = x_po_line_id;
328: --
329: --
330: -- Check if ASL already exists for this combination.

Line 613: FROM po_lines_all pl

609: AND document_type_code = x_type_lookup_code;
610:
611: SELECT expiration_date
612: INTO x_date
613: FROM po_lines_all pl
614: WHERE po_header_id = x_po_header_id
615: AND po_line_id = x_line_id;
616:
617: IF (NVL(x_date , sysdate+1) >= SYSDATE) THEN ---10192008