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 465: FROM qp_pricing_phases a , qp_event_phases b

461: p_request_type_code IN VARCHAR2 DEFAULT NULL) IS
462:
463: CURSOR l_all_lines_info_cur(p_event_code1 VARCHAR2) IS
464: SELECT 'X'
465: FROM qp_pricing_phases a , qp_event_phases b
466: WHERE a.pricing_phase_id = b.pricing_phase_id
467: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y')
468: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM
469: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)

Line 480: FROM qp_event_phases

476: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
477: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
478: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
479: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
480: FROM qp_event_phases
481: WHERE ROWNUM < 7)
482: AND ROWNUM = 1;
483:
484: /* For bug 3006670 (if p_freight_call_flag = 'Y')

Line 493: FROM qp_pricing_phases a , qp_event_phases b

489: * the l_all_lines_info_cur_freight cursor has been modified to reflect this
490: */
491: CURSOR l_all_lines_info_cur_freight(p_event_code1 VARCHAR2) IS
492: SELECT 'X'
493: FROM qp_pricing_phases a , qp_event_phases b
494: WHERE a.pricing_phase_id = b.pricing_phase_id
495: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y')
496: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM
497: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)

Line 508: FROM qp_event_phases

504: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
505: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
506: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
507: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
508: FROM qp_event_phases
509: WHERE ROWNUM < 7)
510: AND ROWNUM = 1;
511:
512: -- l_summary_line_info_cur and l_changed_lines_info_cur were combined into one

Line 532: FROM qp_event_phases

528: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
529: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
530: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
531: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))) PRICING_EVENT_CD
532: FROM qp_event_phases
533: WHERE pricing_phase_id > 1
534: AND ROWNUM < 7) C,
535: QP_EVENT_PHASES B
536: WHERE B.PRICING_EVENT_CODE = C.PRICING_EVENT_CD

Line 535: QP_EVENT_PHASES B

531: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))) PRICING_EVENT_CD
532: FROM qp_event_phases
533: WHERE pricing_phase_id > 1
534: AND ROWNUM < 7) C,
535: QP_EVENT_PHASES B
536: WHERE B.PRICING_EVENT_CODE = C.PRICING_EVENT_CD
537: AND EXISTS (SELECT /*+ no_push_subq no_unnest index(a QP_LIST_LINES_N4) */ 'x' --bug 12677276 14842950
538: FROM qp_list_lines a
539: WHERE a.pricing_phase_id = b.pricing_phase_id

Line 546: FROM qp_event_phases b

542: AND ROWNUM=1;
543:
544: CURSOR l_line_info_ptess_cur(p_event_code1 VARCHAR2, p_mod_level_code VARCHAR2) IS
545: SELECT 'X'
546: FROM qp_event_phases b
547: WHERE b.pricing_event_code IN (SELECT DECODE(ROWNUM
548: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)
549: ,2 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
550: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))

Line 559: FROM qp_event_phases

555: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
556: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
557: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
558: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
559: FROM qp_event_phases
560: WHERE pricing_phase_id > 1
561: AND ROWNUM < 7)
562: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
563: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a

Line 577: FROM qp_event_phases

573: AND ROWNUM=1;
574:
575: CURSOR l_pricing_phase_exists_cur IS
576: SELECT 'X'
577: FROM qp_event_phases
578: WHERE pricing_event_code = p_event_code
579: AND pricing_phase_id = 1;
580:
581:

Line 683: FROM qp_pricing_phases a , qp_event_phases b

679: p_freight_call_flag IN VARCHAR2 := 'N',
680: p_request_type_code IN VARCHAR2 DEFAULT NULL) is
681: CURSOR l_all_lines_info_cur(p_event_code1 VARCHAR2) IS
682: SELECT 'X'
683: FROM qp_pricing_phases a , qp_event_phases b
684: WHERE a.pricing_phase_id = b.pricing_phase_id
685: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y')
686: AND b.pricing_event_code in (SELECT decode(rownum
687: ,1 ,substr(p_event_code,1,instr(p_event_code1,',',1,1)-1)

Line 698: FROM qp_event_phases

694: ,5 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
695: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1))
696: ,6 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
697: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1)))
698: FROM qp_event_phases
699: WHERE rownum < 7)
700: AND ROWNUM = 1;
701:
702: /* For bug 3006670 (if p_freight_call_flag = 'Y')

Line 711: FROM qp_pricing_phases a , qp_event_phases b

707: * the l_all_lines_info_cur_freight cursor has been modified to reflect this
708: */
709: CURSOR l_all_lines_info_cur_freight(p_event_code1 VARCHAR2) IS
710: SELECT 'X'
711: FROM qp_pricing_phases a , qp_event_phases b
712: WHERE a.pricing_phase_id = b.pricing_phase_id
713: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y')
714: AND b.pricing_event_code in (SELECT decode(rownum
715: ,1 ,substr(p_event_code,1,instr(p_event_code1,',',1,1)-1)

Line 726: FROM qp_event_phases

722: ,5 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
723: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1))
724: ,6 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
725: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1)))
726: FROM qp_event_phases
727: WHERE rownum < 7)
728: AND ROWNUM = 1;
729:
730: -- l_summary_line_info_cur and l_changed_lines_info_cur were combined into one

