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_PREQ_GRP dependencies on QP_PREQ_QUAL_TMP

Line 625: Insert into QP_PREQ_QUAL_TMP

621: l_routine VARCHAR2(240):= 'Routine:QP_PREQ_GRP.INSERT_QUAL';
622:
623: BEGIN
624: FORALL i in p_list_header_id.FIRST..p_list_header_id.LAST
625: Insert into QP_PREQ_QUAL_TMP
626: ( LIST_HEADER_ID
627: , LIST_LINE_ID
628: , LINE_INDEX
629: , QUALIFIER_ATTRIBUTE_LEVEL

Line 801: (select /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id,list_line_id,qualifier_grouping_no

797: qph.active_date_second_type,
798: qph.limit_exists_flag,
799: qplatq.derived_qualifier_flag -- Added for TCA
800: from
801: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id,qualifier_grouping_no
802: from qp_preq_qual_tmp
803: where pricing_status_code = G_STATUS_UNCHANGED
804: and pricing_phase_id = p_pricing_phase_id) qptq,
805: qp_qualifiers qpq ,

Line 802: from qp_preq_qual_tmp

798: qph.limit_exists_flag,
799: qplatq.derived_qualifier_flag -- Added for TCA
800: from
801: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id,qualifier_grouping_no
802: from qp_preq_qual_tmp
803: where pricing_status_code = G_STATUS_UNCHANGED
804: and pricing_phase_id = p_pricing_phase_id) qptq,
805: qp_qualifiers qpq ,
806: qp_npreq_line_attrs_tmp qplatq,

Line 902: (select /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id,list_line_id

898: qph.active_date_second_type,
899: qph.limit_exists_flag,
900: qplatq.derived_qualifier_flag -- Added for TCA
901: from
902: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id
903: from qp_preq_qual_tmp
904: where pricing_status_code = G_STATUS_UNCHANGED
905: and pricing_phase_id = p_pricing_phase_id) qptq,
906: qp_qualifiers qpq ,

Line 903: from qp_preq_qual_tmp

899: qph.limit_exists_flag,
900: qplatq.derived_qualifier_flag -- Added for TCA
901: from
902: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id
903: from qp_preq_qual_tmp
904: where pricing_status_code = G_STATUS_UNCHANGED
905: and pricing_phase_id = p_pricing_phase_id) qptq,
906: qp_qualifiers qpq ,
907: qp_npreq_line_attrs_tmp qplatq,

Line 1001: (select /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id,list_line_id,qualifier_grouping_no

997: qph.active_date_second_type,
998: qph.limit_exists_flag,
999: qplatq.derived_qualifier_flag -- Added for TCA
1000: from
1001: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id,qualifier_grouping_no
1002: from qp_preq_qual_tmp
1003: where pricing_status_code = G_STATUS_UNCHANGED
1004: and pricing_phase_id = p_pricing_phase_id) qptq,
1005: qp_qualifiers qpq ,

Line 1002: from qp_preq_qual_tmp

998: qph.limit_exists_flag,
999: qplatq.derived_qualifier_flag -- Added for TCA
1000: from
1001: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id,qualifier_grouping_no
1002: from qp_preq_qual_tmp
1003: where pricing_status_code = G_STATUS_UNCHANGED
1004: and pricing_phase_id = p_pricing_phase_id) qptq,
1005: qp_qualifiers qpq ,
1006: qp_npreq_line_attrs_tmp qplatq,

Line 1104: (select /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id,list_line_id

1100: qph.active_date_second_type,
1101: qph.limit_exists_flag,
1102: qplatq.derived_qualifier_flag -- Added for TCA
1103: from
1104: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id
1105: from qp_preq_qual_tmp
1106: where pricing_status_code = G_STATUS_UNCHANGED
1107: and pricing_phase_id = p_pricing_phase_id) qptq,
1108: qp_qualifiers qpq ,

Line 1105: from qp_preq_qual_tmp

1101: qph.limit_exists_flag,
1102: qplatq.derived_qualifier_flag -- Added for TCA
1103: from
1104: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id
1105: from qp_preq_qual_tmp
1106: where pricing_status_code = G_STATUS_UNCHANGED
1107: and pricing_phase_id = p_pricing_phase_id) qptq,
1108: qp_qualifiers qpq ,
1109: qp_npreq_line_attrs_tmp qplatq,

Line 1204: (select /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id,list_line_id,qualifier_grouping_no

1200: qph.active_date_second_type,
1201: qph.limit_exists_flag,
1202: qplatq.derived_qualifier_flag -- Added for TCA
1203: from
1204: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id,qualifier_grouping_no
1205: from qp_preq_qual_tmp
1206: where pricing_status_code = G_STATUS_UNCHANGED
1207: and pricing_phase_id = p_pricing_phase_id) qptq,
1208: qp_qualifiers qpq ,

Line 1205: from qp_preq_qual_tmp

1201: qph.limit_exists_flag,
1202: qplatq.derived_qualifier_flag -- Added for TCA
1203: from
1204: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id,qualifier_grouping_no
1205: from qp_preq_qual_tmp
1206: where pricing_status_code = G_STATUS_UNCHANGED
1207: and pricing_phase_id = p_pricing_phase_id) qptq,
1208: qp_qualifiers qpq ,
1209: qp_npreq_line_attrs_tmp qplatq,

Line 1308: (select /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id,list_line_id

1304: qph.active_date_second_type,
1305: qph.limit_exists_flag,
1306: qplatq.derived_qualifier_flag -- Added for TCA
1307: from
1308: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id
1309: from qp_preq_qual_tmp
1310: where pricing_status_code = G_STATUS_UNCHANGED
1311: and pricing_phase_id = p_pricing_phase_id) qptq,
1312: qp_qualifiers qpq ,

Line 1309: from qp_preq_qual_tmp

1305: qph.limit_exists_flag,
1306: qplatq.derived_qualifier_flag -- Added for TCA
1307: from
1308: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id
1309: from qp_preq_qual_tmp
1310: where pricing_status_code = G_STATUS_UNCHANGED
1311: and pricing_phase_id = p_pricing_phase_id) qptq,
1312: qp_qualifiers qpq ,
1313: qp_npreq_line_attrs_tmp qplatq,

Line 1410: (select /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id,list_line_id,qualifier_grouping_no

1406: qph.active_date_second_type,
1407: qph.limit_exists_flag,
1408: qplatq.derived_qualifier_flag -- Added for TCA
1409: from
1410: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id,qualifier_grouping_no
1411: from qp_preq_qual_tmp
1412: where pricing_status_code = G_STATUS_UNCHANGED
1413: and pricing_phase_id = p_pricing_phase_id) qptq,
1414: qp_qualifiers qpq ,

Line 1411: from qp_preq_qual_tmp

