APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_DOC_REVISIONS_VL

Line 289: FROM AHL_DOC_REVISIONS_VL

285: AND A.ASO_OBJECT_ID=p_source_mr_header_id
286: and A.doc_title_asso_id=B.doc_title_asso_id
287: AND B.LANGUAGE=USERENV('LANG')
288: AND A.ASO_OBJECT_ID NOT IN (SELECT DOCUMENT_ID
289: FROM AHL_DOC_REVISIONS_VL
290: WHERE DOCUMENT_ID=A.ASO_OBJECT_ID
291: AND NVL(REVISION_STATUS_CODE,'CURRENT')='OBSOLETE');
292:
293: l_doc_title_asso_id NUMBER:=0;