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_LIST_HEADER_PHASES

Line 1757: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1

1753: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
1754: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,ACTIVE_FLAG,5
1755: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,SEARCH_IND,6
1756:
1757: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
1758: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
1759:
1760: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
1761: */

Line 1758: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2

1754: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,ACTIVE_FLAG,5
1755: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,SEARCH_IND,6
1756:
1757: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
1758: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
1759:
1760: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
1761: */
1762: -- Changed the cursor l_outer_qual_cur for bug#3002632

Line 1812: qp_list_header_phases qplh,

1808: qplatq.derived_qualifier_flag -- Added for TCA
1809: from
1810: qp_npreq_line_attrs_tmp qplatq,
1811: qp_qualifiers qpq ,
1812: qp_list_header_phases qplh,
1813: qp_list_headers_b qph,
1814: qp_price_req_sources_v qprs
1815: where
1816: qpq.list_header_id = qplh.list_header_id

Line 1934: qp_list_header_phases qplh,

1930: qplatq.derived_qualifier_flag -- Added for TCA
1931: from
1932: qp_npreq_line_attrs_tmp qplatq,
1933: qp_qualifiers qpq ,
1934: qp_list_header_phases qplh,
1935: qp_list_headers_b qph,
1936: qp_price_req_sources_v qprs
1937: where
1938: qpq.list_header_id = qplh.list_header_id

Line 2058: qp_list_header_phases qplh,

2054: qplatq.derived_qualifier_flag -- Added for TCA
2055: from
2056: qp_npreq_line_attrs_tmp qplatq,
2057: qp_qualifiers qpq ,
2058: qp_list_header_phases qplh,
2059: qp_list_headers_b qph,
2060: qp_price_req_sources_v qprs
2061: where
2062: qpq.list_header_id = qplh.list_header_id

Line 2183: qp_list_header_phases qplh,

2179: qplatq.derived_qualifier_flag -- Added for TCA
2180: from
2181: qp_npreq_line_attrs_tmp qplatq,
2182: qp_qualifiers qpq ,
2183: qp_list_header_phases qplh,
2184: qp_list_headers_b qph,
2185: qp_price_req_sources_v qprs
2186: where
2187: qpq.list_header_id = qplh.list_header_id

Line 2440: qp_list_header_phases

2436: and b.pricing_status_code = G_STATUS_UNCHANGED
2437: and b.line_index is null)
2438: and a.list_header_id in
2439: (select list_header_id from
2440: qp_list_header_phases
2441: where
2442: pricing_phase_id = p_pricing_phase_id
2443: and qualifier_flag = 'Y');
2444:

Line 2479: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1

2475: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
2476: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,ACTIVE_FLAG,5
2477: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,SEARCH_IND,6
2478:
2479: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
2480: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
2481:
2482: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
2483: */

Line 2480: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2

2476: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,ACTIVE_FLAG,5
2477: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,SEARCH_IND,6
2478:
2479: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
2480: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
2481:
2482: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
2483: */
2484: -- Changed the cursor l_outer_qual_cur for bug#3002632

Line 2532: qp_list_header_phases qplh,

2528: qplatq.derived_qualifier_flag -- Added for TCA
2529: from
2530: qp_npreq_line_attrs_tmp qplatq,
2531: qp_qualifiers qpq ,
2532: qp_list_header_phases qplh,
2533: qp_list_headers_b qph,
2534: qp_price_req_sources_v qprs
2535: where
2536: qpq.list_header_id = qplh.list_header_id

Line 2635: qp_list_header_phases qplh,

2631: qplatq.derived_qualifier_flag -- Added for TCA
2632: from
2633: qp_npreq_line_attrs_tmp qplatq,
2634: qp_qualifiers qpq ,
2635: qp_list_header_phases qplh,
2636: qp_list_headers_b qph,
2637: qp_price_req_sources_v qprs
2638: where
2639: qpq.list_header_id = qplh.list_header_id

Line 2741: qp_list_header_phases qplh,

2737:
2738: from
2739: qp_npreq_line_attrs_tmp qplatq,
2740: qp_qualifiers qpq ,
2741: qp_list_header_phases qplh,
2742: qp_list_headers_b qph,
2743: qp_price_req_sources_v qprs
2744: where
2745: qpq.list_header_id = qplh.list_header_id

Line 2848: qp_list_header_phases qplh,

2844:
2845: from
2846: qp_npreq_line_attrs_tmp qplatq,
2847: qp_qualifiers qpq ,
2848: qp_list_header_phases qplh,
2849: qp_list_headers_b qph,
2850: qp_price_req_sources_v qprs
2851: where
2852: qpq.list_header_id = qplh.list_header_id

Line 37768: FROM qp_list_header_phases qplhp,

37764: atrgrps.ASK_FOR_FLAG,
37765: atrgrps.HEADER_LIMIT_EXISTS,
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,

Line 41002: from qp_list_header_phases lhp, qp_list_headers_b qplh

40998: FROM dual
40999: WHERE
41000: EXISTS (
41001: select /*+ ORDERED */ 'x'
41002: from qp_list_header_phases lhp, qp_list_headers_b qplh
41003: where lhp.pricing_phase_id = p_phase_id
41004: and qplh.list_header_id = lhp.list_header_id
41005: and qplh.active_flag = 'Y')
41006: OR