DBA Data[Home] [Help]

APPS.PO_DOCUMENT_LOCK_GRP dependencies on PO_REQUISITION_HEADERS

Line 97: FROM po_requisition_headers porh, po_requisition_lines porl,

93:
94: --
95: CURSOR lock_req_csr IS
96: SELECT 1
97: FROM po_requisition_headers porh, po_requisition_lines porl,
98: po_req_distributions pord
99: WHERE porh.requisition_header_id = p_document_id
100: AND porh.requisition_header_id = porl.requisition_header_id (+) -- JOIN
101: AND porl.requisition_line_id = pord.requisition_line_id (+) -- JOIN

Line 205: FROM po_requisition_headers porh

201: -- Verify that the requisition exists.
202: BEGIN
203: SELECT 1
204: INTO l_dummy
205: FROM po_requisition_headers porh
206: WHERE porh.requisition_header_id = p_document_id;
207: EXCEPTION
208: WHEN no_data_found THEN
209: FND_MESSAGE.set_name('PO', 'PO_INVALID_DOC_IDS');