1407: qph.limit_exists_flag,
1408: qplatq.derived_qualifier_flag -- Added for TCA
1409: from
1410: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id,qualifier_grouping_no
1411: from qp_preq_qual_tmp
1412: where pricing_status_code = G_STATUS_UNCHANGED
1413: and pricing_phase_id = p_pricing_phase_id) qptq,
1414: qp_qualifiers qpq ,
1415: qp_npreq_line_attrs_tmp qplatq,

Line 1511: (select /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id,list_line_id

1507: qph.active_date_second_type,
1508: qph.limit_exists_flag,
1509: qplatq.derived_qualifier_flag -- Added for TCA
1510: from
1511: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id
1512: from qp_preq_qual_tmp
1513: where pricing_status_code = G_STATUS_UNCHANGED
1514: and pricing_phase_id = p_pricing_phase_id) qptq,
1515: qp_qualifiers qpq ,

Line 1512: from qp_preq_qual_tmp

1508: qph.limit_exists_flag,
1509: qplatq.derived_qualifier_flag -- Added for TCA
1510: from
1511: (select /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id,list_line_id
1512: from qp_preq_qual_tmp
1513: where pricing_status_code = G_STATUS_UNCHANGED
1514: and pricing_phase_id = p_pricing_phase_id) qptq,
1515: qp_qualifiers qpq ,
1516: qp_npreq_line_attrs_tmp qplatq,

Line 1575: --Delete from QP_PREQ_QUAL_TMP;

1571: E_ROUTINE_ERRORS EXCEPTION;
1572:
1573: BEGIN
1574:
1575: --Delete from QP_PREQ_QUAL_TMP;
1576:
1577: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_EMPTY;
1578:
1579: OPEN l_mini_outer_qual_cur;

