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 40716: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1

40712: E_DEBUG_ROUTINE_ERROR EXCEPTION;
40713:
40714: l_gone_in_phase_cur_loop varchar2(1); -- bug 3963888
40715: /*
40716: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
40717:
40718: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
40719: */
40720: --ignore_pricing start smbalara 8203956

Line 40759: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40755: QPP.NAME,
40756: --QPEP.PRICING_EVENT_CODE
40757: nvl(QPEP.pattern_search_path,nvl(QPP.pattern_search_path,G_PAT_SEARCH_PATH)) pattern_search_path,
40758: DECODE(nvl(QPEP.pattern_search_path,nvl(QPP.pattern_search_path,G_PAT_SEARCH_PATH)),1,'Search Headers First','Search Lines First') pattern_search_path_desc
40759: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40760: WHERE ((L_MANUAL_ADJUSTMENTS_CALL_FLAG IS NULL)
40761: OR
40762: (L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'N' AND
40763: NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('A', 'B'))

Line 40785: FROM qp_event_phases

40781: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40782: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
40783: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40784: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
40785: FROM qp_event_phases
40786: WHERE rownum < 7)
40787: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40788: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40789: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 40804: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40800: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
40801: QPP.PHASE_SEQUENCE,
40802: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
40803: --QPEP.PRICING_EVENT_CODE
40804: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40805: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'N'
40806: AND NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('A', 'B')
40807: AND QPEP.PRICING_EVENT_CODE IN
40808: (SELECT decode(rownum

Line 40820: FROM qp_event_phases

40816: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40817: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
40818: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40819: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
40820: FROM qp_event_phases
40821: WHERE rownum < 7)
40822: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40823: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40824: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 40836: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40832: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
40833: QPP.PHASE_SEQUENCE,
40834: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
40835: --QPEP.PRICING_EVENT_CODE
40836: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40837: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'Y'
40838: AND L_RETURN_MANUAL_DISCOUNT = 'N'
40839: AND NVL(QPP.MANUAL_MODIFIER_FLAG,'B') in ('M', 'B')
40840: AND QPEP.PRICING_EVENT_CODE IN

Line 40853: FROM qp_event_phases

40849: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40850: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
40851: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40852: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
40853: FROM qp_event_phases
40854: WHERE rownum < 7)
40855: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40856: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40857: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 40869: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40865: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
40866: QPP.PHASE_SEQUENCE,
40867: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
40868: --QPEP.PRICING_EVENT_CODE
40869: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40870: WHERE L_MANUAL_ADJUSTMENTS_CALL_FLAG = 'Y'
40871: AND L_RETURN_MANUAL_DISCOUNT = 'Y'
40872: AND QPEP.PRICING_EVENT_CODE IN
40873: (SELECT decode(rownum

Line 40885: FROM qp_event_phases

40881: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40882: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
40883: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40884: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
40885: FROM qp_event_phases
40886: WHERE rownum < 7)
40887: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40888: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40889: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

Line 40903: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP

40899: nvl(QPP.USER_INCOMPAT_RESOLVE_CODE,QPP.INCOMPAT_RESOLVE_CODE) INCOMPAT_RESOLVE_CODE,
40900: QPP.PHASE_SEQUENCE,
40901: nvl(QPP.USER_FREEZE_OVERRIDE_FLAG,QPP.FREEZE_OVERRIDE_FLAG) FREEZE_OVERRIDE_FLAG
40902: --QPEP.PRICING_EVENT_CODE
40903: FROM QP_PRICING_PHASES QPP, QP_EVENT_PHASES QPEP
40904: WHERE QPEP.PRICING_EVENT_CODE IN
40905: (SELECT decode(rownum
40906: ,1 ,substr(l_event_code,1,instr(l_event_code1,',',1,1)-1)
40907: ,2 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,

Line 40917: FROM qp_event_phases

40913: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40914: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
40915: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
40916: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
40917: FROM qp_event_phases
40918: WHERE rownum < 7)
40919: AND trunc(sysdate) between trunc(nvl(QPEP.START_DATE_ACTIVE,sysdate))
40920: and trunc(nvl(QPEP.END_DATE_ACTIVE,sysdate))
40921: AND QPP.PRICING_PHASE_ID = QPEP.PRICING_PHASE_ID

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

41042:
41043: /*
41044: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
41045:
41046: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
41047: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
41048: */
41049: CURSOR l_check_pricing_phase_exists(l_event_code VARCHAR2,l_event_code1 VARCHAR2) IS
41050: SELECT b.pricing_phase_id,b.freeze_override_flag

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

41043: /*
41044: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
41045:
41046: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
41047: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
41048: */
41049: CURSOR l_check_pricing_phase_exists(l_event_code VARCHAR2,l_event_code1 VARCHAR2) IS
41050: SELECT b.pricing_phase_id,b.freeze_override_flag
41051: FROM qp_event_phases a , qp_pricing_phases b

Line 41051: FROM qp_event_phases a , qp_pricing_phases b

41047: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
41048: */
41049: CURSOR l_check_pricing_phase_exists(l_event_code VARCHAR2,l_event_code1 VARCHAR2) IS
41050: SELECT b.pricing_phase_id,b.freeze_override_flag
41051: FROM qp_event_phases a , qp_pricing_phases b
41052: WHERE a.pricing_event_code in (SELECT decode(rownum
41053: ,1 ,substr(l_event_code,1,instr(l_event_code1,',',1,1)-1)
41054: ,2 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
41055: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))

Line 41064: FROM qp_event_phases

41060: ,5 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
41061: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
41062: ,6 ,substr(l_event_code , instr(l_event_code1,',',1,rownum-1) + 1,
41063: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
41064: FROM qp_event_phases
41065: WHERE rownum < 7)
41066: AND a.pricing_phase_id = G_PRICE_LIST_PHASE_ID
41067: AND b.pricing_phase_id = G_PRICE_LIST_PHASE_ID
41068: AND trunc(sysdate) BETWEEN trunc(nvl(a.START_DATE_ACTIVE,sysdate))