eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_ATTR_GRP_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 382: -- qp_pricing_attributes

378: p_low_list_line_id,
379: p_high_list_line_id);
380:
381: -- update the product_segment_id and pricing_segment_id columns in
382: -- qp_pricing_attributes
383: Update_Prod_Pric_Segment_id(p_list_header_id,
384: p_low_list_line_id,
385: p_high_list_line_id);
386:

Line 569: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph

565: qpl.modifier_level_code modifier_level_code,
566: qpa.product_attribute_datatype attribute_datatype,
567: qpa.product_attr_value attribute_value,
568: 'PROD' attribute_type
569: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph
570: where qph.list_header_id = qpl.list_header_id
571: and qpl.list_line_id = qpa.list_line_id
572: and qpa.excluder_flag = 'N'
573: and qpl.pricing_phase_id > 1

Line 600: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph

596: qpl.modifier_level_code modifier_level_code,
597: qpa.pricing_attribute_datatype attribute_datatype,
598: qpa.pricing_attr_value_from attribute_value,
599: 'PRIC' attribute_type
600: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph
601: where qph.list_header_id = qpl.list_header_id
602: and qpl.list_line_id = qpa.list_line_id
603: and qpl.pricing_phase_id > 1
604: and qpl.qualification_ind in (8,10,12,14,28,30)

Line 671: qp_pricing_attributes qpa

667: qpa.product_attribute_datatype attribute_datatype,
668: qpa.product_attr_value attribute_value,
669: 'PROD' attribute_type
670: from qp_list_lines qpl,
671: qp_pricing_attributes qpa
672: where qpl.list_line_id = qpa.list_line_id
673: and qpa.excluder_flag = 'N'
674: and qpl.qualification_ind in (4,6,20,22)
675: and qpa.product_attribute_context is not null

Line 691: qp_pricing_attributes qpa

687: qpa.pricing_attribute_datatype attribute_datatype,
688: qpa.pricing_attr_value_from attribute_value,
689: 'PRIC' attribute_type
690: from qp_list_lines qpl,
691: qp_pricing_attributes qpa
692: where qpl.list_line_id = qpa.list_line_id
693: and qpl.qualification_ind in (20,22)
694: and qpa.pricing_attribute_context is not null
695: and qpl.list_line_id between p_low_list_line_id and p_high_list_line_id

Line 2272: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes

2268:
2269: -- update the segment_id columns for qualifiers
2270: Update_Qual_Segment_id(p_list_header_id, p_qualifier_group, p_list_line_id, p_list_line_id);
2271:
2272: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
2273: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id, p_list_line_id );
2274: end if;
2275:
2276: -- populate the records in qp_attribute_groups afresh for p_list_header_id, p_list_line_id

Line 2465: from qp_pricing_attributes

2461: -- update qp_list_lines.product_uom_code
2462: begin
2463: select product_uom_code
2464: into l_product_uom_code
2465: from qp_pricing_attributes
2466: where list_header_id = p_list_header_id
2467: and list_line_id = p_list_line_id
2468: and product_uom_code is not null
2469: and rownum = 1;

Line 2508: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes

2504: end if;
2505:
2506: remove_prod_pattern_for_line(p_list_line_id);
2507:
2508: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
2509: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id,
2510: p_list_line_id);
2511:
2512: update_pp_lines(p_list_header_id, p_list_line_id, p_list_line_id);

Line 2659: from qp_pricing_attributes

2655: ,p_high_list_line_id IN NUMBER)
2656: is
2657: cursor c_prod_seg_id is
2658: select distinct PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE
2659: from qp_pricing_attributes
2660: where PRODUCT_ATTRIBUTE_CONTEXT is not null
2661: and PRODUCT_ATTRIBUTE is not null
2662: --and list_header_id = nvl(p_list_header_id, list_header_id)
2663: and list_line_id between p_low_list_line_id and p_high_list_line_id;

Line 2667: from qp_pricing_attributes

2663: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2664:
2665: cursor c_pric_seg_id is
2666: select distinct PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE
2667: from qp_pricing_attributes
2668: where PRICING_ATTRIBUTE_CONTEXT is not null
2669: and PRICING_ATTRIBUTE is not null
2670: --and list_header_id = nvl(p_list_header_id, list_header_id)
2671: and list_line_id between p_low_list_line_id and p_high_list_line_id;

Line 2673: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;

2669: and PRICING_ATTRIBUTE is not null
2670: --and list_header_id = nvl(p_list_header_id, list_header_id)
2671: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2672:
2673: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
2674: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2675: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2676:
2677: segment_id_t segment_id_tab;

Line 2674: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;

2670: --and list_header_id = nvl(p_list_header_id, list_header_id)
2671: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2672:
2673: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
2674: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2675: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2676:
2677: segment_id_t segment_id_tab;
2678: context_t context_tab;

Line 2675: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;

2671: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2672:
2673: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
2674: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2675: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2676:
2677: segment_id_t segment_id_tab;
2678: context_t context_tab;
2679: attribute_t attribute_tab;

Line 2690: -- update the product_segment_id column in qp_pricing_attributes

2686: else
2687: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2688: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2689: end if;
2690: -- update the product_segment_id column in qp_pricing_attributes
2691: segment_id_t.delete;
2692: context_t.delete;
2693: attribute_t.delete;
2694:

Line 2718: update qp_pricing_attributes

2714: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2715: END LOOP;
2716:
2717: FORALL j in 1..context_t.count
2718: update qp_pricing_attributes
2719: set product_segment_id = segment_id_t(j)
2720: where PRODUCT_ATTRIBUTE_CONTEXT = context_t(j)
2721: and PRODUCT_ATTRIBUTE = attribute_t(j)
2722: --and list_header_id = nvl(p_list_header_id, list_header_id)

Line 2734: -- update the pricing_segment_id columns in qp_pricing_attributes

2730: fnd_file.put_line(FND_FILE.LOG, 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2731: end if;
2732: end if; -- context_t.count > 0
2733:
2734: -- update the pricing_segment_id columns in qp_pricing_attributes
2735: segment_id_t.delete;
2736: context_t.delete;
2737: attribute_t.delete;
2738:

Line 2763: update qp_pricing_attributes

2759: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2760: END LOOP;
2761:
2762: FORALL j in 1..context_t.count
2763: update qp_pricing_attributes
2764: set pricing_segment_id = segment_id_t(j)
2765: where PRICING_ATTRIBUTE_CONTEXT = context_t(j)
2766: and PRICING_ATTRIBUTE = attribute_t(j)
2767: --and list_header_id = nvl(p_list_header_id, list_header_id)