Line 1832: and ( qpq.list_header_id in (SELECT /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id -- for qualified headers from Cache_Header_Qualifiers

1828: and qpq.qualifier_attr_value = qplatq.value_from
1829: and qpq.comparison_operator_code = '='
1830: and qpq.search_ind = 1
1831: and qpq.list_line_id <> -1
1832: and ( qpq.list_header_id in (SELECT /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id -- for qualified headers from Cache_Header_Qualifiers
1833: FROM qp_preq_qual_tmp
1834: WHERE pricing_phase_id = p_pricing_phase_id
1835: AND pricing_status_code = G_STATUS_UNCHANGED)
1836: or

Line 1833: FROM qp_preq_qual_tmp

1829: and qpq.comparison_operator_code = '='
1830: and qpq.search_ind = 1
1831: and qpq.list_line_id <> -1
1832: and ( qpq.list_header_id in (SELECT /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id -- for qualified headers from Cache_Header_Qualifiers
1833: FROM qp_preq_qual_tmp
1834: WHERE pricing_phase_id = p_pricing_phase_id
1835: AND pricing_status_code = G_STATUS_UNCHANGED)
1836: or
1837: qpq.header_quals_exist_flag = G_NO) -- Pure line level qualifiers

Line 1954: and ( qpq.list_header_id in (SELECT /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id

1950: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
1951: and qpq.qualifier_datatype = G_NUMERIC
1952: and qpq.search_ind = 1
1953: and qpq.list_line_id <> -1
1954: and ( qpq.list_header_id in (SELECT /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id
1955: FROM qp_preq_qual_tmp
1956: WHERE pricing_phase_id = p_pricing_phase_id
1957: AND pricing_status_code = G_STATUS_UNCHANGED)
1958: or

Line 1955: FROM qp_preq_qual_tmp

1951: and qpq.qualifier_datatype = G_NUMERIC
1952: and qpq.search_ind = 1
1953: and qpq.list_line_id <> -1
1954: and ( qpq.list_header_id in (SELECT /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id
1955: FROM qp_preq_qual_tmp
1956: WHERE pricing_phase_id = p_pricing_phase_id
1957: AND pricing_status_code = G_STATUS_UNCHANGED)
1958: or
1959: qpq.header_quals_exist_flag = G_NO)

Line 2077: and ( qpq.list_header_id in (SELECT /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id

2073: and qpq.qualifier_attribute = qplatq.attribute
2074: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
2075: and qpq.search_ind = 1
2076: and qpq.list_line_id <> -1
2077: and ( qpq.list_header_id in (SELECT /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id
2078: FROM qp_preq_qual_tmp
2079: WHERE pricing_phase_id = p_pricing_phase_id
2080: AND pricing_status_code = G_STATUS_UNCHANGED)
2081: or

Line 2078: FROM qp_preq_qual_tmp

2074: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
2075: and qpq.search_ind = 1
2076: and qpq.list_line_id <> -1
2077: and ( qpq.list_header_id in (SELECT /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id
2078: FROM qp_preq_qual_tmp
2079: WHERE pricing_phase_id = p_pricing_phase_id
2080: AND pricing_status_code = G_STATUS_UNCHANGED)
2081: or
2082: qpq.header_quals_exist_flag = G_NO)

Line 2203: and ( qpq.list_header_id in (SELECT /+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) / distinct list_header_id

2199: and qpq.comparison_operator_code = 'NOT ='
2200: and qpq.qualifier_attr_value <> qplatq.value_from
2201: and qpq.search_ind = 1
2202: and qpq.list_line_id <> -1
2203: and ( qpq.list_header_id in (SELECT /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id
2204: FROM qp_preq_qual_tmp
2205: WHERE pricing_phase_id = p_pricing_phase_id
2206: AND pricing_status_code = G_STATUS_UNCHANGED)
2207: or

Line 2204: FROM qp_preq_qual_tmp

2200: and qpq.qualifier_attr_value <> qplatq.value_from
2201: and qpq.search_ind = 1
2202: and qpq.list_line_id <> -1
2203: and ( qpq.list_header_id in (SELECT /*+ index(qp_preq_qual_tmp QP_PREQ_QUAL_TMP_N7) */ distinct list_header_id
2204: FROM qp_preq_qual_tmp
2205: WHERE pricing_phase_id = p_pricing_phase_id
2206: AND pricing_status_code = G_STATUS_UNCHANGED)
2207: or
2208: qpq.header_quals_exist_flag = G_NO)

Line 2270: --Delete from QP_PREQ_QUAL_TMP;

2266: l_routine VARCHAR2(240):= 'Routine:QP_PREQ_GRP.Cache_Line_Qualifiers';
2267:
2268: BEGIN
2269:
2270: --Delete from QP_PREQ_QUAL_TMP;
2271:
2272: G_LINE_QUALIFIER_TEMP := 'E';
2273:
2274: OPEN l_outer_qual_cur;

Line 2424: UPDATE QP_PREQ_QUAL_TMP a

2420: -- Nitin
2421: -- addeded check to delete header level qualifiers if no line qualifier is selected
2422: -- and the header has no lines without line level qualifier in that phase.
2423:
2424: UPDATE QP_PREQ_QUAL_TMP a
2425: SET a.PRICING_STATUS_CODE = G_DELETED_GRP
2426: WHERE
2427: a.list_line_id = '-1'
2428: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED

Line 2432: (select 'x' from qp_preq_qual_tmp b where

2428: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
2429: AND a.PRICING_PHASE_ID = p_pricing_phase_id
2430: and a.line_index is null
2431: and not exists
2432: (select 'x' from qp_preq_qual_tmp b where
2433: b.list_header_id = a.list_header_id
2434: and b.list_line_id <> '-1'
2435: and b.pricing_phase_id = p_pricing_phase_id
2436: and b.pricing_status_code = G_STATUS_UNCHANGED

Line 2916: --Delete from QP_PREQ_QUAL_TMP;

2912: l_routine VARCHAR2(240):= 'Routine:QP_PREQ_GRP.Cache_Header_Qualifiers';
2913:
2914: BEGIN
2915:
2916: --Delete from QP_PREQ_QUAL_TMP;
2917:
2918: G_QUALIFIER_TEMP := 'E';
2919:
2920: OPEN l_outer_qual_cur;

Line 8108: UPDATE /+ index(a qpprod QP_PREQ_QUAL_TMP_N1) dynamic_sampling(1) / qp_preq_qual_tmp a --5658579

8104:
8105: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
8106: engine_debug('Entering '||l_routine);
8107: END IF;
8108: UPDATE /*+ index(a qpprod QP_PREQ_QUAL_TMP_N1) dynamic_sampling(1) */ qp_preq_qual_tmp a --5658579
8109: --UPDATE qp_preq_qual_tmp a
8110: SET pricing_status_code = G_STATUS_DELETED
8111: WHERE pricing_status_code = G_STATUS_UNCHANGED
8112: AND pricing_phase_id = p_pricing_phase_id

Line 8109: --UPDATE qp_preq_qual_tmp a

8105: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
8106: engine_debug('Entering '||l_routine);
8107: END IF;
8108: UPDATE /*+ index(a qpprod QP_PREQ_QUAL_TMP_N1) dynamic_sampling(1) */ qp_preq_qual_tmp a --5658579
8109: --UPDATE qp_preq_qual_tmp a
8110: SET pricing_status_code = G_STATUS_DELETED
8111: WHERE pricing_status_code = G_STATUS_UNCHANGED
8112: AND pricing_phase_id = p_pricing_phase_id
8113: AND list_line_id = -1

Line 24556: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1

24552: x_status_code OUT NOCOPY VARCHAR2,
24553: x_status_text OUT NOCOPY VARCHAR2) AS
24554:
24555: /*
24556: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24557: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24558: */
24559: CURSOR header_level_qual_attrs_cur IS
24560: SELECT a.LIST_HEADER_ID,

Line 24557: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2

24553: x_status_text OUT NOCOPY VARCHAR2) AS
24554:
24555: /*
24556: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24557: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24558: */
24559: CURSOR header_level_qual_attrs_cur IS
24560: SELECT a.LIST_HEADER_ID,
24561: a.QUALIFIER_GROUPING_NO,

Line 24567: FROM QP_PREQ_QUAL_TMP a

24563: a.UNIQUE_KEY,
24564: COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --bug 8359587
24565: --COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --[julin/3527596,4274099]
24566: 1 --7038849
24567: FROM QP_PREQ_QUAL_TMP a
24568: WHERE a.LIST_LINE_ID = -1
24569: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24570: AND a.PRICING_PHASE_ID = p_pricing_phase_id
24571: AND a.QUALIFIER_GROUPING_NO = -1 --7038849

Line 24581: FROM QP_PREQ_QUAL_TMP a

24577: a.UNIQUE_KEY,
24578: COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --bug 8359587
24579: -- COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --[julin/3527596,4274099]
24580: 2 --7038849
24581: FROM QP_PREQ_QUAL_TMP a
24582: WHERE a.LIST_LINE_ID = -1
24583: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24584: AND a.PRICING_PHASE_ID = p_pricing_phase_id
24585: AND a.QUALIFIER_GROUPING_NO <> -1 --7038849

Line 24590: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1

24586: GROUP BY a.LIST_HEADER_ID, a.QUALIFIER_GROUPING_NO,a.QUALIFIER_GROUP_CNT,a.UNIQUE_KEY
24587: ORDER BY 1,6; --7038849
24588:
24589: /*
24590: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24591: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24592: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24593: */
24594: CURSOR hdr_lvl_qual_attrs_req_line IS

Line 24591: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2

24587: ORDER BY 1,6; --7038849
24588:
24589: /*
24590: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24591: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24592: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24593: */
24594: CURSOR hdr_lvl_qual_attrs_req_line IS
24595: SELECT a.LINE_INDEX,

Line 24592: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3

24588:
24589: /*
24590: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24591: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24592: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24593: */
24594: CURSOR hdr_lvl_qual_attrs_req_line IS
24595: SELECT a.LINE_INDEX,
24596: a.LIST_HEADER_ID,

Line 24603: FROM QP_PREQ_QUAL_TMP a

24599: a.UNIQUE_KEY,
24600: COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --bug 8359587
24601: --COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --[julin/3527596,4274099]
24602: 1 -- 7038849
24603: FROM QP_PREQ_QUAL_TMP a
24604: WHERE a.LIST_LINE_ID = -1
24605: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24606: AND a.PRICING_PHASE_ID = p_pricing_phase_id
24607: --AND a.LINE_INDEX > 0

Line 24619: FROM QP_PREQ_QUAL_TMP a

24615: a.UNIQUE_KEY,
24616: COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --bug 8359587
24617: --COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --[julin/3527596,4274099]
24618: 2 -- 7038849
24619: FROM QP_PREQ_QUAL_TMP a
24620: WHERE a.LIST_LINE_ID = -1
24621: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24622: AND a.PRICING_PHASE_ID = p_pricing_phase_id
24623: --AND a.LINE_INDEX > 0

Line 24629: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

24625: GROUP BY a.LINE_INDEX , a.LIST_HEADER_ID, a.QUALIFIER_GROUPING_NO,a.QUALIFIER_GROUP_CNT,a.UNIQUE_KEY
24626: ORDER BY 1,2,7; --7038849
24627:
24628: /*
24629: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
24630: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
24631: */
24632: CURSOR line_level_qual_attrs_cur IS
24633: SELECT a.LIST_HEADER_ID,

Line 24630: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4

24626: ORDER BY 1,2,7; --7038849
24627:
24628: /*
24629: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
24630: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
24631: */
24632: CURSOR line_level_qual_attrs_cur IS
24633: SELECT a.LIST_HEADER_ID,
24634: a.LIST_LINE_ID,

Line 24642: FROM QP_PREQ_QUAL_TMP a

24638: a.UNIQUE_KEY,
24639: COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --bug 8359587
24640: --COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --[julin/3527596,4274099]
24641: 1 --7038849
24642: FROM QP_PREQ_QUAL_TMP a
24643: WHERE a.LIST_LINE_ID > 0
24644: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24645: AND a.PRICING_PHASE_ID = p_pricing_phase_id
24646: AND a.QUALIFIER_GROUPING_NO = -1 --7038849

Line 24659: FROM QP_PREQ_QUAL_TMP a

24655: a.UNIQUE_KEY,
24656: COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --bug 8359587
24657: --COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --[julin/3527596,4274099]
24658: 2 --7038849
24659: FROM QP_PREQ_QUAL_TMP a
24660: WHERE a.LIST_LINE_ID > 0
24661: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24662: AND a.PRICING_PHASE_ID = p_pricing_phase_id
24663: AND a.QUALIFIER_GROUPING_NO <> -1 --7038849

Line 24669: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1

24665: a.UNIQUE_KEY
24666: ORDER BY 1,2,8; --7038849
24667:
24668: /*
24669: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24670: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24671: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24672: */
24673: CURSOR line_lvl_qual_attrs_req_line IS

Line 24670: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2

24666: ORDER BY 1,2,8; --7038849
24667:
24668: /*
24669: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24670: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24671: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24672: */
24673: CURSOR line_lvl_qual_attrs_req_line IS
24674: SELECT /*+ INDEX (a QP_PREQ_QUAL_TMP_N1) */ a.LINE_INDEX,

Line 24671: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3

24667:
24668: /*
24669: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24670: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24671: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24672: */
24673: CURSOR line_lvl_qual_attrs_req_line IS
24674: SELECT /*+ INDEX (a QP_PREQ_QUAL_TMP_N1) */ a.LINE_INDEX,
24675: a.LIST_HEADER_ID,

Line 24674: SELECT /+ INDEX (a QP_PREQ_QUAL_TMP_N1) / a.LINE_INDEX,

24670: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24671: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24672: */
24673: CURSOR line_lvl_qual_attrs_req_line IS
24674: SELECT /*+ INDEX (a QP_PREQ_QUAL_TMP_N1) */ a.LINE_INDEX,
24675: a.LIST_HEADER_ID,
24676: a.LIST_LINE_ID,
24677: a.QUALIFIER_GROUPING_NO,
24678: a.QUALIFIER_GROUP_CNT,

Line 24684: FROM QP_PREQ_QUAL_TMP a

24680: a.UNIQUE_KEY,
24681: COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --bug 8359587
24682: --COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --[julin/3527596,4274099]
24683: 1
24684: FROM QP_PREQ_QUAL_TMP a
24685: WHERE LIST_LINE_ID > 0
24686: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24687: --AND a.LINE_INDEX > 0
24688: AND a.PRICING_PHASE_ID = p_pricing_phase_id

Line 24693: SELECT /+ INDEX (a QP_PREQ_QUAL_TMP_N1) / a.LINE_INDEX,

24689: AND a.QUALIFIER_GROUPING_NO = -1 --7038849
24690: GROUP BY a.LINE_INDEX, a.LIST_HEADER_ID , a.LIST_LINE_ID,a.QUALIFIER_GROUPING_NO,
24691: a.QUALIFIER_GROUP_CNT,a.HEADER_QUALS_EXIST_FLAG,a.UNIQUE_KEY
24692: UNION ALL --7038849
24693: SELECT /*+ INDEX (a QP_PREQ_QUAL_TMP_N1) */ a.LINE_INDEX,
24694: a.LIST_HEADER_ID,
24695: a.LIST_LINE_ID,
24696: a.QUALIFIER_GROUPING_NO,
24697: a.QUALIFIER_GROUP_CNT,

Line 24703: FROM QP_PREQ_QUAL_TMP a

24699: a.UNIQUE_KEY,
24700: COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --bug 8359587
24701: --COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP, --[julin/3527596,4274099]
24702: 2
24703: FROM QP_PREQ_QUAL_TMP a
24704: WHERE LIST_LINE_ID > 0
24705: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24706: --AND a.LINE_INDEX > 0
24707: AND a.PRICING_PHASE_ID = p_pricing_phase_id

Line 24714: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1

24710: a.QUALIFIER_GROUP_CNT,a.HEADER_QUALS_EXIST_FLAG,a.UNIQUE_KEY
24711: ORDER BY 1,2,3,9; --7038849
24712:
24713: /*
24714: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24715: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24716: */
24717: CURSOR check_hdr_quals_cur(p_list_header_id NUMBER) IS
24718: SELECT LIST_HEADER_ID

Line 24715: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2

24711: ORDER BY 1,2,3,9; --7038849
24712:
24713: /*
24714: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24715: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24716: */
24717: CURSOR check_hdr_quals_cur(p_list_header_id NUMBER) IS
24718: SELECT LIST_HEADER_ID
24719: FROM QP_PREQ_QUAL_TMP

Line 24719: FROM QP_PREQ_QUAL_TMP

24715: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24716: */
24717: CURSOR check_hdr_quals_cur(p_list_header_id NUMBER) IS
24718: SELECT LIST_HEADER_ID
24719: FROM QP_PREQ_QUAL_TMP
24720: WHERE LIST_HEADER_ID = p_list_header_id
24721: AND LIST_LINE_ID = -1
24722: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24723: AND PRICING_PHASE_ID = p_pricing_phase_id

Line 24727: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1

24723: AND PRICING_PHASE_ID = p_pricing_phase_id
24724: AND ROWNUM = 1;
24725:
24726: /*
24727: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24728: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24729: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24730: */
24731: CURSOR check_hdr_quals_cur_req_line(p_list_header_id NUMBER,

Line 24728: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2

24724: AND ROWNUM = 1;
24725:
24726: /*
24727: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24728: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24729: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24730: */
24731: CURSOR check_hdr_quals_cur_req_line(p_list_header_id NUMBER,
24732: p_line_index NUMBER) IS

Line 24729: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3

24725:
24726: /*
24727: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
24728: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
24729: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
24730: */
24731: CURSOR check_hdr_quals_cur_req_line(p_list_header_id NUMBER,
24732: p_line_index NUMBER) IS
24733: SELECT LIST_HEADER_ID

Line 24734: FROM QP_PREQ_QUAL_TMP

24730: */
24731: CURSOR check_hdr_quals_cur_req_line(p_list_header_id NUMBER,
24732: p_line_index NUMBER) IS
24733: SELECT LIST_HEADER_ID
24734: FROM QP_PREQ_QUAL_TMP
24735: WHERE LIST_HEADER_ID = p_list_header_id
24736: AND LINE_INDEX = p_line_index
24737: AND LIST_LINE_ID = -1
24738: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED

Line 24924: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1

24920: END IF;
24921: IF (l_hdr_del_tbl.count > 0) THEN
24922: FORALL i in l_hdr_del_tbl.FIRST..l_hdr_del_tbl.LAST
24923: /*
24924: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
24925: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
24926: */
24927: UPDATE QP_PREQ_QUAL_TMP --upd1
24928: SET PRICING_STATUS_CODE = G_DELETED_GRP

Line 24925: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2

24921: IF (l_hdr_del_tbl.count > 0) THEN
24922: FORALL i in l_hdr_del_tbl.FIRST..l_hdr_del_tbl.LAST
24923: /*
24924: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
24925: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
24926: */
24927: UPDATE QP_PREQ_QUAL_TMP --upd1
24928: SET PRICING_STATUS_CODE = G_DELETED_GRP
24929: WHERE UNIQUE_KEY = l_hdr_del_tbl(i)

Line 24927: UPDATE QP_PREQ_QUAL_TMP --upd1

24923: /*
24924: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
24925: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
24926: */
24927: UPDATE QP_PREQ_QUAL_TMP --upd1
24928: SET PRICING_STATUS_CODE = G_DELETED_GRP
24929: WHERE UNIQUE_KEY = l_hdr_del_tbl(i)
24930: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
24931: AND PRICING_PHASE_ID = p_pricing_phase_id;

Line 25098: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1

25094:
25095: IF (l_line_del_tbl.count > 0 ) THEN
25096: FORALL i in l_line_del_tbl.FIRST..l_line_del_tbl.LAST
25097: /*
25098: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25099: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25100: */
25101: UPDATE QP_PREQ_QUAL_TMP --upd2
25102: SET PRICING_STATUS_CODE = G_DELETED_GRP

Line 25099: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2

25095: IF (l_line_del_tbl.count > 0 ) THEN
25096: FORALL i in l_line_del_tbl.FIRST..l_line_del_tbl.LAST
25097: /*
25098: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25099: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25100: */
25101: UPDATE QP_PREQ_QUAL_TMP --upd2
25102: SET PRICING_STATUS_CODE = G_DELETED_GRP
25103: WHERE UNIQUE_KEY = l_line_del_tbl(i)

Line 25101: UPDATE QP_PREQ_QUAL_TMP --upd2

25097: /*
25098: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25099: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25100: */
25101: UPDATE QP_PREQ_QUAL_TMP --upd2
25102: SET PRICING_STATUS_CODE = G_DELETED_GRP
25103: WHERE UNIQUE_KEY = l_line_del_tbl(i)
25104: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
25105: AND PRICING_PHASE_ID = p_pricing_phase_id;

Line 25244: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1

25240: END IF;
25241: IF (l_hdr_del_tbl.count > 0) THEN
25242: FORALL i in l_hdr_del_tbl.FIRST..l_hdr_del_tbl.LAST
25243: /*
25244: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25245: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25246: */
25247: UPDATE QP_PREQ_QUAL_TMP --upd3
25248: SET PRICING_STATUS_CODE = G_DELETED_GRP

Line 25245: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2

25241: IF (l_hdr_del_tbl.count > 0) THEN
25242: FORALL i in l_hdr_del_tbl.FIRST..l_hdr_del_tbl.LAST
25243: /*
25244: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25245: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25246: */
25247: UPDATE QP_PREQ_QUAL_TMP --upd3
25248: SET PRICING_STATUS_CODE = G_DELETED_GRP
25249: WHERE UNIQUE_KEY = l_hdr_del_tbl(i)

Line 25247: UPDATE QP_PREQ_QUAL_TMP --upd3

25243: /*
25244: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25245: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25246: */
25247: UPDATE QP_PREQ_QUAL_TMP --upd3
25248: SET PRICING_STATUS_CODE = G_DELETED_GRP
25249: WHERE UNIQUE_KEY = l_hdr_del_tbl(i)
25250: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
25251: AND PRICING_PHASE_ID = p_pricing_phase_id;

Line 25435: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1

25431:
25432: IF (l_line_del_tbl.count > 0 ) THEN
25433: FORALL i in l_line_del_tbl.FIRST..l_line_del_tbl.LAST
25434: /*
25435: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25436: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25437: */
25438: UPDATE QP_PREQ_QUAL_TMP --upd4
25439: SET PRICING_STATUS_CODE = G_DELETED_GRP

Line 25436: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2

25432: IF (l_line_del_tbl.count > 0 ) THEN
25433: FORALL i in l_line_del_tbl.FIRST..l_line_del_tbl.LAST
25434: /*
25435: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25436: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25437: */
25438: UPDATE QP_PREQ_QUAL_TMP --upd4
25439: SET PRICING_STATUS_CODE = G_DELETED_GRP
25440: WHERE UNIQUE_KEY = l_line_del_tbl(i)

Line 25438: UPDATE QP_PREQ_QUAL_TMP --upd4

25434: /*
25435: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
25436: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
25437: */
25438: UPDATE QP_PREQ_QUAL_TMP --upd4
25439: SET PRICING_STATUS_CODE = G_DELETED_GRP
25440: WHERE UNIQUE_KEY = l_line_del_tbl(i)
25441: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
25442: AND PRICING_PHASE_ID = p_pricing_phase_id;

Line 25469: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

25465: x_status_code OUT NOCOPY VARCHAR2,
25466: x_status_text OUT NOCOPY VARCHAR2)
25467: AS
25468: /*
25469: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25470: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25471:
25472: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25473: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2

Line 25470: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2

25466: x_status_text OUT NOCOPY VARCHAR2)
25467: AS
25468: /*
25469: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25470: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25471:
25472: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25473: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25474: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3

Line 25539: (select /+ index (qpqq QP_PREQ_QUAL_TMP_N5) /

25535: qpl.accum_context, -- accum range break
25536: qpl.accum_attribute, -- accum range break
25537: qpl.accum_attr_run_src_flag -- accum range break
25538: from
25539: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
25540: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
25541: from qp_preq_qual_tmp qpqq
25542: where pricing_status_code = G_STATUS_UNCHANGED
25543: and pricing_phase_id = p_pricing_phase_id

Line 25541: from qp_preq_qual_tmp qpqq

25537: qpl.accum_attr_run_src_flag -- accum range break
25538: from
25539: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
25540: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
25541: from qp_preq_qual_tmp qpqq
25542: where pricing_status_code = G_STATUS_UNCHANGED
25543: and pricing_phase_id = p_pricing_phase_id
25544: and search_ind = 1
25545: and list_line_id > 0 ) qpq,

Line 25630: (select /+ index (qpqq QP_PREQ_QUAL_TMP_N5) /

25626: qpl.accum_context, -- accum range break
25627: qpl.accum_attribute, -- accum range break
25628: qpl.accum_attr_run_src_flag -- accum range break
25629: from
25630: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
25631: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
25632: from qp_preq_qual_tmp qpqq
25633: where pricing_status_code = G_STATUS_UNCHANGED
25634: and pricing_phase_id = p_pricing_phase_id

Line 25632: from qp_preq_qual_tmp qpqq

25628: qpl.accum_attr_run_src_flag -- accum range break
25629: from
25630: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
25631: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
25632: from qp_preq_qual_tmp qpqq
25633: where pricing_status_code = G_STATUS_UNCHANGED
25634: and pricing_phase_id = p_pricing_phase_id
25635: and search_ind = 1
25636: and list_line_id < 0 ) qpq,

Line 25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

25678: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
25679: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
25680: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
25681:
25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25683: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25684: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
25685: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
25686: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5

Line 25683: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2

25679: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
25680: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
25681:
25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25683: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25684: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
25685: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
25686: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25687:

Line 25684: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3

25680: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
25681:
25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25683: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25684: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
25685: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
25686: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25687:
25688: -- Used for qplatpr and qplatpc

Line 25685: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4

25681:
25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25683: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25684: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
25685: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
25686: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25687:
25688: -- Used for qplatpr and qplatpc
25689: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1

Line 25686: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5

25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25683: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25684: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
25685: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
25686: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25687:
25688: -- Used for qplatpr and qplatpc
25689: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
25690: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2

Line 25701: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

25697:
25698: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_INDEX,1
25699: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_TYPE_CODE,2
25700:
25701: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25702: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25703: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25704:
25705: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1

Line 25702: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2

25698: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_INDEX,1
25699: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_TYPE_CODE,2
25700:
25701: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25702: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25703: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25704:
25705: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25706: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2

Line 25703: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5

25699: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_TYPE_CODE,2
25700:
25701: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25702: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25703: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25704:
25705: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25706: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25707: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3

Line 25785: (select /+ index (qpqq QP_PREQ_QUAL_TMP_N5) /

25781: qpl.accum_context, -- accum range break
25782: qpl.accum_attribute, -- accum range break
25783: qpl.accum_attr_run_src_flag -- accum range break
25784: from
25785: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
25786: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
25787: from qp_preq_qual_tmp qpqq
25788: where pricing_status_code = G_STATUS_UNCHANGED
25789: and pricing_phase_id = p_pricing_phase_id

Line 25787: from qp_preq_qual_tmp qpqq

25783: qpl.accum_attr_run_src_flag -- accum range break
25784: from
25785: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
25786: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
25787: from qp_preq_qual_tmp qpqq
25788: where pricing_status_code = G_STATUS_UNCHANGED
25789: and pricing_phase_id = p_pricing_phase_id
25790: and search_ind = 1
25791: and list_line_id > 0 ) qpq,

Line 25900: (select /+ index (qpqq QP_PREQ_QUAL_TMP_N5) /

25896: qpl.accum_context, -- accum range break
25897: qpl.accum_attribute, -- accum range break
25898: qpl.accum_attr_run_src_flag -- accum range break
25899: from
25900: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
25901: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
25902: from qp_preq_qual_tmp qpqq
25903: where pricing_status_code = G_STATUS_UNCHANGED
25904: and pricing_phase_id = p_pricing_phase_id

Line 25902: from qp_preq_qual_tmp qpqq

25898: qpl.accum_attr_run_src_flag -- accum range break
25899: from
25900: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
25901: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
25902: from qp_preq_qual_tmp qpqq
25903: where pricing_status_code = G_STATUS_UNCHANGED
25904: and pricing_phase_id = p_pricing_phase_id
25905: and search_ind = 1
25906: and list_line_id < 0 ) qpq,

Line 25954: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

25950: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
25951: order by 4,2;
25952:
25953: /*
25954: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25955: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25956: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3
25957: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4
25958:

Line 25955: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2

25951: order by 4,2;
25952:
25953: /*
25954: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25955: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25956: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3
25957: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4
25958:
25959: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1

Line 25956: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3

25952:
25953: /*
25954: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25955: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25956: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3
25957: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4
25958:
25959: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1
25960: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2

Line 25957: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4

25953: /*
25954: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25955: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25956: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3
25957: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4
25958:
25959: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1
25960: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2
25961: */

Line 26009: (select /+ index (qpqq QP_PREQ_QUAL_TMP_N5) /

26005: qpl.accum_context, -- accum range break
26006: qpl.accum_attribute, -- accum range break
26007: qpl.accum_attr_run_src_flag -- accum range break
26008: from
26009: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
26010: distinct line_index, line_type_code,pricing_effective_date,list_header_id, list_line_id,
26011: ask_for_flag, created_from_list_type,header_limit_exists
26012: from qp_preq_qual_tmp qpqq
26013: where pricing_status_code = G_STATUS_UNCHANGED

Line 26012: from qp_preq_qual_tmp qpqq

26008: from
26009: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
26010: distinct line_index, line_type_code,pricing_effective_date,list_header_id, list_line_id,
26011: ask_for_flag, created_from_list_type,header_limit_exists
26012: from qp_preq_qual_tmp qpqq
26013: where pricing_status_code = G_STATUS_UNCHANGED
26014: and pricing_phase_id = p_pricing_phase_id
26015: and search_ind = 1
26016: and list_line_id > 0 ) qpq,

Line 26077: (select /+ index (qpqq QP_PREQ_QUAL_TMP_N5) /

26073: qpl.accum_context, -- accum range break
26074: qpl.accum_attribute, -- accum range break
26075: qpl.accum_attr_run_src_flag -- accum range break
26076: from
26077: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
26078: distinct line_index, line_type_code,pricing_effective_date,list_header_id, list_line_id,
26079: ask_for_flag, created_from_list_type,header_limit_exists
26080: from qp_preq_qual_tmp qpqq
26081: where pricing_status_code = G_STATUS_UNCHANGED

Line 26080: from qp_preq_qual_tmp qpqq

26076: from
26077: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
26078: distinct line_index, line_type_code,pricing_effective_date,list_header_id, list_line_id,
26079: ask_for_flag, created_from_list_type,header_limit_exists
26080: from qp_preq_qual_tmp qpqq
26081: where pricing_status_code = G_STATUS_UNCHANGED
26082: and pricing_phase_id = p_pricing_phase_id
26083: and search_ind = 1
26084: and list_line_id < 0 ) qpq,

Line 26628: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

26624: */
26625:
26626:
26627: /*
26628: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
26629: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
26630: */
26631: CURSOR l_get_line_index_details IS
26632: SELECT distinct

Line 26629: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5

26625:
26626:
26627: /*
26628: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
26629: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
26630: */
26631: CURSOR l_get_line_index_details IS
26632: SELECT distinct
26633: c.LIST_HEADER_ID,

Line 26642: FROM QP_PREQ_QUAL_TMP c

26638: c.PRICING_EFFECTIVE_DATE,
26639: c.START_DATE_ACTIVE_FIRST,
26640: c.START_DATE_ACTIVE_SECOND,
26641: c.LINE_TYPE_CODE
26642: FROM QP_PREQ_QUAL_TMP c
26643: WHERE c.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
26644: AND c.LINE_INDEX > 0
26645: ORDER BY c.LINE_INDEX;
26646:

Line 26655: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1

26651: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
26652: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
26653: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
26654:
26655: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
26656:
26657: -- Full table scan on qp_npreq_lines_tmp
26658: */
26659:

Line 26706: QP_PREQ_QUAL_TMP c ,

26702: NULL ACTIVE_DATE_SECOND_TYPE,
26703: c.HEADER_LIMIT_EXISTS,
26704: a.DERIVED_QUALIFIER_FLAG -- Added for TCA
26705: FROM qp_npreq_lines_tmp b,
26706: QP_PREQ_QUAL_TMP c ,
26707: qp_npreq_line_attrs_tmp a
26708: WHERE a.CONTEXT = c.QUALIFIER_ATTRIBUTE_CONTEXT
26709: AND a.ATTRIBUTE = c.QUALIFIER_ATTRIBUTE
26710: AND a.VALUE_FROM = c.QUALIFIER_ATTRIBUTE_VALUE

Line 26797: QP_PREQ_QUAL_TMP c ,

26793: NULL ACTIVE_DATE_FIRST_TYPE,
26794: NULL ACTIVE_DATE_SECOND_TYPE,
26795: c.HEADER_LIMIT_EXISTS
26796: FROM qp_npreq_lines_tmp b,
26797: QP_PREQ_QUAL_TMP c ,
26798: qp_npreq_line_attrs_tmp a
26799: WHERE a.CONTEXT = c.QUALIFIER_ATTRIBUTE_CONTEXT
26800: AND a.ATTRIBUTE = c.QUALIFIER_ATTRIBUTE
26801: AND a.VALUE_FROM = c.QUALIFIER_ATTRIBUTE_VALUE

Line 26887: QP_PREQ_QUAL_TMP c ,

26883: NULL ACTIVE_DATE_FIRST_TYPE,
26884: NULL ACTIVE_DATE_SECOND_TYPE,
26885: c.HEADER_LIMIT_EXISTS
26886: FROM qp_npreq_lines_tmp b,
26887: QP_PREQ_QUAL_TMP c ,
26888: qp_npreq_line_attrs_tmp a
26889: WHERE a.CONTEXT = c.QUALIFIER_ATTRIBUTE_CONTEXT
26890: AND a.ATTRIBUTE = c.QUALIFIER_ATTRIBUTE
26891: AND a.VALUE_FROM = c.QUALIFIER_ATTRIBUTE_VALUE

Line 26937: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1

26933: AND nvl(b.ACTIVE_DATE_SECOND_TYPE,'X') = nvl(c.ACTIVE_DATE_SECOND_TYPE,nvl(b.ACTIVE_DATE_SECOND_TYPE,'X')); -- SHIP
26934: */
26935:
26936: /*
26937: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
26938: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
26939: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
26940: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
26941: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5

Line 26938: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2

26934: */
26935:
26936: /*
26937: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
26938: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
26939: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
26940: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
26941: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
26942: */

Line 26939: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3

26935:
26936: /*
26937: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
26938: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
26939: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
26940: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
26941: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
26942: */
26943: CURSOR l_get_satisfied_quals(p_list_header_id NUMBER , p_list_line_id NUMBER, p_line_index NUMBER) IS

Line 26940: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4

26936: /*
26937: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
26938: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
26939: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
26940: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
26941: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
26942: */
26943: CURSOR l_get_satisfied_quals(p_list_header_id NUMBER , p_list_line_id NUMBER, p_line_index NUMBER) IS
26944: SELECT /*+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals */

Line 26941: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5

26937: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
26938: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
26939: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
26940: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
26941: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
26942: */
26943: CURSOR l_get_satisfied_quals(p_list_header_id NUMBER , p_list_line_id NUMBER, p_line_index NUMBER) IS
26944: SELECT /*+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals */
26945: c.LIST_HEADER_ID,

Line 26944: SELECT /+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals /

26940: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
26941: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
26942: */
26943: CURSOR l_get_satisfied_quals(p_list_header_id NUMBER , p_list_line_id NUMBER, p_line_index NUMBER) IS
26944: SELECT /*+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals */
26945: c.LIST_HEADER_ID,
26946: c.LIST_LINE_ID,
26947: c.QUALIFIER_GROUP_CNT,
26948: c.HEADER_QUALS_EXIST_FLAG,

Line 26966: FROM QP_PREQ_QUAL_TMP c

26962: c.QUALIFIER_PRICING_ATTR_FLAG,
26963: c.QUALIFIER_OPERATOR_TYPE ,
26964: c.CREATED_FROM_LIST_TYPE,
26965: decode(c.LIST_LINE_ID,-1,'HQ','LQ') QUALIFIER_TYPE
26966: FROM QP_PREQ_QUAL_TMP c
26967: WHERE c.LIST_HEADER_ID = p_list_header_id
26968: AND c.LIST_LINE_ID IN (p_list_line_id,-1)
26969: AND c.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
26970: AND c.LINE_INDEX = p_line_index

Line 26975: SELECT /+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals /

26971: AND c.PRICING_PHASE_ID = p_pricing_phase_id
26972: UNION
26973: -- To get the -1 group qualifiers for non -1 groups only
26974: -- non -1 groups = OTHERS_GROUP_CNT <> 0
26975: SELECT /*+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals */
26976: c.LIST_HEADER_ID,
26977: c.LIST_LINE_ID,
26978: c.QUALIFIER_GROUP_CNT,
26979: c.HEADER_QUALS_EXIST_FLAG,

Line 26997: FROM QP_PREQ_QUAL_TMP c

26993: c.QUALIFIER_PRICING_ATTR_FLAG,
26994: c.QUALIFIER_OPERATOR_TYPE ,
26995: c.CREATED_FROM_LIST_TYPE,
26996: decode(c.LIST_LINE_ID,-1,'HQ','LQ') QUALIFIER_TYPE
26997: FROM QP_PREQ_QUAL_TMP c
26998: WHERE c.LIST_HEADER_ID = p_list_header_id
26999: AND c.LIST_LINE_ID IN (p_list_line_id,-1)
27000: AND c.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
27001: AND c.PRICING_PHASE_ID = p_pricing_phase_id

Line 27012: and b.list_header_id in (select distinct a.list_header_id from qp_preq_qual_tmp a

27008: CURSOR get_list_headers_with_ind2 IS
27009: SELECT/*+ ORDERED */ 'x'
27010: FROM qp_qualifiers b
27011: WHERE b.search_ind = 2
27012: and b.list_header_id in (select distinct a.list_header_id from qp_preq_qual_tmp a
27013: where a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
27014: and a.search_ind = 1
27015: and a.pricing_phase_id = p_pricing_phase_id)
27016: AND rownum = 1;

Line 27118: INDX,QP_PREQ_GRP.select_modifiers.select_modifiers_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

27114: engine_debug('Caching Qualifiers for phase : ' || p_pricing_phase_id || ' Successful');
27115: END IF;
27116: -- For each primary search list header , list line and qualifier grouping no
27117: /*
27118: INDX,QP_PREQ_GRP.select_modifiers.select_modifiers_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
27119: */
27120: /* FOR c1 in (select list_header_id , list_line_id , qualifier_grouping_no
27121: from qp_preq_qual_tmp
27122: where pricing_status_code = G_STATUS_UNCHANGED

Line 27121: from qp_preq_qual_tmp

27117: /*
27118: INDX,QP_PREQ_GRP.select_modifiers.select_modifiers_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
27119: */
27120: /* FOR c1 in (select list_header_id , list_line_id , qualifier_grouping_no
27121: from qp_preq_qual_tmp
27122: where pricing_status_code = G_STATUS_UNCHANGED
27123: and pricing_phase_id = p_pricing_phase_id
27124: order by list_header_id,list_line_id,qualifier_grouping_no) LOOP
27125: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 27179: --update qp_preq_qual_tmp qpqt1

27175: engine_debug('hw: l_get_line_index_for_quals_n path');
27176:
27177: END IF;
27178: -- update null group count
27179: --update qp_preq_qual_tmp qpqt1
27180: --set qpqt1.null_group_cnt = (select count(*)
27181: from qp_preq_qual_tmp qpqt2
27182: where qpqt2.list_header_id = qpqt1.list_header_id
27183: and qpqt2.list_line_id = qpqt1.list_line_id

Line 27181: from qp_preq_qual_tmp qpqt2

27177: END IF;
27178: -- update null group count
27179: --update qp_preq_qual_tmp qpqt1
27180: --set qpqt1.null_group_cnt = (select count(*)
27181: from qp_preq_qual_tmp qpqt2
27182: where qpqt2.list_header_id = qpqt1.list_header_id
27183: and qpqt2.list_line_id = qpqt1.list_line_id
27184: and qpqt2.qualifier_grouping_no = -1
27185: and qpqt2.pricing_status_code <> G_DELETED_GRP

Line 27195: --update qp_preq_qual_tmp qpqt1

27191: --and qpqt1.qualifier_grouping_no = -1; -- should update all groups and not just -1 groups
27192: -- as it is used as null_group_count + other_group_cnt = qualifier_group_cnt
27193:
27194: -- update other group count
27195: --update qp_preq_qual_tmp qpqt1
27196: --set qpqt1.other_group_cnt = (select count(*)
27197: from qp_preq_qual_tmp qpqt2
27198: where qpqt2.list_header_id = qpqt1.list_header_id
27199: and qpqt2.list_line_id = qpqt1.list_line_id

Line 27197: from qp_preq_qual_tmp qpqt2

27193:
27194: -- update other group count
27195: --update qp_preq_qual_tmp qpqt1
27196: --set qpqt1.other_group_cnt = (select count(*)
27197: from qp_preq_qual_tmp qpqt2
27198: where qpqt2.list_header_id = qpqt1.list_header_id
27199: and qpqt2.list_line_id = qpqt1.list_line_id
27200: and qpqt2.qualifier_grouping_no <> -1
27201: and qpqt2.pricing_status_code <> G_DELETED_GRP

Line 27212: from qp_preq_qual_tmp

27208:
27209: IF (G_DEBUG_ENGINE = FND_API.G_TRUE) THEN
27210: for i in (select list_header_id,list_line_id,qualifier_grouping_no,null_group_cnt,other_group_cnt,search_ind,
27211: qualifier_group_cnt,others_group_cnt,qualifier_attribute_context,qualifier_attribute,qualifier_attribute_value
27212: from qp_preq_qual_tmp
27213: where pricing_phase_id = p_pricing_phase_id
27214: and pricing_status_code = 'X'
27215: order by 1,2,3)
27216: loop

Line 27318: engine_debug('Inserting no rows into qp_preq_qual_tmp for each line index');

27314: , G_HEADER_LIMIT_EXISTS_TBL_Q LIMIT nROWS;
27315: EXIT WHEN G_LIST_HEADER_ID_TBL_Q.COUNT = 0;
27316:
27317: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
27318: engine_debug('Inserting no rows into qp_preq_qual_tmp for each line index');
27319: END IF;
27320: IF (G_LIST_HEADER_ID_TBL_Q.COUNT > 0) THEN
27321:
27322: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_UPDATED;

Line 27324: engine_debug('Inserting rows into qp_preq_qual_tmp for each line index: ' || G_LIST_HEADER_ID_TBL_Q.COUNT);

27320: IF (G_LIST_HEADER_ID_TBL_Q.COUNT > 0) THEN
27321:
27322: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_UPDATED;
27323: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
27324: engine_debug('Inserting rows into qp_preq_qual_tmp for each line index: ' || G_LIST_HEADER_ID_TBL_Q.COUNT);
27325:
27326: END IF;
27327: INSERT_QUAL(
27328: G_LIST_HEADER_ID_TBL_Q

Line 27471: engine_debug('Inserting no rows into qp_preq_qual_tmp for each line index');

27467: , G_DERIVED_QUALIFIER_FLAG_TBL_Q LIMIT nROWS; -- Added for TCA
27468: EXIT WHEN G_LIST_HEADER_ID_TBL_Q.COUNT = 0;
27469:
27470: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
27471: engine_debug('Inserting no rows into qp_preq_qual_tmp for each line index');
27472: END IF;
27473: IF (G_LIST_HEADER_ID_TBL_Q.COUNT > 0) THEN
27474:
27475: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_UPDATED;

Line 27477: engine_debug('Inserting rows into qp_preq_qual_tmp for each line index: ' || G_LIST_HEADER_ID_TBL_Q.COUNT);

27473: IF (G_LIST_HEADER_ID_TBL_Q.COUNT > 0) THEN
27474:
27475: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_UPDATED;
27476: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
27477: engine_debug('Inserting rows into qp_preq_qual_tmp for each line index: ' || G_LIST_HEADER_ID_TBL_Q.COUNT);
27478: END IF;
27479: qp_debug_util.tstart('INSERT_QUAL','Cursor INSERT_QUAL');
27480: INSERT_QUAL(
27481: G_LIST_HEADER_ID_TBL_Q

Line 37197: --Delete From QP_PREQ_QUAL_TMP;

37193: --Delete from qp_npreq_lines_tmp;
37194: --Delete from qp_npreq_line_attrs_tmp;
37195: --Delete From qp_npreq_ldets_tmp;
37196: --Delete From qp_npreq_rltd_lines_tmp;
37197: --Delete From QP_PREQ_QUAL_TMP;
37198: --Delete From qp_nformula_step_values_tmp;
37199: --Delete From QP_PREQ_LINE_ATTRS_FORMULA_TMP;
37200:
37201: