POQ_QUAL_AREAS

Details

Schema: FUSION
Object owner: POQ
Object type: VIEW

Columns

Name
QUAL_AREA_ID OBJECT_VERSION_NUMBER QUAL_AREA_NAME SECTION_NAME PRC_BU_ID REVISION_NUMBER ORIGINAL_QUAL_AREA_ID QUAL_AREA_DESCRIPTION GLOBAL_FLAG QUAL_AREA_STATUS QUAL_AREA_USAGE_CODE OWNER_ID INFORMATION_ONLY_FLAG QUAL_AREA_LEVEL STDS_ORG_CODE SUBJECT_CODE LATEST_REVISION_FLAG ACTIVATION_DATE EXPIRATION_REMINDER_PERIOD EXPIRATION_REMINDER_TYPE ENABLE_SCORING_FLAG AUTO_ACCEPT_RESPONSES_FLAG AUTO_POPULATE_RESPONSES_FLAG AUTO_EVALUATE_QUAL_FLAG QUALIFICATION_DURATION QUALIFICATION_DURATION_TYPE SHOW_QUAL_TO_SUPPLIER_FLAG SHOW_QUAL_SUPP_RESP_FLAG SHOW_QUAL_INTER_RESP_FLAG NOTE_TO_SUPPLIER REQUALIFY_EXPIRATION_FLAG REQUALIFY_RESPONSE_FLAG DEFAULT_QUAL_OWNER_FLAG SINGLE_QUAL_AUTO_INIT_FLAG QUALIFICATION_OWNER_ID QUAL_AREA_SURVEY_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

QUAL_AREA_ID

OBJECT_VERSION_NUMBER

QUAL_AREA_NAME

SECTION_NAME

PRC_BU_ID

REVISION_NUMBER

ORIGINAL_QUAL_AREA_ID

QUAL_AREA_DESCRIPTION

GLOBAL_FLAG

QUAL_AREA_STATUS

QUAL_AREA_USAGE_CODE

OWNER_ID

INFORMATION_ONLY_FLAG

QUAL_AREA_LEVEL

STDS_ORG_CODE

SUBJECT_CODE

LATEST_REVISION_FLAG

ACTIVATION_DATE

EXPIRATION_REMINDER_PERIOD

EXPIRATION_REMINDER_TYPE

ENABLE_SCORING_FLAG

AUTO_ACCEPT_RESPONSES_FLAG

AUTO_POPULATE_RESPONSES_FLAG

AUTO_EVALUATE_QUAL_FLAG

QUALIFICATION_DURATION

QUALIFICATION_DURATION_TYPE

SHOW_QUAL_TO_SUPPLIER_FLAG

SHOW_QUAL_SUPP_RESP_FLAG

SHOW_QUAL_INTER_RESP_FLAG

NOTE_TO_SUPPLIER

REQUALIFY_EXPIRATION_FLAG

REQUALIFY_RESPONSE_FLAG

DEFAULT_QUAL_OWNER_FLAG

SINGLE_QUAL_AUTO_INIT_FLAG

QUALIFICATION_OWNER_ID

QUAL_AREA_SURVEY_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.QUAL_AREA_ID QUAL_AREA_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.QUAL_AREA_NAME QUAL_AREA_NAME, T.SECTION_NAME SECTION_NAME, B.PRC_BU_ID PRC_BU_ID, B.REVISION_NUMBER REVISION_NUMBER, B.ORIGINAL_QUAL_AREA_ID ORIGINAL_QUAL_AREA_ID, B.QUAL_AREA_DESCRIPTION QUAL_AREA_DESCRIPTION, B.GLOBAL_FLAG GLOBAL_FLAG, B.QUAL_AREA_STATUS QUAL_AREA_STATUS, B.QUAL_AREA_USAGE_CODE QUAL_AREA_USAGE_CODE, B.OWNER_ID OWNER_ID, B.INFORMATION_ONLY_FLAG INFORMATION_ONLY_FLAG, B.QUAL_AREA_LEVEL QUAL_AREA_LEVEL, B.STDS_ORG_CODE STDS_ORG_CODE, B.SUBJECT_CODE SUBJECT_CODE, B.LATEST_REVISION_FLAG LATEST_REVISION_FLAG, B.ACTIVATION_DATE ACTIVATION_DATE, B.EXPIRATION_REMINDER_PERIOD EXPIRATION_REMINDER_PERIOD, B.EXPIRATION_REMINDER_TYPE EXPIRATION_REMINDER_TYPE, B.ENABLE_SCORING_FLAG ENABLE_SCORING_FLAG, B.AUTO_ACCEPT_RESPONSES_FLAG AUTO_ACCEPT_RESPONSES_FLAG, B.AUTO_POPULATE_RESPONSES_FLAG AUTO_POPULATE_RESPONSES_FLAG, B.AUTO_EVALUATE_QUAL_FLAG AUTO_EVALUATE_QUAL_FLAG, B.QUALIFICATION_DURATION QUALIFICATION_DURATION, B.QUALIFICATION_DURATION_TYPE QUALIFICATION_DURATION_TYPE, B.SHOW_QUAL_TO_SUPPLIER_FLAG SHOW_QUAL_TO_SUPPLIER_FLAG, B.SHOW_QUAL_SUPP_RESP_FLAG SHOW_QUAL_SUPP_RESP_FLAG, B.SHOW_QUAL_INTER_RESP_FLAG SHOW_QUAL_INTER_RESP_FLAG, B.NOTE_TO_SUPPLIER NOTE_TO_SUPPLIER, B.REQUALIFY_EXPIRATION_FLAG REQUALIFY_EXPIRATION_FLAG, B.REQUALIFY_RESPONSE_FLAG REQUALIFY_RESPONSE_FLAG, B.DEFAULT_QUAL_OWNER_FLAG DEFAULT_QUAL_OWNER_FLAG, B.SINGLE_QUAL_AUTO_INIT_FLAG SINGLE_QUAL_AUTO_INIT_FLAG, B.QUALIFICATION_OWNER_ID QUALIFICATION_OWNER_ID, B.QUAL_AREA_SURVEY_FLAG QUAL_AREA_SURVEY_FLAG, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM POQ_QUAL_AREAS_B B, POQ_QUAL_AREAS_TL T WHERE B.QUAL_AREA_ID = T.QUAL_AREA_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.QUAL_AREA_ID QUAL_AREA_ID,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.QUAL_AREA_NAME QUAL_AREA_NAME,

