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_NPREQ_LINE_PATRNS_TMP

Line 21100: qp_npreq_line_patrns_tmp qppattmp,

21096: qpq.qualifier_precedence,
21097: atrgrps.descendents_quals_exist
21098: FROM
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 */

Line 21187: qp_npreq_line_patrns_tmp qppattmp,

21183: qppqual.qualifier_precedence,
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

Line 21247: qp_npreq_line_patrns_tmp qppattmp,

21243: qpq.qualifier_precedence,
21244: atrgrps.descendents_quals_exist
21245: FROM
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 */

Line 21390: qp_npreq_line_patrns_tmp qppattmp,

21386: qppqual.qualifier_precedence,
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

Line 21575: qp_npreq_line_patrns_tmp qppattmp,

21571: qppqual.qualifier_precedence,
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

Line 21702: qp_npreq_line_patrns_tmp qppattmp,

21698: qppqual.qualifier_precedence,
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

Line 21778: qp_npreq_line_patrns_tmp qppattmp1,

21774: 'N' descendents_quals_exist,
21775: qpl.PRICE_BREAK_TYPE_CODE
21776: FROM qp_npreq_lines_tmp qplines,
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

Line 21883: qp_npreq_line_patrns_tmp qppattmp1,

21879: 'N' descendents_quals_exist,
21880: qpl.PRICE_BREAK_TYPE_CODE
21881: FROM qp_npreq_lines_tmp qplines,
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,

Line 23595: qp_npreq_line_patrns_tmp qppattmp1,

23591: QPLINES.CURRENCY_CODE ORDER_CURRENCY,
23592: qpatrgrp.descendents_quals_exist,
23593: QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
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,

Line 23601: qp_npreq_line_patrns_tmp qppattmp2

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
23603: AND (qplines.price_flag = G_YES OR
23604: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
23605: AND qplines.list_price_override_flag in ('N', 'O') -- po integration

Line 23677: qp_npreq_line_patrns_tmp qppattmp1,

23673: QPLINES.CURRENCY_CODE ORDER_CURRENCY,
23674: 'N' descendents_quals_exist,
23675: QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
23676: FROM qp_npreq_lines_tmp qplines,
23677: qp_npreq_line_patrns_tmp qppattmp1,
23678: qp_list_lines qpl,
23679: qp_list_headers_b qph,
23680: qp_pte_source_systems qprs
23681: --qp_price_req_sources_v qprs

Line 23756: qp_npreq_line_patrns_tmp qppattmp1,

23752: QPLINES.CURRENCY_CODE ORDER_CURRENCY,
23753: qpatrgrp.descendents_quals_exist,
23754: QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
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,

Line 23762: qp_npreq_line_patrns_tmp qppattmp2,

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
23764: WHERE QPLINES.VALIDATED_FLAG = G_NO
23765: AND (qplines.price_flag = G_YES OR
23766: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))

Line 23893: qp_npreq_line_patrns_tmp qppattmp1,

23889: QPLINES.CURRENCY_CODE ORDER_CURRENCY,
23890: 'N' descendents_quals_exist,
23891: QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
23892: FROM qp_npreq_lines_tmp qplines,
23893: qp_npreq_line_patrns_tmp qppattmp1,
23894: qp_list_lines qpl,
23895: qp_list_headers_b qph,
23896: --qp_price_req_sources_v qprs,
23897: qp_pte_source_systems qprs,

Line 29478: qp_npreq_line_patrns_tmp qppattmp,

29474: FROM (SELECT /*+ dynamic_sampling(1) */ *
29475: FROM qp_npreq_lines_tmp
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

Line 29546: qp_npreq_line_patrns_tmp qppat,

29542: qplines.pricing_effective_date,
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

Line 29619: qp_npreq_line_patrns_tmp qppattmp1,

29615: qpl.PRICE_BREAK_TYPE_CODE,
29616: qpatrgrp.descendents_quals_exist,
29617: qpatrgrp.effective_precedence --bug 12731268
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,

Line 29625: qp_npreq_line_patrns_tmp qppattmp2

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
29627: AND nvl(qplines.validated_flag,G_NO) = G_NO
29628: AND (qplines.price_flag = G_YES OR
29629: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))

Line 29717: qp_npreq_line_patrns_tmp qppattmp1,

