eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PREQ_GRP dependencies on QP_ATTRIBUTE_GROUPS

Line 21067: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)

21063: AS
21064:
21065: CURSOR L_SEC_LST_HDR_P1_QLFY_SEC_Y IS
21066: SELECT
21067: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)
21068: index(qplines QP_PREQ_LINES_TMP_U1)
21069: index(qprs qp_pte_source_systems_u2)
21070: L_SEC_LST_HDR_P1_QLFY_SEC_Y */
21071: atrgrps.list_header_id,

Line 21103: --qp_attribute_groups atrgrps,

21099: qp_npreq_lines_tmp qplines,
21100: qp_npreq_line_patrns_tmp qppattmp,
21101: QP_QUALIFIERS qpq,
21102: qp_secu_attr_groups_v atrgrps,
21103: --qp_attribute_groups atrgrps,
21104: --QP_PRICE_REQ_SOURCES_V qprs /* yangli */
21105: qp_pte_source_systems qprs
21106: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21107: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE

Line 21214: index(atrgrps QP_ATTRIBUTE_GROUPS_N3)

21210:
21211: CURSOR L_SEC_LST_HDR_P1_QLFY_Y_CURR IS
21212: SELECT
21213: /*+ ORDERED index(qcdt QP_CURRENCY_DETAILS_N2)
21214: index(atrgrps QP_ATTRIBUTE_GROUPS_N3)
21215: index(qplines QP_PREQ_LINES_TMP_U1)
21216: index(qprs qp_pte_source_systems_u2)
21217: L_SEC_LST_HDR_P1_QLFY_Y_CURR */
21218: DISTINCT atrgrps.list_header_id,

Line 21250: --qp_attribute_groups atrgrps,

21246: qp_npreq_lines_tmp qplines,
21247: qp_npreq_line_patrns_tmp qppattmp,
21248: QP_QUALIFIERS qpq,
21249: qp_secu_attr_groups_v atrgrps,
21250: --qp_attribute_groups atrgrps,
21251: --QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
21252: qp_pte_source_systems qprs,
21253: qp_currency_details qcdt
21254: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT

Line 21733: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)

21729: SELECT /*+ ORDERED index(qplines QP_PREQ_LINES_TMP_U1)
21730: index(QPQ QP_QUALIFIERS_N4)
21731: index(qpl QP_LIST_LINES_N17)
21732: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
21733: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)
21734: index(qprs qp_pte_source_systems_u2)
21735: L_SEC_SRCH_BOTH_P2_QLFY_N */
21736: DISTINCT
21737: qpl.LIST_HEADER_ID,

Line 21781: --qp_attribute_groups qpatrgrp,

21777: QP_QUALIFIERS QPQ,
21778: qp_npreq_line_patrns_tmp qppattmp1,
21779: qp_list_lines qpl,
21780: qp_secu_attr_groups_v qpatrgrp,
21781: --qp_attribute_groups qpatrgrp,
21782: qp_pte_source_systems qprs
21783: --qp_price_req_sources_v qprs
21784: WHERE qppattmp1.line_index = qplines.line_index
21785: AND QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT

Line 21837: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)

21833: SELECT /*+ ORDERED index(qplines QP_PREQ_LINES_TMP_U1)
21834: index(QPQ QP_QUALIFIERS_N4)
21835: index(qpl QP_LIST_LINES_N16)
21836: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
21837: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)
21838: index(qcdt QP_CURRENCY_DETAILS_N2)
21839: index(qprs qp_pte_source_systems_u2)
21840: L_SEC_SRCH_BOTH_P2_QLFY_N_CURR */
21841: DISTINCT

Line 21886: --qp_attribute_groups qpatrgrp,

21882: QP_QUALIFIERS QPQ,
21883: qp_npreq_line_patrns_tmp qppattmp1,
21884: qp_list_lines qpl,
21885: qp_secu_attr_groups_v qpatrgrp,
21886: --qp_attribute_groups qpatrgrp,
21887: qp_pte_source_systems qprs,
21888: --qp_price_req_sources_v qprs,
21889: QP_CURRENCY_DETAILS QCDT
21890: WHERE qppattmp1.line_index = qplines.line_index

Line 23550: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)

23546:
23547: SELECT /*+ ORDERED index(qplines QP_PREQ_LINES_TMP_N3)
23548: index(qpl QP_LIST_LINES_N16)
23549: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
23550: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)
23551: index(qppattmp2 QP_NPREQ_LINE_PATRNS_T_N1)
23552: index(qprs qp_pte_source_systems_u2)
23553: l_pat_cache_both */
23554: DISTINCT