T.SECTION_NAME SECTION_NAME,

B.PRC_BU_ID PRC_BU_ID,

B.REVISION_NUMBER REVISION_NUMBER,

B.ORIGINAL_QUAL_AREA_ID ORIGINAL_QUAL_AREA_ID,

B.QUAL_AREA_DESCRIPTION QUAL_AREA_DESCRIPTION,

B.GLOBAL_FLAG GLOBAL_FLAG,

B.QUAL_AREA_STATUS QUAL_AREA_STATUS,

B.QUAL_AREA_USAGE_CODE QUAL_AREA_USAGE_CODE,

B.OWNER_ID OWNER_ID,

B.INFORMATION_ONLY_FLAG INFORMATION_ONLY_FLAG,

B.QUAL_AREA_LEVEL QUAL_AREA_LEVEL,

B.STDS_ORG_CODE STDS_ORG_CODE,

B.SUBJECT_CODE SUBJECT_CODE,

B.LATEST_REVISION_FLAG LATEST_REVISION_FLAG,

B.ACTIVATION_DATE ACTIVATION_DATE,

B.EXPIRATION_REMINDER_PERIOD EXPIRATION_REMINDER_PERIOD,

B.EXPIRATION_REMINDER_TYPE EXPIRATION_REMINDER_TYPE,

B.ENABLE_SCORING_FLAG ENABLE_SCORING_FLAG,

B.AUTO_ACCEPT_RESPONSES_FLAG AUTO_ACCEPT_RESPONSES_FLAG,

B.AUTO_POPULATE_RESPONSES_FLAG AUTO_POPULATE_RESPONSES_FLAG,

B.AUTO_EVALUATE_QUAL_FLAG AUTO_EVALUATE_QUAL_FLAG,

B.QUALIFICATION_DURATION QUALIFICATION_DURATION,

B.QUALIFICATION_DURATION_TYPE QUALIFICATION_DURATION_TYPE,

B.SHOW_QUAL_TO_SUPPLIER_FLAG SHOW_QUAL_TO_SUPPLIER_FLAG,

B.SHOW_QUAL_SUPP_RESP_FLAG SHOW_QUAL_SUPP_RESP_FLAG,

B.SHOW_QUAL_INTER_RESP_FLAG SHOW_QUAL_INTER_RESP_FLAG,

B.NOTE_TO_SUPPLIER NOTE_TO_SUPPLIER,

B.REQUALIFY_EXPIRATION_FLAG REQUALIFY_EXPIRATION_FLAG,

B.REQUALIFY_RESPONSE_FLAG REQUALIFY_RESPONSE_FLAG,

B.DEFAULT_QUAL_OWNER_FLAG DEFAULT_QUAL_OWNER_FLAG,

B.SINGLE_QUAL_AUTO_INIT_FLAG SINGLE_QUAL_AUTO_INIT_FLAG,

B.QUALIFICATION_OWNER_ID QUALIFICATION_OWNER_ID,

B.QUAL_AREA_SURVEY_FLAG QUAL_AREA_SURVEY_FLAG,

B.CREATED_BY CREATED_BY,

B.CREATION_DATE CREATION_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

POQ_QUAL_AREAS_B B,

POQ_QUAL_AREAS_TL T

WHERE

B.QUAL_AREA_ID = T.QUAL_AREA_ID AND T.LANGUAGE = USERENV('LANG')