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 1673: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1

1669: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
1670: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,ACTIVE_FLAG,5
1671: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,SEARCH_IND,6
1672:
1673: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
1674: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
1675:
1676: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
1677: */

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

1670: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,ACTIVE_FLAG,5
1671: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,SEARCH_IND,6
1672:
1673: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
1674: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
1675:
1676: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
1677: */
1678: -- Changed the cursor l_outer_qual_cur for bug#3002632

Line 1728: qp_list_header_phases qplh,

1724: qplatq.derived_qualifier_flag -- Added for TCA
1725: from
1726: qp_npreq_line_attrs_tmp qplatq,
1727: qp_qualifiers qpq ,
1728: qp_list_header_phases qplh,
1729: qp_list_headers_b qph,
1730: qp_price_req_sources_v qprs
1731: where
1732: qpq.list_header_id = qplh.list_header_id

Line 1843: qp_list_header_phases qplh,

1839: qplatq.derived_qualifier_flag -- Added for TCA
1840: from
1841: qp_npreq_line_attrs_tmp qplatq,
1842: qp_qualifiers qpq ,
1843: qp_list_header_phases qplh,
1844: qp_list_headers_b qph,
1845: qp_price_req_sources_v qprs
1846: where
1847: qpq.list_header_id = qplh.list_header_id

Line 1960: qp_list_header_phases qplh,

1956: qplatq.derived_qualifier_flag -- Added for TCA
1957: from
1958: qp_npreq_line_attrs_tmp qplatq,
1959: qp_qualifiers qpq ,
1960: qp_list_header_phases qplh,
1961: qp_list_headers_b qph,
1962: qp_price_req_sources_v qprs
1963: where
1964: qpq.list_header_id = qplh.list_header_id

Line 2078: qp_list_header_phases qplh,

2074: qplatq.derived_qualifier_flag -- Added for TCA
2075: from
2076: qp_npreq_line_attrs_tmp qplatq,
2077: qp_qualifiers qpq ,
2078: qp_list_header_phases qplh,
2079: qp_list_headers_b qph,
2080: qp_price_req_sources_v qprs
2081: where
2082: qpq.list_header_id = qplh.list_header_id

Line 2328: qp_list_header_phases

2324: and b.pricing_status_code = G_STATUS_UNCHANGED
2325: and b.line_index is null)
2326: and a.list_header_id in
2327: (select list_header_id from
2328: qp_list_header_phases
2329: where
2330: pricing_phase_id = p_pricing_phase_id
2331: and qualifier_flag = 'Y');
2332:

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

2363: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,COMPARISON_OPERATOR_CODE,4
2364: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,ACTIVE_FLAG,5
2365: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,SEARCH_IND,6
2366:
2367: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
2368: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
2369:
2370: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
2371: */

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

2364: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,ACTIVE_FLAG,5
2365: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_QUALIFIERS_N4,SEARCH_IND,6
2366:
2367: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
2368: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
2369:
2370: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
2371: */
2372: -- Changed the cursor l_outer_qual_cur for bug#3002632

Line 2420: qp_list_header_phases qplh,

2416: qplatq.derived_qualifier_flag -- Added for TCA
2417: from
2418: qp_npreq_line_attrs_tmp qplatq,
2419: qp_qualifiers qpq ,
2420: qp_list_header_phases qplh,
2421: qp_list_headers_b qph,
2422: qp_price_req_sources_v qprs
2423: where
2424: qpq.list_header_id = qplh.list_header_id

Line 2516: qp_list_header_phases qplh,

2512: qplatq.derived_qualifier_flag -- Added for TCA
2513: from
2514: qp_npreq_line_attrs_tmp qplatq,
2515: qp_qualifiers qpq ,
2516: qp_list_header_phases qplh,
2517: qp_list_headers_b qph,
2518: qp_price_req_sources_v qprs
2519: where
2520: qpq.list_header_id = qplh.list_header_id

Line 2615: qp_list_header_phases qplh,

2611:
2612: from
2613: qp_npreq_line_attrs_tmp qplatq,
2614: qp_qualifiers qpq ,
2615: qp_list_header_phases qplh,
2616: qp_list_headers_b qph,
2617: qp_price_req_sources_v qprs
2618: where
2619: qpq.list_header_id = qplh.list_header_id

Line 2715: qp_list_header_phases qplh,

2711:
2712: from
2713: qp_npreq_line_attrs_tmp qplatq,
2714: qp_qualifiers qpq ,
2715: qp_list_header_phases qplh,
2716: qp_list_headers_b qph,
2717: qp_price_req_sources_v qprs
2718: where
2719: qpq.list_header_id = qplh.list_header_id

Line 32261: from qp_list_header_phases lhp, qp_list_headers_b qplh

32257: FROM dual
32258: WHERE
32259: EXISTS (
32260: select /*+ ORDERED */ 'x'
32261: from qp_list_header_phases lhp, qp_list_headers_b qplh
32262: where lhp.pricing_phase_id = p_phase_id
32263: and qplh.list_header_id = lhp.list_header_id
32264: and qplh.active_flag = 'Y')
32265: OR