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_MAINTAIN_DENORMALIZED_DATA dependencies on QP_QUALIFIERS

Line 618: FROM qp_qualifiers qpq1

614: qpq1.comparison_operator_code,
615: qpq1.qualifier_attr_value,
616: qpq1.qualifier_attr_value_to,
617: count(*) distinct_rows
618: FROM qp_qualifiers qpq1
619: WHERE qpq1.list_header_id between p_List_Header_Id_low and p_List_Header_Id_High --5860276
620: and qpq1.list_header_id is not null
621: AND qpq1.active_flag = 'Y'
622: --for bug 5121471

Line 642: update qp_qualifiers qpq set DISTINCT_ROW_COUNT=

638: END IF;
639:
640:
641: /* Commented for bug 3136350
642: update qp_qualifiers qpq set DISTINCT_ROW_COUNT=
643: (select count(*) from qp_qualifiers qpq1 where
644: qpq.qualifier_context=qpq1.qualifier_context and
645: qpq.qualifier_attribute=qpq1.qualifier_attribute and
646: qpq.qualifier_attr_value=qpq1.qualifier_attr_value and

Line 643: (select count(*) from qp_qualifiers qpq1 where

639:
640:
641: /* Commented for bug 3136350
642: update qp_qualifiers qpq set DISTINCT_ROW_COUNT=
643: (select count(*) from qp_qualifiers qpq1 where
644: qpq.qualifier_context=qpq1.qualifier_context and
645: qpq.qualifier_attribute=qpq1.qualifier_attribute and
646: qpq.qualifier_attr_value=qpq1.qualifier_attr_value and
647: nvl(qpq.qualifier_attr_value_to,'-x') = nvl(qpq1.qualifier_attr_value_to,'-x') and

Line 661: UPDATE qp_qualifiers qpq

657: -- bug 3136350 start
658:
659: FOR rec IN upd_distinct_row_count LOOP
660:
661: UPDATE qp_qualifiers qpq
662: SET DISTINCT_ROW_COUNT = rec.distinct_rows
663: WHERE qpq.qualifier_context = rec.qualifier_context
664: AND qpq.qualifier_attribute = rec.qualifier_attribute
665: AND qpq.comparison_operator_code = rec.comparison_operator_code

Line 779: select list_line_id from qp_qualifiers where

775: select list_line_id from qp_list_lines where
776: list_header_id = p_list_header_id
777: and pricing_phase_id = p_pricing_phase_id
778: minus
779: select list_line_id from qp_qualifiers where
780: list_header_id = p_list_header_id
781: and list_line_id <> -1;
782: l_list_line_id number;
783:

Line 980: from qp_qualifiers

976: select 1
977: into l_count
978: from dual where exists
979: (select 'x'
980: from qp_qualifiers
981: where list_header_id = l_list_header_id_tbl(i)
982: and NOT (qualifier_context = 'MODLIST' and
983: qualifier_attribute = 'QUALIFIER_ATTRIBUTE4')
984: );

Line 1008: from qp_qualifiers

1004: select 1
1005: into l_count
1006: from dual where exists
1007: (select 'x'
1008: from qp_qualifiers
1009: where list_header_id = l_list_header_id_tbl(i)
1010: and nvl(list_line_id,-1) = -1);
1011: EXCEPTION
1012: WHEN NO_DATA_FOUND THEN

Line 1027: from qp_qualifiers

1023: select 1
1024: into l_count
1025: from dual where exists
1026: (select 'x'
1027: from qp_qualifiers
1028: where list_header_id = l_list_header_id_tbl(i)
1029: and list_line_id = l_list_line_id_tbl(i));
1030: EXCEPTION
1031: WHEN NO_DATA_FOUND THEN

Line 1197: FROM qp_qualifiers

1193: /* Added for bug 7038849 */
1194: BEGIN
1195: SELECT MAX(ABS(qualifier_grouping_no))
1196: INTO l_max_qual_no
1197: FROM qp_qualifiers
1198: WHERE list_header_id between l_list_header_id_low and l_list_header_id_high;
1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: l_max_qual_no:= 0;

Line 1216: from qp_qualifiers

1212: --hw
1213: -- this is for modifier only
1214: for c1 in (select rowid,list_header_id,nvl(list_line_id,-1) list_line_id,
1215: nvl(qualifier_grouping_no,-1) qualifier_grouping_no, Distinct_row_count, comparison_operator_code
1216: from qp_qualifiers
1217: where (list_header_id between l_list_header_id_low and l_list_header_id_high)
1218: and list_type_code not in ('PRL','AGR')
1219: --order by list_header_id,nvl(list_line_id,-1),decode(nvl(qualifier_grouping_no,-1), -1, -9999, qualifier_grouping_no), comparison_operator_code, Distinct_row_count) -- 7038849
1220: order by list_header_id,nvl(list_line_id,-1),decode(nvl(qualifier_grouping_no,-1),-1,nvl(qualifier_grouping_no,-1),nvl(qualifier_grouping_no,-1)+l_max_qual_no), comparison_operator_code, Distinct_row_count) -- 7038849

Line 1299: update qp_qualifiers

1295: end loop;
1296:
1297: If l_header_qual_exists_tbl.count >= 1000 then
1298: Forall K in l_header_qual_exists_tbl.First..l_header_qual_exists_tbl.Last
1299: update qp_qualifiers
1300: Set SEARCH_IND = L_Search_Ind_tbl(K),
1301: QUALIFIER_GROUP_CNT = l_group_cnt_tbl(K),
1302: -- qualifier_group_cnt = decode(qualifier_grouping_no, -1, 0, l_group_cnt_tbl(k)),
1303: HEADER_QUALS_EXIST_FLAG=l_header_qual_exists_tbl(K),

Line 1391: update qp_qualifiers

1387: end loop;
1388:
1389: If l_header_qual_exists_tbl.count > 0 then
1390: Forall K in l_header_qual_exists_tbl.First..l_header_qual_exists_tbl.Last
1391: update qp_qualifiers
1392: Set SEARCH_IND = L_Search_Ind_tbl(K),
1393: QUALIFIER_GROUP_CNT = l_group_cnt_tbl(K),
1394: -- qualifier_group_cnt = decode(qualifier_grouping_no, -1, 0, l_group_cnt_tbl(k)),
1395: HEADER_QUALS_EXIST_FLAG=l_header_qual_exists_tbl(K),

Line 1422: update qp_qualifiers

1418:
1419: -- Update all the null grouping number rows to search ind 2 , if there is any other grp
1420: If l_null_header_id_tbl.count > 0 then
1421: Forall J in l_null_header_id_tbl.First..l_null_header_id_tbl.Last
1422: update qp_qualifiers
1423: set search_ind = 2
1424: -- qualifier_group_cnt = qualifier_group_cnt + 1 -- Arbitary increasing the ct by 1 for null grp -- dont care
1425: where nvl(qualifier_grouping_no,-1) = -1
1426: and list_header_id = l_null_header_id_tbl(J)