APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_ASL_SUPPLIERS_V

Line 6560: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph

6556: begin
6557: -- get ASL -- query provided by jenny zheng from QA team
6558: SELECT pasv.asl_status_id, pasv.asl_status_dsp
6559: into x_asl_status_id, x_asl_status_dsp
6560: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph
6561: WHERE pl.item_id = pasv.item_id
6562: AND pl.po_line_id = v_po_line_id -- here use the variable from above
6563: AND pl.po_header_id = ph.po_header_id
6564: AND ph.vendor_id(+) = pasv.vendor_id