DBA Data[Home] [Help]

APPS.PO_REQ_DOCUMENT_LOCK_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

    SELECT 1
    FROM po_requisition_headers H, po_requisition_lines L, po_req_distributions D
    WHERE H.requisition_header_id = p_req_header_id
    AND   H.requisition_header_id = L.requisition_header_id (+)
    AND   L.requisition_line_id = D.requisition_line_id (+)
    FOR UPDATE NOWAIT;