DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CANCEL_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 322: FROM po_requisition_headers_all PRH,

318: l_cto_order NUMBER;
319: BEGIN
320: SELECT count(*)
321: INTO l_cto_order
322: FROM po_requisition_headers_all PRH,
323: po_requisition_lines_all PRL,
324: po_line_locations_all POLL
325: WHERE PRH.interface_source_code = 'CTO'
326: AND PRH.requisition_header_id = PRL.requisition_header_id