APPS.QP_DATA_COMPARE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

SELECT a.list_header_id,
       a.request_id,
       a.list_type_code,
       a.start_date_active,
       a.end_date_active,
       a.automatic_flag,
       a.currency_code,
       a.rounding_factor,
       a.ship_method_code,
       a.freight_terms_code,
       a.terms_id,
       a.comments,
       a.discount_lines_flag,
       a.gsa_indicator,
       a.prorate_flag,
       a.source_system_code,
       a.ask_for_flag,
       a.active_flag,
       a.parent_list_header_id,
       a.start_date_active_first,
       a.end_date_active_first,
       a.active_date_first_type,
       a.start_date_active_second,
       a.end_date_active_second,
       a.active_date_second_type,
       a.limit_exists_flag,
       a.mobile_download,
       a.currency_header_id,
       a.pte_code,
       a.list_source_code,
       a.orig_system_header_ref,
       a.orig_org_id,
       a.global_flag,
       a.sold_to_org_id,
       a.shareable_flag,
       a.locked_from_list_header_id,
       b.language,
       b.source_lang,
       b.name,
       b.description,
       b.version_no
FROM   qp_list_headers_b a ,
       qp_list_headers_tl b
WHERE  a.list_header_id = b.list_header_id
AND    a.list_header_id = p_list_header_id;

Line: 70

SELECT list_header_id
FROM   qp_list_lines
WHERE  list_line_id = p_list_line_id;

Line: 83

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 234

SELECT qualifier_id,
       qualifier_grouping_no,
       qualifier_context,
       qualifier_attribute,
       qualifier_attr_value,
       comparison_operator_code,
       excluder_flag,
       qualifier_rule_id,
       start_date_active,
       end_date_active,
       created_from_rule_id,
       qualifier_precedence,
       list_header_id,
       list_line_id,
       qualifier_datatype,
       qualifier_attr_value_to,
       active_flag,
       list_type_code,
       qual_attr_value_from_number,
       qual_attr_value_to_number,
       search_ind,
       qualifier_group_cnt,
       header_quals_exist_flag,
       distinct_row_count,
       others_group_cnt,
       orig_sys_qualifier_ref,
       orig_sys_header_ref,
       orig_sys_line_ref,
       segment_id
FROM   qp_qualifiers
WHERE  list_header_id = p_list_header_id
ORDER  BY qualifier_context,qualifier_attribute;

Line: 268

SELECT list_header_id
FROM   qp_list_lines
WHERE  list_line_id = p_list_line_id;

Line: 274

SELECT used_in_setup
FROM qp_pte_segments
WHERE segment_id IN
  (SELECT a.segment_id
   FROM   qp_segments_b a,qp_prc_contexts_b b
   WHERE a.segment_mapping_column=p_attribute
   AND   a.prc_context_id=b.prc_context_id
   AND   b.prc_context_type=p_context_type
   AND   b.prc_context_code=p_context);

Line: 293

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 444

SELECT list_line_id,
       list_header_id,
       list_line_type_code,
       start_date_active,
       end_date_active,
       automatic_flag,
       modifier_level_code,
       price_by_formula_id,
       primary_uom_flag,
       price_break_type_code,
       arithmetic_operator,
       operand,
       override_flag,
       accrual_qty,
       accrual_uom_code,
       estim_accrual_rate,
       generate_using_formula_id,
       list_line_no,
       estim_gl_value,
       benefit_price_list_line_id,
       expiration_period_start_date,
       number_expiration_periods,
       expiration_period_uom,
       expiration_date,
       accrual_flag,
       pricing_phase_id,
       pricing_group_sequence,
       incompatibility_grp_code,
       product_precedence,
       proration_type_code,
       accrual_conversion_rate,
       benefit_qty,
       benefit_uom_code,
       qualification_ind,
       limit_exists_flag,
       group_count,
       net_amount_flag,
       recurring_value,
       accum_context,
       accum_attribute,
       accum_attr_run_src_flag,
       break_uom_code,
       break_uom_context,
       break_uom_attribute,
       pattern_id,
       product_uom_code,
       pricing_attribute_count,
       hash_key,
       cache_key
