DBA Data[Home] [Help]

APPS.PO_REQ_DOCUMENT_LOCK_GRP dependencies on PO_REQ_DISTRIBUTIONS

Line 51: FROM po_requisition_headers H, po_requisition_lines L, po_req_distributions D

47:
48: -- SQL What: Locks the header and all the lines, and distributions of the Req.
49: CURSOR lock_req_csr IS
50: SELECT 1
51: FROM po_requisition_headers H, po_requisition_lines L, po_req_distributions D
52: WHERE H.requisition_header_id = p_req_header_id
53: AND H.requisition_header_id = L.requisition_header_id (+)
54: AND L.requisition_line_id = D.requisition_line_id (+)
55: FOR UPDATE NOWAIT;