DBA Data[Home] [Help]

VIEW: APPS.QA_SL_CRITERIA_ASSOCIATION_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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