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.

[Home] [Help]

APPS.QP_PREQ_GRP dependencies on QP_PREQ_QUAL_TMP

Line 590: Insert into QP_PREQ_QUAL_TMP

586: l_routine VARCHAR2(240):= 'Routine:QP_PREQ_GRP.INSERT_QUAL';
587:
588: BEGIN
589: FORALL i in p_list_header_id.FIRST..p_list_header_id.LAST
590: Insert into QP_PREQ_QUAL_TMP
591: ( LIST_HEADER_ID
592: , LIST_LINE_ID
593: , LINE_INDEX
594: , QUALIFIER_ATTRIBUTE_LEVEL

Line 767: from qp_preq_qual_tmp

763: qph.limit_exists_flag,
764: qplatq.derived_qualifier_flag -- Added for TCA
765: from
766: (select distinct list_header_id,list_line_id,qualifier_grouping_no
767: from qp_preq_qual_tmp
768: where pricing_status_code = G_STATUS_UNCHANGED
769: and pricing_phase_id = p_pricing_phase_id) qptq,
770: qp_qualifiers qpq ,
771: qp_npreq_line_attrs_tmp qplatq,

Line 862: from qp_preq_qual_tmp

858: qph.limit_exists_flag,
859: qplatq.derived_qualifier_flag -- Added for TCA
860: from
861: (select distinct list_header_id,list_line_id
862: from qp_preq_qual_tmp
863: where pricing_status_code = G_STATUS_UNCHANGED
864: and pricing_phase_id = p_pricing_phase_id) qptq,
865: qp_qualifiers qpq ,
866: qp_npreq_line_attrs_tmp qplatq,

Line 954: from qp_preq_qual_tmp

950: qph.limit_exists_flag,
951: qplatq.derived_qualifier_flag -- Added for TCA
952: from
953: (select distinct list_header_id,list_line_id,qualifier_grouping_no
954: from qp_preq_qual_tmp
955: where pricing_status_code = G_STATUS_UNCHANGED
956: and pricing_phase_id = p_pricing_phase_id) qptq,
957: qp_qualifiers qpq ,
958: qp_npreq_line_attrs_tmp qplatq,

Line 1051: from qp_preq_qual_tmp

1047: qph.limit_exists_flag,
1048: qplatq.derived_qualifier_flag -- Added for TCA
1049: from
1050: (select distinct list_header_id,list_line_id
1051: from qp_preq_qual_tmp
1052: where pricing_status_code = G_STATUS_UNCHANGED
1053: and pricing_phase_id = p_pricing_phase_id) qptq,
1054: qp_qualifiers qpq ,
1055: qp_npreq_line_attrs_tmp qplatq,

Line 1145: from qp_preq_qual_tmp

1141: qph.limit_exists_flag,
1142: qplatq.derived_qualifier_flag -- Added for TCA
1143: from
1144: (select distinct list_header_id,list_line_id,qualifier_grouping_no
1145: from qp_preq_qual_tmp
1146: where pricing_status_code = G_STATUS_UNCHANGED
1147: and pricing_phase_id = p_pricing_phase_id) qptq,
1148: qp_qualifiers qpq ,
1149: qp_npreq_line_attrs_tmp qplatq,

Line 1243: from qp_preq_qual_tmp

1239: qph.limit_exists_flag,
1240: qplatq.derived_qualifier_flag -- Added for TCA
1241: from
1242: (select distinct list_header_id,list_line_id
1243: from qp_preq_qual_tmp
1244: where pricing_status_code = G_STATUS_UNCHANGED
1245: and pricing_phase_id = p_pricing_phase_id) qptq,
1246: qp_qualifiers qpq ,
1247: qp_npreq_line_attrs_tmp qplatq,

Line 1339: from qp_preq_qual_tmp

1335: qph.limit_exists_flag,
1336: qplatq.derived_qualifier_flag -- Added for TCA
1337: from
1338: (select distinct list_header_id,list_line_id,qualifier_grouping_no
1339: from qp_preq_qual_tmp
1340: where pricing_status_code = G_STATUS_UNCHANGED
1341: and pricing_phase_id = p_pricing_phase_id) qptq,
1342: qp_qualifiers qpq ,
1343: qp_npreq_line_attrs_tmp qplatq,

Line 1434: from qp_preq_qual_tmp

1430: qph.limit_exists_flag,
1431: qplatq.derived_qualifier_flag -- Added for TCA
1432: from
1433: (select distinct list_header_id,list_line_id
1434: from qp_preq_qual_tmp
1435: where pricing_status_code = G_STATUS_UNCHANGED
1436: and pricing_phase_id = p_pricing_phase_id) qptq,
1437: qp_qualifiers qpq ,
1438: qp_npreq_line_attrs_tmp qplatq,

Line 1491: --Delete from QP_PREQ_QUAL_TMP;

1487: E_ROUTINE_ERRORS EXCEPTION;
1488:
1489: BEGIN
1490:
1491: --Delete from QP_PREQ_QUAL_TMP;
1492:
1493: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_EMPTY;
1494:
1495: OPEN l_mini_outer_qual_cur;

Line 1748: FROM qp_preq_qual_tmp

1744: and qpq.comparison_operator_code = '='
1745: and qpq.search_ind = 1
1746: and qpq.list_line_id <> -1
1747: and ( qpq.list_header_id in (SELECT distinct list_header_id -- for qualified headers from Cache_Header_Qualifiers
1748: FROM qp_preq_qual_tmp
1749: WHERE pricing_phase_id = p_pricing_phase_id
1750: AND pricing_status_code = G_STATUS_UNCHANGED)
1751: or
1752: qpq.header_quals_exist_flag = G_NO) -- Pure line level qualifiers

Line 1863: FROM qp_preq_qual_tmp

1859: and qpq.qualifier_datatype = G_NUMERIC
1860: and qpq.search_ind = 1
1861: and qpq.list_line_id <> -1
1862: and ( qpq.list_header_id in (SELECT distinct list_header_id
1863: FROM qp_preq_qual_tmp
1864: WHERE pricing_phase_id = p_pricing_phase_id
1865: AND pricing_status_code = G_STATUS_UNCHANGED)
1866: or
1867: qpq.header_quals_exist_flag = G_NO)

Line 1979: FROM qp_preq_qual_tmp

1975: and qpq.comparison_operator_code = G_OPERATOR_BETWEEN
1976: and qpq.search_ind = 1
1977: and qpq.list_line_id <> -1
1978: and ( qpq.list_header_id in (SELECT distinct list_header_id
1979: FROM qp_preq_qual_tmp
1980: WHERE pricing_phase_id = p_pricing_phase_id
1981: AND pricing_status_code = G_STATUS_UNCHANGED)
1982: or
1983: qpq.header_quals_exist_flag = G_NO)

Line 2098: FROM qp_preq_qual_tmp

2094: and qpq.qualifier_attr_value <> qplatq.value_from
2095: and qpq.search_ind = 1
2096: and qpq.list_line_id <> -1
2097: and ( qpq.list_header_id in (SELECT distinct list_header_id
2098: FROM qp_preq_qual_tmp
2099: WHERE pricing_phase_id = p_pricing_phase_id
2100: AND pricing_status_code = G_STATUS_UNCHANGED)
2101: or
2102: qpq.header_quals_exist_flag = G_NO)

Line 2158: --Delete from QP_PREQ_QUAL_TMP;

2154: l_routine VARCHAR2(240):= 'Routine:QP_PREQ_GRP.Cache_Line_Qualifiers';
2155:
2156: BEGIN
2157:
2158: --Delete from QP_PREQ_QUAL_TMP;
2159:
2160: G_LINE_QUALIFIER_TEMP := 'E';
2161:
2162: OPEN l_outer_qual_cur;

Line 2312: UPDATE QP_PREQ_QUAL_TMP a

2308: -- Nitin
2309: -- addeded check to delete header level qualifiers if no line qualifier is selected
2310: -- and the header has no lines without line level qualifier in that phase.
2311:
2312: UPDATE QP_PREQ_QUAL_TMP a
2313: SET a.PRICING_STATUS_CODE = G_DELETED_GRP
2314: WHERE
2315: a.list_line_id = '-1'
2316: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED

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

2316: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
2317: AND a.PRICING_PHASE_ID = p_pricing_phase_id
2318: and a.line_index is null
2319: and not exists
2320: (select 'x' from qp_preq_qual_tmp b where
2321: b.list_header_id = a.list_header_id
2322: and b.list_line_id <> '-1'
2323: and b.pricing_phase_id = p_pricing_phase_id
2324: and b.pricing_status_code = G_STATUS_UNCHANGED

Line 2776: --Delete from QP_PREQ_QUAL_TMP;

2772: l_routine VARCHAR2(240):= 'Routine:QP_PREQ_GRP.Cache_Header_Qualifiers';
2773:
2774: BEGIN
2775:
2776: --Delete from QP_PREQ_QUAL_TMP;
2777:
2778: G_QUALIFIER_TEMP := 'E';
2779:
2780: OPEN l_outer_qual_cur;

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

7845:
7846: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
7847: engine_debug('Entering '||l_routine);
7848: END IF;
7849: UPDATE /*+ index(a qpprod QP_PREQ_QUAL_TMP_N1) dynamic_sampling(1) */ qp_preq_qual_tmp a --5658579
7850: --UPDATE qp_preq_qual_tmp a
7851: SET pricing_status_code = G_STATUS_DELETED
7852: WHERE pricing_status_code = G_STATUS_UNCHANGED
7853: AND pricing_phase_id = p_pricing_phase_id

Line 7850: --UPDATE qp_preq_qual_tmp a

7846: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
7847: engine_debug('Entering '||l_routine);
7848: END IF;
7849: UPDATE /*+ index(a qpprod QP_PREQ_QUAL_TMP_N1) dynamic_sampling(1) */ qp_preq_qual_tmp a --5658579
7850: --UPDATE qp_preq_qual_tmp a
7851: SET pricing_status_code = G_STATUS_DELETED
7852: WHERE pricing_status_code = G_STATUS_UNCHANGED
7853: AND pricing_phase_id = p_pricing_phase_id
7854: AND list_line_id = -1

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

20731: x_status_code OUT NOCOPY VARCHAR2,
20732: x_status_text OUT NOCOPY VARCHAR2) AS
20733:
20734: /*
20735: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20736: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20737: */
20738: CURSOR header_level_qual_attrs_cur IS
20739: SELECT a.LIST_HEADER_ID,

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

20732: x_status_text OUT NOCOPY VARCHAR2) AS
20733:
20734: /*
20735: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20736: INDX,QP_PREQ_GRP.perform_qualifier_grouping.header_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20737: */
20738: CURSOR header_level_qual_attrs_cur IS
20739: SELECT a.LIST_HEADER_ID,
20740: a.QUALIFIER_GROUPING_NO,