FROM   qp_list_lines
WHERE  list_line_id = p_list_line_id
UNION
SELECT list_line_id,
       list_header_id,
       list_line_type_code,
       start_date_active,
       end_date_active,
       automatic_flag,
       modifier_level_code,
       price_by_formula_id,
       primary_uom_flag,
       price_break_type_code,
       arithmetic_operator,
       operand,
       override_flag,
       accrual_qty,
       accrual_uom_code,
       estim_accrual_rate,
       generate_using_formula_id,
       list_line_no,
       estim_gl_value,
       benefit_price_list_line_id,
       expiration_period_start_date,
       number_expiration_periods,
       expiration_period_uom,
       expiration_date,
       accrual_flag,
       pricing_phase_id,
       pricing_group_sequence,
       incompatibility_grp_code,
       product_precedence,
       proration_type_code,
       accrual_conversion_rate,
       benefit_qty,
       benefit_uom_code,
       qualification_ind,
       limit_exists_flag,
       group_count,
       net_amount_flag,
       recurring_value,
       accum_context,
       accum_attribute,
       accum_attr_run_src_flag,
       break_uom_code,
       break_uom_context,
       break_uom_attribute,
       pattern_id,
       product_uom_code,
       pricing_attribute_count,
       hash_key,
       cache_key
FROM   qp_list_lines
WHERE  list_line_id IN (SELECT to_rltd_modifier_id
                        FROM   qp_rltd_modifiers
                        WHERE  from_rltd_modifier_id = p_list_line_id);

Line: 558

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 732

SELECT pricing_attribute_id,
       list_line_id,
       excluder_flag,
       accumulate_flag,
       product_attribute_context,
       product_attribute,
       product_attr_value,
       product_uom_code,
       pricing_attribute_context,
       pricing_attribute,
       pricing_attr_value_from,
       pricing_attr_value_to,
       attribute_grouping_no,
       product_attribute_datatype,
       pricing_attribute_datatype,
       comparison_operator_code,
       list_header_id,
       pricing_phase_id,
       qualification_ind,
       pricing_attr_value_from_number,
       pricing_attr_value_to_number,
       distinct_row_count,
       search_ind,
       pattern_value_from_positive,
       pattern_value_to_positive,
       pattern_value_from_negative,
       pattern_value_to_negative,
       product_segment_id,
       pricing_segment_id
FROM   qp_pricing_attributes
WHERE  list_line_id = p_list_line_id
UNION
SELECT pricing_attribute_id,
       list_line_id,
       excluder_flag,
       accumulate_flag,
       product_attribute_context,
       product_attribute,
       product_attr_value,
       product_uom_code,
       pricing_attribute_context,
       pricing_attribute,
       pricing_attr_value_from,
       pricing_attr_value_to,
       attribute_grouping_no,
       product_attribute_datatype,
       pricing_attribute_datatype,
       comparison_operator_code,
       list_header_id,
       pricing_phase_id,
       qualification_ind,
       pricing_attr_value_from_number,
       pricing_attr_value_to_number,
       distinct_row_count,
       search_ind,
       pattern_value_from_positive,
       pattern_value_to_positive,
       pattern_value_from_negative,
       pattern_value_to_negative,
       product_segment_id,
       pricing_segment_id
FROM   qp_pricing_attributes
WHERE  list_line_id IN (SELECT to_rltd_modifier_id
                        FROM   qp_rltd_modifiers
                        WHERE  from_rltd_modifier_id = p_list_line_id)
ORDER  BY product_attribute_context,product_attribute;

Line: 800

SELECT used_in_setup
FROM qp_pte_segments
WHERE segment_id IN
  (SELECT a.segment_id
   FROM   qp_segments_b a,qp_prc_contexts_b b
   WHERE a.segment_mapping_column=p_attribute
   AND   a.prc_context_id=b.prc_context_id
   AND   b.prc_context_type=p_context_type
   AND   b.prc_context_code=p_context);

Line: 819

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 957