Line 23598: --qp_attribute_groups qpatrgrp,

23594: FROM qp_npreq_lines_tmp qplines,
23595: qp_npreq_line_patrns_tmp qppattmp1,
23596: qp_list_lines qpl,
23597: qp_secu_attr_groups_v qpatrgrp,
23598: --qp_attribute_groups qpatrgrp,
23599: qp_pte_source_systems qprs,
23600: --qp_price_req_sources_v qprs,
23601: qp_npreq_line_patrns_tmp qppattmp2
23602: WHERE QPLINES.VALIDATED_FLAG = G_NO

Line 23713: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)

23709: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)
23710: index(qplines QP_PREQ_LINES_TMP_N3)
23711: index(qpl QP_LIST_LINES_N16)
23712: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
23713: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)
23714: index(qppattmp2 QP_NPREQ_LINE_PATRNS_T_N1)
23715: index(qprs qp_pte_source_systems_u2)
23716: l_pat_cache_both_curr */
23717: DISTINCT

Line 23759: --qp_attribute_groups qpatrgrp,

23755: FROM qp_npreq_lines_tmp qplines,
23756: qp_npreq_line_patrns_tmp qppattmp1,
23757: qp_list_lines qpl,
23758: qp_secu_attr_groups_v qpatrgrp,
23759: --qp_attribute_groups qpatrgrp,
23760: qp_pte_source_systems qprs,
23761: --qp_price_req_sources_v qprs,
23762: qp_npreq_line_patrns_tmp qppattmp2,
23763: QP_CURRENCY_DETAILS QCDT

Line 29443: SELECT /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)

29439:
29440: -- Path -> Header First - Line Next
29441:
29442: CURSOR l_pat_header_cache_p1 IS
29443: SELECT /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)
29444: index(qppat QP_NPREQ_LINE_PATRNS_T_N2)
29445: index(qprs qp_pte_source_systems_u2)
29446: l_pat_header_cache_p1 */
29447: DISTINCT atrgrps.LIST_HEADER_ID,

Line 29480: --qp_attribute_groups atrgrps,

29476: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition
29477: AND nvl(validated_flag,G_NO) = G_NO) qplines,
29478: qp_npreq_line_patrns_tmp qppattmp,
29479: qp_secu_attr_groups_v atrgrps,
29480: --qp_attribute_groups atrgrps,
29481: qp_pte_source_systems qprs
29482: --qp_price_req_sources_v qprs
29483: WHERE qppattmp.line_index = qplines.line_index
29484: AND atrgrps.pricing_phase_id = p_pricing_phase_id

Line 29575: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)

29571:
29572: SELECT /*+ ORDERED index(qplines QP_PREQ_LINES_TMP_U1)
29573: index(qpl QP_LIST_LINES_N17)
29574: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
29575: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)
29576: index(qppattmp2 QP_NPREQ_LINE_PATRNS_T_N1)
29577: index(qprs qp_pte_source_systems_u2)
29578: l_pat_line_p2 */
29579: DISTINCT

Line 29622: --qp_attribute_groups qpatrgrp,

29618: FROM qp_npreq_lines_tmp qplines,
29619: qp_npreq_line_patrns_tmp qppattmp1,
29620: qp_list_lines qpl,
29621: qp_secu_attr_groups_v qpatrgrp,
29622: --qp_attribute_groups qpatrgrp,
29623: qp_pte_source_systems qprs,
29624: --qp_price_req_sources_v qprs,
29625: qp_npreq_line_patrns_tmp qppattmp2
29626: WHERE qplines.processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition

Line 29670: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)

29666: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)
29667: index(qplines QP_PREQ_LINES_TMP_U1)
29668: index(qpl QP_LIST_LINES_N17)
29669: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
29670: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)
29671: index(qppattmp2 QP_NPREQ_LINE_PATRNS_T_N1)
29672: index(qprs qp_pte_source_systems_u2)
29673: l_pat_line_curr_p2 */
29674: DISTINCT

Line 29720: --qp_attribute_groups qpatrgrp,

29716: FROM qp_npreq_lines_tmp qplines,
29717: qp_npreq_line_patrns_tmp qppattmp1,
29718: qp_list_lines qpl,
29719: qp_secu_attr_groups_v qpatrgrp,
29720: --qp_attribute_groups qpatrgrp,
29721: qp_pte_source_systems qprs,
29722: --qp_price_req_sources_v qprs,
29723: qp_npreq_line_patrns_tmp qppattmp2,
29724: QP_CURRENCY_DETAILS QCDT

