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 790: select list_line_id from qp_qualifiers where

786: select list_line_id from qp_list_lines where
787: list_header_id = p_list_header_id
788: and pricing_phase_id = p_pricing_phase_id
789: minus
790: select list_line_id from qp_qualifiers where
791: list_header_id = p_list_header_id
792: and list_line_id <> -1;
793: l_list_line_id number;
794:

Line 991: from qp_qualifiers

987: select 1
988: into l_count
989: from dual where exists
990: (select 'x'
991: from qp_qualifiers
992: where list_header_id = l_list_header_id_tbl(i)
993: and NOT (qualifier_context = 'MODLIST' and
994: qualifier_attribute = 'QUALIFIER_ATTRIBUTE4')
995: );

Line 1019: from qp_qualifiers

1015: select 1
1016: into l_count
1017: from dual where exists
1018: (select 'x'
1019: from qp_qualifiers
1020: where list_header_id = l_list_header_id_tbl(i)
1021: and nvl(list_line_id,-1) = -1);
1022: EXCEPTION
1023: WHEN NO_DATA_FOUND THEN

Line 1038: from qp_qualifiers

1034: select 1
1035: into l_count
1036: from dual where exists
1037: (select 'x'
1038: from qp_qualifiers
1039: where list_header_id = l_list_header_id_tbl(i)
1040: and list_line_id = l_list_line_id_tbl(i));
1041: EXCEPTION
1042: WHEN NO_DATA_FOUND THEN

Line 1217: FROM qp_qualifiers

1213: /* Added for bug 7038849 */
1214: BEGIN
1215: SELECT MAX(ABS(qualifier_grouping_no))
1216: INTO l_max_qual_no
1217: FROM qp_qualifiers
1218: WHERE list_header_id between l_list_header_id_low and l_list_header_id_high;
1219: EXCEPTION
1220: WHEN OTHERS THEN
1221: l_max_qual_no:= 0;

Line 1236: from qp_qualifiers

1232: --hw
1233: -- this is for modifier only
1234: for c1 in (select rowid,list_header_id,nvl(list_line_id,-1) list_line_id,
1235: nvl(qualifier_grouping_no,-1) qualifier_grouping_no, Distinct_row_count, comparison_operator_code
1236: from qp_qualifiers
1237: where (list_header_id between l_list_header_id_low and l_list_header_id_high)
1238: and list_type_code not in ('PRL','AGR')
1239: --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
1240: 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 1319: update qp_qualifiers

1315: end loop;
1316:
1317: If l_header_qual_exists_tbl.count >= 1000 then
1318: Forall K in l_header_qual_exists_tbl.First..l_header_qual_exists_tbl.Last
1319: update qp_qualifiers
1320: Set SEARCH_IND = L_Search_Ind_tbl(K),
1321: QUALIFIER_GROUP_CNT = l_group_cnt_tbl(K),
1322: -- qualifier_group_cnt = decode(qualifier_grouping_no, -1, 0, l_group_cnt_tbl(k)),
1323: HEADER_QUALS_EXIST_FLAG=l_header_qual_exists_tbl(K),

Line 1411: update qp_qualifiers

1407: end loop;
1408:
1409: If l_header_qual_exists_tbl.count > 0 then
1410: Forall K in l_header_qual_exists_tbl.First..l_header_qual_exists_tbl.Last
1411: update qp_qualifiers
1412: Set SEARCH_IND = L_Search_Ind_tbl(K),
1413: QUALIFIER_GROUP_CNT = l_group_cnt_tbl(K),
1414: -- qualifier_group_cnt = decode(qualifier_grouping_no, -1, 0, l_group_cnt_tbl(k)),
1415: HEADER_QUALS_EXIST_FLAG=l_header_qual_exists_tbl(K),

Line 1442: update qp_qualifiers

1438:
1439: -- Update all the null grouping number rows to search ind 2 , if there is any other grp
1440: If l_null_header_id_tbl.count > 0 then
1441: Forall J in l_null_header_id_tbl.First..l_null_header_id_tbl.Last
1442: update qp_qualifiers
1443: set search_ind = 2
1444: -- qualifier_group_cnt = qualifier_group_cnt + 1 -- Arbitary increasing the ct by 1 for null grp -- dont care
1445: where nvl(qualifier_grouping_no,-1) = -1
1446: and list_header_id = l_null_header_id_tbl(J)