[Home] [Help]
21184: 'N' descendents_quals_exist,
21185: qpl.PRICE_BREAK_TYPE_CODE
21186: FROM qp_npreq_lines_tmp qplines,
21187: qp_npreq_line_patrns_tmp qppattmp,
21188: qp_preq_patrn_qual_tmp qppqual,
21189: qp_list_lines qpl
21190: WHERE qppattmp.LINE_INDEX = qplines.LINE_INDEX
21191: AND qppqual.LINE_INDEX = qplines.LINE_INDEX
21192: AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
21387: 'N' descendents_quals_exist,
21388: qpl.PRICE_BREAK_TYPE_CODE
21389: FROM qp_npreq_lines_tmp qplines,
21390: qp_npreq_line_patrns_tmp qppattmp,
21391: qp_preq_patrn_qual_tmp qppqual,
21392: qp_list_lines qpl
21393: WHERE qppattmp.LINE_INDEX = qplines.LINE_INDEX
21394: AND qppqual.LINE_INDEX = qplines.LINE_INDEX
21395: AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
21572: 'N' descendents_quals_exist,
21573: qpl.PRICE_BREAK_TYPE_CODE
21574: FROM qp_npreq_lines_tmp qplines,
21575: qp_npreq_line_patrns_tmp qppattmp,
21576: qp_preq_patrn_qual_tmp qppqual,
21577: qp_list_lines qpl
21578: WHERE qppattmp.LINE_INDEX = qplines.LINE_INDEX
21579: AND qppqual.LINE_INDEX = qplines.LINE_INDEX
21580: AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
21699: 'N' descendents_quals_exist,
21700: qpl.PRICE_BREAK_TYPE_CODE
21701: FROM qp_npreq_lines_tmp qplines,
21702: qp_npreq_line_patrns_tmp qppattmp,
21703: qp_preq_patrn_qual_tmp qppqual,
21704: qp_list_lines qpl
21705: WHERE qppattmp.LINE_INDEX = qplines.LINE_INDEX
21706: AND qppqual.LINE_INDEX = qplines.LINE_INDEX
21707: AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
22191:
22192: EXIT WHEN l_list_header_id_tbl.COUNT = 0;
22193:
22194: forall i IN 1 .. l_list_header_id_tbl.COUNT
22195: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
22196: list_line_id,
22197: line_index,
22198: matched_pattrn_id,
22199: pricing_phase_id,
22469: END IF;
22470: EXIT WHEN l_list_header_id_tbl.COUNT = 0;
22471: IF p_search_path = 1 THEN
22472: forall i IN 1 .. l_list_header_id_tbl.COUNT
22473: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
22474: list_line_id,
22475: line_index,
22476: matched_pattrn_id,
22477: pricing_phase_id,
22529: ELSE
22530:
22531: forall i IN 1 .. l_list_header_id_tbl.COUNT
22532: INSERT
22533: INTO qp_preq_patrn_qual_tmp(list_header_id,
22534: list_line_id,
22535: line_index,
22536: matched_pattrn_id,
22537: pricing_phase_id,
22596: FROM dual;
22597:
22598:
22599: forall i IN 1 .. l_list_header_id_tbl.COUNT
22600: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
22601: list_line_id,
22602: line_index,
22603: pricing_phase_id,
22604: stage,
22694: qp_debug_util.tstop('QP_EVALUATE_OTHER_OPERATORS_SEC_LIST_CUR');
22695:
22696: qp_debug_util.tstart('SEC_SRCH_PATRN_LIST_CUR_DEL_HDR_TCA', 'Header deletion for TCA');
22697:
22698: UPDATE qp_preq_patrn_qual_tmp a
22699: SET pricing_status_code = G_DELETED_TCA
22700: WHERE pricing_status_code = g_status_unchanged
22701: AND a.descendents_quals_exist = 'Y'
22702: and a.pricing_phase_id = G_PRICE_LIST_PHASE_ID
22722: -- header_quals_exist_flag will be Y only if Not=/Bet header level
22723: -- qualifiers are present for that line.
22724: qp_debug_util.tstart('SEC_SRCH_PATRN_LIST_CUR_DEL_HDR', 'Line deletion');
22725:
22726: UPDATE qp_preq_patrn_qual_tmp a
22727: SET pricing_status_code = G_DELETED_LINE
22728: WHERE pricing_phase_id = G_PRICE_LIST_PHASE_ID
22729: AND pricing_status_code = g_status_unchanged
22730: AND list_line_id <> -1
22731: AND nvl(header_quals_exist_flag, 'N') = 'Y'
22732: AND a.stage = l_stage
22733: AND NOT EXISTS
22734: (SELECT /*+ index(b QP_PREQ_PATRN_QUAL_T_N2) */ 'x'
22735: FROM qp_preq_patrn_qual_tmp b
22736: WHERE b.list_header_id = a.list_header_id
22737: AND b.line_index = a.line_index
22738: AND b.list_line_id = -1
22739: AND b.pricing_phase_id = a.pricing_phase_id
22868:
22869:
22870: if G_MULTI_CURRENCY_PROFILE = 'Y' and G_USE_MULTI_CURRENCY = 'Y' THEN
22871: forall i IN 1 .. l_list_header_id_tbl.COUNT
22872: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
22873: list_line_id,
22874: line_index,
22875: matched_pattrn_id,
22876: pricing_phase_id,
22937: );
22938:
22939: ELSE
22940: forall i IN 1 .. l_list_header_id_tbl.COUNT
22941: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
22942: list_line_id,
22943: line_index,
22944: matched_pattrn_id,
22945: pricing_phase_id,
23131: EXIT WHEN l_list_header_id_tbl.COUNT = 0;
23132:
23133: IF G_MULTI_CURRENCY_PROFILE = 'Y' and G_USE_MULTI_CURRENCY = 'Y' THEN
23134: forall i IN 1 .. l_list_header_id_tbl.COUNT
23135: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
23136: list_line_id,
23137: line_index,
23138: matched_pattrn_id,
23139: pricing_phase_id,
23198: l_descnt_quals_exist(i),
23199: l_PRICE_BREAK_TYPE_CODE(i));
23200: ELSE
23201: forall i IN 1 .. l_list_header_id_tbl.COUNT
23202: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
23203: list_line_id,
23204: line_index,
23205: matched_pattrn_id,
23206: pricing_phase_id,
23304: qp_debug_util.tstop('QP_EVALUATE_OTHER_OPERATORS_SEC_LIST_CUR');
23305:
23306: qp_debug_util.tstart('SEC_SRCH_PATRN_LIST_CUR_DEL_LIN_TCA', 'Line deletion for TCA');
23307:
23308: UPDATE qp_preq_patrn_qual_tmp a
23309: SET pricing_status_code = G_DELETED_TCA
23310: WHERE pricing_status_code = g_status_unchanged
23311: AND a.descendents_quals_exist = 'Y'
23312: and a.pricing_phase_id = G_PRICE_LIST_PHASE_ID
24194: engine_debug('L_LINE_CACHE-l_list_header_id_tbl.COUNT-'||l_list_header_id_tbl.COUNT);
24195:
24196: forall i IN 1 .. l_list_header_id_tbl.COUNT
24197: INSERT
24198: INTO qp_preq_patrn_qual_tmp(list_header_id,
24199: list_line_id,
24200: line_index,
24201: matched_pattrn_id,
24202: pricing_phase_id,
24259: FROM dual;
24260:
24261:
24262: forall i IN 1 .. l_list_header_id_tbl.COUNT
24263: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
24264: list_line_id,
24265: line_index,
24266: pricing_phase_id,
24267: stage,
24354: -- Deleting modifiers line picked up because of TCA
24355:
24356: qp_debug_util.tstart('PATRN_LIST_CUR_DEL_LIN_TCA', 'Line deletion for TCA');
24357:
24358: UPDATE qp_preq_patrn_qual_tmp a
24359: SET pricing_status_code = G_DELETED_TCA
24360: WHERE pricing_status_code = g_status_unchanged
24361: AND a.descendents_quals_exist = 'Y'
24362: and a.pricing_phase_id = p_pricing_phase_id
24382: -- header_quals_exist_flag will be Y only if Not=/Bet header level
24383: -- qualifiers are present for that line.
24384: qp_debug_util.tstart('PATRN_LIST_CUR_DEL_HDR', 'Line deletion');
24385:
24386: UPDATE qp_preq_patrn_qual_tmp a
24387: SET pricing_status_code = G_DELETED_LINE
24388: WHERE pricing_phase_id = p_pricing_phase_id
24389: AND pricing_status_code = g_status_unchanged
24390: AND list_line_id <> -1
24391: AND nvl(header_quals_exist_flag, 'N') = 'Y'
24392: AND a.stage = G_STAGE_CACHE_LST_HDR_LIN_SRCH
24393: AND NOT EXISTS
24394: (SELECT /*+ index(b QP_PREQ_PATRN_QUAL_T_N2) */ 'x'
24395: FROM qp_preq_patrn_qual_tmp b
24396: WHERE b.list_header_id = a.list_header_id
24397: AND b.line_index = a.line_index
24398: AND b.list_line_id = -1
24399: AND b.pricing_phase_id = a.pricing_phase_id
29543: QPL.PRICE_BREAK_TYPE_CODE,
29544: 'N' descendents_quals_exist
29545: FROM qp_npreq_lines_tmp qplines,
29546: qp_npreq_line_patrns_tmp qppat,
29547: qp_preq_patrn_qual_tmp qppqual,
29548: qp_list_lines qpl
29549: WHERE qplines.processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
29550: AND nvl(qplines.validated_flag,G_NO) = G_NO
29551: AND qppat.line_index = qplines.line_index
29964: qpl.PRICE_BREAK_TYPE_CODE,
29965: 'N' descendents_quals_exist
29966: FROM qp_npreq_lines_tmp qplines,
29967: qp_npreq_line_patrns_tmp qppat,
29968: qp_preq_patrn_qual_tmp qppqual,
29969: qp_list_lines qpl
29970: WHERE qplines.processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
29971: AND nvl(qplines.validated_flag,G_NO) = G_NO
29972: AND qppat.line_index = qplines.line_index
30220: EXIT WHEN l_list_header_id_tbl.COUNT = 0;
30221:
30222: forall i IN 1 .. l_list_header_id_tbl.COUNT
30223: INSERT
30224: INTO qp_preq_patrn_qual_tmp(list_header_id,
30225: list_line_id,
30226: line_index,
30227: matched_pattrn_id,
30228: pricing_phase_id,
30287: FROM dual;
30288:
30289:
30290: forall i IN 1 .. l_list_header_id_tbl.COUNT
30291: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
30292: list_line_id,
30293: line_index,
30294: pricing_phase_id,
30295: stage,
30371: END IF;
30372:
30373: qp_debug_util.tstart('PATRN_LIST_CUR_DEL_LIN_TCA_P2', 'Header/Line deletion for TCA');
30374:
30375: UPDATE qp_preq_patrn_qual_tmp a
30376: SET pricing_status_code = G_DELETED_TCA
30377: WHERE pricing_status_code = g_status_unchanged
30378: AND a.descendents_quals_exist = 'Y'
30379: and a.pricing_phase_id = p_pricing_phase_id
30398: qp_debug_util.tstart('DEL_LIN_HDR_QUAL_FAILED','Deleting lines failed in header qualiifiers');
30399:
30400: -- Deleting lines if header is not satisfied.
30401:
30402: UPDATE qp_preq_patrn_qual_tmp a
30403: SET pricing_status_code = G_DELETED_LINE
30404: WHERE pricing_phase_id = p_pricing_phase_id
30405: AND pricing_status_code = g_status_unchanged
30406: AND list_line_id <> -1
30407: AND nvl(header_quals_exist_flag, 'N') = 'Y'
30408: and a.stage = G_STAGE_CACHE_PL_LIN2
30409: AND NOT EXISTS
30410: (SELECT /*+ index(b QP_PREQ_PATRN_QUAL_T_N2) */ 'x'
30411: FROM qp_preq_patrn_qual_tmp b
30412: WHERE b.list_header_id = a.list_header_id
30413: AND b.line_index = a.line_index
30414: AND b.list_line_id = -1
30415: AND b.pricing_phase_id = a.pricing_phase_id
30533: EXIT
30534: WHEN l_list_header_id_tbl.COUNT = 0;
30535:
30536: forall i IN 1 .. l_list_header_id_tbl.COUNT INSERT
30537: INTO qp_preq_patrn_qual_tmp(list_header_id,
30538: list_line_id,
30539: line_index,
30540: matched_pattrn_id,
30541: pricing_phase_id,
30628:
30629:
30630: qp_debug_util.tstart('PATRN_LIST_CUR_DEL_HDR_TCA_P1', 'Header deletion for TCA');
30631:
30632: UPDATE qp_preq_patrn_qual_tmp a
30633: SET pricing_status_code = G_DELETED_TCA
30634: WHERE pricing_status_code = g_status_unchanged
30635: AND a.descendents_quals_exist = 'Y'
30636: and a.pricing_phase_id = p_pricing_phase_id
30766: EXIT
30767: WHEN l_list_header_id_tbl.COUNT = 0;
30768:
30769: forall i IN 1 .. l_list_header_id_tbl.COUNT INSERT
30770: INTO qp_preq_patrn_qual_tmp(list_header_id,
30771: list_line_id,
30772: line_index,
30773: matched_pattrn_id,
30774: pricing_phase_id,
30875: END IF;
30876:
30877: qp_debug_util.tstart('PATRN_LIST_CUR_DEL_LIN_TCA_P1', 'Line deletion for TCA');
30878:
30879: UPDATE qp_preq_patrn_qual_tmp a
30880: SET pricing_status_code = G_DELETED_TCA
30881: WHERE pricing_status_code = g_status_unchanged
30882: AND a.descendents_quals_exist = 'Y'
30883: and a.pricing_phase_id = p_pricing_phase_id
37851: atrgrps.LINE_LIMIT_EXISTS,
37852: atrgrps.descendents_quals_exist,
37853: atrgrps.PRICE_BREAK_TYPE_CODE
37854: FROM qp_npreq_lines_tmp qplines,
37855: qp_preq_patrn_qual_tmp intmdt,
37856: qp_npreq_line_patrns_tmp qppattmp,
37857: qp_attribute_groups atrgrps
37858: WHERE intmdt.pricing_phase_id = p_pricing_phase_id
37859: AND atrgrps.list_header_id = intmdt.list_header_id
38113: atrgrps.ASK_FOR_FLAG,
38114: atrgrps.HEADER_LIMIT_EXISTS,
38115: atrgrps.LINE_LIMIT_EXISTS,
38116: atrgrps.descendents_quals_exist
38117: FROM qp_preq_patrn_qual_tmp intmdt,
38118: qp_secu_attr_groups_v atrgrps,
38119: --qp_attribute_groups atrgrps,
38120: qp_npreq_line_patrns_tmp qppattmp,
38121: qp_npreq_lines_tmp qplines
38349: EXIT
38350: WHEN l_list_header_id_tbl.COUNT = 0;
38351:
38352: forall i IN 1 .. l_list_header_id_tbl.COUNT INSERT
38353: INTO qp_preq_patrn_qual_tmp(list_header_id,
38354: list_line_id,
38355: line_index,
38356: matched_pattrn_id,
38357: pricing_phase_id,
38428: END IF;
38429:
38430: qp_debug_util.tstart('PATRN_LIST_CUR_DEL_HDR_TCA', 'Header deletion for TCA');
38431:
38432: UPDATE qp_preq_patrn_qual_tmp a
38433: SET pricing_status_code = G_DELETED_TCA
38434: WHERE pricing_status_code = g_status_unchanged
38435: AND a.descendents_quals_exist = 'Y'
38436: and a.pricing_phase_id = p_pricing_phase_id
38509: EXIT
38510: WHEN l_list_header_id_tbl.COUNT = 0;
38511:
38512: forall i IN 1 .. l_list_header_id_tbl.COUNT
38513: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
38514: list_line_id,
38515: line_index,
38516: matched_pattrn_id,
38517: pricing_phase_id,
38592: qp_debug_util.tstop('QP_EVALUATE_OTHER_OPERATORS_P1_L');
38593:
38594: qp_debug_util.tstart('PATRN_LIST_CUR_DEL_LIN_TCA', 'Line deletion for TCA');
38595:
38596: UPDATE qp_preq_patrn_qual_tmp a
38597: SET pricing_status_code = G_DELETED_TCA
38598: WHERE pricing_status_code = g_status_unchanged
38599: AND a.descendents_quals_exist = 'Y'
38600: and a.pricing_phase_id = p_pricing_phase_id
38680: EXIT
38681: WHEN l_list_header_id_tbl.COUNT = 0;
38682:
38683: FORALL i IN 1 .. l_list_header_id_tbl.COUNT
38684: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
38685: list_line_id,
38686: line_index,
38687: matched_pattrn_id,
38688: pricing_phase_id,
38722: l_line_lmt_exists(i)
38723: FROM dual;
38724:
38725: FORALL i IN 1 .. l_list_header_id_tbl.COUNT
38726: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
38727: list_line_id,
38728: line_index,
38729: matched_pattrn_id,
38730: pricing_phase_id,
38770: CLOSE l_both_cache_path2_cur;
38771: qp_debug_util.tstop('PATRN_SELECT_MODIFIERS_BOTH_CACHE_CUR_PATH2');
38772:
38773: IF qp_preq_grp.g_debug_engine = fnd_api.g_true THEN
38774: qp_debug_util.print_table_data_csv('QP_PREQ_PATRN_QUAL_TMP','SEL_MOD_QUAL_AFT_LIN_CACH_P2_'||p_pricing_phase_id);
38775: END IF;
38776:
38777: qp_debug_util.tstart('Populate_Temp_Tables_NEQ_BTW_P2_L', 'Populate_Temp_Tables_NEQ_BTW_P2_L');
38778:
38806:
38807: qp_debug_util.tstop('QP_EVALUATE_OTHER_OPERATORS_P2_L');
38808:
38809: IF qp_preq_grp.g_debug_engine = fnd_api.g_true THEN
38810: qp_debug_util.print_table_data_csv('QP_PREQ_PATRN_QUAL_TMP','SEL_MOD_QUAL_AFT_LIN_EVL_OTH_OPR_P2_'||p_pricing_phase_id);
38811: END IF;
38812:
38813: IF qp_preq_grp.g_debug_engine = fnd_api.g_true THEN
38814: qp_preq_grp.engine_debug('Caching Header Qualifiers for satisfied Lines, pure Header quals, only prod, only prod-pric for phase : ' || p_pricing_phase_id);
38815: END IF;
38816:
38817: qp_debug_util.tstart('PATRN_SELECT_MODIFIERS_DEL_HDR_PATH2', 'Line deletion');
38818:
38819: UPDATE qp_preq_patrn_qual_tmp a
38820: SET pricing_status_code = G_DELETED_LINE
38821: WHERE pricing_phase_id = p_pricing_phase_id
38822: AND pricing_status_code = qp_preq_grp.g_status_unchanged
38823: AND list_line_id <> -1
38823: AND list_line_id <> -1
38824: AND nvl(header_quals_exist_flag, 'N') = 'Y'
38825: AND NOT EXISTS
38826: (SELECT 'x'
38827: FROM qp_preq_patrn_qual_tmp b
38828: WHERE b.list_header_id = a.list_header_id
38829: AND b.list_line_id = -1
38830: AND b.pricing_phase_id = a.pricing_phase_id
38831: AND b.pricing_status_code = qp_preq_grp.g_status_unchanged
38890: EXIT
38891: WHEN l_list_header_id_tbl.COUNT = 0;
38892:
38893: FORALL i IN 1 .. l_list_header_id_tbl.COUNT
38894: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
38895: list_line_id,
38896: line_index,
38897: matched_pattrn_id,
38898: pricing_phase_id,
39029: EXIT
39030: WHEN l_list_header_id_tbl.COUNT = 0;
39031:
39032: FORALL i IN 1 .. l_list_header_id_tbl.COUNT
39033: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
39034: list_line_id,
39035: line_index,
39036: matched_pattrn_id,
39037: pricing_phase_id,
39107: qp_debug_util.tstop('QP_EVALUATE_OTHER_OPERATORS_P2_H');
39108:
39109: qp_debug_util.tstart('PATRN_LIST_CUR_DEL_LIN_TCA', 'Line/Header deletion for TCA');
39110:
39111: UPDATE qp_preq_patrn_qual_tmp a
39112: SET pricing_status_code = G_DELETED_TCA
39113: WHERE pricing_status_code = g_status_unchanged
39114: AND a.descendents_quals_exist = 'Y'
39115: and a.pricing_phase_id = p_pricing_phase_id
39133: qp_debug_util.tstop('PATRN_LIST_CUR_DEL_LIN_TCA');
39134:
39135: qp_debug_util.tstart('PATRN_SELECT_MODIFIERS_DEL_HDR_PATH2', 'Line deletion');
39136:
39137: UPDATE qp_preq_patrn_qual_tmp a
39138: SET pricing_status_code = G_DELETED_LINE
39139: WHERE pricing_phase_id = p_pricing_phase_id
39140: AND pricing_status_code = qp_preq_grp.g_status_unchanged
39141: AND list_line_id <> -1
39142: AND nvl(header_quals_exist_flag, 'N') = 'Y'
39143: AND a.stage = G_STAGE_CACHE_MOD_LIN
39144: AND NOT EXISTS
39145: (SELECT 'x'
39146: FROM qp_preq_patrn_qual_tmp b
39147: WHERE b.list_header_id = a.list_header_id
39148: AND b.list_line_id = -1
39149: AND b.line_index = a.line_index
39150: AND b.pricing_phase_id = a.pricing_phase_id
39159: qp_debug_util.tstart('PATRN_SELECT_MODIFIERS_UPD_EXCLUDER', 'Delete Excluder rows');
39160:
39161: -- Delete Excluded Line Details Directly if the inner select returns an excluded row
39162:
39163: UPDATE qp_preq_patrn_qual_tmp a
39164: SET pricing_status_code = G_DELETED_EXCLUDER
39165: WHERE pricing_phase_id = p_pricing_phase_id
39166: AND pricing_status_code = qp_preq_grp.g_status_unchanged
39167: AND EXISTS
39284: qp_preq_grp.engine_debug('Entering QP_EVALUATE_OTHER_OPERATORS');
39285: END IF;
39286:
39287: UPDATE /*+ index(a qp_preq_patrn_qual_t_n3) */
39288: QP_PREQ_PATRN_QUAL_TMP a
39289: SET pricing_status_code = G_DEL_ATTR_NOT_SRCD_CMN_GRP
39290: WHERE pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
39291: AND eq_flag = 'N'
39292: AND stage = p_stage
39308: HAVING COUNT(DISTINCT b.CONTEXT||b.ATTRIBUTE||b.SETUP_VALUE_FROM) = a.null_other_oprt_count);
39309:
39310:
39311: UPDATE /*+ index(a qp_preq_patrn_qual_t_n3) */
39312: QP_PREQ_PATRN_QUAL_TMP a
39313: SET pricing_status_code = G_DEL_ATTR_NOT_SRCD_GRP
39314: WHERE pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
39315: AND eq_flag = 'N'
39316: AND stage = p_stage
39333: GROUP BY b.line_index,b.list_header_id,b.list_line_id, b.grouping_number
39334: HAVING COUNT(DISTINCT b.CONTEXT||b.ATTRIBUTE||b.SETUP_VALUE_FROM) = a.other_oprt_count);
39335:
39336:
39337: UPDATE QP_PREQ_PATRN_QUAL_TMP
39338: SET pricing_status_code = G_DEL_OTHR_OPR_CMN_GRP
39339: WHERE pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
39340: AND stage = p_stage
39341: AND (line_index , list_header_id , list_line_id) IN
39377: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))
39378: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))
39379: AND a.grouping_number = -1);
39380:
39381: UPDATE QP_PREQ_PATRN_QUAL_TMP
39382: SET pricing_status_code = G_DEL_OTHR_OPR_GRP
39383: WHERE pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
39384: AND stage = p_stage
39385: AND (line_index , list_header_id , list_line_id, grouping_no) IN
39596: list_type_code, ask_for_flag, HEADER_LIMIT_EXISTS,
39597: CURRENCY_DETAIL_ID, CURRENCY_HEADER_ID, SELLING_ROUNDING_FACTOR,
39598: ORDER_CURRENCY, BASE_CURRENCY_CODE, BREAK_UOM_CODE,
39599: BREAK_UOM_CONTEXT, BREAK_UOM_ATTRIBUTE, PRICING_EFFECTIVE_DATE
39600: FROM QP_PREQ_PATRN_QUAL_TMP
39601: WHERE stage = p_stage
39602: AND pricing_phase_id = p_pricing_phase_id
39603: AND list_line_id <> -1
39604: AND pricing_status_code = G_STATUS_UNCHANGED
39883: --qpq.SEGMENT_ID,
39884: qplines.derived_qualifier_flag
39885: FROM
39886: qp_npreq_ldets_tmp qpldets,
39887: QP_PREQ_PATRN_QUAL_TMP qppatq,
39888: qp_qualifiers qpq,
39889: qp_npreq_line_attrs_tmp qplines
39890: WHERE
39891: qpldets.pricing_phase_id = p_pricing_phase_id
39935: --qpq.SEGMENT_ID,
39936: qplines.derived_qualifier_flag
39937: FROM
39938: qp_npreq_ldets_tmp qpldets,
39939: QP_PREQ_PATRN_QUAL_TMP qppatq,
39940: qp_qualifiers qpq,
39941: qp_npreq_line_attrs_tmp qplines
39942: WHERE
39943: qpldets.pricing_phase_id = p_pricing_phase_id
40047: --qpq.SEGMENT_ID,
40048: qplines.derived_qualifier_flag
40049: FROM
40050: qp_npreq_ldets_tmp qpldets,
40051: QP_PREQ_PATRN_QUAL_TMP qppatq,
40052: qp_qualifiers qpq,
40053: qp_npreq_line_attrs_tmp qplines
40054: WHERE
40055: qpldets.pricing_phase_id = p_pricing_phase_id
40098: --qpq.SEGMENT_ID,
40099: qplines.derived_qualifier_flag
40100: FROM
40101: qp_npreq_ldets_tmp qpldets,
40102: QP_PREQ_PATRN_QUAL_TMP qppatq,
40103: qp_qualifiers qpq,
40104: qp_npreq_line_attrs_tmp qplines
40105: WHERE
40106: qpldets.pricing_phase_id = p_pricing_phase_id
40155: UPDATE qp_npreq_line_attrs_tmp a
40156: SET a.QUALIFIER_PRECEDENCE = (SELECT /*+ index(b qp_preq_patrn_qual_t_n2) */
40157: -- DISTINCT QUALIFIER_PRECEDENCE --bug 12731268
40158: MIN(QUALIFIER_PRECEDENCE) --Bug 10216430
40159: FROM QP_PREQ_PATRN_QUAL_TMP b
40160: WHERE b.LINE_INDEX = a.line_index
40161: AND b.list_header_id = a.list_header_id
40162: AND b.LIST_LINE_ID = a.LIST_LINE_ID
40163: AND b.stage = p_stage
40270: qppatq.MODIFIER_LEVEL_CODE, -- MODIFIER_LEVEL_CODE,
40271: --qplines.SEGMENT_ID,
40272: qplines.derived_qualifier_flag
40273: FROM
40274: QP_PREQ_PATRN_QUAL_TMP qppatq,
40275: qp_qualifiers qpq,
40276: qp_npreq_line_attrs_tmp qplines
40277: WHERE
40278: qppatq.pricing_phase_id = p_pricing_phase_id
40318: qppatq.MODIFIER_LEVEL_CODE, -- MODIFIER_LEVEL_CODE,
40319: --qplines.SEGMENT_ID,
40320: qplines.derived_qualifier_flag
40321: FROM
40322: QP_PREQ_PATRN_QUAL_TMP qppatq,
40323: qp_qualifiers qpq,
40324: qp_npreq_line_attrs_tmp qplines
40325: WHERE
40326: qppatq.pricing_phase_id = p_pricing_phase_id
40426: FROM
40427: (
40428: SELECT DISTINCT pricing_phase_id, line_index, list_header_id, list_line_id,
40429: eq_flag, MODIFIER_LEVEL_CODE
40430: FROM QP_PREQ_PATRN_QUAL_TMP
40431: WHERE stage = p_stage
40432: )qppat,
40433: QP_PRICING_ATTRIBUTES qppatr,
40434: qp_npreq_line_attrs_tmp qplaptr
40521: qppatq.MODIFIER_LEVEL_CODE, -- MODIFIER_LEVEL_CODE,
40522: --qplines.SEGMENT_ID,
40523: qplines.derived_qualifier_flag
40524: FROM
40525: QP_PREQ_PATRN_QUAL_TMP qppatq,
40526: qp_qualifiers qpq,
40527: qp_npreq_line_attrs_tmp qplines
40528: WHERE
40529: qppatq.pricing_phase_id = p_pricing_phase_id
40571: qppatq.MODIFIER_LEVEL_CODE, -- MODIFIER_LEVEL_CODE,
40572: --qplines.SEGMENT_ID,
40573: qplines.derived_qualifier_flag
40574: FROM
40575: QP_PREQ_PATRN_QUAL_TMP qppatq,
40576: qp_qualifiers qpq,
40577: qp_npreq_line_attrs_tmp qplines
40578: WHERE
40579: qppatq.pricing_phase_id = p_pricing_phase_id