POQ_QUAL_ASMT_INIT

Details

Schema: FUSION
Object owner: POQ
Object type: VIEW

Columns

Name
QUALIFICATION_ID QUALIFICATION_NUMBER QUALIFICATION_NAME QUAL_AREA_ID QUAL_PRC_BU_ID QUAL_SUPPLIER_ID QUAL_SUPPLIER_SITE_ID QUAL_SUPP_CONTACT_PARTY_ID QUAL_OWNER_ID QUALIFICATION_OUTCOME QUAL_STATUS QUAL_EFFECTIVE_START_DATE QUAL_EFFECTIVE_END_DATE QUAL_EVALUATION_DUE_DATE QUAL_EVALUATED_BY QUALIFICATION_COMMENTS QUAL_EVALUATION_DATE QUAL_CANCELED_BY QUAL_CANCELED_DATE QUAL_CANCELED_REASON_CODE QUAL_LATEST_FLAG QUAL_REQUEST_ID QUAL_CREATION_DATE ASSESSMENT_ID ASSESSMENT_NUMBER ASSESSMENT_NAME QUAL_MODEL_ID ASMT_PRC_BU_ID ASMT_SUPPLIER_ID ASMT_SUPPLIER_SITE_ID ASMT_SUPP_CONTACT_PARTY_ID ASMT_OWNER_ID ASSESSMENT_OUTCOME ASMT_STATUS ASMT_EVALUATION_DUE_DATE ASMT_EVALUATED_BY ASSESSMENT_COMMENTS ASMT_EVALUATION_DATE ASMT_EFFECTIVE_START_DATE ASMT_EFFECTIVE_END_DATE ASMT_LATEST_FLAG ASMT_CANCELED_BY ASMT_CANCELED_DATE ASMT_CANCELED_REASON_CODE SEND_SUPP_QNNAIRE_FLAG SEND_INT_QNNAIRE_FLAG ASMT_REQUEST_ID ASMT_CREATION_DATE INITIATIVE_ID INITIATIVE_NUMBER TITLE DESCRIPTION INITIATIVE_STATUS TYPE INITIATIVE_PRC_BU_ID INITIATIVE_OWNER_ID INTERNAL_NOTE REUSE_ACTIVE_QUAL_FLAG LAUNCH_DATE COMPLETED_DATE INITIATIVE_CANCELED_DATE INITIATIVE_CANCELED_BY INITIATIVE_CANCELED_REASON INITIATIVE_CREATION_DATE QUAL_COMPLETED_DATE ASMT_COMPLETED_DATE QUAL_EXP_REMINDER_PERIOD QUAL_EXP_REMINDER_TYPE ASMT_EXP_REMINDER_PERIOD ASMT_EXP_REMINDER_TYPE QUAL_CREATION_SOURCE QUAL_AUTO_EVALUATED_FLAG QUAL_QUALIFICATION_SCORE QUAL_ORIG_QUALIFICATION_SCORE QA_ORIG_QUALIFICATION_OUTCOME QUAL_OVERRIDE_REASON QUAL_OVERRIDDEN_BY QUAL_OVERRIDE_DATE QA_SHOW_QUAL_TO_SUPPLIER_FLAG QUAL_SHOW_QUAL_SUPP_RESP_FLAG QUAL_SHOW_QUAL_INTER_RESP_FLAG QUAL_NOTE_TO_SUPPLIER QUAL_REQUALIFY_EXECUTED_FLAG QUAL_REQUALIFY_EXPIRATION_FLAG QUAL_REQUALIFY_RESPONSE_FLAG QUAL_EVAL_READY_DATE WEIGHT QUAL_WEIGHTED_SCORE INITIATIVE_CREATION_SOURCE INIT_AUTO_ACC_RESPONSES_FLAG INIT_AUTO_POP_RESPONSES_FLAG INIT_LAST_OVER_REMINDER_DATE ASMT_ASSESSMENT_SCORE ASMT_ORIG_ASSESSMENT_SCORE ASMT_ORIG_ASSESSMENT_OUTCOME ASMT_OVERRIDE_REASON ASMT_OVERRIDEN_BY ASMT_OVERRIDE_DATE ASMT_AUTO_EVALUATED_FLAG ASMT_SHOW_ASSESS_TO_SUPP_FLAG ASMT_SHOW_ASSESSMENT_QUAL_FLAG ASMT_NOTE_TO_SUPPLIER ASMT_SOURCING_ELIGIBILITY_CODE ASMT_EVAL_READY_DATE

