APPS.PO_DOCUMENT_LOCK_GRP dependencies on PO_RELEASES

Line 88: FROM po_releases POR, po_line_locations PLL, po_distributions POD

84: -- SQL What: Locks the release and all its shipments and distributions.
85: -- SQL Why: To prevent others from modifying the document.
86: CURSOR lock_release_csr IS
87: SELECT 1
88: FROM po_releases POR, po_line_locations PLL, po_distributions POD
89: WHERE POR.po_release_id = p_document_id
90: AND POR.po_release_id = PLL.po_release_id (+) -- JOIN
91: AND PLL.line_location_id = POD.line_location_id (+) -- JOIN
92: FOR UPDATE NOWAIT;

Line 181: FROM po_releases

177: -- Verify that the release exists.
178: BEGIN
179: SELECT 1
180: INTO l_dummy
181: FROM po_releases
182: WHERE po_release_id = p_document_id;
183: EXCEPTION
184: WHEN no_data_found THEN
185: FND_MESSAGE.set_name('PO', 'PO_INVALID_DOC_IDS');

Line 383: FROM po_releases POR, po_line_locations PLL,

379: -- SQL What: Locks the release and all its shipments and distributions.
380: -- SQL Why: To prevent others from modifying the document.
381: CURSOR lock_release_csr IS
382: SELECT 1
383: FROM po_releases POR, po_line_locations PLL,
384: po_distributions POD,
385: po_session_gt gt
386: WHERE gt.KEY=po_sesiongt_key
387: AND POR.po_release_id =gt.char4