Oracle Fusion · Data dictionary
POQ_QUAL_ASMT_INIT_V
SharedUsed in 3 subject areas74 reporting columns
denormalized view.
Primary key: not yet catalogued for POQ_QUAL_ASMT_INIT_V, reference Oracle Tables & Views guide.
Joins (inferred from key columns): ASSESSMENT_ID → POQ_ASSESSMENTS · INITIATIVE_ID → POQ_INITIATIVES
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASMT_ASSESSMENT_SCORE | ● | Asmt assessment score. | |
| ASMT_AUTO_EVALUATED_FLAG | ● | Indicator (Y/N) for the asmt auto evaluated. | |
| ASMT_CANCELED_DATE | ● | Asmt canceled date. | |
| ASMT_CANCELED_REASON_CODE | ● | Code identifying the asmt canceled reason. | |
| ASMT_COMPLETED_DATE | ● | Asmt completed date. | |
| ASMT_CREATION_DATE | ● | Asmt creation date. | |
| ASMT_EFFECTIVE_END_DATE | ● | Asmt effective end date. | |
| ASMT_EFFECTIVE_START_DATE | ● | Asmt effective start date. | |
| ASMT_EVALUATION_DATE | ● | Asmt evaluation date. | |
| ASMT_EVALUATION_DUE_DATE | ● | Asmt evaluation due date. | |
| ASMT_EVAL_READY_DATE | ● | Asmt eval ready date. | |
| ASMT_EXP_REMINDER_PERIOD | ● | Asmt exp reminder period. | |
| ASMT_EXP_REMINDER_TYPE | ● | Type of asmt exp reminder. | |
| ASMT_LATEST_FLAG | ● | Indicator (Y/N) for the asmt latest. | |
| ASMT_NOTE_TO_SUPPLIER | ● | Asmt note to supplier. | |
| ASMT_ORIG_ASSESSMENT_OUTCOME | ● | Asmt orig assessment outcome. | |
| ASMT_ORIG_ASSESSMENT_SCORE | ● | Asmt orig assessment score. | |
| ASMT_OVERRIDE_DATE | ● | Asmt override date. | |
| ASMT_OVERRIDE_REASON | ● | Asmt override reason. | |
| ASMT_SHOW_ASSESSMENT_QUAL_FLAG | ● | Indicator (Y/N) for the asmt show assessment qual. | |
| ASMT_SHOW_ASSESS_TO_SUPP_FLAG | ● | Indicator (Y/N) for the asmt show assess to supplier. | |
| ASMT_SOURCING_ELIGIBILITY_CODE | ● | Code identifying the asmt sourcing eligibility. | |
| ASSESSMENT_COMMENTS | ● | Assessment comments. | |
| ASSESSMENT_ID | ● | Identifier for the assessment. | |
| ASSESSMENT_NAME | ● | Name of the assessment. | |
| ASSESSMENT_NUMBER | ● | Assessment number. | |
| ASSESSMENT_OUTCOME | ● | Assessment outcome. | |
| COMPLETED_DATE | ● | Completed date. | |
| DESCRIPTION | ● | Description. | |
| INITIATIVE_CANCELED_DATE | ● | Initiative canceled date. | |
| INITIATIVE_CANCELED_REASON | ● | Initiative canceled reason. | |
| INITIATIVE_CREATION_DATE | ● | Initiative creation date. | |
| INITIATIVE_ID | ● | Identifier for the initiative. | |
| INITIATIVE_NUMBER | ● | Initiative number. | |
| INIT_AUTO_ACC_RESPONSES_FLAG | ● | Indicator (Y/N) for the init auto acc responses. | |
| INIT_AUTO_POP_RESPONSES_FLAG | ● | Indicator (Y/N) for the init auto pop responses. | |
| INIT_LAST_OVER_REMINDER_DATE | ● | Init last over reminder date. | |
| INTERNAL_NOTE | ● | Internal note. | |
| LAUNCH_DATE | ● | Launch date. | |
| QA_ORIG_QUALIFICATION_OUTCOME | ● | Qa orig qualification outcome. | |
| QA_SHOW_QUAL_TO_SUPPLIER_FLAG | ● | Indicator (Y/N) for the qa show qual to supplier. | |
| QUALIFICATION_COMMENTS | ● | Qualification comments. | |
| QUALIFICATION_ID | ● | Identifier for the qualification. | |
| QUALIFICATION_NAME | ● | Name of the qualification. | |
| QUALIFICATION_NUMBER | ● | Qualification number. | |
| QUALIFICATION_OUTCOME | ● | Qualification outcome. | |
| QUAL_AREA_ID | ● | Identifier for the qual area. | |
| QUAL_AUTO_EVALUATED_FLAG | ● | Indicator (Y/N) for the qual auto evaluated. | |
| QUAL_CANCELED_DATE | ● | Qual canceled date. | |
| QUAL_CANCELED_REASON_CODE | ● | Code identifying the qual canceled reason. | |
| QUAL_COMPLETED_DATE | ● | Qual completed date. | |
| QUAL_CREATION_DATE | ● | Qual creation date. | |
| QUAL_EFFECTIVE_END_DATE | ● | Qual effective end date. | |
| QUAL_EFFECTIVE_START_DATE | ● | Qual effective start date. | |
| QUAL_EVALUATION_DATE | ● | Qual evaluation date. | |
| QUAL_EVALUATION_DUE_DATE | ● | Qual evaluation due date. | |
| QUAL_EVAL_READY_DATE | ● | Qual eval ready date. | |
| QUAL_EXP_REMINDER_PERIOD | ● | Qual exp reminder period. | |
| QUAL_EXP_REMINDER_TYPE | ● | Type of qual exp reminder. | |
| QUAL_LATEST_FLAG | ● | Indicator (Y/N) for the qual latest. | |
| QUAL_NOTE_TO_SUPPLIER | ● | Qual note to supplier. | |
| QUAL_ORIG_QUALIFICATION_SCORE | ● | Qual orig qualification score. | |
| QUAL_OVERRIDE_DATE | ● | Qual override date. | |
| QUAL_OVERRIDE_REASON | ● | Qual override reason. | |
| QUAL_QUALIFICATION_SCORE | ● | Qual qualification score. | |
| QUAL_REQUALIFY_EXECUTED_FLAG | ● | Indicator (Y/N) for the qual requalify executed. | |
| QUAL_REQUALIFY_EXPIRATION_FLAG | ● | Indicator (Y/N) for the qual requalify expiration. | |
| QUAL_REQUALIFY_RESPONSE_FLAG | ● | Indicator (Y/N) for the qual requalify response. | |
| QUAL_SHOW_QUAL_INTER_RESP_FLAG | ● | Indicator (Y/N) for the qual show qual inter resp. | |
| QUAL_SHOW_QUAL_SUPP_RESP_FLAG | ● | Indicator (Y/N) for the qual show qual supplier resp. | |
| QUAL_WEIGHTED_SCORE | ● | Qual weighted score. | |
| REUSE_ACTIVE_QUAL_FLAG | ● | Indicator (Y/N) for the reuse active qual. | |
| TITLE | ● | Title. | |
| TYPE | ● | Type. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Supplier Qualification - Qualifications and Assessments Real Time
- Supplier Qualification - Supplier Eligibility History Real Time
- Supplier Qualification - Supplier Eligibility Real Time
Need the extract + dbt staging for POQ_QUAL_ASMT_INIT_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table