View: OKL_VP_QACHECK_RESULTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_VP_QACHECK_RESULTS_UV

View Text

SELECT PDFT.NAME NAME
, PDFT.DESCRIPTION DESCRIPTION
, PDFT.COMMENTS COMMENTS
, PDFB.PACKAGE_NAME PACKAGE_NAME
, PDFB.PROCEDURE_NAME PROCEDURE_NAME
, QLP.PDF_ID PDF_ID
, QLP.RUN_SEQUENCE RUN_SEQUENCE
, QLP.SEVERITY SEVERITY
FROM OKC_PROCESS_DEFS_B PDFB
, OKC_PROCESS_DEFS_TL PDFT
, OKC_QA_LIST_PROCESSES QLP
, OKC_QA_CHECK_LISTS_TL QCL
WHERE PDFB.ID = PDFT.ID
AND PDFT.LANGUAGE = USERENV('LANG')
AND PDFB.ID = QLP.PDF_ID
AND QLP.QCL_ID=QCL.ID

Columns