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_PRICING_PHASES

Line 31776: FROM QP_PRICING_PHASES

31772: INDX,QP_PREQ_GRP.get_price_list_sequence.cur_get_price_list_sequence,- No Index Used -,NA,NA
31773: */
31774: SELECT PHASE_SEQUENCE,PRICING_PHASE_ID
31775: INTO G_PRICE_LIST_SEQUENCE,G_PRICE_LIST_PHASE_ID
31776: FROM QP_PRICING_PHASES
31777: WHERE LIST_TYPE_CODE = 'PRL'
31778: AND ROWNUM < 2;
31779:
31780: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 32003: INDX,QP_PREQ_GRP.price_request.l_phase_cur,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1

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:
32006: -- Essilor Fix bug 2789138
32007: --[julin/4865213] merged unions, plan unaffected

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 32049: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

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
32049: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
32050: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
32051: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))
32052: ORDER BY 5,3 DESC;
32053:

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 32084: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

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
32084: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
32085: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
32086: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))
32087: UNION
32088: SELECT QPP.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 32117: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

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
32117: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
32118: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
32119: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))
32120: UNION
32121: SELECT QPP.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 32149: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

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
32149: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
32150: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
32151: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))*/
32152:
32153: /* CURSOR l_phase_cur(l_event_code VARCHAR2,

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 32181: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'

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
32181: -- if p_control_rec.get_freight_flag is 'Y' then select phases from qp_pricing_phases table freight_exists column has value 'Y'
32182: AND ((nvl(p_control_rec.get_freight_flag, G_NO) = G_YES AND QPP.freight_exists = G_YES) OR
32183: (nvl(p_control_rec.get_freight_flag, G_NO) = G_NO))
32184: ORDER BY QPP.PHASE_SEQUENCE,SEARCH_FLAG DESC; */
32185:

Line 32303: INDX,QP_PREQ_GRP.price_request.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1

32299: LINE_DETAIL_INDEX
32300: FROM qp_npreq_line_attrs_tmp;
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: */

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))