Name

QUALIFICATION_ID

QUALIFICATION_NUMBER

QUALIFICATION_NAME

QUAL_AREA_ID

QUAL_PRC_BU_ID

QUAL_SUPPLIER_ID

QUAL_SUPPLIER_SITE_ID

QUAL_SUPP_CONTACT_PARTY_ID

QUAL_OWNER_ID

QUALIFICATION_OUTCOME

QUAL_STATUS

QUAL_EFFECTIVE_START_DATE

QUAL_EFFECTIVE_END_DATE

QUAL_EVALUATION_DUE_DATE

QUAL_EVALUATED_BY

QUALIFICATION_COMMENTS

QUAL_EVALUATION_DATE

QUAL_CANCELED_BY

QUAL_CANCELED_DATE

QUAL_CANCELED_REASON_CODE

QUAL_LATEST_FLAG

QUAL_REQUEST_ID

QUAL_CREATION_DATE

ASSESSMENT_ID

ASSESSMENT_NUMBER

ASSESSMENT_NAME

QUAL_MODEL_ID

ASMT_PRC_BU_ID

ASMT_SUPPLIER_ID

ASMT_SUPPLIER_SITE_ID

ASMT_SUPP_CONTACT_PARTY_ID

ASMT_OWNER_ID

ASSESSMENT_OUTCOME

ASMT_STATUS

ASMT_EVALUATION_DUE_DATE

ASMT_EVALUATED_BY

ASSESSMENT_COMMENTS

ASMT_EVALUATION_DATE

ASMT_EFFECTIVE_START_DATE

ASMT_EFFECTIVE_END_DATE

ASMT_LATEST_FLAG

ASMT_CANCELED_BY

ASMT_CANCELED_DATE

ASMT_CANCELED_REASON_CODE

SEND_SUPP_QNNAIRE_FLAG

SEND_INT_QNNAIRE_FLAG

ASMT_REQUEST_ID

ASMT_CREATION_DATE

INITIATIVE_ID

INITIATIVE_NUMBER

TITLE

DESCRIPTION

INITIATIVE_STATUS

TYPE

INITIATIVE_PRC_BU_ID

INITIATIVE_OWNER_ID

INTERNAL_NOTE

REUSE_ACTIVE_QUAL_FLAG

LAUNCH_DATE

COMPLETED_DATE

INITIATIVE_CANCELED_DATE

INITIATIVE_CANCELED_BY

INITIATIVE_CANCELED_REASON

INITIATIVE_CREATION_DATE

QUAL_COMPLETED_DATE

ASMT_COMPLETED_DATE

QUAL_EXP_REMINDER_PERIOD

QUAL_EXP_REMINDER_TYPE

ASMT_EXP_REMINDER_PERIOD

ASMT_EXP_REMINDER_TYPE

QUAL_CREATION_SOURCE

QUAL_AUTO_EVALUATED_FLAG

QUAL_QUALIFICATION_SCORE

QUAL_ORIG_QUALIFICATION_SCORE

QA_ORIG_QUALIFICATION_OUTCOME

QUAL_OVERRIDE_REASON

QUAL_OVERRIDDEN_BY

QUAL_OVERRIDE_DATE

QA_SHOW_QUAL_TO_SUPPLIER_FLAG