29713: qpl.PRICE_BREAK_TYPE_CODE,
29714: qpatrgrp.descendents_quals_exist,
29715: qpatrgrp.effective_precedence --bug 12731268
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,

Line 29723: qp_npreq_line_patrns_tmp qppattmp2,

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
29725: WHERE qplines.processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition
29726: AND nvl(qplines.validated_flag,G_NO) = G_NO
29727: AND (qplines.price_flag = G_YES OR

Line 29847: qp_npreq_line_patrns_tmp qppattmp,

29843: FROM (SELECT /*+ dynamic_sampling(1) */ *
29844: FROM qp_npreq_lines_tmp
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,

Line 29967: qp_npreq_line_patrns_tmp qppat,

29963: qplines.pricing_effective_date,
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

Line 37630: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)

37626: upper_limit := lower_limit + G_CHUNK_SIZE;
37627:
37628: --change in index qp_preq_line_attrs_tmp_n9???
37629:
37630: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)
37631: SELECT /*+ ORDERED index(attr qp_preq_line_attrs_tmp_n9) */
37632: attr.line_index,
37633: qpp.pattern_id,
37634: sys_connect_by_path(attr.value_from, '|') hash_key

Line 37652: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)

37648:
37649: lower_limit := upper_limit + 1;
37650: END LOOP;
37651: /* ELSE
37652: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)
37653: SELECT /*+ ORDERED index(attr qp_preq_line_attrs_tmp_n9) */
37654: /* attr.line_index,
37655: qpp.pattern_id,
37656: sys_connect_by_path(attr.value_from, '|') hash_key

Line 37677: engine_debug(l_routine || 'inserted ' || SQL%ROWCOUNT || ' rows to qp_npreq_line_patrns_tmp'

37673:
37674:
37675: /*IF l_debug = FND_API.G_TRUE
37676: THEN
37677: engine_debug(l_routine || 'inserted ' || SQL%ROWCOUNT || ' rows to qp_npreq_line_patrns_tmp'
37678: || ' pricing_phase_id = ' || p_pricing_phase_id);
37679: END IF; */
37680:
37681: qp_debug_util.tstart('def_patrns', 'Default Patterns');

Line 37692: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)

37688: END IF;
37689:
37690: IF NVL(FND_PROFILE.VALUE(QP_PREQ_GRP.G_BLIND_DISCOUNT),'N') = 'Y'
37691: THEN
37692: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)
37693: SELECT line_index, -2, 'BLIND'
37694: FROM qp_npreq_lines_tmp;
37695:
37696: END IF;

Line 37697: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)

37693: SELECT line_index, -2, 'BLIND'
37694: FROM qp_npreq_lines_tmp;
37695:
37696: END IF;
37697: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)
37698: SELECT line_index, -3, 'BLIND'
37699: FROM qp_npreq_lines_tmp;
37700:
37701: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)

Line 37701: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)

37697: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)
37698: SELECT line_index, -3, 'BLIND'
37699: FROM qp_npreq_lines_tmp;
37700:
37701: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)
37702: SELECT line_index, -1, 'NOEQUALS'
37703: FROM qp_npreq_lines_tmp;
37704:
37705: G_PATRNS_TWO_THREE_INSERTED := 'Y';

Line 37771: qp_npreq_line_patrns_tmp qppattmp,

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
37775: WHERE qplhp.pricing_phase_id = p_pricing_phase_id

Line 37856: qp_npreq_line_patrns_tmp qppattmp,

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
37860: AND intmdt.stage = G_STAGE_CACHE_MOD_HDR

Line 37928: qp_npreq_line_patrns_tmp qppattmp,

37924: atrgrps.LINE_LIMIT_EXISTS,
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

Line 38020: qp_npreq_line_patrns_tmp qppattmp,

38016: atrgrps.LINE_LIMIT_EXISTS,
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

Line 38120: qp_npreq_line_patrns_tmp qppattmp,

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
38124: AND intmdt.stage = G_STAGE_CACHE_MOD_LIN

Line 38169: qp_npreq_line_patrns_tmp qppattmp_l,

38165: atrgrps_h.ASK_FOR_FLAG,
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

Line 38172: qp_npreq_line_patrns_tmp qppattmp_h,

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
38176: AND atrgrps_l.list_header_id = atrgrps_h.list_header_id -- Filter