APPS.QA_SKIPLOT_RES_ENGINE dependencies on PO_HEADERS

Line 931: ' FROM rcv_supply rs, rcv_transactions rt, po_headers ph ' ||

927: --
928: else
929: shls_query :=
930: ' SELECT distinct rs.shipment_line_id ' ||
931: ' FROM rcv_supply rs, rcv_transactions rt, po_headers ph ' ||
932: ' WHERE rs.rcv_transaction_id = rt.transaction_id ' ||
933: ' AND rs.po_header_id = ph.po_header_id ' ||
934: ' AND ph.segment1 = :1 ' ||
935: ' AND rs.to_organization_id = :2 ' ||

Line 1783: po_headers ph

1779: CURSOR c(c_org_id NUMBER, c_po_num VARCHAR2, c_item_id NUMBER) IS
1780: SELECT past.status
1781: FROM po_approved_supplier_list pasl,
1782: po_asl_statuses past,
1783: po_headers ph
1784: WHERE ph.segment1 = c_po_num AND
1785: ph.vendor_id = pasl.vendor_id(+) AND
1786: ph.vendor_site_id = pasl.vendor_site_id(+) AND
1787: pasl.using_organization_id = c_org_id AND

Line 1794: po_headers ph

1790:
1791: /*
1792: select asl_status_dsp
1793: from po_asl_suppliers_v pasv,
1794: po_headers ph
1795: where ph.segment1 = c_po_num
1796: and ph.vendor_id = pasv.vendor_id(+)
1797: and ph.vendor_site_id = pasv.vendor_site_id(+)
1798: and pasv.using_organization_id = c_org_id