Oracle Fusion · Data dictionary
POQ_QUAL_AREAS_VL
SharedUsed in 2 subject areas27 reporting columns
view layer, joins the base table with translations for the current language.
Primary key: not yet catalogued for POQ_QUAL_AREAS_VL, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVATION_DATE | ● | Activation date. | |
| AUTO_ACCEPT_RESPONSES_FLAG | ● | Indicator (Y/N) for the auto accept responses. | |
| AUTO_EVALUATE_QUAL_FLAG | ● | Indicator (Y/N) for the auto evaluate qual. | |
| AUTO_POPULATE_RESPONSES_FLAG | ● | Indicator (Y/N) for the auto populate responses. | |
| ENABLE_SCORING_FLAG | ● | Indicator (Y/N) for the enable scoring. | |
| EXPIRATION_REMINDER_PERIOD | ● | Expiration reminder period. | |
| EXPIRATION_REMINDER_TYPE | ● | Type of expiration reminder. | |
| GLOBAL_FLAG | ● | Indicator (Y/N) for the global. | |
| INFORMATION_ONLY_FLAG | ● | Indicator (Y/N) for the information only. | |
| LATEST_REVISION_FLAG | ● | Indicator (Y/N) for the latest revision. | |
| NOTE_TO_SUPPLIER | ● | Note to supplier. | |
| QUALIFICATION_DURATION | ● | Qualification duration. | |
| QUALIFICATION_DURATION_TYPE | ● | Type of qualification duration. | |
| QUAL_AREA_DESCRIPTION | ● | Description of the qual area. | |
| QUAL_AREA_LEVEL | ● | Qual area level. | |
| QUAL_AREA_NAME | ● | Name of the qual area. | |
| QUAL_AREA_STATUS | ● | Status of the qual area. | |
| QUAL_AREA_SURVEY_FLAG | ● | Indicator (Y/N) for the qual area survey. | |
| REQUALIFY_EXPIRATION_FLAG | ● | Indicator (Y/N) for the requalify expiration. | |
| REQUALIFY_RESPONSE_FLAG | ● | Indicator (Y/N) for the requalify response. | |
| REVISION_NUMBER | ● | Revision number. | |
| SECTION_NAME | ● | Name of the section. | |
| SHOW_QUAL_INTER_RESP_FLAG | ● | Indicator (Y/N) for the show qual inter resp. | |
| SHOW_QUAL_SUPP_RESP_FLAG | ● | Indicator (Y/N) for the show qual supplier resp. | |
| SHOW_QUAL_TO_SUPPLIER_FLAG | ● | Indicator (Y/N) for the show qual to supplier. | |
| STDS_ORG_CODE | ● | Code identifying the stds organization. | |
| SUBJECT_CODE | ● | Code identifying the subject. |
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 - Question Responses Real Time
Need the extract + dbt staging for POQ_QUAL_AREAS_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table