Line 20746: FROM QP_PREQ_QUAL_TMP a

20742: a.UNIQUE_KEY,
20743: -- COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP [julin/3527596,4274099]
20744: COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP,
20745: 1 --7038849
20746: FROM QP_PREQ_QUAL_TMP a
20747: WHERE a.LIST_LINE_ID = -1
20748: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20749: AND a.PRICING_PHASE_ID = p_pricing_phase_id
20750: AND a.QUALIFIER_GROUPING_NO = -1 --7038849

Line 20760: FROM QP_PREQ_QUAL_TMP a

20756: a.UNIQUE_KEY,
20757: -- COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP [julin/3527596,4274099]
20758: COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP,
20759: 2 --7038849
20760: FROM QP_PREQ_QUAL_TMP a
20761: WHERE a.LIST_LINE_ID = -1
20762: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20763: AND a.PRICING_PHASE_ID = p_pricing_phase_id
20764: AND a.QUALIFIER_GROUPING_NO <> -1 --7038849

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

20765: GROUP BY a.LIST_HEADER_ID, a.QUALIFIER_GROUPING_NO,a.QUALIFIER_GROUP_CNT,a.UNIQUE_KEY
20766: ORDER BY 1,6; --7038849
20767:
20768: /*
20769: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20770: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20771: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20772: */
20773: CURSOR hdr_lvl_qual_attrs_req_line IS

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

