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_PS_ATTR_GRP_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 774: from qp_pricing_attributes

770: SET used_in_search = 'Y'
771: WHERE NVL(used_in_search,'N') = 'N'
772: AND segment_id in
773: (select pricing_segment_id
774: from qp_pricing_attributes
775: where /*list_line_id in (
776: select list_line_id from qp_attribute_groups where eq_flag = 'N'
777: UNION
778: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 800: from qp_pricing_attributes

796: SET used_in_search = 'Y'
797: WHERE NVL(used_in_search,'N') = 'N'
798: AND segment_id in
799: (select pricing_segment_id
800: from qp_pricing_attributes
801: where /*list_line_id in (
802: select list_line_id from qp_attribute_groups where eq_flag = 'N'
803: UNION
804: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 1034: -- qp_pricing_attributes

1030: g_pattern_upg_chunk_table(l_count).low_list_line_id,
1031: g_pattern_upg_chunk_table(l_count).high_list_line_id);
1032:
1033: -- update the product_segment_id and pricing_segment_id columns in
1034: -- qp_pricing_attributes
1035: Update_Prod_Pric_Segment_id(p_list_header_id,
1036: g_pattern_upg_chunk_table(l_count).low_list_line_id,
1037: g_pattern_upg_chunk_table(l_count).high_list_line_id);
1038:

Line 1382: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa

1378: qpl.modifier_level_code modifier_level_code,
1379: qpa.product_attribute_datatype attribute_datatype,
1380: qpa.product_attr_value attribute_value,
1381: 'PROD' attribute_type
1382: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa
1383: where qph.list_header_id = p_list_header_id
1384: AND qpl.list_header_id = qph.list_header_id
1385: and qpl.list_line_id = qpa.list_line_id
1386: and qpa.excluder_flag = 'N'

Line 1441: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa

1437: qpl.modifier_level_code modifier_level_code,
1438: qpa.pricing_attribute_datatype attribute_datatype,
1439: qpa.pricing_attr_value_from attribute_value,
1440: 'PRIC' attribute_type
1441: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa
1442: where qph.list_header_id = p_list_header_id
1443: AND qph.list_header_id = qpl.list_header_id
1444: and qpl.list_line_id = qpa.list_line_id
1445: and qpl.pricing_phase_id > 1

Line 1557: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa

1553: qpl.modifier_level_code modifier_level_code,
1554: qpa.product_attribute_datatype attribute_datatype,
1555: qpa.product_attr_value attribute_value,
1556: 'PROD' attribute_type
1557: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa
1558: where qpl.list_header_id = qph.list_header_id
1559: and qpl.list_line_id = qpa.list_line_id
1560: and qpa.excluder_flag = 'N'
1561: and qpl.pricing_phase_id > 1

Line 1615: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa

1611: qpl.modifier_level_code modifier_level_code,
1612: qpa.pricing_attribute_datatype attribute_datatype,
1613: qpa.pricing_attr_value_from attribute_value,
1614: 'PRIC' attribute_type
1615: from qp_list_headers_all_b qph, qp_list_lines qpl, qp_pricing_attributes qpa
1616: where qph.list_header_id = qpl.list_header_id
1617: and qpl.list_line_id = qpa.list_line_id
1618: and qpl.pricing_phase_id > 1
1619: and qpl.qualification_ind in (8,10,12,14,28,30)

Line 1800: qp_pricing_attributes qpa

1796:
1797: 'PROD' attribute_type
1798: from qp_list_headers_all_b qph,
1799: qp_list_lines qpl,
1800: qp_pricing_attributes qpa
1801: where qph.list_header_id = p_list_header_id
1802: AND qph.list_header_id = qpl.list_header_id
1803: AND qpl.list_line_id = qpa.list_line_id
1804: and qpa.excluder_flag = 'N'

Line 1863: qp_pricing_attributes qpa

1859:
1860: 'PRIC' attribute_type
1861: from qp_list_headers_all_b qph,
1862: qp_list_lines qpl,
1863: qp_pricing_attributes qpa
1864: where qph.list_header_id = p_list_header_id
1865: AND qpl.list_header_id = qph.list_header_id
1866: AND qpl.list_line_id = qpa.list_line_id
1867: and qpl.qualification_ind in (20,22)

Line 1981: qp_pricing_attributes qpa

1977: ---- Added for PL/SQL Pattern Search
1978: 'PROD' attribute_type
1979: from qp_list_headers_all_b qph,
1980: qp_list_lines qpl,
1981: qp_pricing_attributes qpa
1982: where qph.list_header_id = qpl.list_header_id
1983: AND qpl.list_line_id = qpa.list_line_id
1984: and qpa.excluder_flag = 'N'
1985: and qpl.qualification_ind in (4,6,20,22)

Line 2041: qp_pricing_attributes qpa

2037: ---- Added for PL/SQL Pattern Search
2038: 'PRIC' attribute_type
2039: from qp_list_headers_all_b qph,
2040: qp_list_lines qpl,
2041: qp_pricing_attributes qpa
2042: where qpl.list_header_id = qph.list_header_id
2043: AND qpl.list_line_id = qpa.list_line_id
2044: and qpl.qualification_ind in (20,22)
2045: and qpa.pricing_attribute_context is not null

Line 4546: from qp_pricing_attributes

4542: SET used_in_search = 'Y'
4543: WHERE NVL(used_in_search,'N') = 'N'
4544: AND segment_id in
4545: (select pricing_segment_id
4546: from qp_pricing_attributes
4547: where /*list_line_id in (
4548: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4549: UNION
4550: select list_line_id from qp_list_lines where eq_flag = 'N')

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

4631:
4632: -- update the segment_id columns for qualifiers
4633: Update_Qual_Segment_id(p_list_header_id, p_qualifier_group, p_list_line_id, p_list_line_id);
4634:
4635: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
4636: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id, p_list_line_id );
4637: end if;
4638:
4639: -- populate the records in qp_attribute_groups afresh for p_list_header_id, p_list_line_id

Line 4796: from qp_pricing_attributes

4792: SET used_in_search = 'Y'
4793: WHERE NVL(used_in_search,'N') = 'N'
4794: AND segment_id in
4795: (select pricing_segment_id
4796: from qp_pricing_attributes
4797: where /*list_line_id in (
4798: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4799: UNION
4800: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 4882: from qp_pricing_attributes

4878: -- update qp_list_lines.product_uom_code
4879: begin
4880: select product_uom_code
4881: into l_product_uom_code
4882: from qp_pricing_attributes
4883: where list_header_id = p_list_header_id
4884: and list_line_id = p_list_line_id
4885: and product_uom_code is not null
4886: and rownum = 1;

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

4921: end if;
4922:
4923: remove_prod_pattern_for_line(p_list_line_id);
4924:
4925: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
4926: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id,
4927: p_list_line_id);
4928:
4929: update_pp_lines(p_list_header_id, p_list_line_id, p_list_line_id);

Line 4963: from qp_pricing_attributes

4959: SET used_in_search = 'Y'
4960: WHERE NVL(used_in_search,'N') = 'N'
4961: AND segment_id in
4962: (select pricing_segment_id
4963: from qp_pricing_attributes
4964: where /*list_line_id in (
4965: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4966: UNION
4967: select list_line_id from qp_list_lines where eq_flag = 'N')

Line 5165: from qp_pricing_attributes

5161: ,p_high_list_line_id IN NUMBER)
5162: is
5163: cursor c_prod_seg_id is
5164: select distinct PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE
5165: from qp_pricing_attributes
5166: where PRODUCT_ATTRIBUTE_CONTEXT is not null
5167: and PRODUCT_ATTRIBUTE is not null
5168: and list_header_id = p_list_header_id
5169: and list_line_id between p_low_list_line_id and p_high_list_line_id;

Line 5173: from qp_pricing_attributes

5169: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5170:
5171: cursor c_prod_seg_id_hdr_null is
5172: select distinct PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE
5173: from qp_pricing_attributes
5174: where PRODUCT_ATTRIBUTE_CONTEXT is not null
5175: and PRODUCT_ATTRIBUTE is not null
5176: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5177: cursor c_pric_seg_id is

Line 5179: from qp_pricing_attributes

5175: and PRODUCT_ATTRIBUTE is not null
5176: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5177: cursor c_pric_seg_id is
5178: select distinct PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE
5179: from qp_pricing_attributes
5180: where PRICING_ATTRIBUTE_CONTEXT is not null
5181: and PRICING_ATTRIBUTE is not null
5182: and list_header_id = p_list_header_id
5183: and list_line_id between p_low_list_line_id and p_high_list_line_id;

Line 5186: from qp_pricing_attributes

5182: and list_header_id = p_list_header_id
5183: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5184: cursor c_pric_seg_id_hdr_null is
5185: select distinct PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE
5186: from qp_pricing_attributes
5187: where PRICING_ATTRIBUTE_CONTEXT is not null
5188: and PRICING_ATTRIBUTE is not null
5189: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5190:

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

5187: where PRICING_ATTRIBUTE_CONTEXT is not null
5188: and PRICING_ATTRIBUTE is not null
5189: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5190:
5191: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
5192: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
5193: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
5194:
5195: segment_id_t segment_id_tab;

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

5188: and PRICING_ATTRIBUTE is not null
5189: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5190:
5191: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
5192: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
5193: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
5194:
5195: segment_id_t segment_id_tab;
5196: context_t context_tab;

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

5189: and list_line_id between p_low_list_line_id and p_high_list_line_id;
5190:
5191: TYPE segment_id_tab IS TABLE OF qp_pricing_attributes.product_segment_id%TYPE INDEX BY BINARY_INTEGER;
5192: TYPE context_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE_CONTEXT%TYPE INDEX BY BINARY_INTEGER;
5193: TYPE attribute_tab IS TABLE OF qp_pricing_attributes.PRODUCT_ATTRIBUTE%TYPE INDEX BY BINARY_INTEGER;
5194:
5195: segment_id_t segment_id_tab;
5196: context_t context_tab;
5197: attribute_t attribute_tab;

Line 5208: -- update the product_segment_id column in qp_pricing_attributes

5204: else
5205: write_log( 'Inside Update_Prod_Pric_Segment_id');
5206: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5207: end if;
5208: -- update the product_segment_id column in qp_pricing_attributes
5209: segment_id_t.delete;
5210: context_t.delete;
5211: attribute_t.delete;
5212:

Line 5244: update qp_pricing_attributes

5240: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
5241: END LOOP;
5242:
5243: FORALL j in 1..context_t.count
5244: update qp_pricing_attributes
5245: set product_segment_id = segment_id_t(j)
5246: where PRODUCT_ATTRIBUTE_CONTEXT = context_t(j)
5247: and PRODUCT_ATTRIBUTE = attribute_t(j)
5248: and list_header_id = nvl(p_list_header_id, list_header_id)

Line 5260: -- update the pricing_segment_id columns in qp_pricing_attributes

5256: write_log( 'End time product segments :'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SSSS'));
5257: end if;
5258: end if; -- context_t.count > 0
5259:
5260: -- update the pricing_segment_id columns in qp_pricing_attributes
5261: segment_id_t.delete;
5262: context_t.delete;
5263: attribute_t.delete;
5264:

Line 5297: update qp_pricing_attributes

5293: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
5294: END LOOP;
5295:
5296: FORALL j in 1..context_t.count
5297: update qp_pricing_attributes
5298: set pricing_segment_id = segment_id_t(j)
5299: where PRICING_ATTRIBUTE_CONTEXT = context_t(j)
5300: and PRICING_ATTRIBUTE = attribute_t(j)
5301: and list_header_id = nvl(p_list_header_id, list_header_id)