QUAL_SHOW_QUAL_SUPP_RESP_FLAG

QUAL_SHOW_QUAL_INTER_RESP_FLAG

QUAL_NOTE_TO_SUPPLIER

QUAL_REQUALIFY_EXECUTED_FLAG

QUAL_REQUALIFY_EXPIRATION_FLAG

QUAL_REQUALIFY_RESPONSE_FLAG

QUAL_EVAL_READY_DATE

WEIGHT

QUAL_WEIGHTED_SCORE

INITIATIVE_CREATION_SOURCE

INIT_AUTO_ACC_RESPONSES_FLAG

INIT_AUTO_POP_RESPONSES_FLAG

INIT_LAST_OVER_REMINDER_DATE

ASMT_ASSESSMENT_SCORE

ASMT_ORIG_ASSESSMENT_SCORE

ASMT_ORIG_ASSESSMENT_OUTCOME

ASMT_OVERRIDE_REASON

ASMT_OVERRIDEN_BY

ASMT_OVERRIDE_DATE

ASMT_AUTO_EVALUATED_FLAG

ASMT_SHOW_ASSESS_TO_SUPP_FLAG

ASMT_SHOW_ASSESSMENT_QUAL_FLAG

ASMT_NOTE_TO_SUPPLIER

ASMT_SOURCING_ELIGIBILITY_CODE

ASMT_EVAL_READY_DATE

Query