20766: ORDER BY 1,6; --7038849
20767:
20768: /*
20769: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20770: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20771: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20772: */
20773: CURSOR hdr_lvl_qual_attrs_req_line IS
20774: SELECT a.LINE_INDEX,

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

20767:
20768: /*
20769: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20770: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20771: INDX,QP_PREQ_GRP.perform_qualifier_grouping.hdr_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20772: */
20773: CURSOR hdr_lvl_qual_attrs_req_line IS
20774: SELECT a.LINE_INDEX,
20775: a.LIST_HEADER_ID,

Line 20782: FROM QP_PREQ_QUAL_TMP a

20778: a.UNIQUE_KEY,
20779: -- COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP [julin/3527596,4274099]
20780: COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP,
20781: 1 -- 7038849
20782: FROM QP_PREQ_QUAL_TMP a
20783: WHERE a.LIST_LINE_ID = -1
20784: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20785: AND a.PRICING_PHASE_ID = p_pricing_phase_id
20786: --AND a.LINE_INDEX > 0

Line 20798: FROM QP_PREQ_QUAL_TMP a

20794: a.UNIQUE_KEY,
20795: -- COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP [julin/3527596,4274099]
20796: COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP,
20797: 2 -- 7038849
20798: FROM QP_PREQ_QUAL_TMP a
20799: WHERE a.LIST_LINE_ID = -1
20800: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20801: AND a.PRICING_PHASE_ID = p_pricing_phase_id
20802: --AND a.LINE_INDEX > 0

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

20804: GROUP BY a.LINE_INDEX , a.LIST_HEADER_ID, a.QUALIFIER_GROUPING_NO,a.QUALIFIER_GROUP_CNT,a.UNIQUE_KEY
20805: ORDER BY 1,2,7; --7038849
20806:
20807: /*
20808: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
20809: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
20810: */
20811: CURSOR line_level_qual_attrs_cur IS
20812: SELECT a.LIST_HEADER_ID,

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

20805: ORDER BY 1,2,7; --7038849
20806:
20807: /*
20808: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
20809: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_level_qual_attrs_cur,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
20810: */
20811: CURSOR line_level_qual_attrs_cur IS
20812: SELECT a.LIST_HEADER_ID,
20813: a.LIST_LINE_ID,

Line 20821: FROM QP_PREQ_QUAL_TMP a

20817: a.UNIQUE_KEY,
20818: -- COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP [julin/3527596,4274099]
20819: COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP,
20820: 1 --7038849
20821: FROM QP_PREQ_QUAL_TMP a
20822: WHERE a.LIST_LINE_ID > 0
20823: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20824: AND a.PRICING_PHASE_ID = p_pricing_phase_id
20825: AND a.QUALIFIER_GROUPING_NO = -1 --7038849

Line 20838: FROM QP_PREQ_QUAL_TMP a

20834: a.UNIQUE_KEY,
20835: -- COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP [julin/3527596,4274099]
20836: COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP,
20837: 2 --7038849
20838: FROM QP_PREQ_QUAL_TMP a
20839: WHERE a.LIST_LINE_ID > 0
20840: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20841: AND a.PRICING_PHASE_ID = p_pricing_phase_id
20842: AND a.QUALIFIER_GROUPING_NO <> -1 --7038849

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

20844: a.UNIQUE_KEY
20845: ORDER BY 1,2,8; --7038849
20846:
20847: /*
20848: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20849: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20850: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20851: */
20852: CURSOR line_lvl_qual_attrs_req_line IS

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

20845: ORDER BY 1,2,8; --7038849
20846:
20847: /*
20848: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20849: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20850: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20851: */
20852: CURSOR line_lvl_qual_attrs_req_line IS
20853: SELECT /*+ INDEX (a QP_PREQ_QUAL_TMP_N1) */ a.LINE_INDEX,

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

20846:
20847: /*
20848: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20849: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20850: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20851: */
20852: CURSOR line_lvl_qual_attrs_req_line IS
20853: SELECT /*+ INDEX (a QP_PREQ_QUAL_TMP_N1) */ a.LINE_INDEX,
20854: a.LIST_HEADER_ID,

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

20849: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20850: INDX,QP_PREQ_GRP.perform_qualifier_grouping.line_lvl_qual_attrs_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20851: */
20852: CURSOR line_lvl_qual_attrs_req_line IS
20853: SELECT /*+ INDEX (a QP_PREQ_QUAL_TMP_N1) */ a.LINE_INDEX,
20854: a.LIST_HEADER_ID,
20855: a.LIST_LINE_ID,
20856: a.QUALIFIER_GROUPING_NO,
20857: a.QUALIFIER_GROUP_CNT,

Line 20863: FROM QP_PREQ_QUAL_TMP a

20859: a.UNIQUE_KEY,
20860: -- COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP [julin/3527596,4274099]
20861: COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP,
20862: 1
20863: FROM QP_PREQ_QUAL_TMP a
20864: WHERE LIST_LINE_ID > 0
20865: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20866: --AND a.LINE_INDEX > 0
20867: AND a.PRICING_PHASE_ID = p_pricing_phase_id

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

20868: AND a.QUALIFIER_GROUPING_NO = -1 --7038849
20869: GROUP BY a.LINE_INDEX, a.LIST_HEADER_ID , a.LIST_LINE_ID,a.QUALIFIER_GROUPING_NO,
20870: a.QUALIFIER_GROUP_CNT,a.HEADER_QUALS_EXIST_FLAG,a.UNIQUE_KEY
20871: UNION ALL --7038849
20872: SELECT /*+ INDEX (a QP_PREQ_QUAL_TMP_N1) */ a.LINE_INDEX,
20873: a.LIST_HEADER_ID,
20874: a.LIST_LINE_ID,
20875: a.QUALIFIER_GROUPING_NO,
20876: a.QUALIFIER_GROUP_CNT,

Line 20882: FROM QP_PREQ_QUAL_TMP a