Line 737: FROM qp_event_phases b

733: -- passing p_mod_level_code='LINE' is equiv. to l_changed_lines_info_cur
734: --Modified cursor query for Bug 12677276
735: /*CURSOR l_line_info_cur(p_event_code1 VARCHAR2, p_mod_level_code VARCHAR2) IS
736: SELECT 'X'
737: FROM qp_event_phases b
738: WHERE b.pricing_event_code in (SELECT decode(rownum
739: ,1 ,substr(p_event_code,1,instr(p_event_code1,',',1,1)-1)
740: ,2 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
741: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1))

Line 750: FROM qp_event_phases

746: ,5 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
747: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1))
748: ,6 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
749: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1)))
750: FROM qp_event_phases
751: WHERE pricing_phase_id > 1
752: AND rownum < 7)
753: AND EXISTS (SELECT 'x'
754: FROM qp_list_lines a

Line 775: FROM qp_event_phases

771: ,5 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
772: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1))
773: ,6 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
774: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1))) PRICING_EVENT_CD
775: FROM qp_event_phases
776: WHERE pricing_phase_id > 1
777: AND rownum < 7) C,
778: QP_EVENT_PHASES B
779: WHERE B.PRICING_EVENT_CODE = C.PRICING_EVENT_CD

Line 778: QP_EVENT_PHASES B

774: instr(p_event_code1,',',1,rownum)-1 - instr(p_event_code1,',',1,rownum-1))) PRICING_EVENT_CD
775: FROM qp_event_phases
776: WHERE pricing_phase_id > 1
777: AND rownum < 7) C,
778: QP_EVENT_PHASES B
779: WHERE B.PRICING_EVENT_CODE = C.PRICING_EVENT_CD
780: AND EXISTS (SELECT /*+ no_push_subq no_unnest index(a QP_LIST_LINES_N4) */ 'x' -- 14842950
781: FROM qp_list_lines a
782: WHERE a.pricing_phase_id = b.pricing_phase_id

Line 790: FROM qp_event_phases b

786: --End bug 12677276
787:
788: CURSOR l_line_info_ptess_cur(p_event_code1 VARCHAR2, p_mod_level_code VARCHAR2) IS
789: SELECT 'X'
790: FROM qp_event_phases b
791: WHERE b.pricing_event_code IN (SELECT DECODE(ROWNUM
792: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)
793: ,2 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
794: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))

Line 803: FROM qp_event_phases

799: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
800: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
801: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
802: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
803: FROM qp_event_phases
804: WHERE pricing_phase_id > 1
805: AND ROWNUM < 7)
806: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
807: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a

Line 821: FROM qp_event_phases

817: AND ROWNUM=1;
818:
819: CURSOR l_pricing_phase_exists_cur IS
820: SELECT 'X'
821: FROM qp_event_phases
822: WHERE pricing_event_code = p_event_code
823: AND pricing_phase_id = 1;
824:
825:

Line 955: FROM qp_pricing_phases a , qp_event_phases b

951: x_manual_all_lines_status OUT NOCOPY VARCHAR2) IS
952:
953: CURSOR l_manual_all_lines_info_cur(p_event_code1 VARCHAR2) IS
954: SELECT 'Y'
955: FROM qp_pricing_phases a , qp_event_phases b
956: WHERE a.pricing_phase_id = b.pricing_phase_id
957: AND a.line_group_exists = 'Y' -- no need to consider PRG/OID for manual mod call
958: AND a.manual_modifier_flag in ('M','B') -- phases tagged to have manual modifiers
959: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM

Line 971: FROM qp_event_phases

967: ,5 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
968: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1))
969: ,6 ,SUBSTR(p_event_code , INSTR(p_event_code1,',',1,ROWNUM-1) + 1,
970: INSTR(p_event_code1,',',1,ROWNUM)-1 - INSTR(p_event_code1,',',1,ROWNUM-1)))
971: FROM qp_event_phases
972: WHERE ROWNUM < 7)
973: AND ROWNUM = 1;
974:
975: l_manual_grpline_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('QP_MANUAL_LINEGROUP'),'N');