SQL_Statement
SELECT QUAL.QUALIFICATION_ID, QUAL.QUALIFICATION_NUMBER, QUAL.QUALIFICATION_NAME, QUAL.QUAL_AREA_ID, QUAL.PRC_BU_ID QUAL_PRC_BU_ID, QUAL.SUPPLIER_ID QUAL_SUPPLIER_ID, QUAL.SUPPLIER_SITE_ID QUAL_SUPPLIER_SITE_ID, QUAL.SUPP_CONTACT_PARTY_ID QUAL_SUPP_CONTACT_PARTY_ID, QUAL.OWNER_ID QUAL_OWNER_ID, QUAL.QUALIFICATION_OUTCOME, QUAL.STATUS QUAL_STATUS, QUAL.EFFECTIVE_START_DATE QUAL_EFFECTIVE_START_DATE, QUAL.EFFECTIVE_END_DATE QUAL_EFFECTIVE_END_DATE, QUAL.EVALUATION_DUE_DATE QUAL_EVALUATION_DUE_DATE, QUAL.EVALUATED_BY QUAL_EVALUATED_BY, QUAL.QUALIFICATION_COMMENTS, QUAL.EVALUATION_DATE QUAL_EVALUATION_DATE, QUAL.CANCELED_BY QUAL_CANCELED_BY, QUAL.CANCELED_DATE QUAL_CANCELED_DATE, QUAL.CANCELED_REASON_CODE QUAL_CANCELED_REASON_CODE, QUAL.LATEST_FLAG QUAL_LATEST_FLAG, QUAL.REQUEST_ID QUAL_REQUEST_ID, QUAL.CREATION_DATE QUAL_CREATION_DATE, ASMT.ASSESSMENT_ID, ASMT.ASSESSMENT_NUMBER, ASMT.ASSESSMENT_NAME, ASMT.QUAL_MODEL_ID, ASMT.PRC_BU_ID ASMT_PRC_BU_ID, ASMT.SUPPLIER_ID ASMT_SUPPLIER_ID, ASMT.SUPPLIER_SITE_ID ASMT_SUPPLIER_SITE_ID, ASMT.SUPP_CONTACT_PARTY_ID ASMT_SUPP_CONTACT_PARTY_ID, ASMT.OWNER_ID ASMT_OWNER_ID, ASMT.ASSESSMENT_OUTCOME, ASMT.STATUS ASMT_STATUS, ASMT.EVALUATION_DUE_DATE ASMT_EVALUATION_DUE_DATE, ASMT.EVALUATED_BY ASMT_EVALUATED_BY, ASMT.ASSESSMENT_COMMENTS, ASMT.EVALUATION_DATE ASMT_EVALUATION_DATE, ASMT.EFFECTIVE_START_DATE ASMT_EFFECTIVE_START_DATE, ASMT.EFFECTIVE_END_DATE ASMT_EFFECTIVE_END_DATE, ASMT.LATEST_FLAG ASMT_LATEST_FLAG, ASMT.CANCELED_BY ASMT_CANCELED_BY, ASMT.CANCELED_DATE ASMT_CANCELED_DATE, ASMT.CANCELED_REASON_CODE ASMT_CANCELED_REASON_CODE, ASMT.SEND_SUPP_QNNAIRE_FLAG, ASMT.SEND_INT_QNNAIRE_FLAG, ASMT.REQUEST_ID ASMT_REQUEST_ID, ASMT.CREATION_DATE ASMT_CREATION_DATE, NVL(INIT1.INITIATIVE_ID, INIT2.INITIATIVE_ID) INITIATIVE_ID, NVL(INIT1.INITIATIVE_NUMBER, INIT2.INITIATIVE_NUMBER) INITIATIVE_NUMBER, NVL(INIT1.TITLE, INIT2.TITLE) TITLE, NVL(INIT1.DESCRIPTION, INIT2.DESCRIPTION) DESCRIPTION, NVL(INIT1.STATUS, INIT2.STATUS) INITIATIVE_STATUS, NVL(INIT1.TYPE, INIT2.TYPE) TYPE, NVL(INIT1.PRC_BU_ID, INIT2.PRC_BU_ID) INITIATIVE_PRC_BU_ID, NVL(INIT1.OWNER_ID, INIT2.OWNER_ID) INITIATIVE_OWNER_ID, NVL(INIT1.INTERNAL_NOTE, INIT2.INTERNAL_NOTE) INTERNAL_NOTE, NVL(INIT1.REUSE_ACTIVE_QUAL_FLAG, INIT2.REUSE_ACTIVE_QUAL_FLAG) REUSE_ACTIVE_QUAL_FLAG, NVL(INIT1.LAUNCH_DATE, INIT2.LAUNCH_DATE) LAUNCH_DATE, NVL(INIT1.COMPLETED_DATE, INIT2.COMPLETED_DATE) COMPLETED_DATE, NVL(INIT1.CANCELED_DATE, INIT2.CANCELED_DATE) INITIATIVE_CANCELED_DATE, NVL(INIT1.CANCELED_BY, INIT2.CANCELED_BY) INITIATIVE_CANCELED_BY, NVL(INIT1.CANCELED_REASON_CODE, INIT2.CANCELED_REASON_CODE) INITIATIVE_CANCELED_REASON, NVL(INIT1.CREATION_DATE, INIT2.CREATION_DATE) INITIATIVE_CREATION_DATE, QUAL.COMPLETED_DATE QUAL_COMPLETED_DATE, ASMT.COMPLETED_DATE ASMT_COMPLETED_DATE, QUAL.EXPIRATION_REMINDER_PERIOD QUAL_EXP_REMINDER_PERIOD, QUAL.EXPIRATION_REMINDER_TYPE QUAL_EXP_REMINDER_TYPE, ASMT.EXPIRATION_REMINDER_PERIOD ASMT_EXP_REMINDER_PERIOD, ASMT.EXPIRATION_REMINDER_TYPE ASMT_EXP_REMINDER_TYPE, QUAL.CREATION_SOURCE QUAL_CREATION_SOURCE, QUAL.AUTO_EVALUATED_FLAG QUAL_AUTO_EVALUATED_FLAG, QUAL.QUALIFICATION_SCORE QUAL_QUALIFICATION_SCORE, QUAL.ORIG_QUALIFICATION_SCORE QUAL_ORIG_QUALIFICATION_SCORE, QUAL.ORIG_QUALIFICATION_OUTCOME QA_ORIG_QUALIFICATION_OUTCOME, QUAL.OVERRIDE_REASON QUAL_OVERRIDE_REASON, QUAL.OVERRIDDEN_BY QUAL_OVERRIDDEN_BY, QUAL.OVERRIDE_DATE QUAL_OVERRIDE_DATE, QUAL.SHOW_QUAL_TO_SUPPLIER_FLAG QA_SHOW_QUAL_TO_SUPPLIER_FLAG, QUAL.SHOW_QUAL_SUPP_RESP_FLAG QUAL_SHOW_QUAL_SUPP_RESP_FLAG, QUAL.SHOW_QUAL_INTER_RESP_FLAG QUAL_SHOW_QUAL_INTER_RESP_FLAG, QUAL.NOTE_TO_SUPPLIER QUAL_NOTE_TO_SUPPLIER, QUAL.REQUALIFY_EXECUTED_FLAG QUAL_REQUALIFY_EXECUTED_FLAG, QUAL.REQUALIFY_EXPIRATION_FLAG QUAL_REQUALIFY_EXPIRATION_FLAG, QUAL.REQUALIFY_RESPONSE_FLAG QUAL_REQUALIFY_RESPONSE_FLAG, QUAL.EVAL_READY_DATE QUAL_EVAL_READY_DATE, QM.WEIGHT WEIGHT, (QM.WEIGHT * QUAL.QUALIFICATION_SCORE) / 100 QUAL_WEIGHTED_SCORE, NVL(INIT1.CREATION_SOURCE, INIT2.CREATION_SOURCE) INITIATIVE_CREATION_SOURCE, NVL(INIT1.AUTO_ACCEPT_RESPONSES_FLAG, INIT2.AUTO_ACCEPT_RESPONSES_FLAG) INIT_AUTO_ACC_RESPONSES_FLAG, NVL(INIT1.AUTO_POPULATE_RESPONSES_FLAG, INIT2.AUTO_POPULATE_RESPONSES_FLAG) INIT_AUTO_POP_RESPONSES_FLAG, NVL(INIT1.LAST_OVERDUE_REMINDER_DATE, INIT2.LAST_OVERDUE_REMINDER_DATE) INIT_LAST_OVER_REMINDER_DATE, ASMT.ASSESSMENT_SCORE ASMT_ASSESSMENT_SCORE, ASMT.ORIG_ASSESSMENT_SCORE ASMT_ORIG_ASSESSMENT_SCORE, ASMT.ORIG_ASSESSMENT_OUTCOME ASMT_ORIG_ASSESSMENT_OUTCOME, ASMT.OVERRIDE_REASON ASMT_OVERRIDE_REASON, ASMT.OVERRIDEN_BY ASMT_OVERRIDEN_BY, ASMT.OVERRIDE_DATE ASMT_OVERRIDE_DATE, ASMT.AUTO_EVALUATED_FLAG ASMT_AUTO_EVALUATED_FLAG, ASMT.SHOW_ASSESSMT_TO_SUPP_FLAG ASMT_SHOW_ASSESS_TO_SUPP_FLAG, ASMT.SHOW_ASSESSMENT_QUAL_FLAG ASMT_SHOW_ASSESSMENT_QUAL_FLAG, ASMT.NOTE_TO_SUPPLIER ASMT_NOTE_TO_SUPPLIER, ASMT.SOURCING_ELIGIBILITY_CODE ASMT_SOURCING_ELIGIBILITY_CODE, ASMT.EVAL_READY_DATE ASMT_EVAL_READY_DATE FROM POQ_QUALIFICATIONS QUAL, POQ_ASSESSMENT_QUALS AQ, POQ_ASSESSMENTS ASMT, POQ_INITIATIVES INIT1, POQ_INITIATIVES INIT2, POQ_QUAL_MODEL_AREAS QM WHERE QUAL.QUALIFICATION_ID = AQ.QUALIFICATION_ID(+) AND AQ.ASSESSMENT_ID = ASMT.ASSESSMENT_ID(+) AND ASMT.INITIATIVE_ID = INIT1.INITIATIVE_ID(+) AND QUAL.INITIATIVE_ID = INIT2.INITIATIVE_ID(+) AND ASMT.QUAL_MODEL_ID = QM.QUAL_MODEL_ID(+) AND QUAL.QUAL_AREA_ID = QM.QUAL_AREA_ID(+)

