APPS.OKC_CONTRACT_DOCS_GRP dependencies on OKC_LOOKUPS_V

Line 2545: FROM OKC_LOOKUPS_V LOOKUPS, OKC_DOC_QA_LISTS QA

2541:
2542: SELECT LOOKUPS.meaning qa_name,
2543: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag ,
2544: decode(LOOKUPS.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa
2545: FROM OKC_LOOKUPS_V LOOKUPS, OKC_DOC_QA_LISTS QA
2546: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
2547: AND QA.QA_CODE(+) = LOOKUPS.LOOKUP_CODE
2548: AND LOOKUPS.LOOKUP_TYPE = 'OKC_TERM_QA_LIST'
2549: AND LOOKUPS.LOOKUP_CODE='CHECK_PRIMARY_CONTRACT';