20878: a.UNIQUE_KEY,
20879: -- COUNT(distinct qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP [julin/3527596,4274099]
20880: COUNT(qualifier_attribute_context || qualifier_attribute || setup_value_from ) NO_OF_QUALIFIERS_IN_GRP,
20881: 2
20882: FROM QP_PREQ_QUAL_TMP a
20883: WHERE LIST_LINE_ID > 0
20884: AND a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20885: --AND a.LINE_INDEX > 0
20886: AND a.PRICING_PHASE_ID = p_pricing_phase_id

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

20889: a.QUALIFIER_GROUP_CNT,a.HEADER_QUALS_EXIST_FLAG,a.UNIQUE_KEY
20890: ORDER BY 1,2,3,9; --7038849
20891:
20892: /*
20893: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20894: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20895: */
20896: CURSOR check_hdr_quals_cur(p_list_header_id NUMBER) IS
20897: SELECT LIST_HEADER_ID

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

20890: ORDER BY 1,2,3,9; --7038849
20891:
20892: /*
20893: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20894: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20895: */
20896: CURSOR check_hdr_quals_cur(p_list_header_id NUMBER) IS
20897: SELECT LIST_HEADER_ID
20898: FROM QP_PREQ_QUAL_TMP

Line 20898: FROM QP_PREQ_QUAL_TMP

20894: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20895: */
20896: CURSOR check_hdr_quals_cur(p_list_header_id NUMBER) IS
20897: SELECT LIST_HEADER_ID
20898: FROM QP_PREQ_QUAL_TMP
20899: WHERE LIST_HEADER_ID = p_list_header_id
20900: AND LIST_LINE_ID = -1
20901: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
20902: AND PRICING_PHASE_ID = p_pricing_phase_id

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

20902: AND PRICING_PHASE_ID = p_pricing_phase_id
20903: AND ROWNUM = 1;
20904:
20905: /*
20906: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20907: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20908: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20909: */
20910: CURSOR check_hdr_quals_cur_req_line(p_list_header_id NUMBER,

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

20903: AND ROWNUM = 1;
20904:
20905: /*
20906: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20907: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20908: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20909: */
20910: CURSOR check_hdr_quals_cur_req_line(p_list_header_id NUMBER,
20911: p_line_index NUMBER) IS

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

20904:
20905: /*
20906: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LIST_LINE_ID,1
20907: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,PRICING_STATUS_CODE,2
20908: INDX,QP_PREQ_GRP.perform_qualifier_grouping.check_hdr_quals_cur_req_line,QP_PREQ_QUAL_TMP_N1,LINE_INDEX,3
20909: */
20910: CURSOR check_hdr_quals_cur_req_line(p_list_header_id NUMBER,
20911: p_line_index NUMBER) IS
20912: SELECT LIST_HEADER_ID

Line 20913: FROM QP_PREQ_QUAL_TMP

20909: */
20910: CURSOR check_hdr_quals_cur_req_line(p_list_header_id NUMBER,
20911: p_line_index NUMBER) IS
20912: SELECT LIST_HEADER_ID
20913: FROM QP_PREQ_QUAL_TMP
20914: WHERE LIST_HEADER_ID = p_list_header_id
20915: AND LINE_INDEX = p_line_index
20916: AND LIST_LINE_ID = -1
20917: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED

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

21099: END IF;
21100: IF (l_hdr_del_tbl.count > 0) THEN
21101: FORALL i in l_hdr_del_tbl.FIRST..l_hdr_del_tbl.LAST
21102: /*
21103: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21104: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21105: */
21106: UPDATE QP_PREQ_QUAL_TMP --upd1
21107: SET PRICING_STATUS_CODE = G_DELETED_GRP

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

21100: IF (l_hdr_del_tbl.count > 0) THEN
21101: FORALL i in l_hdr_del_tbl.FIRST..l_hdr_del_tbl.LAST
21102: /*
21103: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21104: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21105: */
21106: UPDATE QP_PREQ_QUAL_TMP --upd1
21107: SET PRICING_STATUS_CODE = G_DELETED_GRP
21108: WHERE UNIQUE_KEY = l_hdr_del_tbl(i)

Line 21106: UPDATE QP_PREQ_QUAL_TMP --upd1

21102: /*
21103: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21104: INDX,QP_PREQ_GRP.perform_qualifier_grouping.upd1,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21105: */
21106: UPDATE QP_PREQ_QUAL_TMP --upd1
21107: SET PRICING_STATUS_CODE = G_DELETED_GRP
21108: WHERE UNIQUE_KEY = l_hdr_del_tbl(i)
21109: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
21110: AND PRICING_PHASE_ID = p_pricing_phase_id;

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

21273:
21274: IF (l_line_del_tbl.count > 0 ) THEN
21275: FORALL i in l_line_del_tbl.FIRST..l_line_del_tbl.LAST
21276: /*
21277: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21278: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21279: */
21280: UPDATE QP_PREQ_QUAL_TMP --upd2
21281: SET PRICING_STATUS_CODE = G_DELETED_GRP

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

21274: IF (l_line_del_tbl.count > 0 ) THEN
21275: FORALL i in l_line_del_tbl.FIRST..l_line_del_tbl.LAST
21276: /*
21277: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21278: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21279: */
21280: UPDATE QP_PREQ_QUAL_TMP --upd2
21281: SET PRICING_STATUS_CODE = G_DELETED_GRP
21282: WHERE UNIQUE_KEY = l_line_del_tbl(i)

Line 21280: UPDATE QP_PREQ_QUAL_TMP --upd2

21276: /*
21277: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21278: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd2,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21279: */
21280: UPDATE QP_PREQ_QUAL_TMP --upd2
21281: SET PRICING_STATUS_CODE = G_DELETED_GRP
21282: WHERE UNIQUE_KEY = l_line_del_tbl(i)
21283: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
21284: AND PRICING_PHASE_ID = p_pricing_phase_id;

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

21419: END IF;
21420: IF (l_hdr_del_tbl.count > 0) THEN
21421: FORALL i in l_hdr_del_tbl.FIRST..l_hdr_del_tbl.LAST
21422: /*
21423: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21424: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21425: */
21426: UPDATE QP_PREQ_QUAL_TMP --upd3
21427: SET PRICING_STATUS_CODE = G_DELETED_GRP

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

21420: IF (l_hdr_del_tbl.count > 0) THEN
21421: FORALL i in l_hdr_del_tbl.FIRST..l_hdr_del_tbl.LAST
21422: /*
21423: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21424: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21425: */
21426: UPDATE QP_PREQ_QUAL_TMP --upd3
21427: SET PRICING_STATUS_CODE = G_DELETED_GRP
21428: WHERE UNIQUE_KEY = l_hdr_del_tbl(i)

Line 21426: UPDATE QP_PREQ_QUAL_TMP --upd3

21422: /*
21423: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21424: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd3,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21425: */
21426: UPDATE QP_PREQ_QUAL_TMP --upd3
21427: SET PRICING_STATUS_CODE = G_DELETED_GRP
21428: WHERE UNIQUE_KEY = l_hdr_del_tbl(i)
21429: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
21430: AND PRICING_PHASE_ID = p_pricing_phase_id;

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

21610:
21611: IF (l_line_del_tbl.count > 0 ) THEN
21612: FORALL i in l_line_del_tbl.FIRST..l_line_del_tbl.LAST
21613: /*
21614: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21615: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21616: */
21617: UPDATE QP_PREQ_QUAL_TMP --upd4
21618: SET PRICING_STATUS_CODE = G_DELETED_GRP

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

21611: IF (l_line_del_tbl.count > 0 ) THEN
21612: FORALL i in l_line_del_tbl.FIRST..l_line_del_tbl.LAST
21613: /*
21614: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21615: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21616: */
21617: UPDATE QP_PREQ_QUAL_TMP --upd4
21618: SET PRICING_STATUS_CODE = G_DELETED_GRP
21619: WHERE UNIQUE_KEY = l_line_del_tbl(i)

Line 21617: UPDATE QP_PREQ_QUAL_TMP --upd4

21613: /*
21614: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
21615: INDX,QP_PREQ_GRP.perform_qualifier_grouping.perform_qualifier_grouping_upd4,QP_PREQ_QUAL_TMP_N3,UNIQUE_KEY,2
21616: */
21617: UPDATE QP_PREQ_QUAL_TMP --upd4
21618: SET PRICING_STATUS_CODE = G_DELETED_GRP
21619: WHERE UNIQUE_KEY = l_line_del_tbl(i)
21620: AND PRICING_STATUS_CODE = G_STATUS_UNCHANGED
21621: AND PRICING_PHASE_ID = p_pricing_phase_id;

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

21644: x_status_code OUT NOCOPY VARCHAR2,
21645: x_status_text OUT NOCOPY VARCHAR2)
21646: AS
21647: /*
21648: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21649: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21650:
21651: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
21652: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2

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

21645: x_status_text OUT NOCOPY VARCHAR2)
21646: AS
21647: /*
21648: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21649: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21650:
21651: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
21652: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
21653: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3

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

21712: qpl.accum_context, -- accum range break
21713: qpl.accum_attribute, -- accum range break
21714: qpl.accum_attr_run_src_flag -- accum range break
21715: from
21716: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
21717: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
21718: from qp_preq_qual_tmp qpqq
21719: where pricing_status_code = G_STATUS_UNCHANGED
21720: and pricing_phase_id = p_pricing_phase_id

Line 21718: from qp_preq_qual_tmp qpqq

21714: qpl.accum_attr_run_src_flag -- accum range break
21715: from
21716: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
21717: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
21718: from qp_preq_qual_tmp qpqq
21719: where pricing_status_code = G_STATUS_UNCHANGED
21720: and pricing_phase_id = p_pricing_phase_id
21721: and search_ind = 1
21722: and list_line_id > 0 ) qpq,

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

21801: qpl.accum_context, -- accum range break
21802: qpl.accum_attribute, -- accum range break
21803: qpl.accum_attr_run_src_flag -- accum range break
21804: from
21805: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
21806: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
21807: from qp_preq_qual_tmp qpqq
21808: where pricing_status_code = G_STATUS_UNCHANGED
21809: and pricing_phase_id = p_pricing_phase_id

Line 21807: from qp_preq_qual_tmp qpqq

21803: qpl.accum_attr_run_src_flag -- accum range break
21804: from
21805: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
21806: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
21807: from qp_preq_qual_tmp qpqq
21808: where pricing_status_code = G_STATUS_UNCHANGED
21809: and pricing_phase_id = p_pricing_phase_id
21810: and search_ind = 1
21811: and list_line_id < 0 ) qpq,

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

21853: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
21854: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
21855: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
21856:
21857: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21858: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21859: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
21860: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
21861: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5

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

21854: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
21855: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
21856:
21857: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21858: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21859: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
21860: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
21861: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
21862:

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

21855: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
21856:
21857: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21858: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21859: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
21860: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
21861: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
21862:
21863: -- Used for qplatpr and qplatpc

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

21856:
21857: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21858: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21859: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
21860: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
21861: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
21862:
21863: -- Used for qplatpr and qplatpc
21864: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1

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

21857: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21858: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21859: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
21860: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_LINE_ID,4
21861: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
21862:
21863: -- Used for qplatpr and qplatpc
21864: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
21865: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2

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

21872:
21873: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_INDEX,1
21874: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_TYPE_CODE,2
21875:
21876: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21877: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21878: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
21879:
21880: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1

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

21873: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_INDEX,1
21874: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_TYPE_CODE,2
21875:
21876: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21877: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21878: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
21879:
21880: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
21881: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2

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

21874: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_lines_tmp_U1,LINE_TYPE_CODE,2
21875:
21876: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
21877: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
21878: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
21879:
21880: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
21881: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
21882: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3

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

21954: qpl.accum_context, -- accum range break
21955: qpl.accum_attribute, -- accum range break
21956: qpl.accum_attr_run_src_flag -- accum range break
21957: from
21958: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
21959: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
21960: from qp_preq_qual_tmp qpqq
21961: where pricing_status_code = G_STATUS_UNCHANGED
21962: and pricing_phase_id = p_pricing_phase_id

Line 21960: from qp_preq_qual_tmp qpqq

21956: qpl.accum_attr_run_src_flag -- accum range break
21957: from
21958: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
21959: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
21960: from qp_preq_qual_tmp qpqq
21961: where pricing_status_code = G_STATUS_UNCHANGED
21962: and pricing_phase_id = p_pricing_phase_id
21963: and search_ind = 1
21964: and list_line_id > 0 ) qpq,

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

22067: qpl.accum_context, -- accum range break
22068: qpl.accum_attribute, -- accum range break
22069: qpl.accum_attr_run_src_flag -- accum range break
22070: from
22071: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
22072: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
22073: from qp_preq_qual_tmp qpqq
22074: where pricing_status_code = G_STATUS_UNCHANGED
22075: and pricing_phase_id = p_pricing_phase_id

Line 22073: from qp_preq_qual_tmp qpqq

22069: qpl.accum_attr_run_src_flag -- accum range break
22070: from
22071: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
22072: distinct line_index, list_header_id, list_line_id, ask_for_flag,created_from_list_type,header_limit_exists
22073: from qp_preq_qual_tmp qpqq
22074: where pricing_status_code = G_STATUS_UNCHANGED
22075: and pricing_phase_id = p_pricing_phase_id
22076: and search_ind = 1
22077: and list_line_id < 0 ) qpq,

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

22121: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
22122: order by 4,2;
22123:
22124: /*
22125: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
22126: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
22127: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3
22128: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4
22129:

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

22122: order by 4,2;
22123:
22124: /*
22125: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
22126: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
22127: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3
22128: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4
22129:
22130: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1

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

22123:
22124: /*
22125: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
22126: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
22127: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3
22128: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4
22129:
22130: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1
22131: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2

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

22124: /*
22125: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
22126: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
22127: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_header_id,3
22128: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,list_line_id,4
22129:
22130: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1
22131: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2
22132: */

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

22174: qpl.accum_context, -- accum range break
22175: qpl.accum_attribute, -- accum range break
22176: qpl.accum_attr_run_src_flag -- accum range break
22177: from
22178: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
22179: distinct line_index, line_type_code,pricing_effective_date,list_header_id, list_line_id,
22180: ask_for_flag, created_from_list_type,header_limit_exists
22181: from qp_preq_qual_tmp qpqq
22182: where pricing_status_code = G_STATUS_UNCHANGED

Line 22181: from qp_preq_qual_tmp qpqq

22177: from
22178: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
22179: distinct line_index, line_type_code,pricing_effective_date,list_header_id, list_line_id,
22180: ask_for_flag, created_from_list_type,header_limit_exists
22181: from qp_preq_qual_tmp qpqq
22182: where pricing_status_code = G_STATUS_UNCHANGED
22183: and pricing_phase_id = p_pricing_phase_id
22184: and search_ind = 1
22185: and list_line_id > 0 ) qpq,

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