SQL_Statement

SELECT

QUAL.QUALIFICATION_ID,

QUAL.QUALIFICATION_NUMBER,

QUAL.QUALIFICATION_NAME,

QUAL.QUAL_AREA_ID,

QUAL.PRC_BU_ID QUAL_PRC_BU_ID,

QUAL.SUPPLIER_ID QUAL_SUPPLIER_ID,

QUAL.SUPPLIER_SITE_ID QUAL_SUPPLIER_SITE_ID,

QUAL.SUPP_CONTACT_PARTY_ID QUAL_SUPP_CONTACT_PARTY_ID,

QUAL.OWNER_ID QUAL_OWNER_ID,

QUAL.QUALIFICATION_OUTCOME,

QUAL.STATUS QUAL_STATUS,

QUAL.EFFECTIVE_START_DATE QUAL_EFFECTIVE_START_DATE,

QUAL.EFFECTIVE_END_DATE QUAL_EFFECTIVE_END_DATE,

QUAL.EVALUATION_DUE_DATE QUAL_EVALUATION_DUE_DATE,

QUAL.EVALUATED_BY QUAL_EVALUATED_BY,

QUAL.QUALIFICATION_COMMENTS,

QUAL.EVALUATION_DATE QUAL_EVALUATION_DATE,

QUAL.CANCELED_BY QUAL_CANCELED_BY,