Line 29812: SELECT /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3) index(qppat QP_NPREQ_LINE_PATRNS_T_N2)

29808:
29809: -- Path -> Header First - Line Next
29810:
29811: CURSOR l_pat_header_cache_curr_p1 IS
29812: SELECT /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3) index(qppat QP_NPREQ_LINE_PATRNS_T_N2)
29813: index(QCDT QP_CURRENCY_DETAILS_N2)
29814: index(qprs qp_pte_source_systems_u2)
29815: l_pat_header_cache_curr_p1 */
29816: DISTINCT atrgrps.LIST_HEADER_ID,

Line 29849: --qp_attribute_groups atrgrps,

29845: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition
29846: AND nvl(validated_flag,G_NO) = G_NO) qplines,
29847: qp_npreq_line_patrns_tmp qppattmp,
29848: qp_secu_attr_groups_v atrgrps,
29849: --qp_attribute_groups atrgrps,
29850: qp_pte_source_systems qprs,
29851: --qp_price_req_sources_v qprs,
29852: QP_CURRENCY_DETAILS QCDT
29853: WHERE qppattmp.line_index = qplines.line_index

Line 37744: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N1)

37740: /* Header cache cursor*/
37741:
37742: CURSOR l_header_cache_cur(p_pricing_phase_id NUMBER) IS
37743: SELECT
37744: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N1)
37745: index(qplines QP_PREQ_LINES_TMP_U1)
37746: index(qprs qp_pte_source_systems_u2)
37747: l_header_cache_cur */
37748: DISTINCT atrgrps.list_header_id,

Line 37770: --qp_attribute_groups atrgrps,

37766: atrgrps.LINE_LIMIT_EXISTS,
37767: atrgrps.descendents_quals_exist
37768: FROM qp_list_header_phases qplhp,
37769: qp_secu_attr_groups_v atrgrps,
37770: --qp_attribute_groups atrgrps,
37771: qp_npreq_line_patrns_tmp qppattmp,
37772: qp_npreq_lines_tmp qplines,
37773: qp_pte_source_systems qprs
37774: --qp_price_req_sources_v qprs

Line 37829: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)

37825: /* line cache cursor*/
37826:
37827: CURSOR l_line_cache_cur(p_pricing_phase_id NUMBER) IS
37828: SELECT
37829: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)
37830: index(qppattmp QP_NPREQ_LINE_PATRNS_T_N2)
37831: index(intmdt QP_PREQ_PATRN_QUAL_T_N2)
37832: l_line_cache_cur */
37833: DISTINCT atrgrps.list_header_id,

Line 37857: qp_attribute_groups atrgrps

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
37860: AND intmdt.stage = G_STAGE_CACHE_MOD_HDR
37861: AND atrgrps.list_line_id <> -1 -- Filter

Line 37905: + ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3) index(qppattmp QP_NPREQ_LINE_PATRNS_T_N2) l_line_cache_cur */

37901: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES);
37902: /*UNION ALL
37903: SELECT
37904: ---This union all is to fetch all the lines whose header_quals_exist_flag is N(means pure no header quals)
37905: + ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3) index(qppattmp QP_NPREQ_LINE_PATRNS_T_N2) l_line_cache_cur */
37906: /* DISTINCT atrgrps.list_header_id,
37907: atrgrps.list_line_id list_line_id,
37908: qplines.line_index line_index,
37909: qppattmp.pattern_id matched_pattrn_id,

Line 37929: qp_attribute_groups atrgrps

37925: atrgrps.descendents_quals_exist,
37926: atrgrps.PRICE_BREAK_TYPE_CODE
37927: FROM qp_npreq_lines_tmp qplines,
37928: qp_npreq_line_patrns_tmp qppattmp,
37929: qp_attribute_groups atrgrps
37930: WHERE atrgrps.pricing_phase_id = p_pricing_phase_id
37931: AND nvl(atrgrps.header_quals_exist_flag, 'N') = 'N'
37932: AND qppattmp.pattern_id = atrgrps.pattern_id -- Match
37933: AND qppattmp.hash_key = atrgrps.hash_key -- Match

Line 37993: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)

37989: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)*/
37990:
37991: CURSOR l_line_cache_path2_cur(p_pricing_phase_id NUMBER) IS
37992: SELECT
37993: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)
37994: index(qppattmp QP_NPREQ_LINE_PATRNS_T_N2)
37995: index(qplines QP_PREQ_LINES_TMP_U1)
37996: index(qprs qp_pte_source_systems_u2)
37997: l_line_cache_path2_cur */