22240: qpl.accum_context, -- accum range break
22241: qpl.accum_attribute, -- accum range break
22242: qpl.accum_attr_run_src_flag -- accum range break
22243: from
22244: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
22245: distinct line_index, line_type_code,pricing_effective_date,list_header_id, list_line_id,
22246: ask_for_flag, created_from_list_type,header_limit_exists
22247: from qp_preq_qual_tmp qpqq
22248: where pricing_status_code = G_STATUS_UNCHANGED

Line 22247: from qp_preq_qual_tmp qpqq

22243: from
22244: (select /*+ index (qpqq QP_PREQ_QUAL_TMP_N5) */
22245: distinct line_index, line_type_code,pricing_effective_date,list_header_id, list_line_id,
22246: ask_for_flag, created_from_list_type,header_limit_exists
22247: from qp_preq_qual_tmp qpqq
22248: where pricing_status_code = G_STATUS_UNCHANGED
22249: and pricing_phase_id = p_pricing_phase_id
22250: and search_ind = 1
22251: and list_line_id < 0 ) qpq,

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

22785: */
22786:
22787:
22788: /*
22789: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
22790: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
22791: */
22792: CURSOR l_get_line_index_details IS
22793: SELECT distinct

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

22786:
22787:
22788: /*
22789: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
22790: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_details,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
22791: */
22792: CURSOR l_get_line_index_details IS
22793: SELECT distinct
22794: c.LIST_HEADER_ID,

