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.

[Home] [Help]

View: QA_SL_CRITERIA_ASSOCIATION_V

Product:	QA - Quality
Description:	Skip Lot association to criteria header
Implementation/DBA Data:	APPS.QA_SL_CRITERIA_ASSOCIATION_V

View Text

SELECT QSLA.ROWID SL_ROW_ID
, QSLA.CRITERIA_ID
, QSLA.PROCESS_ID
, QSLP.PROCESS_CODE
, QSLA.EFFECTIVE_FROM SL_EFFECTIVE_FROM
, QSLA.EFFECTIVE_TO SL_EFFECTIVE_TO
, QSLA.LOTSIZE_FROM
, QSLA.LOTSIZE_TO
, QSLA.WF_ROLE_NAME SL_WF_ROLE_NAME
, QSLA.INSP_STAGE
, QSLA.LAST_UPDATE_DATE
, QSLA.LAST_UPDATED_BY
, QSLA.CREATION_DATE
, QSLA.CREATED_BY
, QSLA.LAST_UPDATE_LOGIN
FROM QA_SKIPLOT_ASSOCIATION QSLA
, QA_SKIPLOT_PROCESSES QSLP
WHERE QSLA.PROCESS_ID = QSLP.PROCESS_ID

Columns

Name
SL_ROW_ID
CRITERIA_ID
PROCESS_ID
PROCESS_CODE
SL_EFFECTIVE_FROM
SL_EFFECTIVE_TO
LOTSIZE_FROM
LOTSIZE_TO
SL_WF_ROLE_NAME
INSP_STAGE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN