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_EVENT_PHASES

Line 32001: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1

31997: E_DEBUG_ROUTINE_ERROR EXCEPTION;
31998:
31999: l_gone_in_phase_cur_loop varchar2(1); -- bug 3963888
32000: /*
32001: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
32002:
32003: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
32004: */
32005:

Line 32018: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

32014: QPP.PHASE_SEQUENCE,
32015: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG,
32016: QPP.NAME
32017: --QPEP.PRICING_EVENT_CODE
32018: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
32019: WHERE ((L_MANUAL_ADJUSTMENTS_CALL_FLAG IS NULL)
32020: OR
32021: (L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'N' AND
32022: NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('A', 'B'))

Line 32044: FROM qp_event_phases

32040: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32041: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
32042: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32043: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
32044: FROM qp_event_phases
32045: WHERE rownum < 7)
32046: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
32047: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
32048: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 32063: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

32059: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
32060: QPP.PHASE_SEQUENCE,
32061: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
32062: --QPEP.PRICING_EVENT_CODE
32063: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
32064: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'N'
32065: AND NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('A', 'B')
32066: AND QPEP.PRICING_EVENT_CODE IN
32067: (SELECT decode(rownum

Line 32079: FROM qp_event_phases

32075: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32076: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
32077: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32078: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
32079: FROM qp_event_phases
32080: WHERE rownum < 7)
32081: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
32082: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
32083: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 32095: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

32091: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
32092: QPP.PHASE_SEQUENCE,
32093: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
32094: --QPEP.PRICING_EVENT_CODE
32095: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
32096: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'Y'
32097: AND L_RETURN_MANUAL_DISCOUNT = 'N'
32098: AND NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('M', 'B')
32099: AND QPEP.PRICING_EVENT_CODE IN

Line 32112: FROM qp_event_phases

32108: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32109: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
32110: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32111: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
32112: FROM qp_event_phases
32113: WHERE rownum < 7)
32114: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
32115: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
32116: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 32128: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

32124: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
32125: QPP.PHASE_SEQUENCE,
32126: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
32127: --QPEP.PRICING_EVENT_CODE
32128: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
32129: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'Y'
32130: AND L_RETURN_MANUAL_DISCOUNT = 'Y'
32131: AND QPEP.PRICING_EVENT_CODE IN
32132: (SELECT decode(rownum

Line 32144: FROM qp_event_phases

32140: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32141: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
32142: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32143: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
32144: FROM qp_event_phases
32145: WHERE rownum < 7)
32146: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
32147: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
32148: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 32162: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

32158: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
32159: QPP.PHASE_SEQUENCE,
32160: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
32161: --QPEP.PRICING_EVENT_CODE
32162: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
32163: WHERE QPEP.PRICING_EVENT_CODE IN
32164: (SELECT decode(rownum
32165: ,1 ,substr(l_event_code,1,instr(l_event_code1,',',1,1)-1)
32166: ,2 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,

Line 32176: FROM qp_event_phases

32172: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32173: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
32174: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32175: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
32176: FROM qp_event_phases
32177: WHERE rownum < 7)
32178: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
32179: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
32180: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 32305: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1

32301:
32302: /*
32303: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
32304:
32305: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
32306: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
32307: */
32308: CURSOR l_check_pricing_phase_exists(l_event_code VARCHAR2,l_event_code1 VARCHAR2) IS
32309: SELECT b.pricing_phase_id,b.freeze_override_flag

Line 32306: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2

32302: /*
32303: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
32304:
32305: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
32306: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
32307: */
32308: CURSOR l_check_pricing_phase_exists(l_event_code VARCHAR2,l_event_code1 VARCHAR2) IS
32309: SELECT b.pricing_phase_id,b.freeze_override_flag
32310: FROM qp_event_phases a , qp_pricing_phases b

Line 32310: FROM qp_event_phases a , qp_pricing_phases b

32306: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
32307: */
32308: CURSOR l_check_pricing_phase_exists(l_event_code VARCHAR2,l_event_code1 VARCHAR2) IS
32309: SELECT b.pricing_phase_id,b.freeze_override_flag
32310: FROM qp_event_phases a , qp_pricing_phases b
32311: WHERE a.pricing_event_code in (SELECT decode(rownum
32312: ,1 ,substr(l_event_code,1,instr(l_event_code1,',',1,1)-1)
32313: ,2 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32314: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))

Line 32323: FROM qp_event_phases

32319: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32320: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
32321: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
32322: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
32323: FROM qp_event_phases
32324: WHERE rownum < 7)
32325: AND a.pricing_phase_id = G_PRICE_LIST_PHASE_ID
32326: AND b.pricing_phase_id = G_PRICE_LIST_PHASE_ID
32327: AND trunc(sysdate) BETWEEN trunc(nvl(a.START_DATE_ACTIVE,sysdate))