Line 38021: qp_attribute_groups atrgrps,

38017: atrgrps.descendents_quals_exist,
38018: atrgrps.PRICE_BREAK_TYPE_CODE
38019: FROM qp_npreq_lines_tmp qplines,
38020: qp_npreq_line_patrns_tmp qppattmp,
38021: qp_attribute_groups atrgrps,
38022: qp_pte_source_systems qprs
38023: WHERE atrgrps.list_line_id <> -1 -- Filter
38024: AND atrgrps.pattern_id = qppattmp.pattern_id -- Match
38025: AND atrgrps.hash_key = qppattmp.hash_key -- Match

Line 38093: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N1)

38089:
38090: CURSOR l_hdr_cache_cur_path2(p_pricing_phase_id NUMBER) IS
38091: SELECT
38092:
38093: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N1)
38094: index(qppattmp QP_NPREQ_LINE_PATRNS_T_N2)
38095: index(intmdt QP_PREQ_PATRN_QUAL_T_N1)
38096: l_hdr_cache_cur_path2 */
38097: DISTINCT atrgrps.list_header_id,

Line 38119: --qp_attribute_groups atrgrps,

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
38122: WHERE intmdt.pricing_phase_id = p_pricing_phase_id
38123: AND atrgrps.list_header_id = intmdt.list_header_id

Line 38137: /*+ ORDERED index(atrgrps_l QP_ATTRIBUTE_GROUPS_N3)

38133: AND TRUNC(nvl(atrgrps.end_date_active_q, nvl(qplines.pricing_effective_date, sysdate)));
38134:
38135: /*CURSOR l_both_cache_path2_cur(p_pricing_phase_id NUMBER) IS
38136: SELECT
38137: /*+ ORDERED index(atrgrps_l QP_ATTRIBUTE_GROUPS_N3)
38138: index(atrgrps_h QP_ATTRIBUTE_GROUPS_N1)
38139: index(qplines QP_PREQ_LINES_TMP_N4)
38140: index(qppattmp_h QP_NPREQ_LINE_PATRNS_T_N1)
38141: index(qppattmp_l QP_NPREQ_LINE_PATRNS_T_N2)

Line 38138: index(atrgrps_h QP_ATTRIBUTE_GROUPS_N1)

38134:
38135: /*CURSOR l_both_cache_path2_cur(p_pricing_phase_id NUMBER) IS
38136: SELECT
38137: /*+ ORDERED index(atrgrps_l QP_ATTRIBUTE_GROUPS_N3)
38138: index(atrgrps_h QP_ATTRIBUTE_GROUPS_N1)
38139: index(qplines QP_PREQ_LINES_TMP_N4)
38140: index(qppattmp_h QP_NPREQ_LINE_PATRNS_T_N1)
38141: index(qppattmp_l QP_NPREQ_LINE_PATRNS_T_N2)
38142: l_both_cache_path2_cur */

Line 38170: qp_attribute_groups atrgrps_l,

38166: atrgrps_h.HEADER_LIMIT_EXISTS,
38167: atrgrps_l.LINE_LIMIT_EXISTS
38168: FROM qp_npreq_lines_tmp qplines,
38169: qp_npreq_line_patrns_tmp qppattmp_l,
38170: qp_attribute_groups atrgrps_l,
38171: qp_attribute_groups atrgrps_h,
38172: qp_npreq_line_patrns_tmp qppattmp_h,
38173: qp_price_req_sources_v qprs
38174: WHERE atrgrps_l.list_line_id <> -1 -- Filter

Line 38171: qp_attribute_groups atrgrps_h,

38167: atrgrps_l.LINE_LIMIT_EXISTS
38168: FROM qp_npreq_lines_tmp qplines,
38169: qp_npreq_line_patrns_tmp qppattmp_l,
38170: qp_attribute_groups atrgrps_l,
38171: qp_attribute_groups atrgrps_h,
38172: qp_npreq_line_patrns_tmp qppattmp_h,
38173: qp_price_req_sources_v qprs
38174: WHERE atrgrps_l.list_line_id <> -1 -- Filter
38175: AND atrgrps_h.list_line_id = -1 -- Filter