APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_PRICING_ATTRIBUTES

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

157: update qp_pte_segments set used_in_setup='Y'
158: where nvl(used_in_setup,'N')='N'
159: and segment_id in
160: (select a.segment_id
161: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c
162: where c.list_header_id = p_list_header_id
163: and a.segment_mapping_column = c.pricing_attribute
164: and a.prc_context_id = b.prc_context_id
165: and b.prc_context_type = 'PRICING_ATTRIBUTE'

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

168: update qp_pte_segments set used_in_setup='Y'
169: where nvl(used_in_setup,'N')='N'
170: and segment_id in
171: (select a.segment_id
172: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c
173: where c.list_header_id = p_list_header_id
174: and a.segment_mapping_column = c.product_attribute
175: and a.prc_context_id = b.prc_context_id
176: and b.prc_context_type = 'PRODUCT'

Line 647: FROM QP_RLTD_MODIFIERS QRMA, QP_PRICING_ATTRIBUTES QPBVA

643: Cursor C_break_lines(p_list_line_id number) IS
644: --Begin Bug No: 7321885
645: SELECT PRICING_ATTR_VALUE_FROM_NUMBER,
646: PRICING_ATTR_VALUE_TO_NUMBER
647: FROM QP_RLTD_MODIFIERS QRMA, QP_PRICING_ATTRIBUTES QPBVA
648: WHERE QRMA.FROM_RLTD_MODIFIER_ID = p_list_line_id AND
649: QRMA.TO_RLTD_MODIFIER_ID = QPBVA.LIST_LINE_ID
650: AND QRMA.RLTD_MODIFIER_GRP_TYPE = 'PRICE BREAK'
651: AND QPBVA.PRICING_ATTRIBUTE_DATATYPE = 'N'

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

747:
748: Cursor c_break_lines_attr_values(p_list_line_id number) IS
749: SELECT qpa.PRICING_ATTR_VALUE_FROM,
750: qpa.PRICING_ATTR_VALUE_TO
751: from qp_list_lines ql, qp_pricing_attributes qpa,qp_rltd_modifiers qrm
752: WHERE ql.list_line_id = qpa.list_line_id
753: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
754: and qrm.to_rltd_modifier_id = ql.list_line_id
755: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'

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

865: SELECT qpa.PRICING_ATTR_VALUE_FROM_NUMBER,
866: qpa.PRICING_ATTR_VALUE_FROM,
867: qpa.PRICING_ATTR_VALUE_TO_NUMBER,
868: qpa.PRICING_ATTR_VALUE_TO
869: from qp_list_lines ql,qp_pricing_attributes qpa,qp_rltd_modifiers qrm
870: WHERE ql.list_line_id = qpa.list_line_id
871: and ql.list_line_type_code IN ('SUR', 'DIS', 'PLL')
872: and qrm.to_rltd_modifier_id = ql.list_line_id
873: and qrm.rltd_modifier_grp_type = 'PRICE BREAK'

Line 930: UPDATE qp_pricing_attributes SET

926: ||'|'||rpad(lpad(c_break_lines_attr_val_rec.pricing_attr_value_to,20,' '),25,' ')
927: );
928:
929: BEGIN
930: UPDATE qp_pricing_attributes SET
931: PRICING_ATTR_VALUE_FROM = l_prc_attr_val_from,
932: PRICING_ATTR_VALUE_FROM_NUMBER = l_prc_attr_val_from_number
933: WHERE CURRENT OF c_break_lines_attr_values;
934: EXCEPTION

Line 1388: from qp_pricing_attributes qpprod

1384: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 4
1385: where qpl.list_header_id=p_list_header_id
1386: and exists (
1387: select /*+ no_unnest */ 'X' --5612361
1388: from qp_pricing_attributes qpprod
1389: where qpprod.list_line_id = qpl.list_line_id
1390: and qpprod.excluder_flag = 'N');
1391:
1392: -- If Pricing Attributes exist

Line 1398: from qp_pricing_attributes qpprod

1394: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 16
1395: where qpl.list_header_id=p_list_header_id
1396: and exists (
1397: select 'X'
1398: from qp_pricing_attributes qpprod
1399: where qpprod.list_line_id = qpl.list_line_id
1400: and qpprod.list_header_id = p_list_header_id --bug#4261111
1401: and qpprod.pricing_attribute_context is not null
1402: and qpprod.pricing_attribute is not null

Line 1409: update qp_pricing_attributes

1405: /*5612361
1406: for list_lines_rec IN list_lines_cur(p_list_header_id)
1407: loop
1408:
1409: update qp_pricing_attributes
1410: set qualification_ind = list_lines_rec.qualification_ind
1411: where list_line_id = list_lines_rec.list_line_id;
1412:
1413: end loop;

Line 1418: UPDATE QP_PRICING_ATTRIBUTES A

1414: */
1415:
1416: --5612361
1417:
1418: UPDATE QP_PRICING_ATTRIBUTES A
1419: SET QUALIFICATION_IND = (SELECT QUALIFICATION_IND
1420: FROM QP_LIST_LINES
1421: where A.LIST_LINE_ID = LIST_LINE_ID
1422: and LIST_HEADER_ID = p_list_header_id)

Line 1670: from qp_pricing_attributes qpprod

1666: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 4
1667: where qpl.list_line_id=p_list_line_id
1668: and exists (
1669: select 'X'
1670: from qp_pricing_attributes qpprod
1671: where qpprod.list_line_id = p_list_line_id
1672: and qpprod.excluder_flag = 'N')
1673: returning qpl.qualification_ind into l_qualification_ind;
1674:

Line 1681: from qp_pricing_attributes qpprod

1677: set qpl.qualification_ind= nvl(qpl.qualification_ind, 0) + 16
1678: where qpl.list_line_id=p_list_line_id
1679: and exists (
1680: select 'X'
1681: from qp_pricing_attributes qpprod
1682: where qpprod.list_line_id = p_list_line_id
1683: and qpprod.pricing_attribute_context is not null
1684: and qpprod.pricing_attribute is not null
1685: -- changes made per rchellam's request --spgopal

Line 1689: update qp_pricing_attributes pra

1685: -- changes made per rchellam's request --spgopal
1686: and qpprod.pricing_attr_value_from is not null)
1687: returning qpl.qualification_ind into l_qualification_ind;
1688:
1689: update qp_pricing_attributes pra
1690: set pra.qualification_ind = l_qualification_ind
1691: where pra.list_line_id = p_list_line_id;
1692:
1693: EXCEPTION

Line 1854: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;

1850:
1851: l_status NUMBER;
1852: l_list_line_id NUMBER;
1853: l_list_line_type_code VARCHAR2(30);
1854: l_Pricing_Attr_rec QP_PRICING_ATTRIBUTES%rowtype;
1855:
1856: Cursor C_pbh_product_details IS
1857: SELECT product_attribute_context,
1858: product_attribute,

Line 1861: FROM QP_PRICING_ATTRIBUTES

1857: SELECT product_attribute_context,
1858: product_attribute,
1859: product_attr_value,
1860: product_uom_code
1861: FROM QP_PRICING_ATTRIBUTES
1862: WHERE list_line_id = p_list_line_id;
1863:
1864:
1865:

Line 1882: UPDATE qp_Pricing_Attributes SET

1878:
1879: FOR i in C_pbh_product_details
1880: LOOP
1881:
1882: UPDATE qp_Pricing_Attributes SET
1883: Product_attribute_context = i.Product_attribute_context
1884: ,Product_attribute = i.Product_attribute
1885: ,Product_attr_value = i.Product_attr_value
1886: ,Product_uom_code = i.Product_Uom_Code

Line 1943: from qp_pricing_attributes

1939:
1940: -- open c_Pricing_Attr(p_list_line_id); LOOP
1941:
1942: for C_Pricing_Attr in (select pricing_attribute_id
1943: from qp_pricing_attributes
1944: where list_line_id = p_list_line_id) LOOP
1945:
1946:
1947: Update QP_PRICING_ATTRIBUTES Set

Line 1947: Update QP_PRICING_ATTRIBUTES Set

1943: from qp_pricing_attributes
1944: where list_line_id = p_list_line_id) LOOP
1945:
1946:
1947: Update QP_PRICING_ATTRIBUTES Set
1948: LIST_HEADER_ID = l_List_Header_ID,
1949: PRICING_PHASE_ID = l_Pricing_Phase_ID
1950: where PRICING_ATTRIBUTE_ID = C_Pricing_Attr.Pricing_Attribute_ID;
1951:

Line 2504: from qp_pricing_attributes qpa

2500: pricing_phase_id) (
2501: select distinct qpa.product_attribute,
2502: qpa.product_attr_value,
2503: p_pricing_phase_id
2504: from qp_pricing_attributes qpa
2505: where qpa.list_line_id = p_list_line_id
2506: and not exists (
2507: select 'Y' from qp_adv_mod_products
2508: where pricing_phase_id = p_pricing_phase_id

Line 2623: from qp_pricing_attributes qpa

2619: pricing_phase_id) (
2620: select distinct qpa.product_attribute,
2621: qpa.product_attr_value,
2622: p_pricing_phase_id
2623: from qp_pricing_attributes qpa
2624: where qpa.list_line_id = p_list_line_id
2625: and not exists (
2626: select 'Y' from qp_adv_mod_products
2627: where pricing_phase_id = p_pricing_phase_id

Line 2638: from qp_pricing_attributes

2634: p_pricing_phase_id
2635: into l_product_attribute,
2636: l_product_attr_value,
2637: l_pricing_phase_id
2638: from qp_pricing_attributes
2639: where list_line_id = p_list_line_id;
2640:
2641: --tuned SQl to avoid cartesian join
2642: delete from qp_adv_mod_products

Line 2647: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168

2643: where pricing_phase_id = p_old_pricing_phase_id
2644: and product_attribute = l_product_attribute
2645: and product_attr_value = l_product_attr_value
2646: and not exists (
2647: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2648: from qp_pricing_attributes qpa,
2649: qp_list_lines qpl,
2650: qp_list_headers_b qph
2651: where qpa.pricing_phase_id = p_old_pricing_phase_id

Line 2648: from qp_pricing_attributes qpa,

2644: and product_attribute = l_product_attribute
2645: and product_attr_value = l_product_attr_value
2646: and not exists (
2647: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2648: from qp_pricing_attributes qpa,
2649: qp_list_lines qpl,
2650: qp_list_headers_b qph
2651: where qpa.pricing_phase_id = p_old_pricing_phase_id
2652: and qpa.product_attribute = l_product_attribute

Line 2660: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168

2656: and qph.list_header_id = qpa.list_header_id
2657: and qph.active_flag = 'Y'
2658: and rownum = 1
2659: union
2660: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2661: from qp_rltd_modifiers qpr,
2662: qp_list_lines qpl,
2663: qp_pricing_attributes qpa,
2664: qp_list_headers_b qph

Line 2663: qp_pricing_attributes qpa,

2659: union
2660: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2661: from qp_rltd_modifiers qpr,
2662: qp_list_lines qpl,
2663: qp_pricing_attributes qpa,
2664: qp_list_headers_b qph
2665: where qpa.pricing_phase_id = p_old_pricing_phase_id
2666: and qpa.product_attribute = l_product_attribute
2667: and qpa.product_attr_value = l_product_attr_value

Line 2676: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168

2672: and qph.list_header_id = qpa.list_header_id
2673: and qph.active_flag = 'Y'
2674: and rownum = 1
2675: union
2676: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2677: from qp_list_lines qpl,
2678: qp_pricing_attributes qpa,
2679: qp_list_headers_b qph
2680: where qpa.pricing_phase_id = p_old_pricing_phase_id

Line 2678: qp_pricing_attributes qpa,

2674: and rownum = 1
2675: union
2676: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2677: from qp_list_lines qpl,
2678: qp_pricing_attributes qpa,
2679: qp_list_headers_b qph
2680: where qpa.pricing_phase_id = p_old_pricing_phase_id
2681: and qpa.product_attribute = l_product_attribute
2682: and qpa.product_attr_value = l_product_attr_value

Line 2712: qp_pricing_attributes qpa

2708: qpl.pricing_phase_id,
2709: qpa.product_attribute,
2710: qpa.product_attr_value
2711: from qp_list_lines qpl,
2712: qp_pricing_attributes qpa
2713: where qpl.list_header_id = p_list_header_id
2714: and qpa.list_line_id = qpl.list_line_id;
2715:
2716: begin

Line 2761: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168

2757: where pricing_phase_id = line_cursor.pricing_phase_id
2758: and product_attribute = line_cursor.product_attribute
2759: and product_attr_value = line_cursor.product_attr_value
2760: and not exists (
2761: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2762: from qp_pricing_attributes qpa,
2763: qp_list_lines qpl,
2764: qp_list_headers_b qph
2765: where qpa.pricing_phase_id = line_cursor.pricing_phase_id

Line 2762: from qp_pricing_attributes qpa,

2758: and product_attribute = line_cursor.product_attribute
2759: and product_attr_value = line_cursor.product_attr_value
2760: and not exists (
2761: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2762: from qp_pricing_attributes qpa,
2763: qp_list_lines qpl,
2764: qp_list_headers_b qph
2765: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2766: and qpa.product_attribute = line_cursor.product_attribute

Line 2774: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168

2770: and qph.list_header_id = qpa.list_header_id
2771: and qph.active_flag = 'Y'
2772: and rownum = 1
2773: union
2774: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2775: from qp_rltd_modifiers qpr,
2776: qp_list_lines qpl,
2777: qp_pricing_attributes qpa,
2778: qp_list_headers_b qph

Line 2777: qp_pricing_attributes qpa,

2773: union
2774: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2775: from qp_rltd_modifiers qpr,
2776: qp_list_lines qpl,
2777: qp_pricing_attributes qpa,
2778: qp_list_headers_b qph
2779: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2780: and qpa.product_attribute = line_cursor.product_attribute
2781: and qpa.product_attr_value = line_cursor.product_attr_value

Line 2790: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168

2786: and qph.list_header_id = qpa.list_header_id
2787: and qph.active_flag = 'Y'
2788: and rownum = 1
2789: union
2790: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2791: from qp_list_lines qpl,
2792: qp_pricing_attributes qpa,
2793: qp_list_headers_b qph
2794: where qpa.pricing_phase_id = line_cursor.pricing_phase_id

Line 2792: qp_pricing_attributes qpa,

2788: and rownum = 1
2789: union
2790: select /*+ index(qpa QP_PRICING_ATTRIBUTES_N12) */ 'Y' --bug#11813168
2791: from qp_list_lines qpl,
2792: qp_pricing_attributes qpa,
2793: qp_list_headers_b qph
2794: where qpa.pricing_phase_id = line_cursor.pricing_phase_id
2795: and qpa.product_attribute = line_cursor.product_attribute
2796: and qpa.product_attr_value = line_cursor.product_attr_value