POQ_QUAL_AREAS_VL
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 |
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') |