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

Line 153: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c

149: update qp_pte_segments set used_in_setup='Y'
150: where nvl(used_in_setup,'N')='N'
151: and segment_id in
152: (select a.segment_id
153: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c
154: where c.list_header_id = p_list_header_id
155: and a.segment_mapping_column = c.pricing_attribute
156: and a.prc_context_id = b.prc_context_id
157: and b.prc_context_type = 'PRICING_ATTRIBUTE'

Line 164: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c

160: update qp_pte_segments set used_in_setup='Y'
161: where nvl(used_in_setup,'N')='N'
162: and segment_id in
163: (select a.segment_id
164: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c
165: where c.list_header_id = p_list_header_id
166: and a.segment_mapping_column = c.product_attribute
167: and a.prc_context_id = b.prc_context_id
168: and b.prc_context_type = 'PRODUCT'

Line 639: FROM QP_RLTD_MODIFIERS QRMA, QP_PRICING_ATTRIBUTES QPBVA

635: Cursor C_break_lines(p_list_line_id number) IS
636: --Begin Bug No: 7321885
637: SELECT PRICING_ATTR_VALUE_FROM_NUMBER,
638: PRICING_ATTR_VALUE_TO_NUMBER
639: FROM QP_RLTD_MODIFIERS QRMA, QP_PRICING_ATTRIBUTES QPBVA
640: WHERE QRMA.FROM_RLTD_MODIFIER_ID = p_list_line_id AND
641: QRMA.TO_RLTD_MODIFIER_ID = QPBVA.LIST_LINE_ID
642: AND QRMA.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'
643: AND QPBVA.PRICING_ATTRIBUTE_DATATYPE = 'N'

Line 743: from qp_list_lines ql, qp_pricing_attributes qpa,qp_rltd_modifiers qrm

739:
740: Cursor c_break_lines_attr_values(p_list_line_id number) IS
741: SELECT qpa.PRICING_ATTR_VALUE_FROM,
742: qpa.PRICING_ATTR_VALUE_TO
743: from qp_list_lines ql, qp_pricing_attributes qpa,qp_rltd_modifiers qrm
744: WHERE ql.list_line_id = qpa.list_line_id
745: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
746: and qrm.to_rltd_modifier_id = ql.list_line_id
747: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'

Line 861: from qp_list_lines ql,qp_pricing_attributes qpa,qp_rltd_modifiers qrm

857: SELECT qpa.PRICING_ATTR_VALUE_FROM_NUMBER,
858: qpa.PRICING_ATTR_VALUE_FROM,
859: qpa.PRICING_ATTR_VALUE_TO_NUMBER,
860: qpa.PRICING_ATTR_VALUE_TO
861: from qp_list_lines ql,qp_pricing_attributes qpa,qp_rltd_modifiers qrm
862: WHERE ql.list_line_id = qpa.list_line_id
863: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
864: and qrm.to_rltd_modifier_id = ql.list_line_id
865: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'

Line 922: UPDATE qp_pricing_attributes SET

918: ||'|'||rpad(lpad(c_break_lines_attr_val_rec.pricing_attr_value_to,20,' '),25,' ')
919: );
920:
921: BEGIN
922: UPDATE qp_pricing_attributes SET
923: PRICING_ATTR_VALUE_FROM = l_prc_attr_val_from,
924: PRICING_ATTR_VALUE_FROM_NUMBER = l_prc_attr_val_from_number
925: WHERE CURRENT OF c_break_lines_attr_values;
926: EXCEPTION

Line 1380: from qp_pricing_attributes qpprod

1376: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 4
1377: where qpl.list_header_id=p_list_header_id
1378: and exists (
1379: select /*+ no_unnest */ 'X' --5612361
1380: from qp_pricing_attributes qpprod
1381: where qpprod.list_line_id = qpl.list_line_id
1382: and qpprod.excluder_flag = 'N');
1383:
1384: -- If Pricing Attributes exist

Line 1390: from qp_pricing_attributes qpprod

1386: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 16
1387: where qpl.list_header_id=p_list_header_id
1388: and exists (
1389: select 'X'
1390: from qp_pricing_attributes qpprod
1391: where qpprod.list_line_id = qpl.list_line_id
1392: and qpprod.list_header_id = p_list_header_id --bug#4261111
1393: and qpprod.pricing_attribute_context is not null
1394: and qpprod.pricing_attribute is not null

Line 1401: update qp_pricing_attributes

1397: /*5612361
1398: for list_lines_rec IN list_lines_cur(p_list_header_id)
1399: loop
1400:
1401: update qp_pricing_attributes
1402: set qualification_ind = list_lines_rec.qualification_ind
1403: where list_line_id = list_lines_rec.list_line_id;
1404:
1405: end loop;

Line 1410: UPDATE QP_PRICING_ATTRIBUTES A

1406: */
1407:
1408: --5612361
1409:
1410: UPDATE QP_PRICING_ATTRIBUTES A
1411: SET QUALIFICATION_IND = (SELECT QUALIFICATION_IND
1412: FROM QP_LIST_LINES
1413: where A.LIST_LINE_ID = LIST_LINE_ID
1414: and LIST_HEADER_ID = p_list_header_id)

Line 1662: from qp_pricing_attributes qpprod

1658: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 4
1659: where qpl.list_line_id=p_list_line_id
1660: and exists (
1661: select 'X'
1662: from qp_pricing_attributes qpprod
1663: where qpprod.list_line_id = p_list_line_id
1664: and qpprod.excluder_flag = 'N')
1665: returning qpl.qualification_ind into l_qualification_ind;
1666:

Line 1673: from qp_pricing_attributes qpprod

1669: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 16
1670: where qpl.list_line_id=p_list_line_id
1671: and exists (
1672: select 'X'
1673: from qp_pricing_attributes qpprod
1674: where qpprod.list_line_id = p_list_line_id
1675: and qpprod.pricing_attribute_context is not null
1676: and qpprod.pricing_attribute is not null
1677: -- changes made per rchellam's request --spgopal

Line 1681: update qp_pricing_attributes pra

1677: -- changes made per rchellam's request --spgopal
1678: and qpprod.pricing_attr_value_from is not null)
1679: returning qpl.qualification_ind into l_qualification_ind;
1680:
1681: update qp_pricing_attributes pra
1682: set pra.qualification_ind = l_qualification_ind
1683: where pra.list_line_id = p_list_line_id;
1684:
1685: EXCEPTION

Line 1846: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;

1842:
1843: l_status NUMBER;
1844: l_list_line_id NUMBER;
1845: l_list_line_type_code VARCHAR2(30);
1846: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;
1847:
1848: Cursor C_pbh_product_details IS
1849: SELECT product_attribute_context,
1850: product_attribute,

Line 1853: FROM QP_PRICING_ATTRIBUTES

1849: SELECT product_attribute_context,
1850: product_attribute,
1851: product_attr_value,
1852: product_uom_code
1853: FROM QP_PRICING_ATTRIBUTES
1854: WHERE list_line_id = p_list_line_id;
1855:
1856:
1857:

Line 1874: UPDATE qp_Pricing_Attributes SET

1870:
1871: FOR i in C_pbh_product_details
1872: LOOP
1873:
1874: UPDATE qp_Pricing_Attributes SET
1875: Product_attribute_context = i.Product_attribute_context
1876: ,Product_attribute = i.Product_attribute
1877: ,Product_attr_value = i.Product_attr_value
1878: ,Product_uom_code = i.Product_Uom_Code

Line 1935: from qp_pricing_attributes

1931:
1932: -- open c_Pricing_Attr(p_list_line_id); LOOP
1933:
1934: for C_Pricing_Attr in (select pricing_attribute_id
1935: from qp_pricing_attributes
1936: where list_line_id = p_list_line_id) LOOP
1937:
1938:
1939: Update QP_PRICING_ATTRIBUTES Set

Line 1939: Update QP_PRICING_ATTRIBUTES Set

1935: from qp_pricing_attributes
1936: where list_line_id = p_list_line_id) LOOP
1937:
1938:
1939: Update QP_PRICING_ATTRIBUTES Set
1940: LIST_HEADER_ID = l_List_Header_ID,
1941: PRICING_PHASE_ID = l_Pricing_Phase_ID
1942: where PRICING_ATTRIBUTE_ID = C_Pricing_Attr.Pricing_Attribute_ID;
1943:

Line 2493: from qp_pricing_attributes qpa

2489: pricing_phase_id) (
2490: select distinct qpa.product_attribute,
2491: qpa.product_attr_value,
2492: p_pricing_phase_id
2493: from qp_pricing_attributes qpa
2494: where qpa.list_line_id = p_list_line_id
2495: and not exists (
2496: select 'Y' from qp_adv_mod_products
2497: where pricing_phase_id = p_pricing_phase_id

Line 2612: from qp_pricing_attributes qpa

2608: pricing_phase_id) (
2609: select distinct qpa.product_attribute,
2610: qpa.product_attr_value,
2611: p_pricing_phase_id
2612: from qp_pricing_attributes qpa
2613: where qpa.list_line_id = p_list_line_id
2614: and not exists (
2615: select 'Y' from qp_adv_mod_products
2616: where pricing_phase_id = p_pricing_phase_id

Line 2627: from qp_pricing_attributes

2623: p_pricing_phase_id
2624: into l_product_attribute,
2625: l_product_attr_value,
2626: l_pricing_phase_id
2627: from qp_pricing_attributes
2628: where list_line_id = p_list_line_id;
2629:
2630: --tuned SQl to avoid cartesian join
2631: delete from qp_adv_mod_products

Line 2637: from qp_pricing_attributes qpa,

2633: and product_attribute = l_product_attribute
2634: and product_attr_value = l_product_attr_value
2635: and not exists (
2636: select 'Y'
2637: from qp_pricing_attributes qpa,
2638: qp_list_lines qpl,
2639: qp_list_headers_b qph
2640: where qpa.pricing_phase_id = p_old_pricing_phase_id
2641: and qpa.product_attribute = l_product_attribute

Line 2652: qp_pricing_attributes qpa,

2648: union
2649: select 'Y'
2650: from qp_rltd_modifiers qpr,
2651: qp_list_lines qpl,
2652: qp_pricing_attributes qpa,
2653: qp_list_headers_b qph
2654: where qpa.pricing_phase_id = p_old_pricing_phase_id
2655: and qpa.product_attribute = l_product_attribute
2656: and qpa.product_attr_value = l_product_attr_value

Line 2667: qp_pricing_attributes qpa,

2663: and rownum = 1
2664: union
2665: select 'Y'
2666: from qp_list_lines qpl,
2667: qp_pricing_attributes qpa,
2668: qp_list_headers_b qph
2669: where qpa.pricing_phase_id = p_old_pricing_phase_id
2670: and qpa.product_attribute = l_product_attribute
2671: and qpa.product_attr_value = l_product_attr_value

Line 2701: qp_pricing_attributes qpa

2697: qpl.pricing_phase_id,
2698: qpa.product_attribute,
2699: qpa.product_attr_value
2700: from qp_list_lines qpl,
2701: qp_pricing_attributes qpa
2702: where qpl.list_header_id = p_list_header_id
2703: and qpa.list_line_id = qpl.list_line_id;
2704:
2705: begin

Line 2751: from qp_pricing_attributes qpa,

2747: and product_attribute = line_cursor.product_attribute
2748: and product_attr_value = line_cursor.product_attr_value
2749: and not exists (
2750: select 'Y'
2751: from qp_pricing_attributes qpa,
2752: qp_list_lines qpl,
2753: qp_list_headers_b qph
2754: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2755: and qpa.product_attribute = line_cursor.product_attribute

Line 2766: qp_pricing_attributes qpa,

2762: union
2763: select 'Y'
2764: from qp_rltd_modifiers qpr,
2765: qp_list_lines qpl,
2766: qp_pricing_attributes qpa,
2767: qp_list_headers_b qph
2768: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2769: and qpa.product_attribute = line_cursor.product_attribute
2770: and qpa.product_attr_value = line_cursor.product_attr_value

Line 2781: qp_pricing_attributes qpa,

2777: and rownum = 1
2778: union
2779: select 'Y'
2780: from qp_list_lines qpl,
2781: qp_pricing_attributes qpa,
2782: qp_list_headers_b qph
2783: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2784: and qpa.product_attribute = line_cursor.product_attribute
2785: and qpa.product_attr_value = line_cursor.product_attr_value