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 376: -- qp_pricing_attributes

372: p_low_list_line_id,
373: p_high_list_line_id);
374:
375: -- update the product_segment_id and pricing_segment_id columns in
376: -- qp_pricing_attributes
377: Update_Prod_Pric_Segment_id(p_list_header_id,
378: p_low_list_line_id,
379: p_high_list_line_id);
380:

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

559: qpl.modifier_level_code modifier_level_code,
560: qpa.product_attribute_datatype attribute_datatype,
561: qpa.product_attr_value attribute_value,
562: 'PROD' attribute_type
563: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph
564: where qph.list_header_id = qpl.list_header_id
565: and qpl.list_line_id = qpa.list_line_id
566: and qpa.excluder_flag = 'N'
567: and qpl.pricing_phase_id > 1

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

590: qpl.modifier_level_code modifier_level_code,
591: qpa.pricing_attribute_datatype attribute_datatype,
592: qpa.pricing_attr_value_from attribute_value,
593: 'PRIC' attribute_type
594: from qp_list_lines qpl, qp_pricing_attributes qpa, qp_list_headers_b qph
595: where qph.list_header_id = qpl.list_header_id
596: and qpl.list_line_id = qpa.list_line_id
597: and qpl.pricing_phase_id > 1
598: and qpl.qualification_ind in (8,10,12,14,28,30)

Line 665: qp_pricing_attributes qpa

661: qpa.product_attribute_datatype attribute_datatype,
662: qpa.product_attr_value attribute_value,
663: 'PROD' attribute_type
664: from qp_list_lines qpl,
665: qp_pricing_attributes qpa
666: where qpl.list_line_id = qpa.list_line_id
667: and qpa.excluder_flag = 'N'
668: and qpl.qualification_ind in (4,6,20,22)
669: and qpa.product_attribute_context is not null

Line 685: qp_pricing_attributes qpa

681: qpa.pricing_attribute_datatype attribute_datatype,
682: qpa.pricing_attr_value_from attribute_value,
683: 'PRIC' attribute_type
684: from qp_list_lines qpl,
685: qp_pricing_attributes qpa
686: where qpl.list_line_id = qpa.list_line_id
687: and qpl.qualification_ind in (20,22)
688: and qpa.pricing_attribute_context is not null
689: and qpl.list_line_id between p_low_list_line_id and p_high_list_line_id

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

2262:
2263: -- update the segment_id columns for qualifiers
2264: Update_Qual_Segment_id(p_list_header_id, p_qualifier_group, p_list_line_id, p_list_line_id);
2265:
2266: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
2267: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id, p_list_line_id );
2268: end if;
2269:
2270: -- populate the records in qp_attribute_groups afresh for p_list_header_id, p_list_line_id

Line 2459: from qp_pricing_attributes

2455: -- update qp_list_lines.product_uom_code
2456: begin
2457: select product_uom_code
2458: into l_product_uom_code
2459: from qp_pricing_attributes
2460: where list_header_id = p_list_header_id
2461: and list_line_id = p_list_line_id
2462: and product_uom_code is not null
2463: and rownum = 1;

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

2498: end if;
2499:
2500: remove_prod_pattern_for_line(p_list_line_id);
2501:
2502: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
2503: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id,
2504: p_list_line_id);
2505:
2506: update_pp_lines(p_list_header_id, p_list_line_id, p_list_line_id);

Line 2653: from qp_pricing_attributes

2649: ,p_high_list_line_id IN NUMBER)
2650: is
2651: cursor c_prod_seg_id is
2652: select distinct PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE
2653: from qp_pricing_attributes
2654: where PRODUCT_ATTRIBUTE_CONTEXT is not null
2655: and PRODUCT_ATTRIBUTE is not null
2656: --and list_header_id = nvl(p_list_header_id, list_header_id)
2657: and list_line_id between p_low_list_line_id and p_high_list_line_id;

Line 2661: from qp_pricing_attributes

2657: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2658:
2659: cursor c_pric_seg_id is
2660: select distinct PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE
2661: from qp_pricing_attributes
2662: where PRICING_ATTRIBUTE_CONTEXT is not null
2663: and PRICING_ATTRIBUTE is not null
2664: --and list_header_id = nvl(p_list_header_id, list_header_id)
2665: and list_line_id between p_low_list_line_id and p_high_list_line_id;

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

2663: and PRICING_ATTRIBUTE is not null
2664: --and list_header_id = nvl(p_list_header_id, list_header_id)
2665: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2666:
2667: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
2668: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2669: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2670:
2671: segment_id_t segment_id_tab;

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

2664: --and list_header_id = nvl(p_list_header_id, list_header_id)
2665: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2666:
2667: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
2668: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2669: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2670:
2671: segment_id_t segment_id_tab;
2672: context_t context_tab;

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

2665: and list_line_id between p_low_list_line_id and p_high_list_line_id;
2666:
2667: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
2668: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
2669: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
2670:
2671: segment_id_t segment_id_tab;
2672: context_t context_tab;
2673: attribute_t attribute_tab;

Line 2684: -- update the product_segment_id column in qp_pricing_attributes

2680: else
2681: fnd_file.put_line(FND_FILE.LOG, 'Inside Update_Prod_Pric_Segment_id');
2682: fnd_file.put_line(FND_FILE.LOG, 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2683: end if;
2684: -- update the product_segment_id column in qp_pricing_attributes
2685: segment_id_t.delete;
2686: context_t.delete;
2687: attribute_t.delete;
2688:

Line 2712: update qp_pricing_attributes

2708: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2709: END LOOP;
2710:
2711: FORALL j in 1..context_t.count
2712: update qp_pricing_attributes
2713: set product_segment_id = segment_id_t(j)
2714: where PRODUCT_ATTRIBUTE_CONTEXT = context_t(j)
2715: and PRODUCT_ATTRIBUTE = attribute_t(j)
2716: --and list_header_id = nvl(p_list_header_id, list_header_id)

Line 2728: -- update the pricing_segment_id columns in qp_pricing_attributes

2724: fnd_file.put_line(FND_FILE.LOG, 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
2725: end if;
2726: end if; -- context_t.count > 0
2727:
2728: -- update the pricing_segment_id columns in qp_pricing_attributes
2729: segment_id_t.delete;
2730: context_t.delete;
2731: attribute_t.delete;
2732:

Line 2757: update qp_pricing_attributes

2753: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2754: END LOOP;
2755:
2756: FORALL j in 1..context_t.count
2757: update qp_pricing_attributes
2758: set pricing_segment_id = segment_id_t(j)
2759: where PRICING_ATTRIBUTE_CONTEXT = context_t(j)
2760: and PRICING_ATTRIBUTE = attribute_t(j)
2761: --and list_header_id = nvl(p_list_header_id, list_header_id)