Line 22803: FROM QP_PREQ_QUAL_TMP c

22799: c.PRICING_EFFECTIVE_DATE,
22800: c.START_DATE_ACTIVE_FIRST,
22801: c.START_DATE_ACTIVE_SECOND,
22802: c.LINE_TYPE_CODE
22803: FROM QP_PREQ_QUAL_TMP c
22804: WHERE c.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
22805: AND c.LINE_INDEX > 0
22806: ORDER BY c.LINE_INDEX;
22807:

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

22812: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
22813: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
22814: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
22815:
22816: INDX,QP_PREQ_GRP.select_modifiers.l_get_line_index_for_quals,QP_PREQ_QUAL_TMP_N3,PRICING_STATUS_CODE,1
22817:
22818: -- Full table scan on qp_npreq_lines_tmp
22819: */
22820:

Line 22867: QP_PREQ_QUAL_TMP c ,

22863: NULL ACTIVE_DATE_SECOND_TYPE,
22864: c.HEADER_LIMIT_EXISTS,
22865: a.DERIVED_QUALIFIER_FLAG -- Added for TCA
22866: FROM qp_npreq_lines_tmp b,
22867: QP_PREQ_QUAL_TMP c ,
22868: qp_npreq_line_attrs_tmp a
22869: WHERE a.CONTEXT = c.QUALIFIER_ATTRIBUTE_CONTEXT
22870: AND a.ATTRIBUTE = c.QUALIFIER_ATTRIBUTE
22871: AND a.VALUE_FROM = c.QUALIFIER_ATTRIBUTE_VALUE

Line 22958: QP_PREQ_QUAL_TMP c ,

