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 DUAL

Line 7765: FROM dual

7761: IF G_LIN_QTY_ATTR_SRCD <> G_YES THEN
7762: BEGIN
7763: SELECT 1
7764: INTO l_lin_qty_exists
7765: FROM dual
7766: WHERE EXISTS (SELECT 1
7767: FROM qp_npreq_line_attrs_tmp
7768: WHERE CONTEXT = G_PRIC_VOLUME_CONTEXT
7769: AND ATTRIBUTE = G_QUANTITY_ATTRIBUTE

Line 8503: FROM dual;

8499:
8500: IF (p_line_tbl(I).LINE_ID IS NULL) THEN
8501: SELECT qp_limit_price_request_code_s.nextval
8502: INTO l_order_line_id
8503: FROM dual;
8504: ELSE
8505: l_order_line_id := p_line_tbl(I).LINE_ID;
8506: END IF;
8507:

Line 13744: FROM DUAL

13740: CURSOR get_excluded_prods_between(p_line_index PLS_INTEGER,
13741: p_list_header_id PLS_INTEGER,
13742: p_list_line_id PLS_INTEGER) IS
13743: SELECT 1
13744: FROM DUAL
13745: WHERE EXISTS
13746: (SELECT /*+ index(QP_PREQ_LINE_ATTRS_TMP QP_PREQ_LINE_ATTRS_TMP_N10) */ 'x' --9679930
13747: FROM QP_PREQ_LINE_ATTRS_TMP
13748: WHERE LINE_INDEX = p_line_index

Line 22596: FROM dual;

22592: l_base_curr_code(i),
22593: l_prcng_effctve_dt(i),
22594: L_qualifier_precedence(i),
22595: l_PRICE_BREAK_TYPE_CODE(i)
22596: FROM dual;
22597:
22598:
22599: forall i IN 1 .. l_list_header_id_tbl.COUNT
22600: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,

Line 22631: FROM dual

22627: l_modf_lvl_code(i),
22628: l_ag_othr_oprt_cnt(i),
22629: l_null_other_oprt_count(i),
22630: l_descnt_quals_exist(i)
22631: FROM dual
22632: WHERE l_ag_eq_flag(i) = 'N'
22633: OR l_descnt_quals_exist(i) = 'Y';
22634:
22635: END IF;

Line 24259: FROM dual;

24255: L_SELLNG_ROUND_FTR(i),
24256: l_base_curr_code(i),
24257: l_prcng_effctve_dt(i),
24258: l_PRICE_BREAK_TYPE_CODE(i)
24259: FROM dual;
24260:
24261:
24262: forall i IN 1 .. l_list_header_id_tbl.COUNT
24263: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,

Line 24298: FROM dual

24294: l_null_other_oprt_count(i),
24295: l_descnt_quals_exist(i),
24296: l_ag_matched_pat_id_tbl(i), -- bug 10216430
24297: l_ag_mtchd_hash_key_tbl(i) -- bug 10216430
24298: FROM dual
24299: WHERE l_ag_eq_flag(i) = 'N'
24300: OR l_descnt_quals_exist(i) = 'Y'
24301: OR l_ag_mtchd_hash_key_tbl(i)<>'BLIND'; -- bug 10216430
24302:

Line 30287: FROM dual;

30283: l_base_curr_code(i),
30284: l_prcng_effctve_dt(i),
30285: l_PRICE_BREAK_TYPE_CODE(i),
30286: l_qual_effective_precedence(i) --bug 12731268
30287: FROM dual;
30288:
30289:
30290: forall i IN 1 .. l_list_header_id_tbl.COUNT
30291: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,

Line 30328: FROM dual

30324: l_descnt_quals_exist(i),
30325: l_qual_effective_precedence(i), --bug 12731268
30326: l_ag_matched_pat_id_tbl(i), -- bug 10216430
30327: l_ag_mtchd_hash_key_tbl(i) -- bug 10216430
30328: FROM dual
30329: WHERE l_ag_eq_flag(i) = 'N'
30330: OR l_descnt_quals_exist(i) = 'Y'
30331: OR l_ag_mtchd_hash_key_tbl(i)<>'BLIND'; -- bug 10216430
30332:

Line 38723: FROM dual;

38719: l_list_type_code(i),
38720: l_ask_for_flag(i),
38721: l_hdr_lmt_exists(i),
38722: l_line_lmt_exists(i)
38723: FROM dual;
38724:
38725: FORALL i IN 1 .. l_list_header_id_tbl.COUNT
38726: INSERT INTO qp_preq_patrn_qual_tmp(list_header_id,
38727: list_line_id,

Line 38765: FROM dual

38761: l_list_type_code(i),
38762: l_ask_for_flag(i),
38763: l_hdr_lmt_exists(i),
38764: l_line_lmt_exists(i)
38765: FROM dual
38766: WHERE l_hdr_eq_flag(i) = 'N';
38767:
38768: --exit when l_header_cache_cur%rowcount < l_limit;
38769: END LOOP;

Line 40952: FROM dual

40948: INDX,QP_PREQ_GRP.price_request.get_source_system_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
40949: */
40950: CURSOR get_source_system_cur IS
40951: SELECT 'X'
40952: FROM dual
40953: WHERE EXISTS
40954: (Select 'X'
40955: --From QP_PRICE_REQ_SOURCES
40956: From QP_PRICE_REQ_SOURCES_V /* yangli */

Line 40998: FROM dual

40994: -- lines/headers; assuming that phase/qual on lines is a better EXISTS filter than
40995: -- active flag on headers (can purge if many inactive modifiers)
40996: CURSOR l_chk_phase_exists(p_phase_id IN PLS_INTEGER) IS
40997: SELECT 'x'
40998: FROM dual
40999: WHERE
41000: EXISTS (
41001: select /*+ ORDERED */ 'x'
41002: from qp_list_header_phases lhp, qp_list_headers_b qplh

Line 41026: select 'X' from dual

41022: and qpll.list_header_id = qplh.list_header_id
41023: and qpll.pricing_phase_id = p_phase_id
41024: and qpll.qualification_ind in (0, 2, 4, 6, 8, 10, 12, 14, 20, 22, 28, 30)
41025: and rownum = 1;
41026: select 'X' from dual
41027: where exists (select 'X' from qp_list_lines
41028: where pricing_phase_id = p_phase_id
41029: AND modifier_level_code IN ('LINE','LINEGROUP','ORDER') --3169430
41030: and rownum = 1);*/

Line 41216: SELECT DECODE(G_PAT_SEARCH_PATH,1,'Search Headers First','Search Lines First') INTO l_patrn_srch_path_desc FROM dual;

41212: G_PAT_SEARCH_PATH := NVL(FND_PROFILE.VALUE('QP_PATTERN_SEARCH_PATH'),2);
41213: G_QP_PATTERN_SEARCH := NVL(FND_PROFILE.VALUE('QP_PATTERN_SEARCH'),'N');
41214: G_LIN_QTY_ATTR_SRCD := 'N';
41215:
41216: SELECT DECODE(G_PAT_SEARCH_PATH,1,'Search Headers First','Search Lines First') INTO l_patrn_srch_path_desc FROM dual;
41217:
41218: IF G_QP_PATTERN_SEARCH = 'B' THEN
41219: l_patrn_srch_prof_desc:= 'Both Modifier and Price List';
41220: ELSIF G_QP_PATTERN_SEARCH = 'M' THEN

Line 42983: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';

42979: g_total_redo := g_total_redo + (l_pricing_end_redo - l_pricing_start_redo);
42980:
42981: --Changes for bug2961617
42982: /*
42983: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';
42984: */
42985:
42986: IF G_QP_DEBUG_PROFILE_VALUE = G_ENGINE_TIME_TRACE_ON THEN --3085171
42987: BEGIN

Line 42989: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';

42985:
42986: IF G_QP_DEBUG_PROFILE_VALUE = G_ENGINE_TIME_TRACE_ON THEN --3085171
42987: BEGIN
42988:
42989: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';
42990: /*
42991: SELECT 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: '||G_VERSION ||g_start_redo ||g_total_redo ||g_start_time ||g_total_time INTO l_time_stats FROM DUAL;
42992: */
42993:

Line 42991: SELECT 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: '||G_VERSION ||g_start_redo ||g_total_redo ||g_start_time ||g_total_time INTO l_time_stats FROM DUAL;

42987: BEGIN
42988:
42989: execute immediate 'select ' || '''' || 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: ' || G_VERSION || ', ' || g_start_redo || ', ' || g_total_redo || ', ' || g_start_time || ', ' || g_total_time || '''' || ' from dual ';
42990: /*
42991: SELECT 'QP_PREQ_GRP: version, start redo, total redo, start time, total time: '||G_VERSION ||g_start_redo ||g_total_redo ||g_start_time ||g_total_time INTO l_time_stats FROM DUAL;
42992: */
42993:
42994: EXCEPTION
42995:

Line 43006: execute immediate 'select '||''''|| ' Total Time in QP_PREQ_GRP(in sec) : ' || l_time_difference||' Total redo in QP_PREQ_GRP : '||l_redo_difference||''''||' from dual ';

43002:
43003: /*
43004: l_redo_difference := l_pricing_end_redo - l_pricing_start_redo ;
43005:
43006: execute immediate 'select '||''''|| ' Total Time in QP_PREQ_GRP(in sec) : ' || l_time_difference||' Total redo in QP_PREQ_GRP : '||l_redo_difference||''''||' from dual ';
43007: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
43008: engine_debug('redo log in GRP '||l_redo_difference);
43009: END IF;
43010: */