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_UTIL_PUB dependencies on QP_EVENT_PHASES

Line 399: FROM qp_pricing_phases a , qp_event_phases b

395: p_request_type_code IN VARCHAR2 DEFAULT NULL) IS
396:
397: CURSOR l_all_lines_info_cur(p_event_code1 VARCHAR2) IS
398: SELECT 'X'
399: FROM qp_pricing_phases a , qp_event_phases b
400: WHERE a.pricing_phase_id = b.pricing_phase_id
401: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y')
402: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM
403: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)

Line 414: FROM qp_event_phases

410: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
411: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
412: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
413: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
414: FROM qp_event_phases
415: WHERE ROWNUM < 7)
416: AND ROWNUM = 1;
417:
418: /* For bug 3006670 (if p_freight_call_flag = 'Y')

Line 427: FROM qp_pricing_phases a , qp_event_phases b

423: * the l_all_lines_info_cur_freight cursor has been modified to reflect this
424: */
425: CURSOR l_all_lines_info_cur_freight(p_event_code1 VARCHAR2) IS
426: SELECT 'X'
427: FROM qp_pricing_phases a , qp_event_phases b
428: WHERE a.pricing_phase_id = b.pricing_phase_id
429: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y')
430: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM
431: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)

Line 442: FROM qp_event_phases

438: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
439: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
440: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
441: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
442: FROM qp_event_phases
443: WHERE ROWNUM < 7)
444: AND ROWNUM = 1;
445:
446: -- l_summary_line_info_cur and l_changed_lines_info_cur were combined into one

Line 453: FROM qp_event_phases b

449: -- passing p_mod_level_code='LINE' is equiv. to l_changed_lines_info_cur
450: -- [julin/4676740] tuned EXISTS clause
451: CURSOR l_line_info_cur(p_event_code1 VARCHAR2, p_mod_level_code VARCHAR2) IS
452: SELECT 'X'
453: FROM qp_event_phases b
454: WHERE b.pricing_event_code IN (SELECT DECODE(ROWNUM
455: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)
456: ,2 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
457: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))

Line 466: FROM qp_event_phases

462: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
463: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
464: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
465: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
466: FROM qp_event_phases
467: WHERE pricing_phase_id > 1
468: AND ROWNUM < 7)
469: AND EXISTS (SELECT 'x'
470: FROM qp_list_lines a

Line 478: FROM qp_event_phases b

474: AND ROWNUM=1;
475:
476: CURSOR l_line_info_ptess_cur(p_event_code1 VARCHAR2, p_mod_level_code VARCHAR2) IS
477: SELECT 'X'
478: FROM qp_event_phases b
479: WHERE b.pricing_event_code IN (SELECT DECODE(ROWNUM
480: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)
481: ,2 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
482: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))

Line 491: FROM qp_event_phases

487: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
488: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
489: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
490: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
491: FROM qp_event_phases
492: WHERE pricing_phase_id > 1
493: AND ROWNUM < 7)
494: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
495: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a

Line 509: FROM qp_event_phases

505: AND ROWNUM=1;
506:
507: CURSOR l_pricing_phase_exists_cur IS
508: SELECT 'X'
509: FROM qp_event_phases
510: WHERE pricing_event_code = p_event_code
511: AND pricing_phase_id = 1;
512:
513:

Line 630: FROM qp_pricing_phases a , qp_event_phases b

626: x_manual_all_lines_status OUT NOCOPY VARCHAR2) IS
627:
628: CURSOR l_manual_all_lines_info_cur(p_event_code1 VARCHAR2) IS
629: SELECT 'Y'
630: FROM qp_pricing_phases a , qp_event_phases b
631: WHERE a.pricing_phase_id = b.pricing_phase_id
632: AND a.line_group_exists = 'Y' -- no need to consider PRG/OID for manual mod call
633: AND a.manual_modifier_flag in ('M','B') -- phases tagged to have manual modifiers
634: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM

Line 646: FROM qp_event_phases

642: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
643: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
644: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
645: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
646: FROM qp_event_phases
647: WHERE ROWNUM < 7)
648: AND ROWNUM = 1;
649:
650: BEGIN