22954: NULL ACTIVE_DATE_FIRST_TYPE,
22955: NULL ACTIVE_DATE_SECOND_TYPE,
22956: c.HEADER_LIMIT_EXISTS
22957: FROM qp_npreq_lines_tmp b,
22958: QP_PREQ_QUAL_TMP c ,
22959: qp_npreq_line_attrs_tmp a
22960: WHERE a.CONTEXT = c.QUALIFIER_ATTRIBUTE_CONTEXT
22961: AND a.ATTRIBUTE = c.QUALIFIER_ATTRIBUTE
22962: AND a.VALUE_FROM = c.QUALIFIER_ATTRIBUTE_VALUE

Line 23048: QP_PREQ_QUAL_TMP c ,

23044: NULL ACTIVE_DATE_FIRST_TYPE,
23045: NULL ACTIVE_DATE_SECOND_TYPE,
23046: c.HEADER_LIMIT_EXISTS
23047: FROM qp_npreq_lines_tmp b,
23048: QP_PREQ_QUAL_TMP c ,
23049: qp_npreq_line_attrs_tmp a
23050: WHERE a.CONTEXT = c.QUALIFIER_ATTRIBUTE_CONTEXT
23051: AND a.ATTRIBUTE = c.QUALIFIER_ATTRIBUTE
23052: AND a.VALUE_FROM = c.QUALIFIER_ATTRIBUTE_VALUE

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

23094: AND nvl(b.ACTIVE_DATE_SECOND_TYPE,'X') = nvl(c.ACTIVE_DATE_SECOND_TYPE,nvl(b.ACTIVE_DATE_SECOND_TYPE,'X')); -- SHIP
23095: */
23096:
23097: /*
23098: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
23099: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
23100: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
23101: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
23102: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5

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

23095: */
23096:
23097: /*
23098: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
23099: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
23100: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
23101: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
23102: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
23103: */

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

23096:
23097: /*
23098: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
23099: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
23100: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
23101: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
23102: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
23103: */
23104: CURSOR l_get_satisfied_quals(p_list_header_id NUMBER , p_list_line_id NUMBER, p_line_index NUMBER) IS

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

23097: /*
23098: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
23099: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
23100: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
23101: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
23102: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
23103: */
23104: CURSOR l_get_satisfied_quals(p_list_header_id NUMBER , p_list_line_id NUMBER, p_line_index NUMBER) IS
23105: SELECT /*+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals */

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

23098: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LINE_INDEX,1
23099: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_PHASE_ID,2
23100: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,PRICING_STATUS_CODE,3
23101: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
23102: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
23103: */
23104: CURSOR l_get_satisfied_quals(p_list_header_id NUMBER , p_list_line_id NUMBER, p_line_index NUMBER) IS
23105: SELECT /*+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals */
23106: c.LIST_HEADER_ID,

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

23101: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_HEADER_ID,4
23102: INDX,QP_PREQ_GRP.select_modifiers.l_get_satisfied_quals,QP_PREQ_QUAL_TMP_N2,LIST_LINE_ID,5
23103: */
23104: CURSOR l_get_satisfied_quals(p_list_header_id NUMBER , p_list_line_id NUMBER, p_line_index NUMBER) IS
23105: SELECT /*+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals */
23106: c.LIST_HEADER_ID,
23107: c.LIST_LINE_ID,
23108: c.QUALIFIER_GROUP_CNT,
23109: c.HEADER_QUALS_EXIST_FLAG,

Line 23127: FROM QP_PREQ_QUAL_TMP c

23123: c.QUALIFIER_PRICING_ATTR_FLAG,
23124: c.QUALIFIER_OPERATOR_TYPE ,
23125: c.CREATED_FROM_LIST_TYPE,
23126: decode(c.LIST_LINE_ID,-1,'HQ','LQ') QUALIFIER_TYPE
23127: FROM QP_PREQ_QUAL_TMP c
23128: WHERE c.LIST_HEADER_ID = p_list_header_id
23129: AND c.LIST_LINE_ID IN (p_list_line_id,-1)
23130: AND c.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
23131: AND c.LINE_INDEX = p_line_index

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

23132: AND c.PRICING_PHASE_ID = p_pricing_phase_id
23133: UNION
23134: -- To get the -1 group qualifiers for non -1 groups only
23135: -- non -1 groups = OTHERS_GROUP_CNT <> 0
23136: SELECT /*+ INDEX(c QP_PREQ_QUAL_TMP_N1) l_get_satisfied_quals */
23137: c.LIST_HEADER_ID,
23138: c.LIST_LINE_ID,
23139: c.QUALIFIER_GROUP_CNT,
23140: c.HEADER_QUALS_EXIST_FLAG,

Line 23158: FROM QP_PREQ_QUAL_TMP c

23154: c.QUALIFIER_PRICING_ATTR_FLAG,
23155: c.QUALIFIER_OPERATOR_TYPE ,
23156: c.CREATED_FROM_LIST_TYPE,
23157: decode(c.LIST_LINE_ID,-1,'HQ','LQ') QUALIFIER_TYPE
23158: FROM QP_PREQ_QUAL_TMP c
23159: WHERE c.LIST_HEADER_ID = p_list_header_id
23160: AND c.LIST_LINE_ID IN (p_list_line_id,-1)
23161: AND c.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
23162: AND c.PRICING_PHASE_ID = p_pricing_phase_id

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

23169: CURSOR get_list_headers_with_ind2 IS
23170: SELECT/*+ ORDERED */ 'x'
23171: FROM qp_qualifiers b
23172: WHERE b.search_ind = 2
23173: and b.list_header_id in (select distinct a.list_header_id from qp_preq_qual_tmp a
23174: where a.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
23175: and a.search_ind = 1
23176: and a.pricing_phase_id = p_pricing_phase_id)
23177: AND rownum = 1;

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