QUAL.CANCELED_DATE QUAL_CANCELED_DATE,

QUAL.CANCELED_REASON_CODE QUAL_CANCELED_REASON_CODE,

QUAL.LATEST_FLAG QUAL_LATEST_FLAG,

QUAL.REQUEST_ID QUAL_REQUEST_ID,

QUAL.CREATION_DATE QUAL_CREATION_DATE,

ASMT.ASSESSMENT_ID,

ASMT.ASSESSMENT_NUMBER,

ASMT.ASSESSMENT_NAME,

ASMT.QUAL_MODEL_ID,

ASMT.PRC_BU_ID ASMT_PRC_BU_ID,

ASMT.SUPPLIER_ID ASMT_SUPPLIER_ID,

ASMT.SUPPLIER_SITE_ID ASMT_SUPPLIER_SITE_ID,

ASMT.SUPP_CONTACT_PARTY_ID ASMT_SUPP_CONTACT_PARTY_ID,

ASMT.OWNER_ID ASMT_OWNER_ID,

ASMT.ASSESSMENT_OUTCOME,

ASMT.STATUS ASMT_STATUS,

ASMT.EVALUATION_DUE_DATE ASMT_EVALUATION_DUE_DATE,

ASMT.EVALUATED_BY ASMT_EVALUATED_BY,

ASMT.ASSESSMENT_COMMENTS,

ASMT.EVALUATION_DATE ASMT_EVALUATION_DATE,

ASMT.EFFECTIVE_START_DATE ASMT_EFFECTIVE_START_DATE,

ASMT.EFFECTIVE_END_DATE ASMT_EFFECTIVE_END_DATE,

ASMT.LATEST_FLAG ASMT_LATEST_FLAG,

ASMT.CANCELED_BY ASMT_CANCELED_BY,

ASMT.CANCELED_DATE ASMT_CANCELED_DATE,

ASMT.CANCELED_REASON_CODE ASMT_CANCELED_REASON_CODE,

ASMT.SEND_SUPP_QNNAIRE_FLAG,

