eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_VP_QACHECK_RESULTS_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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