QSC_PROD_GRP_VALIDATION_V

Details

• Schema: FUSION

• Object owner: QSC

• Object type: VIEW

Query

SQL_Statement

WITH po_value AS ( SELECT /*+ MATERIALIZE */ nvl(fpov.profile_option_value, 'N') AS profile_option_value FROM fnd_profile_options fpo LEFT JOIN fnd_profile_option_values fpov ON fpov.profile_option_id = fpo.profile_option_id AND fpov.application_id = fpo.application_id WHERE fpo.profile_option_name = 'ORA_QSC_ENABLE_PIM_CATALOG_MIGRATION' ) SELECT qsc_prod_groups_b.prod_group_id, qsc_prod_groups_b.internal_name, qsc_prod_groups_b.ref_number, qsc_prod_groups_tl.prod_group_name, qsc_prod_groups_tl.prod_group_desc_text, qsc_prod_groups_tl.language, qsc_prod_grp_details.prod_grp_details_id, qsc_prod_grp_details.active_flag, qsc_prod_grp_details.start_date, qsc_prod_grp_details.end_date, qsc_prod_grp_details.model_name, qsc_prod_grp_details.model_config_attributes, qsc_prod_grp_details.model_line, qsc_prod_grp_details.model_family, nvl2(qsc_prod_grp_details.model_name, 'Y', 'N') AS quotable_flag, qsc_prod_groups_b.created_by, qsc_prod_groups_b.creation_date, qsc_prod_groups_b.last_updated_by, qsc_prod_groups_b.last_update_date, qsc_prod_groups_b.last_update_login, qsc_prod_groups_b.object_version_number FROM qsc_prod_groups_b, qsc_prod_groups_tl, qsc_prod_grp_details, po_value WHERE po_value.profile_option_value = 'N' AND qsc_prod_groups_b.prod_group_id = qsc_prod_groups_tl.prod_group_id AND qsc_prod_groups_tl.language = userenv('LANG') AND qsc_prod_groups_b.prod_group_id = qsc_prod_grp_details.prod_group_id AND qsc_prod_groups_b.runtime_revision_num = qsc_prod_grp_details.revision_num UNION ALL SELECT egp_categories_b.category_id AS prod_group_id, NULL AS internal_name, egp_categories_b.category_code AS ref_number, egp_categories_tl.category_name AS prod_group_name, egp_categories_tl.description AS prod_group_desc_text, egp_categories_tl.language, NULL AS prod_grp_details_id, NULL AS active_flag, egp_categories_b.start_date_active AS start_date, egp_categories_b.end_date_active AS end_date, NULL AS model_name, NULL AS model_config_attributes, NULL AS model_line, NULL AS model_family, NULL AS quotable_flag, egp_categories_b.created_by, egp_categories_b.creation_date, egp_categories_b.last_updated_by, egp_categories_b.last_update_date, egp_categories_b.last_update_login, egp_categories_b.object_version_number FROM egp_categories_b, egp_categories_tl, po_value WHERE po_value.profile_option_value = 'Y' AND egp_categories_b.category_id = egp_categories_tl.category_id AND egp_categories_tl.language = userenv('LANG')