APPS.QA_SKIPLOT_RES_ENGINE dependencies on PO_HEADERS_TRX_V

Line 1009: ' FROM rcv_supply rs, rcv_transactions rt,qa_skiplot_rcv_results qsrr , PO_HEADERS_TRX_V ph '||

1005: -- bug 9652549 CLM changes
1006: --
1007: shls_query :=
1008: ' SELECT distinct rs.shipment_line_id ' ||
1009: ' FROM rcv_supply rs, rcv_transactions rt,qa_skiplot_rcv_results qsrr , PO_HEADERS_TRX_V ph '||
1010: ' WHERE rs.rcv_transaction_id = rt.transaction_id ' ||
1011: ' AND rs.po_header_id = ph.po_header_id ' ||
1012: ' AND ph.segment1 = :1 ' ||
1013: ' AND rs.to_organization_id = :2 ' ||

Line 1976: PO_HEADERS_TRX_V ph

1972: CURSOR c(c_org_id NUMBER, c_po_num VARCHAR2, c_item_id NUMBER) IS
1973: SELECT past.status
1974: FROM po_approved_supplier_list pasl,
1975: po_asl_statuses past,
1976: PO_HEADERS_TRX_V ph
1977: WHERE ph.segment1 = c_po_num AND
1978: ph.vendor_id = pasl.vendor_id AND
1979: ph.vendor_site_id = nvl(pasl.vendor_site_id,ph.vendor_site_id) AND
1980: (pasl.using_organization_id = c_org_id or pasl.using_organization_id = -1) AND