APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_ASL_SUPPLIERS_V

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

4657: begin
4658: -- get ASL -- query provided by jenny zheng from QA team
4659: SELECT pasv.asl_status_id, pasv.asl_status_dsp
4660: into x_asl_status_id, x_asl_status_dsp
4661: FROM po_asl_suppliers_v pasv, po_lines pl, po_headers ph
4662: WHERE pl.item_id = pasv.item_id
4663: AND pl.po_line_id = v_po_line_id -- here use the variable from above
4664: AND pl.po_header_id = ph.po_header_id
4665: AND ph.vendor_id(+) = pasv.vendor_id