23275: engine_debug('Caching Qualifiers for phase : ' || p_pricing_phase_id || ' Successful');
23276: END IF;
23277: -- For each primary search list header , list line and qualifier grouping no
23278: /*
23279: INDX,QP_PREQ_GRP.select_modifiers.select_modifiers_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
23280: */
23281: /* FOR c1 in (select list_header_id , list_line_id , qualifier_grouping_no
23282: from qp_preq_qual_tmp
23283: where pricing_status_code = G_STATUS_UNCHANGED

Line 23282: from qp_preq_qual_tmp

23278: /*
23279: INDX,QP_PREQ_GRP.select_modifiers.select_modifiers_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
23280: */
23281: /* FOR c1 in (select list_header_id , list_line_id , qualifier_grouping_no
23282: from qp_preq_qual_tmp
23283: where pricing_status_code = G_STATUS_UNCHANGED
23284: and pricing_phase_id = p_pricing_phase_id
23285: order by list_header_id,list_line_id,qualifier_grouping_no) LOOP
23286: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 23340: --update qp_preq_qual_tmp qpqt1

23336: engine_debug('hw: l_get_line_index_for_quals_n path');
23337:
23338: END IF;
23339: -- update null group count
23340: --update qp_preq_qual_tmp qpqt1
23341: --set qpqt1.null_group_cnt = (select count(*)
23342: from qp_preq_qual_tmp qpqt2
23343: where qpqt2.list_header_id = qpqt1.list_header_id
23344: and qpqt2.list_line_id = qpqt1.list_line_id

Line 23342: from qp_preq_qual_tmp qpqt2

23338: END IF;
23339: -- update null group count
23340: --update qp_preq_qual_tmp qpqt1
23341: --set qpqt1.null_group_cnt = (select count(*)
23342: from qp_preq_qual_tmp qpqt2
23343: where qpqt2.list_header_id = qpqt1.list_header_id
23344: and qpqt2.list_line_id = qpqt1.list_line_id
23345: and qpqt2.qualifier_grouping_no = -1
23346: and qpqt2.pricing_status_code <> G_DELETED_GRP

Line 23356: --update qp_preq_qual_tmp qpqt1

23352: --and qpqt1.qualifier_grouping_no = -1; -- should update all groups and not just -1 groups
23353: -- as it is used as null_group_count + other_group_cnt = qualifier_group_cnt
23354:
23355: -- update other group count
23356: --update qp_preq_qual_tmp qpqt1
23357: --set qpqt1.other_group_cnt = (select count(*)
23358: from qp_preq_qual_tmp qpqt2
23359: where qpqt2.list_header_id = qpqt1.list_header_id
23360: and qpqt2.list_line_id = qpqt1.list_line_id

Line 23358: from qp_preq_qual_tmp qpqt2

23354:
23355: -- update other group count
23356: --update qp_preq_qual_tmp qpqt1
23357: --set qpqt1.other_group_cnt = (select count(*)
23358: from qp_preq_qual_tmp qpqt2
23359: where qpqt2.list_header_id = qpqt1.list_header_id
23360: and qpqt2.list_line_id = qpqt1.list_line_id
23361: and qpqt2.qualifier_grouping_no <> -1
23362: and qpqt2.pricing_status_code <> G_DELETED_GRP

Line 23373: from qp_preq_qual_tmp

23369:
23370: IF (G_DEBUG_ENGINE = FND_API.G_TRUE) THEN
23371: for i in (select list_header_id,list_line_id,qualifier_grouping_no,null_group_cnt,other_group_cnt,search_ind,
23372: qualifier_group_cnt,others_group_cnt,qualifier_attribute_context,qualifier_attribute,qualifier_attribute_value
23373: from qp_preq_qual_tmp
23374: where pricing_phase_id = p_pricing_phase_id
23375: and pricing_status_code = 'X'
23376: order by 1,2,3)
23377: loop

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

23475: , G_HEADER_LIMIT_EXISTS_TBL_Q LIMIT nROWS;
23476: EXIT WHEN G_LIST_HEADER_ID_TBL_Q.COUNT = 0;
23477:
23478: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
23479: engine_debug('Inserting no rows into qp_preq_qual_tmp for each line index');
23480: END IF;
23481: IF (G_LIST_HEADER_ID_TBL_Q.COUNT > 0) THEN
23482:
23483: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_UPDATED;

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

23481: IF (G_LIST_HEADER_ID_TBL_Q.COUNT > 0) THEN
23482:
23483: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_UPDATED;
23484: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
23485: engine_debug('Inserting rows into qp_preq_qual_tmp for each line index: ' || G_LIST_HEADER_ID_TBL_Q.COUNT);
23486:
23487: END IF;
23488: INSERT_QUAL(
23489: G_LIST_HEADER_ID_TBL_Q

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

23628: , G_DERIVED_QUALIFIER_FLAG_TBL_Q LIMIT nROWS; -- Added for TCA
23629: EXIT WHEN G_LIST_HEADER_ID_TBL_Q.COUNT = 0;
23630:
23631: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
23632: engine_debug('Inserting no rows into qp_preq_qual_tmp for each line index');
23633: END IF;
23634: IF (G_LIST_HEADER_ID_TBL_Q.COUNT > 0) THEN
23635:
23636: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_UPDATED;

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

23634: IF (G_LIST_HEADER_ID_TBL_Q.COUNT > 0) THEN
23635:
23636: --G_QUALIFIER_TEMP := G_QUALIFIER_TEMP_UPDATED;
23637: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
23638: engine_debug('Inserting rows into qp_preq_qual_tmp for each line index: ' || G_LIST_HEADER_ID_TBL_Q.COUNT);
23639: END IF;
23640: INSERT_QUAL(
23641: G_LIST_HEADER_ID_TBL_Q
23642: , G_LIST_LINE_ID_TBL_Q

Line 31619: --Delete From QP_PREQ_QUAL_TMP;

31615: --Delete from qp_npreq_lines_tmp;
31616: --Delete from qp_npreq_line_attrs_tmp;
31617: --Delete From qp_npreq_ldets_tmp;
31618: --Delete From qp_npreq_rltd_lines_tmp;
31619: --Delete From QP_PREQ_QUAL_TMP;
31620: --Delete From qp_nformula_step_values_tmp;
31621: --Delete From QP_PREQ_LINE_ATTRS_FORMULA_TMP;
31622:
31623: