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_PTE_SOURCE_SYSTEMS

Line 21069: index(qprs qp_pte_source_systems_u2)

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,
21072: atrgrps.list_line_id list_line_id,
21073: qplines.line_index line_index,

Line 21105: qp_pte_source_systems qprs

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
21108: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
21109: AND QPQ.COMPARISON_OPERATOR_CODE = '='

Line 21216: index(qprs qp_pte_source_systems_u2)

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,
21219: atrgrps.list_line_id list_line_id,
21220: qplines.line_index line_index,

Line 21252: qp_pte_source_systems qprs,

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
21255: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
21256: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)

Line 21418: index(qprs qp_pte_source_systems_u2)

21414: CURSOR L_SEC_LST_HDR_P1_QLFY_N_CURR IS
21415: SELECT
21416: /*+ ORDERED index(qplines QP_PREQ_LINES_TMP_U1)
21417: index(qcdt QP_CURRENCY_DETAILS_N2)
21418: index(qprs qp_pte_source_systems_u2)
21419: L_SEC_LST_HDR_P1_QLFY_N_CURR */
21420: DISTINCT qph.list_header_id,
21421: -1 list_line_id,
21422: qplines.line_index line_index,

Line 21451: qp_pte_source_systems qprs,

21447: FROM
21448: qp_npreq_lines_tmp qplines,
21449: QP_QUALIFIERS qpq,
21450: qp_list_headers_b qph,
21451: qp_pte_source_systems qprs,
21452: --QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
21453: qp_currency_details qcdt
21454: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21455: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE

Line 21602: index(qprs qp_pte_source_systems_u2)

21598:
21599: CURSOR L_SEC_LST_HDR_P1_QLFY_SEC_N IS
21600: SELECT
21601: /*+ ORDERED index(qplines QP_PREQ_LINES_TMP_U1)
21602: index(qprs qp_pte_source_systems_u2)
21603: L_SEC_LST_HDR_P1_QLFY_SEC_N */
21604: DISTINCT qph.list_header_id,
21605: -1 list_line_id,
21606: qplines.line_index line_index,

Line 21635: qp_pte_source_systems qprs

21631: FROM
21632: qp_npreq_lines_tmp qplines,
21633: QP_QUALIFIERS qpq,
21634: qp_list_headers_b qph,
21635: qp_pte_source_systems qprs
21636: --QP_PRICE_REQ_SOURCES_V qprs /* yangli */
21637: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21638: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
21639: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)

Line 21734: index(qprs qp_pte_source_systems_u2)

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,
21738: qpl.LIST_LINE_ID,

Line 21782: qp_pte_source_systems qprs

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
21786: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE

Line 21839: index(qprs qp_pte_source_systems_u2)

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
21842: qpl.LIST_HEADER_ID,
21843: qpl.LIST_LINE_ID,

Line 21887: qp_pte_source_systems qprs,

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
21891: AND QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT

Line 23552: index(qprs qp_pte_source_systems_u2)

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
23555: qpl.LIST_HEADER_ID,
23556: qpl.LIST_LINE_ID,

Line 23599: qp_pte_source_systems qprs,

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
23603: AND (qplines.price_flag = G_YES OR

Line 23637: index(qprs qp_pte_source_systems_u2)

23633: UNION ALL
23634: SELECT /*+ ORDERED index(qplines QP_PREQ_LINES_TMP_N3)
23635: index(qpl QP_LIST_LINES_N16)
23636: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
23637: index(qprs qp_pte_source_systems_u2)
23638: l_pat_cache_both */
23639: DISTINCT
23640: qpl.LIST_HEADER_ID,
23641: qpl.LIST_LINE_ID,

Line 23680: qp_pte_source_systems qprs

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
23682: WHERE QPLINES.VALIDATED_FLAG = G_YES
23683: AND (qplines.price_flag = G_YES OR
23684: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))

Line 23715: index(qprs qp_pte_source_systems_u2)

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
23718: qpl.LIST_HEADER_ID,
23719: qpl.LIST_LINE_ID,

Line 23760: qp_pte_source_systems qprs,

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
23764: WHERE QPLINES.VALIDATED_FLAG = G_NO

Line 23852: index(qprs qp_pte_source_systems_u2)

23848: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)
23849: index(qplines QP_PREQ_LINES_TMP_N3)
23850: index(qpl QP_LIST_LINES_N16)
23851: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
23852: index(qprs qp_pte_source_systems_u2)
23853: l_pat_cache_both_curr */
23854: DISTINCT
23855: qpl.LIST_HEADER_ID,
23856: qpl.LIST_LINE_ID,

Line 23897: qp_pte_source_systems qprs,

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,
23898: QP_CURRENCY_DETAILS QCDT
23899: WHERE QPLINES.VALIDATED_FLAG = G_YES
23900: AND (qplines.price_flag = G_YES OR
23901: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))

Line 29445: index(qprs qp_pte_source_systems_u2)

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,
29448: atrgrps.LIST_LINE_ID,
29449: qplines.LINE_INDEX,

Line 29481: qp_pte_source_systems qprs

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
29485: AND atrgrps.list_line_id = -1

Line 29577: index(qprs qp_pte_source_systems_u2)

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
29580: qpl.LIST_HEADER_ID,
29581: qpl.LIST_LINE_ID,

Line 29623: qp_pte_source_systems qprs,

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
29627: AND nvl(qplines.validated_flag,G_NO) = G_NO

Line 29672: index(qprs qp_pte_source_systems_u2)

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
29675: qpl.LIST_HEADER_ID,
29676: qpl.LIST_LINE_ID,

Line 29721: qp_pte_source_systems qprs,

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
29725: WHERE qplines.processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition

Line 29814: index(qprs qp_pte_source_systems_u2)

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,
29817: atrgrps.LIST_LINE_ID,
29818: qplines.LINE_INDEX,

Line 29850: qp_pte_source_systems qprs,

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
29854: AND atrgrps.pricing_phase_id = p_pricing_phase_id

Line 37746: index(qprs qp_pte_source_systems_u2)

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,
37749: atrgrps.list_line_id list_line_id,
37750: qplines.line_index line_index,

Line 37773: qp_pte_source_systems qprs

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
37776: AND atrgrps.list_header_id = qplhp.list_header_id
37777: AND atrgrps.list_line_id = -1 -- Filter

Line 37996: index(qprs qp_pte_source_systems_u2)

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 */
37998: DISTINCT atrgrps.list_header_id,
37999: atrgrps.list_line_id list_line_id,
38000: qplines.line_index line_index,

Line 38022: qp_pte_source_systems qprs

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
38026: AND atrgrps.pte_code = G_PTE_CODE