Analytics Catalog/Data dictionary/POQ_QUAL_AREAS_VL
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
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

ColumnKeyIn reportsDescription (inferred)
ACTIVATION_DATEActivation date.
AUTO_ACCEPT_RESPONSES_FLAGIndicator (Y/N) for the auto accept responses.
AUTO_EVALUATE_QUAL_FLAGIndicator (Y/N) for the auto evaluate qual.
AUTO_POPULATE_RESPONSES_FLAGIndicator (Y/N) for the auto populate responses.
ENABLE_SCORING_FLAGIndicator (Y/N) for the enable scoring.
EXPIRATION_REMINDER_PERIODExpiration reminder period.
EXPIRATION_REMINDER_TYPEType of expiration reminder.
GLOBAL_FLAGIndicator (Y/N) for the global.
INFORMATION_ONLY_FLAGIndicator (Y/N) for the information only.
LATEST_REVISION_FLAGIndicator (Y/N) for the latest revision.
NOTE_TO_SUPPLIERNote to supplier.
QUALIFICATION_DURATIONQualification duration.
QUALIFICATION_DURATION_TYPEType of qualification duration.
QUAL_AREA_DESCRIPTIONDescription of the qual area.
QUAL_AREA_LEVELQual area level.
QUAL_AREA_NAMEName of the qual area.
QUAL_AREA_STATUSStatus of the qual area.
QUAL_AREA_SURVEY_FLAGIndicator (Y/N) for the qual area survey.
REQUALIFY_EXPIRATION_FLAGIndicator (Y/N) for the requalify expiration.
REQUALIFY_RESPONSE_FLAGIndicator (Y/N) for the requalify response.
REVISION_NUMBERRevision number.
SECTION_NAMEName of the section.
SHOW_QUAL_INTER_RESP_FLAGIndicator (Y/N) for the show qual inter resp.
SHOW_QUAL_SUPP_RESP_FLAGIndicator (Y/N) for the show qual supplier resp.
SHOW_QUAL_TO_SUPPLIER_FLAGIndicator (Y/N) for the show qual to supplier.
STDS_ORG_CODECode identifying the stds organization.
SUBJECT_CODECode 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.

Need the extract + dbt staging for POQ_QUAL_AREAS_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us