SELECT rltd_modifier_id,
       rltd_modifier_grp_no,
       from_rltd_modifier_id,
       to_rltd_modifier_id,
       rltd_modifier_grp_type
FROM   qp_rltd_modifiers
WHERE  from_rltd_modifier_id = p_list_line_id;

Line: 974

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 1051

SELECT list_header_id,
       pricing_phase_id,
       qualifier_flag
FROM   qp_list_header_phases
WHERE  list_header_id = p_list_header_id;

Line: 1058

SELECT list_header_id
FROM   qp_list_lines
WHERE  list_line_id = p_list_line_id;

Line: 1071

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 1151

SELECT modifier_level_code,
       phase_sequence,
       pricing_phase_id,
       incompat_resolve_code,
       name,
       seeded_flag,
       freeze_override_flag,
       user_freeze_override_flag,
       user_incompat_resolve_code,
       line_group_exists,
       oid_exists,
       rltd_exists,
       freight_exists,
       manual_modifier_flag
FROM   qp_pricing_phases
ORDER  BY phase_sequence;

Line: 1177

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 1242

SELECT pricing_phase_id,
       product_attribute,
       product_attr_value
FROM   qp_adv_mod_products
WHERE  pricing_phase_id = p_pricing_phase_id;

Line: 1249

SELECT pricing_phase_id
FROM   qp_list_lines
WHERE  list_line_id = p_list_line_id;

Line: 1263

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 1322

SELECT list_header_id,
       list_line_id,
       active_flag,
       list_type_code,
       start_date_active_q,
       end_date_active_q,
       pattern_id,
       currency_code ,
       ask_for_flag,
       limit_exists,
       source_system_code,
       effective_precedence,
       grouping_no,
       pricing_phase_id,
       modifier_level_code,
       hash_key,
       cache_key
FROM   qp_attribute_groups
WHERE  list_header_id = p_list_header_id;

Line: 1343

SELECT list_header_id
FROM   qp_list_lines
WHERE  list_line_id = p_list_line_id;

Line: 1356

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 1469

SELECT pattern_id,
       segment_id,
       pattern_type,
       pattern_string
FROM   qp_patterns
WHERE  pattern_id = p_pattern_id
ORDER  BY pattern_id,segment_id;

Line: 1478

SELECT pattern_id
FROM   qp_list_lines
WHERE  list_line_id = p_list_line_id;

Line: 1483

SELECT pattern_id,list_line_id,list_header_id
FROM   qp_attribute_groups
WHERE  list_header_id IN (SELECT list_header_id FROM qp_list_lines WHERE list_line_id = p_list_line_id)
AND    list_line_id IN (p_list_line_id , -1);

Line: 1497

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 1654

SELECT pattern_id,
       pricing_phase_id
FROM   qp_pattern_phases
WHERE  pricing_phase_id = p_pricing_phase_id
AND    pattern_id = p_pattern_id;

Line: 1661

SELECT a.list_header_id,a.pattern_id,a.pricing_phase_id
FROM   qp_list_lines a , qp_pattern_phases b
WHERE  a.list_line_id = p_list_line_id
AND    a.pattern_id = b.pattern_id
AND    a.pricing_phase_id = b.pricing_phase_id;

Line: 1668

SELECT a.list_header_id,a.pattern_id,c.pricing_phase_id
FROM   qp_attribute_groups a ,
       (SELECT distinct list_header_id, pricing_phase_id
        FROM qp_list_lines WHERE list_line_id = p_list_line_id)  b ,
       qp_pattern_phases c
WHERE  a.list_header_id  = b.list_header_id
AND    a.pattern_id = c.pattern_id
AND    a.list_line_id = -1;

Line: 1678

SELECT a.list_header_id,a.pattern_id,a.pricing_phase_id
FROM   qp_attribute_groups a, qp_pattern_phases b
WHERE  a.list_line_id = p_list_line_id
AND    a.pattern_id = b.pattern_id
AND    a.pricing_phase_id = b.pricing_phase_id;

Line: 1693

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');

Line: 1878

SELECT fnd_profile.value(profile_name)
FROM   dual;

Line: 1890

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Please select a directory included in the utl_file_dir parameter for this database');