ASMT.SEND_INT_QNNAIRE_FLAG,

ASMT.REQUEST_ID ASMT_REQUEST_ID,

ASMT.CREATION_DATE ASMT_CREATION_DATE,

NVL(INIT1.INITIATIVE_ID, INIT2.INITIATIVE_ID) INITIATIVE_ID,

NVL(INIT1.INITIATIVE_NUMBER, INIT2.INITIATIVE_NUMBER) INITIATIVE_NUMBER,

NVL(INIT1.TITLE, INIT2.TITLE) TITLE,

NVL(INIT1.DESCRIPTION, INIT2.DESCRIPTION) DESCRIPTION,

NVL(INIT1.STATUS, INIT2.STATUS) INITIATIVE_STATUS,

NVL(INIT1.TYPE, INIT2.TYPE) TYPE,

NVL(INIT1.PRC_BU_ID, INIT2.PRC_BU_ID) INITIATIVE_PRC_BU_ID,

NVL(INIT1.OWNER_ID, INIT2.OWNER_ID) INITIATIVE_OWNER_ID,

NVL(INIT1.INTERNAL_NOTE, INIT2.INTERNAL_NOTE) INTERNAL_NOTE,

NVL(INIT1.REUSE_ACTIVE_QUAL_FLAG, INIT2.REUSE_ACTIVE_QUAL_FLAG) REUSE_ACTIVE_QUAL_FLAG,

NVL(INIT1.LAUNCH_DATE, INIT2.LAUNCH_DATE) LAUNCH_DATE,

NVL(INIT1.COMPLETED_DATE, INIT2.COMPLETED_DATE) COMPLETED_DATE,

NVL(INIT1.CANCELED_DATE, INIT2.CANCELED_DATE) INITIATIVE_CANCELED_DATE,

NVL(INIT1.CANCELED_BY, INIT2.CANCELED_BY) INITIATIVE_CANCELED_BY,

NVL(INIT1.CANCELED_REASON_CODE, INIT2.CANCELED_REASON_CODE) INITIATIVE_CANCELED_REASON,

NVL(INIT1.CREATION_DATE, INIT2.CREATION_DATE) INITIATIVE_CREATION_DATE,

QUAL.COMPLETED_DATE QUAL_COMPLETED_DATE,

ASMT.COMPLETED_DATE ASMT_COMPLETED_DATE,

QUAL.EXPIRATION_REMINDER_PERIOD QUAL_EXP_REMINDER_PERIOD,

QUAL.EXPIRATION_REMINDER_TYPE QUAL_EXP_REMINDER_TYPE,

ASMT.EXPIRATION_REMINDER_PERIOD ASMT_EXP_REMINDER_PERIOD,

ASMT.EXPIRATION_REMINDER_TYPE ASMT_EXP_REMINDER_TYPE,

QUAL.CREATION_SOURCE QUAL_CREATION_SOURCE,

QUAL.AUTO_EVALUATED_FLAG QUAL_AUTO_EVALUATED_FLAG,

QUAL.QUALIFICATION_SCORE QUAL_QUALIFICATION_SCORE,

QUAL.ORIG_QUALIFICATION_SCORE QUAL_ORIG_QUALIFICATION_SCORE,

QUAL.ORIG_QUALIFICATION_OUTCOME QA_ORIG_QUALIFICATION_OUTCOME,

QUAL.OVERRIDE_REASON QUAL_OVERRIDE_REASON,

QUAL.OVERRIDDEN_BY QUAL_OVERRIDDEN_BY,

QUAL.OVERRIDE_DATE QUAL_OVERRIDE_DATE,

QUAL.SHOW_QUAL_TO_SUPPLIER_FLAG QA_SHOW_QUAL_TO_SUPPLIER_FLAG,

QUAL.SHOW_QUAL_SUPP_RESP_FLAG QUAL_SHOW_QUAL_SUPP_RESP_FLAG,

