DBA Data[Home] [Help]

APPS.OKC_TERMS_QA_GRP dependencies on FND_LOOKUPS

Line 89: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA

85: SELECT fnd.lookup_code qa_code,
86: fnd.meaning qa_name,
87: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag ,
88: decode(fnd.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa
89: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA
90: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
91: AND QA.QA_CODE(+) = FND.LOOKUP_CODE
92: AND FND.LOOKUP_CODE = 'CHECK_TERMS_EXIST'
93: AND Fnd.LOOKUP_TYPE=G_QA_LOOKUP;