QUAL.SHOW_QUAL_INTER_RESP_FLAG QUAL_SHOW_QUAL_INTER_RESP_FLAG,

QUAL.NOTE_TO_SUPPLIER QUAL_NOTE_TO_SUPPLIER,

QUAL.REQUALIFY_EXECUTED_FLAG QUAL_REQUALIFY_EXECUTED_FLAG,

QUAL.REQUALIFY_EXPIRATION_FLAG QUAL_REQUALIFY_EXPIRATION_FLAG,

QUAL.REQUALIFY_RESPONSE_FLAG QUAL_REQUALIFY_RESPONSE_FLAG,

QUAL.EVAL_READY_DATE QUAL_EVAL_READY_DATE,

QM.WEIGHT WEIGHT,

(QM.WEIGHT * QUAL.QUALIFICATION_SCORE) / 100 QUAL_WEIGHTED_SCORE,

NVL(INIT1.CREATION_SOURCE, INIT2.CREATION_SOURCE) INITIATIVE_CREATION_SOURCE,

NVL(INIT1.AUTO_ACCEPT_RESPONSES_FLAG, INIT2.AUTO_ACCEPT_RESPONSES_FLAG) INIT_AUTO_ACC_RESPONSES_FLAG,

NVL(INIT1.AUTO_POPULATE_RESPONSES_FLAG, INIT2.AUTO_POPULATE_RESPONSES_FLAG) INIT_AUTO_POP_RESPONSES_FLAG,

NVL(INIT1.LAST_OVERDUE_REMINDER_DATE, INIT2.LAST_OVERDUE_REMINDER_DATE) INIT_LAST_OVER_REMINDER_DATE,

ASMT.ASSESSMENT_SCORE ASMT_ASSESSMENT_SCORE,

ASMT.ORIG_ASSESSMENT_SCORE ASMT_ORIG_ASSESSMENT_SCORE,

ASMT.ORIG_ASSESSMENT_OUTCOME ASMT_ORIG_ASSESSMENT_OUTCOME,

ASMT.OVERRIDE_REASON ASMT_OVERRIDE_REASON,

ASMT.OVERRIDEN_BY ASMT_OVERRIDEN_BY,

ASMT.OVERRIDE_DATE ASMT_OVERRIDE_DATE,

ASMT.AUTO_EVALUATED_FLAG ASMT_AUTO_EVALUATED_FLAG,

ASMT.SHOW_ASSESSMT_TO_SUPP_FLAG ASMT_SHOW_ASSESS_TO_SUPP_FLAG,

ASMT.SHOW_ASSESSMENT_QUAL_FLAG ASMT_SHOW_ASSESSMENT_QUAL_FLAG,

ASMT.NOTE_TO_SUPPLIER ASMT_NOTE_TO_SUPPLIER,

ASMT.SOURCING_ELIGIBILITY_CODE ASMT_SOURCING_ELIGIBILITY_CODE,

ASMT.EVAL_READY_DATE ASMT_EVAL_READY_DATE

FROM

POQ_QUALIFICATIONS QUAL,

POQ_ASSESSMENT_QUALS AQ,

POQ_ASSESSMENTS ASMT,

POQ_INITIATIVES INIT1,

POQ_INITIATIVES INIT2,

POQ_QUAL_MODEL_AREAS QM

WHERE

QUAL.QUALIFICATION_ID = AQ.QUALIFICATION_ID(+) AND AQ.ASSESSMENT_ID = ASMT.ASSESSMENT_ID(+) AND ASMT.INITIATIVE_ID = INIT1.INITIATIVE_ID(+) AND QUAL.INITIATIVE_ID = INIT2.INITIATIVE_ID(+) AND ASMT.QUAL_MODEL_ID = QM.QUAL_MODEL_ID(+) AND QUAL.QUAL_AREA_ID = QM.QUAL_AREA_ID(+)